RS03843: SQL EXCEPTION WITH DB2 WHEN SYNCHRONIZING A RESOURCE WITH A FQN LONGER THAN 46 CHARS

APAR status

• Closed as program error.

Error description

• During synchronization if a resource has a long name DB2 might
  throw an SQL exception during the synchronization
                              java.lang.RuntimeException:
  java.sql.SQLException: The value of a host variable in the
  EXECUTE or OPEN statement is out of range for its corresponding
  use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.61.65
  	at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.getE
  lementDetails(IlrSessionFacadeImpl.java:7704)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
  essorImpl.java:90)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
  ethodAccessorImpl.java:55)
  	at java.lang.reflect.Method.invoke(Method.java:508)
  	at ilog.rules.teamserver.transaction.IlrTransactionalInvocatio
  nHandler.invoke(IlrTransactionalInvocationHandler.java:107)
  	at com.sun.proxy.$Proxy171.getElementDetails(Unknown Source)
  	at ilog.rules.teamserver.model.impl.IlrAbstractSession.getElem
  entDetails(IlrAbstractSession.java:2117)
  	at ilog.rules.teamserver.model.dataaccess.SignatureProvider.in
  itDetailsFromUuid(SignatureProvider.java:489)
  	at ilog.rules.teamserver.model.dataaccess.SignatureProvider.fe
  tchSignatures(SignatureProvider.java:353)
  	at ilog.rules.model.dataaccess.RuleModelDataAccess.fetchSignat
  ures(RuleModelDataAccess.java:128)
  	at ilog.rules.model.dataaccess.RuleModelDataAccess.readData(Ru
  leModelDataAccess.java:213)
  	at ilog.rules.synchronization.endpoint.remote.server.UpdateHan
  dler.process(UpdateHandler.java:40)
  	at ilog.rules.synchronization.endpoint.remote.server.UpdateHan
  dler.process(UpdateHandler.java:24)
  	at ilog.rules.synchronization.endpoint.remote.server.MessageHa
  ndlerFactory.process(MessageHandlerFactory.java:84)
  	at ilog.rules.teamserver.web.servlets.RtsSyncServlet.doPost(Rt
  sSyncServlet.java:203)
  

Local fix

• rename the resource so that the name is less than 46 characters
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users synchronizing resources with DB2 database.             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * During synchronization if a resource has a long name DB2     *
  * might                                                        *
  * throw an SQL exception during the synchronization            *
  *                             java.lang.RuntimeException:      *
  * java.sql.SQLException: The value of a host variable in the   *
  * EXECUTE or OPEN statement is out of range for its            *
  * corresponding                                                *
  * use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.61.65           *
  * 	at                                                          *
  * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.getE  *
  * lementDetails(IlrSessionFacadeImpl.java:7704)                *
  * 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native      *
  * Method)                                                      *
  * 	at                                                          *
  * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc  *
  * essorImpl.java:90)                                           *
  * 	at                                                          *
  * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM  *
  * ethodAccessorImpl.java:55)                                   *
  * 	at java.lang.reflect.Method.invoke(Method.java:508)         *
  * 	at                                                          *
  * ilog.rules.teamserver.transaction.IlrTransactionalInvocatio  *
  * nHandler.invoke(IlrTransactionalInvocationHandler.java:107)  *
  * 	at com.sun.proxy.$Proxy171.getElementDetails(Unknown        *
  * Source)                                                      *
  * 	at                                                          *
  * ilog.rules.teamserver.model.impl.IlrAbstractSession.getElem  *
  * entDetails(IlrAbstractSession.java:2117)                     *
  * 	at                                                          *
  * ilog.rules.teamserver.model.dataaccess.SignatureProvider.in  *
  * itDetailsFromUuid(SignatureProvider.java:489)                *
  * 	at                                                          *
  * ilog.rules.teamserver.model.dataaccess.SignatureProvider.fe  *
  * tchSignatures(SignatureProvider.java:353)                    *
  * 	at                                                          *
  * ilog.rules.model.dataaccess.RuleModelDataAccess.fetchSignat  *
  * ures(RuleModelDataAccess.java:128)                           *
  * 	at                                                          *
  * ilog.rules.model.dataaccess.RuleModelDataAccess.readData(Ru  *
  * leModelDataAccess.java:213)                                  *
  * 	at                                                          *
  * ilog.rules.synchronization.endpoint.remote.server.UpdateHan  *
  * dler.process(UpdateHandler.java:40)                          *
  * 	at                                                          *
  * ilog.rules.synchronization.endpoint.remote.server.UpdateHan  *
  * dler.process(UpdateHandler.java:24)                          *
  * 	at                                                          *
  * ilog.rules.synchronization.endpoint.remote.server.MessageHa  *
  * ndlerFactory.process(MessageHandlerFactory.java:84)          *
  * 	at                                                          *
  * ilog.rules.teamserver.web.servlets.RtsSyncServlet.doPost(Rt  *
  * sSyncServlet.java:203)                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The code has been fixed.
  

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

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels