2 Replies Latest reply on Apr 10, 2013 5:46 PM by 1002205

    Informatica repository error for sessions.

    1002205
      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.