Skip to main content
W
wgalanis1-Visitor
1-Visitor
December 5, 2015
Solved

Getting Error dialog on object check in.

  • December 5, 2015
  • 1 reply
  • 1923 views

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

Pro-E Error.png

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.
Best answer by wgalanis

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.

1 reply

W
wgalanis1-VisitorAuthor
1-Visitor
December 7, 2015

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

W
wgalanis1-VisitorAuthorAnswer
1-Visitor
December 7, 2015

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.

Terms & ConditionsAccessibility statement