Post reply

Job Failiing with Error [SQLSTATE 42000] (Error 170) when run from UI.

  • August 29, 2005 at 2:24 am

    #90642

    Hi guys,

    Got a strange problem...

    I have a application made in C#.net that call a stored procedure to create a job on the fly. The job runs and deletes after completion.We are using a distributed enviorment with tables being on 2 different servers.The jobs has 5 steps to it and runs on a system admin account.

    This job failes on the third step where a call is made to a stored procedure that creates a temporary table to store the data. The job runs the first 2 steps successfully without any error and gives this error on third step.

    Line 1: Incorrect syntax near ')'. [SQLSTATE 42000] (Error 170).  The step failed.

    the strange part is it runs sucessfully when invoked from QA

    Regards

    Puneet

  • August 29, 2005 at 8:41 am

    #585863

    One problem I have found in scripting a job, is if there are GO statements in the code, the SP may not generate the job.  It runs in QA because QA can parse the steps correctly.



    Michelle

  • August 29, 2005 at 11:03 pm

    #586044

    Hi,

    got the problem it was due to an empty string being generated. Guess it was due to the go statement only. Thanks a ton

    Puneet

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply