IBM Support

IT30220: AFTER ORACLE FAILOVER THE TABLE FG_EVENT IS NOT POPULATED

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • After Oracle failover the table FG_EVENT is not populated

Local fix

  • 



Problem summary


    

  • Users Affected:

Sterling File Gateway




Problem Description:

Sterling File Gateway event details are missing after a DB
failover, FG_EVENTS are missing.  Log errors and possible stack
traces might include the following:

[2019-11-20 14:12:55.116] ERROR EventWorkerBatchedBase.run() ?
Event Worker is ending and will be restarted





[2019-11-20 14:12:55.116] ERROR [XAHelper].getNonXAConnection:
Connection is bad

[2019-11-20 14:12:55.116] ERROR 000310100301
UTIL.FRAME_JDBC.ERR_XAHelper_getNonXAConnection1
XAHelper.getNonXAConnection failed trying to create XAResource
for: mssqlPool

[2019-11-20 14:12:55.116] ERROR [XAHelper].getNonXAConnection:
Connection is bad

[2019-11-20 14:12:55.116] ERROR 000310100301
UTIL.FRAME_JDBC.ERR_XAHelper_getNonXAConnection1
XAHelper.getNonXAConnection failed trying to create XAResource
for: mssqlPool

[2019-11-20 14:12:55.116] ERROR 000110020217
WORKFLOW.QUEUE.ERR_BasicExecutor_uncaughtException Thread
filegateway.eventworker.2 died, exception was:

[2019-11-20 14:12:55.116] ERROR [1574277175116]Error description
not available

[2019-11-20 14:12:55.116] ERRORDTL [1574277175116]<?xml
version="1.0" encoding="UTF-8"?>

                                                <Errors>


<Error
ErrorCode="com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCCo
nnectionException"


ErrorDescription="Error description not available"
ErrorRelatedMoreInfo="">


<Attribute Name="ErrorCode"
Value="com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCConnec
tionException"/>


<Attribute Name="ErrorDescription" Value="Error description not
available"/>


<Error
ErrorCode="com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCCo
nnectionException"


ErrorDescription="" ErrorRelatedMoreInfo="IO Error: Connection
Reset">


<Stack>java.sql.SQLRecoverableException: IO Error: Connection
Reset


at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPrepar
edStatement.java:967)


at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
atement.java:1150)


at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
ePreparedStatement.java:4798)


at oracle.jdbc.driver.
OraclePreparedStatement.execute(OraclePreparedStatement.java:490
1)


at oracle.jdbc.driver.
OraclePreparedStatementWrapper.execute(OraclePreparedStatementWr
apper.java:1385)


at
com.yantra.ycp.core.YCPConnHolder.setInitialState(YCPConnHolder.
java:187)


at
com.yantra.ycp.core.YCPConnHolder.initializeConnection(YCPConnHo
lder.java:137)


at
com.yantra.ycp.core.YCPConnHolder.getConnection(YCPConnHolder.ja
va:340)


at
com.yantra.ycp.core.YCPMultiConnHolder.getConnection(YCPMultiCon
nHolder.java:113)


at
com.yantra.ycp.core.YCPContext.getConnection(YCPContext.java:179
)


at
com.sterlingcommerce.fg.visibility.evf.EventWorkerBatchedBase.ha
ndleBatch(EventWorkerBatchedBase.java:161)


at
com.sterlingcommerce.fg.visibility.evf.EventWorkerBatchedBase.ru
n(EventWorkerBatchedBase.java:148)


at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
utor.java:1160)


at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
cutor.java:635)


at java.lang.Thread.run(Thread.java:812)













[2019-11-20 14:12:55.116] ERROR [XAHelper].getNonXAConnection:
Connection is bad

[2019-11-20 14:12:55.116] ERROR 000310100301
UTIL.FRAME_JDBC.ERR_XAHelper_getNonXAConnection1
XAHelper.getNonXAConnection failed trying to create XAResource
for: mssqlPool

[2019-11-20 14:12:55.116] ERROR [XAHelper].getNonXAConnection:
Connection is bad

[2019-11-20 14:12:55.116] ERROR 000310100301
UTIL.FRAME_JDBC.ERR_XAHelper_getNonXAConnection1
XAHelper.getNonXAConnection failed trying to create XAResource
for: mssqlPool

[2019-11-20 14:12:55.116] ERROR 000110020217
WORKFLOW.QUEUE.ERR_BasicExecutor_uncaughtException Thread
filegateway.eventworker.2 died, exception was:

[2019-11-20 14:12:55.116] ERROR [1574277175116]Error description
not available

[2019-11-20 14:12:55.116] ERRORDTL [1574277175116]<?xml
version="1.0" encoding="UTF-8"?>

                                                <Errors>


<Error
ErrorCode="com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCCo
nnectionException"


ErrorDescription="Error description not available"
ErrorRelatedMoreInfo="">


<Attribute Name="ErrorCode"
Value="com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCConnec
tionException"/>


<Attribute Name="ErrorDescription" Value="Error description not
available"/>


<Error
ErrorCode="com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCCo
nnectionException"


ErrorDescription=""
ErrorRelatedMoreInfo="com.sterlingcommerce.woodstock.util.frame.
jdbc.JDBCConnectionException:


com.microsoft.sqlserver.jdbc.SQLServerException: The connection
is closed.">


<Stack>com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCConnec
tionException:


com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCConnectionExc
eption: com.microsoft.sqlserver.jdbc.SQLServerException:


The connection is closed.


at
com.sterlingcommerce.woodstock.util.frame.jdbc.NoAppVendor.getNo
AppConnection(NoAppVendor.java:120)


at
com.sterlingcommerce.woodstock.util.frame.jdbc.NoAppVendor.getTr
ansactionalConnection(NoAppVendor.java:29)


at
com.sterlingcommerce.woodstock.util.frame.jdbc.AbstractVendor.ge
tConnection(AbstractVendor.java:39)


at
com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService
.getConnection(ConnectionService.java:249)


at
com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService
.getConnection(ConnectionService.java:773)


at
com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCService.getCo
nnection(JDBCService.java:231)


at
com.yantra.interop.util.TransactionWrapper.getConnection(Transac
tionWrapper.java:102)


at
com.yantra.ycp.core.YCPConnHolder.createConnection(YCPConnHolder
.java:268)


at
com.yantra.ycp.core.YCPConnHolder.initializeConnection(YCPConnHo
lder.java:135)


at
com.yantra.ycp.core.YCPConnHolder.getConnection(YCPConnHolder.ja
va:340)


at
com.yantra.ycp.core.YCPMultiConnHolder.getConnection(YCPMultiCon
nHolder.java:113)


at
com.yantra.ycp.core.YCPContext.getConnection(YCPContext.java:179
)


at
com.sterlingcommerce.fg.visibility.evf.EventWorkerBatchedBase.ha
ndleBatch(EventWorkerBatchedBase.java:160)


at
com.sterlingcommerce.fg.visibility.evf.EventWorkerBatchedBase.ru
n(EventWorkerBatchedBase.java:147)


at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
utor.java:1157)


at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
cutor.java:627)


at java.lang.Thread.run(Thread.java:798)



Platforms Affected:

ALL

    



Problem conclusion


    

  • Resolution Summary:
A code fix is provided.
Corrected database exceptions with event queue worker
threads.



Delivered in:

6000303

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT30220
    • 

  • Reported component name
    STR B2B INTEGRA
    • 

  • Reported component ID
    5725D0600
    • 

  • Reported release
    526
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-09-13
    • 

  • Closed date
    2020-11-11
    • 

  • Last modified date
    2020-11-13
    • 





    

  • 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
    STR B2B INTEGRA
    • 

  • Fixed component ID
    5725D0600
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            16 November 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback