MS-SQL customers see "WARNING" for Oracle in the upgrade pre-check logs

Document ID : KB000115683
Last Modified Date : 11/10/2018
Show Technical Document Details
Issue:
When MS-SQL customers run the upgrade pre-check from 15.3 to 15.5 they see "WARNING" for Oracle in the logs.

STEPS TO REPRODUCE

1. Run the upgrade pre-check from 15.3 to 15.5.
2. Check the precheck-results.xml file

Actual Results:
"WARNING" for Oracle DB are displayed in the logs. See:
<result name="check-db-export-permissions.xml" value="WARNING">
<resultinfo>Application database schema user ‘niku’ does not have CREATE ANY DIRECTORY privilege. Application database schema user ‘niku’ does not have SELECT privilege on DBA_DATAPUMP_JOBS.</resultinfo>
</result>
 
<result name="check-db-dwh-export-permissions.xml" value="WARNING">
<resultinfo>Application database schema user ‘PPM_DWH’ does not have CREATE ANY DIRECTORY privilege. Application database schema user ‘PPM_DWH’ does not have SELECT privilege on DBA_DATAPUMP_JOBS.</resultinfo>
</result>
 
Expected Results:
SQL customers should not see such warnings in the logs because DATAPUMP is oracle features.  The CREATE ANY DIRECTORY permission and SELECT permission on DBA_DATAPUMP_JOBS are Oracle permissions.
 
Workaround:
Ignore those particular warnings in the checkinstall.log
Cause:
Caused by DE44376
Resolution:
Fixed in 15.5.1.