1. Home
  2. Support
Article - CS263000

psbatch command fails with error "An internal Parts library error has occurred: list_table('SELECT * FROM xxx.loc_group'): failed" in Servigistics Click Parts Planning (C-Parts)

Modified: 18-May-2017   


Applies To

  • Servigistics Click Parts Planning 7.2 N/A to 7.7.2 N/A

Description

  • running report through psbatch command aborts
    • prior to running psbatch:
      • changed C-Parts license key
      • dbpatch -U all failed
        • ========================================
          == STEP 1: Drop Triggers/Views/etc. ==
          ========================================
          Dropping java resources . . .
          Dropping java stored procedures . . .
          <ORACLE_HOME>/bin/dropjava: <ORACLE_HOME>/jdk/jre//bin/java: not found
          These objects were not dropped:
          META-INF/MANIFEST.MF CausalCodeToY55 CausalCodeToY55$CausalCode DataValidator FlexFieldToAttr JavaProcedureUtil LHierConversion PartObjidToPid PartObjidToPid$Column PartObjidToPid$ForeignKey PartObjidToPid$Table PlanProductModified ProductBomConversion StockLocToLoc StockLocToLoc$DimSetInfo com/xelus/parts/db/SqlUtils com/xelus/parts/db/pselect/AttrConfigCache com/xelus/parts/db/pselect/AttrConfigCache$Rec com/xelus/parts/db/pselect/CheckSum com/xelus/parts/db/pselect/EntityConfigCache com/xelus/parts/db/pselect/EntityConfigCache$Id com/xelus/parts/db/pselect/EntityConfigCache$Rec com/xelus/parts/db/pselect/InheritanceCache com/xelus/parts/db/pselect/LocationGidCache com/xelus/parts/db/pselect/PselectFns com/xelus/parts/db/pselect/TheaterLhierCache
          There are probably active processes accessing the database. Try again when these processes are stopped.
          ERROR: Failed to delete triggers, procedures and/or views.
          Please press ENTER . . .
    • psbatch -f <directory>/xxx.psb -g <configurable report title> -configname $CONFIGNAME aborts
      • Error in System Log
        • About to issue new PS Generic report
          Oracle Error: ORA-00942: table or view does not exist
          SQL statement failed in 'sqlselect': SELECT * FROM xxx.loc_group
           An internal Parts library error has occurred:
          list_table('SELECT * FROM xxx.loc_group'): failed
          CORBA::SystemException:IDL:omg.org/CORBA/UNKNOWN:1.0: minor = 0x2828 (list_table('SELECT * FROM xewgnp1.loc_group'): failed (code 17) dbtables.cpp, line 122), completion status = MAYBE
           
This is a printer-friendly version of Article 263000 and may be out of date. For the latest version click CS263000