3 Replies Latest reply: Nov 8, 2012 9:46 AM by Voltaire RSS

    Informatica 8.6.1 - Oracle_BI_DW_Base.rep Failed.

    972667
      HI,

      I am getting the following error while restoring Oracle_BI_DW_Base.rep . Could you please guide me,

      Restore Contents operation on repository [infoserver] started at 11/05/2012 14:38:13.
      Restoring repository contents from file [C:\Informatica\PowerCenter8.6.1\server\infa_shared \Backup\Oracle_BI_DW_Base.rep].

      domain name: Domain_adc2170893
      Backup file repository version : 179 Current repository version : 179
      File backup version : 10 Current backup version : 10
      Backup file is valid : Yes
      Backup file code page id : 2252 Current code page id : 2252
      Backup file repository data version : 88 Current repository data version : 88
      Repository backed up in Backup file has External Authentican Module : No
      Domain of Backup file : Domain_adc2170893
      Description of Backup file :
      8.6.1 HotFix9
      Restoring table OPB_SCHEDULE_LOGIC
      Restoring table OPB_SESSION
      Restoring table OPB_SESSION_CONFIG
      Restoring table OPB_CFG_ATTR
      Restoring table OPB_COMPONENT
      Restoring table OPB_SWIDGET_INST
      Unexpected data found in file C:\Informatica\PowerCenter8.6.1\server\infa_shared \Backup\Oracle_BI_DW_Base.rep!


      Unable to restore Repository.

      An error has occurred while creating contents. Dropping repository tables...
      Restore Contents operation on repository [infoserver] ended at 11/05/2012 14:43:27. Elapsed time is 0:05:14.

      Thanks

      Edited by: user8127044 on Nov 5, 2012 11:35 PM
        • 1. Re: Informatica 8.6.1 - Oracle_BI_DW_Base.rep Failed.
          872635
          Hi,

          Please check your Oracle BIApps version. Confirm is it compatible for Informatica 8.6.1. then provide the required permissions/privileges to Informatica repository (INF_REP) Schema.

          Regards,
          Nagaraju Puppala
          • 2. Re: Informatica 8.6.1 - Oracle_BI_DW_Base.rep Failed.
            972667
            Hi,

            Thanks for the reply.

            The OBIA version is 7.6.9.2 which is compatiable with informatica 8.6.1. I have given the DBA proviliges to informatica repository. It is throwing error after the statement Restoring table OPB_SWIDGET_INST.


            Restoring table OPB_CFG_ATTR
            Restoring table OPB_COMPONENT
            Restoring table OPB_SWIDGET_INST
            Unexpected data found in file C:\Informatica\PowerCenter8.6.1\server\infa_shared \Backup\Oracle_BI_DW_Base.rep!


            INFO Tue Nov 6 16:01:01 2012 3416 REP_62301 Restore Contents operation on repository [infoserver] ended at 11/06/2012 16:01:01. Elapsed time is 0:07:18.

            INFO Tue Nov 6 16:00:46 2012 3416 REP_62301 An error has occurred while creating contents. Dropping repository tables...

            INFO Tue Nov 6 16:00:46 2012 3416 REP_62301
            Unable to restore Repository.


            INFO Tue Nov 6 16:00:46 2012 3416 REP_62301 Unexpected data found in file C:\Informatica\PowerCenter8.6.1\server\infa_shared\Backup\Oracle_BI_DW_Base.rep!

            INFO Tue Nov 6 16:00:38 2012 3416 REP_62301 Restoring table OPB_SWIDGET_INST

            INFO Tue Nov 6 16:00:34 2012 3416 REP_62301 Restoring table OPB_COMPONENT



            I am not sure what is going wrong.

            Thanks
            Ram
            • 3. Re: Informatica 8.6.1 - Oracle_BI_DW_Base.rep Failed.
              Voltaire
              Hi Ram,

              Was Informatica 8.6.1 HF installed on the target system. Can you Include the Log to confirm the repository version and export version etc.

              Regards,
              Jay