2 Replies Latest reply: Apr 10, 2013 12:46 PM by 1002205 RSS

    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.
        • 1. Re: Informatica repository error for sessions.
          Sher Ullah Baig
          HI,
          As per error message your target column is having wrong data type. Your Target column data type should be "LONG"
          "ORA-01461: can bind a LONG value only for insert into a LONG column"
          Open 'SIL_Agg_CampaignHistory' flow in informatica Designer and find target table from Mapping and check weather Target table column data type.

          Regards
          Sher

          Edited by: Sher Ullah Baig on Apr 10, 2013 4:46 PM
          • 2. Re: Informatica repository error for sessions.
            1002205
            The target table load is already completed. After loading target table it will insert record in opb table. If we restart integration service then we are not seeing this error message. Same session is getting completing without any error message. Thats pretty strange thing for me.