This discussion is archived
3 Replies Latest reply: Nov 8, 2012 9:46 AM by Voltaire RSS

Informatica 8.6.1 - Oracle_BI_DW_Base.rep Failed.

972667 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points