IBM Support

RS01798: SQL EXCEPTION WHEN MERGING BRANCH IN DECISION CENTER

Subscribe

You can track all active APARs for this component.

 

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 number

    RS01798

  • Reported component name

    WS DECISION CTR

  • Reported component ID

    5725B6900

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-29

  • Closed date

    2014-11-05

  • Last modified date

    2014-11-05

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
08 January 2022