Post reply

Update Stats Job causing Dropped Connections and Cursor not Declared errors

  • September 5, 2013 at 3:27 pm

    #282145

    Has anyone ran across or have seen dropped connections from TIBCO and getting a 'cursor not declared' error message when running an Update Stats job.

    The issue started about 4 weeks ago and only occurred when our weekly maintenance job was running which 'Update Statistics' on most of our tables. The SQL job runs fine with no errors but we are dropping connections and receiving the following type of error message from the drivers.

    ErrorCode: BW-JDBC-100014, ErrorMessage: "JDBC error reported: (SQLState = HY000) - java.sql.SQLException: [tibc

    osoftwareinc][SQLServer JDBC Driver][SQLServer]The cursor was not declared."

    It only happens with the SQL job runs.

    Any suggestions?

    Thanks,

    Daniel

  • November 19, 2013 at 9:24 am

    #1667476

    Hi, have you found the root cause and solution / workaround for the issue? I am facing the same issue in our system and have no idea how to fix it.

  • November 19, 2013 at 9:29 am

    #1667478

    No, besides updating the TIBCO drivers.

  • November 19, 2013 at 9:51 am

    #1667488

    Thanks for the quick reply. My I know What driver you are using now?

  • November 19, 2013 at 10:44 am

    #1667503

    Didn't solve the problem by changing the drives...But we switched to JTDS driver instead.

Viewing 5 posts - 1 through 4 (of 4 total)

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