mike_se Contributor.

PPM Support Tip: 9.2 Upgrade missing a row for DMS Migration Service

When upgrading to 9.2 version, Document Management Solution (DMS) Migration Service row not added to database.

After upgrading Project and Portfolio Management (PPM) from 8.0 to 9.1 to 9.2, unable to enable and migrate documents to use DMS.

When initiating the migration, get the following error:
"An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:

Running a query to see if the DMS Migration Service was present returned no rows:
select * from KNTA_SERVICES_NlS where reference_code = '_DMS_MIGRATION_ENGINE_SERVICE'

Defect QCCR1L53425

The 9.2 upgrade did not add a row to the database for the DMS Migration Service (the feature was added to a 9.1 Service Pack, and was not necessary to deploy a Service Pack when moving from 8.0 to 9.2 version).

Step 1. Stop PPM and run the following SQL: FixMissingRecord.zip

Step 2. Verify the following service is present (one record should be returned):
select * from KNTA_SERVICES_NlS where reference_code = '_DMS_MIGRATION_ENGINE_SERVICE'

Step 3. Restart PPM

Step 4. Test the DMS Migration again.

NOTE: Since this is a manual update to the database schema, make sure to test in STAGE first and backup any data incase original data needs to be restored.

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Labels (1)
1 Reply
Super Contributor.. kintanadan Super Contributor..
Super Contributor..

Re: PPM Support Tip: 9.2 Upgrade missing a row for DMS Migration Service

This is only true if you upgrade to 9.2 from 9.12 or earlier.

The missing 9.2 upgrade script is called: knta_services_913_1.sql, which I assume was introduced in 9.13.



The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.