June 30, 2016 at 10:51 am
Experts,
User sent me detail of an error "Cannot update the data for the master gateway. The domain configuration repository database may not be available. Verify that the database is available.
java.sql.SQLNonTransientConnectionException: [informatica][SQLServer JDBC Driver]Your connection was terminated.
at com.informatica.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at com.informatica.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at com.informatica.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at com.informatica.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at com.informatica.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at com.informatica.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at com.informatica.jdbc.sqlserver.tds.ddo.c(Unknown Source)
at com.informatica.jdbc.sqlserver.tds.ddn.f(Unknown Source)
at com.informatica.jdbc.sqlserver.tds.ddn.a(Unknown Source)
at com.informatica.jdbc.sqlserver.dda3.h(Unknown Source)
at com.informatica.jdbc.sqlserverbase.dde7.w(Unknown Source)
at com.informatica.jdbc.sqlserverbase.dde7.y(Unknown Source)
at com.informatica.jdbc.sqlserverbase.ddd2.executeUpdate(Unknown Source)
at com.informatica.isp.domainservice.MasterElector.executeUpdateAndClose(MasterElector.java:757)
at com.informatica.isp.domainservice.MasterElector.updateMyRowInDB(MasterElector.java:883)
at com.informatica.isp.domainservice.MasterElector.access$9(MasterElector.java:874)
at com.informatica.isp.domainservice.MasterElector$MasterElectDataWriter.updateRow(MasterElector.java:1060)
at com.informatica.isp.domainservice.MasterElector$MasterElectDataWriter.run(MasterElector.java:982)
at java.lang.Thread.run(Thread.java:745)"
I checked the error log on SQL Server and didn't see any connection issue. How do I troubleshoot this issue?How do I know if this is SQL Server issue or Informatica issue?
July 1, 2016 at 2:14 am
I have had similar issues, it ended up with logging a support ticket with informatica.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply