search cancel

BSI 8.3.5.5 database import failed

book

Article ID: 243293

calendar_today

Updated On:

Products

CA Business Service Insight

Issue/Introduction

Dear Team,

 We've used the below approach for upgrading the BSI version from 83.5 to 8.3.5.5.

1. Create new database, app and web server Windows server 2019 standard on separate server.
2. Install BSI database by using BSI Setup in BSI database server.
3. Installed BSI App and Web on separate server.
4. Able to login BSI application on default database and everything is working fine.
5. We've export the data from previous version database server successfully by using Export/Import utility.
6. And then trying to Import old database data to newly created database server.

Now while doing import on newly created database server its got failed with many error. Attaching log file your reference. Please check suggest on priority.

 

Thanks

Environment

Release : 8.35

Component :

Resolution

Export command :
===============
expdp bsiadmin schemas=bsiadmin directory=dmpdir dumpfile=bsiadmin.dmp logfile=bsiadminlog.log

Import Command :
impdp bsiadmin/[email protected] schemas=BSIADMIN directory=dmp_dir dumpfile=BSIADMIN.DMP logfile=bsiadmin.log table_exists_action=replace include=table PARTITION_OPTIONS=MERGE

Additional Information

  Full database export and different modes:: https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#SUTIL887