Hi All,

We have migrated WAS 6.1 to WAS 8.0 successfully. I am getting the errors in logs.

When i do testconnection its successful, i am able to login into application. I check in logs some DB connection failed and errors are getting. Please check it and help me is there any problem.



 00000798 ConnectionEve W   J2CA0206W: A connection error occurred.  To help determine the problem, enable the Diagnose Connection Usage option on
 the Connection Factory or Data Source.
[6/4/13 12:33:30:923 GMT+05:30] 00000798 ConnectionEve A   J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adapter for resource jdbc/DOTS.
The exception is: java.sql.SQLException: null DSRA0010E: SQL State = 58004, Error Code = -1,042
[6/4/13 12:33:30:925 GMT+05:30] 00000798 DAOTestPaperD E   null DSRA0010E: SQL State = 58004, Error Code = -1,042
[6/4/13 12:33:30:928 GMT+05:30] 00000798 DAOTestPaperD E   DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 2;DB2INST1.TESTPAPERMASTER
[6/4/13 12:33:30:929 GMT+05:30] 00000798 DAOTestPaperD E   Records were not inserted into table TESTPAPERMASTER & TESTPAPERDETAIL & TESTPAPERSETTING
[6/4/13 12:33:30:929 GMT+05:30] 00000798 DAOTestPaperD E   CSXDT0251E: This record keyname should be unique.
[6/4/13 12:33:30:930 GMT+05:30] 00000798 DAOBaseDB2    E   DSRA9110E: Connection is closed.
[6/4/13 12:33:30:959 GMT+05:30] 00000798 renderkit     W   Unable to find component with ID outputLabel in view.
[6/4/13 12:33:30:988 GMT+05:30] 00000798 LocalTranCoor W   WLTC0033W: Resource jdbc/DOTS rolled back in cleanup of LocalTransactionContainment.
[6/4/13 12:33:30:988 GMT+05:30] 00000798 LocalTranCoor W   WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainment.


Thanks,
Chinna.

Hi Chinna,

  your connectivity with DB is OK, seems an application error (duplicate record).


  Records were not inserted into table TESTPAPERMASTER & TESTPAPERDETAIL & TESTPAPERSETTING
  CSXDT0251E: This record keyname should be unique.

  Hope this helps.

Regards

Navigate to the Datasource which you are getting fatal error.

right side , Additonal properties-->click  websphere application server datasource properties 

enabled the check boxes under Pretest connection properties

Pretest existing pooled connections & Pretest new connections

and restart and test the application.

Let me know if the issue still persits.

Thanks
Venkata

Thanks for your help...!!!

Gabriel  yor right...!!! We have checked the SQL code. Trying to incert duplicate value its not inserting.

Thanks,
Chinna.