Getting Error dialog on object check in.

[wgalanis]

User are getting this error on checking in an object to the vault.

System Info:

Pro/Engineer Wildfire 3.0 running on Oracle 9.2.0.5 DB and (ahem!) Windows Server 2000.

We just recovered the database from a crash and this behavior occurs.

I have been in this position for five weeks, so no snarky comments about the environment .  I am working on modernizing it, but first...

Anyway, I will be trolling through the logs this weekend to see if a clue pops up.

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[wgalanis]

More information from the user's logs:

Error Stack:

Error 0:

Message: This error message has internal usage only.

It should be never put into stack.

Please check the online knowledge database at www.ptc.com

and/or contact Technical Support,

Arguments:

Error 1:

Message: This error message has internal usage only.

It should be never put into stack.

Please check the online knowledge database at www.ptc.com

and/or contact Technical Support,

Arguments:

Error 2:

Message: This error message has internal usage only.

It should be never put into stack.

Please check the online knowledge database at www.ptc.com

and/or contact Technical Support,

Arguments:

Error 3:

Message: ToolKit Error : -4068

Arguments:

    0: ORA-04068: existing state of packages has been discarded

ORA-04063: package body "PDM.PDMSP_TXNMODE_PKG" has errors

ORA-06508: PL/SQL: could not find program unit being called

ORA-06512: at line 1

[wgalanis · Accepted solution]

OK, solved the issue with my very competent DBA.

Solution to Pro/Engineering issue:

Error at USER end:

Message: ToolKit Error : -4068

Arguments:    0:

ORA-04068: existing state of packages has been discarded

ORA-04063: package body "PDM.PDMSP_TXNMODE_PKG" has errors

ORA-06508: PL/SQL: could not find program unit being called

ORA-06512: at line 1

On server side (SQLPlus):

select owner, object_name, object_type, status from dba_objects where owner = ‘PDM’ and object_name = ‘PDMSP_TXNMODE_PKG’;

OUTPUT:

OWNER  OBJECT_NAME          OBJECT_TYPE  STATUS

------- -------------------- ------------  -------------

PDM    PDMSP_TXNMODE_PKG    PACKAGE      VALID

PDM    PDMSP_TXNMODE_PKG    PACKAGE BODY  INVALID

SQL> set serveroutput on;

SQL> alter package PDM.PDMSP_TXNMODE_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY PDM.PDMSP_TXNMODE_PKG:

LINE/COL ERROR

-------- -----------------------------------------------------------------

71/9    PL/SQL: SQL Statement ignored

72/14    PL/SQL: ORA-00942: table or view does not exist

133/17  PLS-00201: identifier 'DBMS_LOCK' must be declared

133/17  PL/SQL: Statement ignored

Oops, have to do more stuff:

SQL> grant execute on DBMS_LOCK to PDM;

Grant succeeded.

SQL> set serveroutput on;

SQL> alter package PDM.PDMSP_TXNMODE_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY PDM.PDMSP_TXNMODE_PKG:

LINE/COL ERROR

-------- -----------------------------------------------------------------

71/9    PL/SQL: SQL Statement ignored

72/14    PL/SQL: ORA-00942: table or view does not exist

Getting Closer, another step

More changes:

SQL> grant select any dictionary to PDM;

SQL> grant select any table to PDM;

SQL> set serveroutput on;

SQL> alter package PDM.PDMSP_TXNMODE_PKG compile body;

SQL> show errors;

No errors.

Yes!

Validating:

SQL> select owner, object_name, object_type, status from dba_objects where owner = 'PDM' and object_name = 'PDMSP_TXNMODE_PKG';

OWNER                          OBJECT_NAME          OBJECT_TYPE       STATUS

------------------------------ --------------------- ---------------- -------

PDM                            PDMSP_TXNMODE_PKG    PACKAGE           VALID

PDM                            PDMSP_TXNMODE_PKG    PACKAGE BODY      VALID

Now, check for more surprises:

SQL> exec dbms_utility.compile_schema('PDM',FALSE);

PL/SQL procedure successfully completed.

SQL> select count(*) from dba_objects where owner = 'PDM' and status = 'INVALID';

  COUNT(*)

----------

        0

All done and users can check in drawings.