RS01798: SQL EXCEPTION WHEN MERGING BRANCH IN DECISION CENTER

Operational Decision Manager V8.5.1.2 Fix Pack
Operational Decision Manager V8.7.0.1 Fix Pack
Operational Decision Manager V8.7.1 Download Document
Operational Decision Manager V8.7.1 Refresh Pack
Operational Decision Manager z/OS 8.7.1.2 Fix Pack

APAR status

• Closed as program error.

Error description

• The following exception occurs when merging some branches in
  Decision Center.
  
  Caused by: java.lang.RuntimeException: java.sql.SQLException:
  DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null,
  DRIVER=3.62.56
  at
  ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.findObjec
  ts(IlrSessionFacadeImpl.java:3068)
  at
  ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.findEleme
  nts(IlrSessionFacadeImpl.java:3225)
  at
  ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.findEleme
  nts(IlrSessionFacadeImpl.java:3315)
  at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
  at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:37)
  at java.lang.reflect.Method.invoke(Method.java:611)
  at
  ilog.rules.teamserver.transaction.IlrTransactionalInvocationHand
  ler.invoke(IlrTransactionalInvocationHandler.java:35)
  at $Proxy24.findElements(Unknown Source)
  at
  ilog.rules.teamserver.model.impl.IlrAbstractSession.findElements
  (IlrAbstractSession.java:423)
  at
  ilog.rules.teamserver.model.impl.IlrAbstractCachingSession.findE
  lements(IlrAbstractCachingSession.java:199)
  at
  ilog.rules.teamserver.model.finders.Finder.doFind(Finder.java:15
  6)
  at
  ilog.rules.teamserver.model.finders.Finder.findDetails(Finder.ja
  va:72)
  at
  ilog.rules.teamserver.model.finders.DataFinder.findDetails(DataF
  inder.java:242)
  at
  ilog.rules.teamserver.ejb.service.reporting.IlrMergeReportServic
  es.findReport(IlrMergeReportServices.java:207)
  at
  ilog.rules.teamserver.ejb.service.reporting.IlrMergeReportServic
  es.generateReport(IlrMergeReportServices.java:78)
  at
  ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.generateM
  ergeReport(IlrSessionFacadeImpl.java:7991)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:60)
  at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:37)
  at java.lang.reflect.Method.invoke(Method.java:611)
  at
  ilog.rules.teamserver.transaction.IlrTransactionalInvocationHand
  ler.invoke(IlrTransactionalInvocationHandler.java:35)
  at $Proxy24.generateMergeReport(Unknown Source)
  at
  ilog.rules.teamserver.model.impl.IlrAbstractSession.generateMerg
  eReport(IlrAbstractSession.java:2072)
  at
  ilog.rules.teamserver.web.gwt.branchMerge.services.BranchMergeSe
  rviceImpl.generateReport(BranchMergeServiceImpl.java:650)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:60)
  at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:37)
  at java.lang.reflect.Method.invoke(Method.java:611)
  at
  com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.j
  ava:562)
  

Local fix

• Manually update (increase) the lenght of MERGEREPORT table's
  SOURCEBRANCH and TARGETBRANCH to same value than BASELINE.NAME
  column length
  

Problem summary

• The size of a column is too short and does not support properly
   UTF16 characters
  

Problem conclusion

• The code is 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:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R851 PSY

     UP