Post reply

sp_webtask failing after SP4 update.

  • March 14, 2003 at 12:32 pm

    #58609

    Quite recently we have applied SP4 and Update to SP4 on a SQL Server 7.0 Server. Now the version its showing is 7.00.1077. One of the jobs scheduled on this server is ... runwebtask job. This is how I am executing on a User database:

    EXEC sp_runwebtask @procname = N'proc1'

    This used to get executed very well earlier. All it does is create an HTML file locally on the server. Now this started FAILING with the following error:

    Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement. [SQLSTATE 42000]

    Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007]

    OR

    Msg 16882, Sev 11: SQL Web Assistant: Web task not found. Verify the name of the task for possible errors. [SQLSTATE 42000]

    Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007]

    Please Help!!!!

    Thanks & Regards,

    Murali Damera.

    SQL DBA.

    .

  • March 17, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • April 16, 2003 at 8:23 am

    #454361

    Any thoughts?!

    .

  • May 19, 2003 at 9:00 am

    #457645

    Any inputs on this?!

    .

  • May 19, 2003 at 9:31 am

    #457648

    Did you have a chance to see if it worked with SP4 before hotfix ?

    quote:

    Quite recently we have applied SP4 and Update to SP4 on a SQL Server 7.0 Server. Now the version its showing is 7.00.1077. One of the jobs scheduled on this server is ... runwebtask job. This is how I am executing on a User database:

    EXEC sp_runwebtask @procname = N'proc1'

    This used to get executed very well earlier. All it does is create an HTML file locally on the server. Now this started FAILING with the following error:

    Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement. [SQLSTATE 42000]

    Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007]

    OR

    Msg 16882, Sev 11: SQL Web Assistant: Web task not found. Verify the name of the task for possible errors. [SQLSTATE 42000]

    Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007]

    Please Help!!!!

    Thanks & Regards,

    Murali Damera.

    SQL DBA.

    John Zacharkan

    Edited by - zach_john on 05/19/2003 09:31:53 AM

    Edited by - zach_john on 05/19/2003 09:32:07 AM

    Edited by - zach_john on 05/19/2003 09:32:39 AM

    Edited by - zach_john on 05/19/2003 09:33:30 AM


    John Zacharkan

  • May 19, 2003 at 9:40 am

    #457649

    No. We have applied both SP4 and hotfix on the same day.

    .

  • May 19, 2003 at 9:49 am

    #457651

    If you can send me the code I'll try it here on sp4 without hotfix

    Seperate issue since you're on 1077 can you verify my post reply here

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12264&FORUM_ID=5&CAT_ID=1&Topic_Title=Maintenace+plan+won%27t+change&Forum_Title=Administration

    John Zacharkan


    John Zacharkan

Viewing 7 posts - 1 through 6 (of 6 total)

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