This discussion is archived
1 Reply Latest reply: Nov 2, 2013 9:00 AM by Joe Weinstein RSS

datasynch interrupt sql server jdbc error

user648334 Newbie
Currently Being Moderated

we have increased number of views on db and done some elaborations on the existing one. when performing a data synch it stops and errors are shown:

28/10/13 9:59: Start synchronization in progress.

28/10/13 9:59: Mode sync: synchronize

28/10/13 9:59: Connected to the origin server.

28/10/13 9:59: Connected to the target server.

28/10/13 9:59: Suppressing Missing Values ​​in progress.

28/10/13 14:50: error while sending request to the source connector. Exception: DBConnector: failed to doQuery; nested exception is:

java.sql.SQLException: [FMWGEN] [SQLServer JDBC Driver] [SQLServer] SHUTDOWN is in progress.

28/10/13 14:50: Translation failed - Could not open source query. Exception:; nested exception is:

DBConnector: failed to doQuery; nested exception is:

java.sql.SQLException: [FMWGEN] [SQLServer JDBC Driver] [SQLServer] SHUTDOWN is in progress.

28/10/13 14:50: No logs available source.

28/10/13 14:50: Connector of origin properly disconnected.

28/10/13 14:50: Connector target properly disconnected.

 

db sql server becomes busy and queries stay pending.

how to solve it?

many thanks

  • 1. Re: datasynch interrupt sql server jdbc error
    Joe Weinstein Expert
    Currently Being Moderated

    This is nothing you can solve or prevent at the WebLogic end. The error message is clear that the DBMS

    is telling you it is shutting down. Nothing good can happen by this to open JDBC connections. Yes the

    DBMS is busy; busy putting it's final affairs in order, and queries will only pend for a short while till they

    die completely, when the DBMS turns itself off completely. If what you're saying is that you get this message

    and then the DBMS never dies but remains in a zombie state, you must call MS for DBMS support.

    HTH,

    Joe

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points