IJ46260: UPDATEDB FAILED FROM 7612 IFIX TO 7613 IFIX WITH ORACLE DB -- INVALID INDENTIFIER

APAR status

• Closed as program error.

Error description

• This issue was found in the Oracle env only.  In the DB2 or SQL
  server env, the issue can't be reproduced.  
  
  To reproduce :
  From TPAE 7612 IFIX IF031 --> upgrade to the 7613 IFIX IF006, 
  the Updatedb will fail with the following error : 
   false
   BEGINUPDATEDBERROR
   Product: Tivoli's process automation engine
   Error running script: HF7613_57
   UPDATEDBFILE: HF7613_57.dbc
   Script: Error
  rollback
  
  ERROR: BMXAA7025E  Script failed while running.;
  BMXAA8313E  A statement failed to execute inside a freeform
  statement. See the nested exception.;
  ORA-00904: "OAUTHACCESSTOKENDEXPDATE": invalid identifier
  ;
  ORA-00904: "OAUTHACCESSTOKENDEXPDATE": invalid identifier
  
   
    at psdi.dbmanage.ScriptRun(ScriptRun.java: 272)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  514)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  361)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  313)
   
    at psdi.tools.RunScripts(RunScripts.java: 160)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 3008)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 4712)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 5889)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 320)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 3443)
  Caused by: BMXAA8313E  A statement failed to execute inside a
  freeform statement. See the nested exception.;
  ORA-00904: "OAUTHACCESSTOKENDEXPDATE": invalid identifier
  ;
  ORA-00904: "OAUTHACCESSTOKENDEXPDATE": invalid identifier
  
   
    at psdi.dbmanage.statement.FreeFormStatement(FreeFormStatemen
  t.java:520)
   
    at psdi.dbmanage.statement.FreeFormStatement(FreeFormStatemen
  t.java:295)
   
    at psdi.dbmanage.statement.Script(Script.java: 332)
   
    at psdi.dbmanage.statement.Script(Script.java: 313)
   
    at psdi.dbmanage.ScriptRun(ScriptRun.java: 266)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  514)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  361)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  313)
   
    at psdi.tools.RunScripts(RunScripts.java: 160)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 3008)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 4712)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 5889)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 320)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 3443)
  Caused by: ORA-00904: "OAUTHACCESSTOKENDEXPDATE": invalid
  identifier
  ;
  
      at psdi.dbmanage.statement.FreeFormStatement(FreeFormStatem
  ent.java:520)
   
    at psdi.dbmanage.statement.FreeFormStatement(FreeFormStatemen
  t.java:295)
   
    at psdi.dbmanage.statement.Script(Script.java: 332)
   
    at psdi.dbmanage.statement.Script(Script.java: 313)
   
    at psdi.dbmanage.ScriptRun(ScriptRun.java: 266)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  514)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  361)
   
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  313)
   
    at psdi.tools.RunScripts(RunScripts.java: 160)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 3008)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 4712)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 5889)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 320)
   
    at psdi.tools.UpdateDB(UpdateDB.java: 3443)
  Caused by: ORA-00904: "OAUTHACCESSTOKENDEXPDATE": invalid
  identifier
  ;
  
   
  

Local fix

Problem summary

Problem conclusion

• This problem is not applicable to Manage 8.6 or 8.7, but will be
  fixed in a patch for 8.5 and in IFIXes for 7.6.1.2 and 7.6.1.3.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels