The migrateToInstalledFP.sh script execution fails at importing 'ACG' and 'Roles' for a company

Technote (troubleshooting)


Problem(Abstract)

The migrateToInstalledFP.sh script execution fails at importing 'ACG' and 'Roles' for a company. This script is located at $TOP/bin/migration directory.

Symptom

The migrateToInstalledFP.sh script execution fails with the following messages:

Importing ACG and Roles for company: <company_name>

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Migration Failed : ACG
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Please see the file for further details :
/<product_install_directory>/logs/errfile.log

-----------------------------------------------------------
Summary of the migration
-----------------------------------------------------------


Cause

In the errfile.log located at $TOP/logs/ directory the following error is thrown,

"Exception in thread "main" java.lang.NullPointerException
at com.ibm.ccd.synchronize.DBSchemaVersion.isSynchronized(DBSchemaVersion.java:84)
at com.ibm.ccd.envexpimp.common.EnvironmentImporter.main(EnvironmentImporter.java:586)"

The possible cause of the above exception is the missing data in the product's dbv database table.


Resolving the problem

The steps to resolve the issue, if the cause of the exception is same as mentioned in the Cause section above, are:

1. Execute the following SQL query and if the query returns 0 rows or an empty data proceed with the
step 2.

select * from dbv

2. UPDATE or INSERT with appropriate product version value in the dbv database table.

a) If the step 1 query returned 1 row with an empty dbv_version column, execute the following UPDATE statement,

UPDATE dbv set dbv_version=<product_version>

For example, if the product version is 9.1.0 then execute the following query,
UPDATE dbv set dbv_version=9.1.0

b) If the step 1 query returned 0 rows, execute the following INSERT statement,

INSERT INTO dbv VALUES (<product_version>)

For example, if the product version is 10.1.0 then execute the following query,
INSERT INTO dbv VALUES (10.1.0)

3. Run the migrateToInstalledFP.sh script

If there are no other errors or exceptions the migration of the data should complete successfully.


Cross reference information
Segment Product Component Platform Version Edition
Information Management InfoSphere Master Data Management Collaboration Server AIX, Linux, Solaris 10.0, 10.1

Product Alias/Synonym

MDMCE
MDMCS
MDMPIM
MDM Server for PIM
MDM Collaboration Server
InfoSphere MDM Server for PIM
InfoSphere Master Data Management Collaboration Server
InfoSphere Master Data Management Collaborative Edition
InfoSphere Master Data Management Server for Product Information Management

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Master Data Management Server for Product Information Management
Database

Software version:

9.1

Operating system(s):

AIX, HP-UX, Linux, Solaris

Reference #:

1634028

Modified date:

2013-04-24

Translate my page

Machine Translation

Content navigation