IJ45611: IN A CASE SENSITIVE DATABASE, IFACETABLECONSUMER THROWS SQL ERROR WHEN ENTERPRISESERVICE PARAMETER IN THE CRONTASK IS SET TO ENT

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  
  In case sensitive database, IFACETABLECONSUMER throws SQL error
  when ENTERPRISESERVICE parameter in the crontask is set to
  enterprise service name.
  
  Invalid object name 'TESTIFACE'.
  com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object
  name 'TESTIFACE'.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromData
  baseError(SQLServerException.java:262)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResul
  t(SQLServerStatement.java:1624)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doEx
  ecutePreparedStatement(SQLServerPreparedStatement.java:594)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$Prep
  StmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.jav
  a:7194)
  
  System Information:
  
  IBM Tpae Integration Framework 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In case sensitive database, IFACETABLECONSUMER throws SQL    *
  * error when ENTERPRISESERVICE parameter in the crontask is    *
  * set to                                                       *
  * enterprise service name.                                     *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.x Product
  

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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels