Demantra 1223 Install Errors with IMP-00041: Warning: object created with compilation warnings
Last updated on MARCH 08, 2017
Applies to:Oracle Demantra Demand Management - Version 12.2.3 and later
Information in this document applies to any platform.
Customer is doing a 12.2.3 install and it errors with objects not getting compiled. They get the following errors in the Installer:
Errors were encountered during the execution of the "Import Data" process:
"IMP-00041: Warning: object created with compilation warning
Click 'View' to view the log file, or 'Exit' to exit the installation
The Install logs show
2015-03-04 19:18:40,240 [DEBUG] - STDERR> Import terminated successfully with warnings.
2015-03-04 19:18:40,287 [DEBUG] - exitCode = proc.exitValue(): 3
2015-03-04 19:18:40,318 [DEBUG] - Log file: E:\Demantra1223\Demand Planner\Database Objects\Oracle Server\dumps\import.log
2015-03-04 19:18:40,318 [DEBUG] - task.isFailed(): true
2015-03-04 19:18:40,318 [DEBUG] - Errors: * IMP-00041: Warning: object created with compilation warnings
2015-03-04 19:18:40,318 [DEBUG] - Done executing com.demantra.panels.ExecuteDatabaseTasksPanel.
2015-03-04 19:31:16,137 [DEBUG] - Errors were encountered during task Import Data
If the customer tries to compile all the objects manually they do not get compiled and it gives
SQL> alter package DP.SYNCH compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY DP.SYNCH:
526/5 PL/SQL: Statement ignored
526/5 PLS-00201: identifier 'DBMS_JOB' must be declared
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms