This content has been marked as final. Show 3 replies
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.
Thanks for the reply.
The OBIA version is 126.96.36.199 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.
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.