none
Query was cancelled. ". [SQLSTATE 01000] (Error 7412). The step failed.

    Question

  • Hi All,

    I was running a SQL query from SQL agent which connects to Netezza using linked server I tested it using mangement studio it worked fine with very little data set ,

    When I scheduled using SQL server agent it failed giving this following error.

    Executed as user: EUR\ldnfitsqlems04. Cannot fetch a row from OLE DB provider "NZOLEDB" for linked server "NETEZZA_PRODUCTION". [SQLSTATE 42000] (Error 7330)  OLE DB provider "NZOLEDB" for linked server "NETEZZA_PRODUCTION" returned message "ERROR:  Query was cancelled. ". [SQLSTATE 01000] (Error 7412).  The step failed.

    Help Please.

    Thanks

    Sri


    Sri.Tummala

    Wednesday, December 19, 2012 9:31 AM

Answers

All replies