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