UC Get Old Rep is Invalid

Document ID : KB000089177
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
UC Get Old Rep is Invalid
Resolution:
Detailed Description and Symptoms

U0003592 Status: '' Native error: '24344' Msg: 'ORA-24344: success with compilation error'

U0003592 Status: '' Native error: '6550' Msg: 'ORA-06550: line 2, column 5:

PLS-00905: object UC4.UC_GET_OLD_REP is invalid 

(These warning messages will repeat every 10 or 15 seconds)


Investigation

During an update of OM from 6.00A to 8.00A, while performing the load of the InitialData for 8.00A, the following error messages occur:

U0003592 Status: '' Native error: '24344' Msg: 'ORA-24344: success with compilation error'

U0003592 Status: '' Native error: '6550' Msg: 'ORA-06550: line 2, column 5:

PLS-00905: object UC4.UC_GET_OLD_REP is invalid 

(These warning messages will repeat every 10 or 15 seconds)

 

This is an example of the entries found in the DBLoad log:

create or replace procedure UC_GET_OLD_REP

....

begin

select count(table_name) into tabcount from user_tables wh

20101023/110544.989 - U0003592 Status: '' Native error: '24344' Msg: 'ORA-24344: success with compilation error'

20101023/110544.990 - U0038042

begin

    UC_GET_LAST_AGENT_LOG();

    UC_WRITE_NEW_AGENT_REP();   

end;

20101023/110609.574 - U0003524 ===> Time critical DB call!       OPC: 'EXEC' time: '24:583.103.999'

20101023/110609.574 - U0003525 ===> '

begin

    UC_GET_LAST_AGENT_LOG();

    UC_WRITE_NEW_AGENT_REP();   

end;

20101023/110609.579 - U0038042 ----------------------------------------------------------

20101023/110609.607 - U0038042 Disable to skip copying of reports for now

20101023/110609.613 - U0038042 Note: This can only be skipped and performed later WITHOUT ILM installation!!!

20101023/110609.619 - U0038042 ../db/oracle/8.00A/do_report.sql

20101023/110609.626 - U0038042 begin

    UC_GET_OLD_REP(10000, 1);

end;

20101023/110609.654 - U0029108 SQL_ERROR    Database handles  DB-HENV: 6000000000400020  DB-HDBC: 60000000000cd908

20101023/110609.654 - U0003591 DB error info: Opc: 'OCIStmtExecute' Return code: 'ERROR'

20101023/110609.654 - U0003592 Status: '' Native error: '6550' Msg: 'ORA-06550: line 2, column 5:

PLS-00905: object UC4.UC_GET_OLD_REP is invalid

ORA-06550: line 2, column 5:

PL/SQL: Statement ignored'

****************************************. 


Solution

Although these messages are received during the DBLoad update of the InitialData, the OM 8.00A system should be working.  These messages mean that only the statistical records were converted - not the reports from the 6.00A OM database. 

No reports from the version 6.00A system are available in the 8.00A system (if needed, old reports will need to be retrieved from the 6.00A system).  If the 6.00A reports are not needed, then there is no need to be concerned by these messages.

 

The reports and statistical data in the database can be manually converted after the Automic system has been updated to version 8.00. Automic provides stored procedures that can be used to repeat a failed conversion process. Refer to "Administration Manual" - "Installation" - "Update Installation" - "Converting Reports after Updating to 8.00A" for a detailed description.