Symantec IGA

Expand all | Collapse all

IDM 14.2 Error: [FMWGEN][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction

  • 1.  IDM 14.2 Error: [FMWGEN][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction

    Posted 06-07-2018 05:31 PM

    Hello,

     

    I am receiving the following error on my new IDM 14.2 installation. Has anyone seen this and found a resolution?

    WebLogic 12.1.3, Identity Manager 14.2, SQL Server 2012, Windows Server 2016

     

    17:22:52,608 ERROR [com.workpoint.server.pojo.GenericServerBean] [FMWGEN][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction. Desc:4500000006.
    SQL = UPDATE WP_MONITOR SET LU_DATE=2018-06-07 17:20:06.715 WHERE MONITOR_FIFO=4550
    2018-06-07 17:22:52,624 [Query_jobq#JobQ1#WPDS] ERROR com.workpoint.queue.query.JobQQueryThread - Unable to query job monitor instances due to RemoteException.
    com.workpoint.server.ejb.WorkPointEJBException: An SQL Exception has occurred. Please see the server logs for details.
    at com.workpoint.server.pojo.GenericServerBean.createException(Unknown Source)
    at com.workpoint.server.pojo.GenericServerBean.createException(Unknown Source)
    at com.workpoint.server.pojo.MonitorPvtBean.queryJobQMonitors(Unknown Source)
    at com.workpoint.server.pojo.MonitorPvt_EJB_c88wzu_MonitorPvtImpl.__WL_invoke(Unknown Source)
    at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:34)
    at com.workpoint.server.pojo.MonitorPvt_EJB_c88wzu_MonitorPvtImpl.queryJobQMonitors(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
    at com.sun.proxy.$Proxy122.queryJobQMonitors(Unknown Source)
    at com.workpoint.client.Monitor.queryJobQMonitors(Unknown Source)
    at com.workpoint.queue.query.JobQQueryThread.performQuery(Unknown Source)
    at com.workpoint.queue.query.QQueryThread.run(Unknown Source)



  • 2.  Re: IDM 14.2 Error: [FMWGEN][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction

    Posted 06-08-2018 09:14 AM

    Is there any action that triggers this? Or is it just happening on startup?

     

    It appears that this is the Workpoint monitoring queue trying to access the WPDS datasource to see if there are any jobs to process, but it it's failing.

     

    Have you checked the SQL server's logs from this time frame to see if there's an error there?