My Oracle Support Banner

Microsoft Project Objects Will Not Compile when created or clone WAM Database instance (Doc ID 565531.1)

Last updated on JULY 13, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.10 and later
Information in this document applies to any platform.

Symptoms

Used EXP to dump the Synergen user out of the 9i LIVE database. Then used IMP to bring the data
into the 10g DEV database. Everything worked fine except the MSproject stuff. Can't seem to get
these compiled.


SQL> spool off
SQL> /* User Instructions:
SQL> Run this script again if there are still "INVALID" objects.
SQL> This script will recompile any "INVALID" objects.
SQL> The following objects are now invalid
SQL> */
SQL> select substr(object_name,1,30),object_type from user_objects
2 where status = 'INVALID';
SV_MSPROJECT_TASK VIEW
SV_MSPROJECT_SUBPROJECT VIEW
SV_MSPROJ98_TASK VIEW
SV_MSPROJ98_SUBPROJECT VIEW
SV_MSPROJ98_RESOURCE VIEW
SV_MSPROJECT_RESOURCE VIEW
SV_MSPROJ98_ITEM VIEW
SV_MSPROJECT_ITEM VIEW
SDBP_GET_MSPROJ98_STATUS PROCEDURE
SDBP_GET_MSPROJECT_STATUS PROCEDURE
SDBP_BOOLEAN_WRAPPER PROCEDURE
MSP_BACKUP_TASK PROCEDURE
SDBT_AU_MSP_PROJECTS TRIGGER
SDBP_GENERATE_MSPROJECT PACKAGE BODY
SDBP_GENERATE_MSPROJECT98 PACKAGE BODY
SDBP_UPDATE_MSPROJECT PACKAGE BODY

16 rows selected.







Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.