PH60729: INVALID IDENTIFIER CAUSES "COULD NOT EXTRACT RESULTSET" IN DEPLOY LOGS.

APAR status

• Closed as program error.

Error description

• When viewing the deployserver log file after upgrade to 7.3.2.1,
  you see the following error message due to
  ORA-00904: "SCHEMA_NAME"."LAST_LOCKED_HEARTBEAT": invalid
  identifier.
  
  ERROR ac2017-worker-8
  com.urbancode.ds.subsys.deploy.agent.comm.netty.server.api.GetPl
  uginListApiHandler - Internal server error: ch=c0416a0c
  req=7983cd56-5abf-4ef4-b19b-951296573bb7:1
  errId=403dbf48-faee-4601-a00c-b97759063394
  message={org.hibernate.exception.SQLGrammarException: could not
  extract ResultSet}
  javax.persistence.PersistenceException:
  org.hibernate.exception.SQLGrammarException: could not extract
  ResultSet
          at
  org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionC
  onverterImpl.java:154)
          at
  org.hibernate.query.internal.AbstractProducedQuery.list(Abstract
  ProducedQuery.java:1602)
          at
  com.urbancode.ds.subsys.deploy.agent.AgentFactory.getPluginListV
  ersions(AgentFactory.java:1035)
          at
  com.urbancode.ds.subsys.deploy.agent.comm.netty.server.api.GetPl
  uginListApiHandler.transaction(GetPluginListApiHandler.java:71)
          at
  com.urbancode.ds.persistence.database.DBOperation$Proxy.transact
  ion(DBOperation.java:57)
          at
  com.urbancode.ds.persistence.database.DBOperator.runOperationInT
  x(DBOperator.java:270)
          at
  com.urbancode.ds.persistence.database.DBOperator$TxRunner.run(DB
  Operator.java:360)
          at
  java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Thre
  adPoolExecutor.java:1136)
          at
  java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Thr
  eadPoolExecutor.java:635)
          at java.base/java.lang.Thread.run(Thread.java:857)
          at
  com.urbancode.commons.util.concurrent.NamedThreadFactory$NamedTh
  read.run(NamedThreadFactory.java:37)
  Caused by: org.hibernate.exception.SQLGrammarException: could
  not extract ResultSet
          at
  org.hibernate.exception.internal.SQLExceptionTypeDelegate.conver
  t(SQLExceptionTypeDelegate.java:63)
          at
  org.hibernate.exception.internal.StandardSQLExceptionConverter.c
  onvert(StandardSQLExceptionConverter.java:42)
          at
  org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExce
  ptionHelper.java:113)
          at
  org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExce
  ptionHelper.java:99)
          at
  org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(R
  esultSetReturnImpl.java:67)
          at
  org.hibernate.loader.Loader.getResultSet(Loader.java:2303)
          at
  org.hibernate.loader.Loader.executeQueryStatement(Loader.java:20
  56)
          at
  org.hibernate.loader.Loader.executeQueryStatement(Loader.java:20
  18)
          at org.hibernate.loader.Loader.doQuery(Loader.java:948)
          at
  org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollectio
  ns(Loader.java:349)
          at org.hibernate.loader.Loader.doList(Loader.java:2849)
          at org.hibernate.loader.Loader.doList(Loader.java:2831)
          at
  org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:266
  3)
          at org.hibernate.loader.Loader.list(Loader.java:2658)
          at
  org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:
  338)
          at
  org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.j
  ava:2141)
          at
  org.hibernate.internal.AbstractSharedSessionContract.list(Abstra
  ctSharedSessionContract.java:1172)
          at
  org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryI
  mpl.java:176)
          at
  org.hibernate.query.internal.AbstractProducedQuery.list(Abstract
  ProducedQuery.java:1593)
          ... 9 more
  Caused by: java.sql.SQLSyntaxErrorException: ORA-00904:
  "SCHEMA_NAME"."LAST_LOCKED_HEARTBEAT": invalid identifier
          at
  oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509
  )
          at
  oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461
  )
          at
  oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
          at
  oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
          at
  oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
          at
  oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
  ment.java:270)
          at
  oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
  ment.java:91)
          at
  oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPr
  eparedStatement.java:807)
          at
  oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleSt
  atement.java:991)
          at
  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
  atement.java:1176)
          at
  oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
  ePreparedStatement.java:3671)
          at
  oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPrepa
  redStatement.java:1426)
          at
  oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePr
  eparedStatement.java:3718)
          at
  oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(O
  raclePreparedStatementWrapper.java:1167)
          at
  com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(Proxy
  PreparedStatement.java:52)
          at
  com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery
  (HikariProxyPreparedStatement.java)
          at
  org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(R
  esultSetReturnImpl.java:57)
          ... 23 more
  Caused by: Error : 904, Position : 34, Sql = select     0 as
  result_index,     SCHEMA_NAME.last_locked_heartbeat as
  plugin_list_version from     hlk_lock where     id = :1  union
  all select     1 as result_index,     agntmd.plugin_list_version
  as plugin_list_version from     SCHEMA_NAME.ds_agent_metadata
  agntmd     inner join SCHEMA_NAME.ds_agent agnt on agnt.id =
  agntmd.id where     agnt.endpoint_id = :2      and
  agnt.ghosted_date = 0, OriginalSql = select     0 as
  result_index,     SCHEMA_NAME.last_locked_heartbeat as
  plugin_list_version from     hlk_lock where     id = ? union all
  select     1 as result_index,     agntmd.plugin_list_version as
  plugin_list_version from     SCHEMA_NAME.ds_agent_metadata
  agntmd     inner join SCHEMA_NAME.ds_agent agnt on agnt.id =
  agntmd.id where     agnt.endpoint_id = ?     and
  agnt.ghosted_date = 0, Error Msg = ORA-00904:
  "SCHEMA_NAME"."LAST_LOCKED_HEARTBEAT": invalid identifier
  at
  oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513
  )
  ... 40 more
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DevOps Deploy Web UI Users                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Invalid identifier causes "could not extract ResultSet" in   *
  * Deploy logs.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fix is provided in IBM UrbanCode Deploy 8.0.1.1              *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 8.0.1.1
  

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

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels