Informatica repository error for sessions.
Hi All,
we are getting the following error messages in the Informatica load run. If we restart informatica services then the issue is getting resolved. After couple of sessions we are seeing the same error message. checked with DBA if any tables got corrupted in the repsoitory, he said everything is working fine. We have restarted server box, purged old log files, restarted informatica respository and integration services several times, but we are still facing same issue.
ERROR : REP_12014 : (4400|4228) An error occurred while accessing the repository
ERROR : REP_12400 : (4400|4228) Repository Error (
ORA-01461: can bind a LONG value only for insert into a LONG column
Database driver error...
Function Name : Execute
SQL Stmt : UPDATE OPB_WFLOW_RUN SET END_TIME = ?, RUN_STATUS_CODE = ?, RUN_ERR_MSG = ?, RUN_ERR_CODE = ?, SERVER_NODE_NAME = ? WHERE WORKFLOW_ID = ? AND WORKFLOW_RUN_ID = ? AND VERSION_NUMBER = ? AND RUNINST_NAME = ?
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : UPDATE OPB_WFLOW_RUN SET END_TIME = ?, RUN_STATUS_CODE = ?, RUN_ERR_MSG = ?, RUN_ERR_CODE = ?, SERVER_NODE_NAME = ? WHERE WORKFLOW_ID = ? AND WORKFLOW_RUN_ID = ? AND VERSION_NUMBER = ? AND RUNINST_NAME = ?
Oracle Fatal Error)
ERROR : REP_12400 : (4400|4228) Repository Error ([REP_12014] An error occurred while accessing the repository
ORA-01461: can bind a LONG value only for insert into a LONG column
Database driver error...
Function Name : Execute
SQL Stmt : UPDATE OPB_WFLOW_RUN SET END_TIME = ?, RUN_STATUS_CODE = ?, RUN_ERR_MSG = ?, RUN_ERR_CODE = ?, SERVER_NODE_NAME = ? WHERE WORKFLOW_ID = ? AND WORKFLOW_RUN_ID = ? AND VERSION_NUMBER = ? AND RUNINST_NAME = ?
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : UPDATE OPB_WFLOW_RUN SET END_TIME = ?, RUN_STATUS_CODE = ?, RUN_ERR_MSG = ?, RUN_ERR_CODE = ?, SERVER_NODE_NAME = ? WHERE WORKFLOW_ID = ? AND WORKFLOW_RUN_ID = ? AND VERSION_NUMBER = ? AND RUNINST_NAME = ?
Oracle Fatal Error)
ERROR : LM_36403 : (4400|4228) Workflow [SIL_Agg_CampaignHistory]: error in logging the end of execution to repository.
ERROR : LM_36320 [Wed Apr 10 02:25:47 2013] : (4400|4228) Workflow [SIL_Agg_CampaignHistory]: Execution failed.