IBM Support

IT15008: CONNECT DIRECT SESSION CREATES DUPLICATE ROWS IN ARCHIVE_INFO AND ACT_SESSION TABLES FOR THE SAME WF_ID / SESSION_ID

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.

Direct links to fixes

Media_IM_5020601_7
Media_IM_5020601_7
Media_IM_5020601_7
Media_IM_5020601_7
si_52_build_5020500_interimfix_13
si_52_build_5020500_interimfix_13
si_52_build_5020500_interimfix_13

 

APAR status

  • Closed as program error.

Error description

  • Duplicate rows are created for visibility ACT_SESSION and
ARCHIVE_INFO database tables, which then causes an ORA-00001
database error when Connect Direct sends two files in one
session.

Local fix

  • STRRTC - 495643
LB / AC
Circumvention: No workaround available

Problem summary

  • Users Affected:
All

Problem Description:
The visibility log reports
"SQLIntegrityConstraintViolationException: ORA-00001:
Violation of UNIQUE constraint (OWNER_SFT.ACT_SESSION_PK)"
during some CDSA SNODE sessions.

Platforms Affected:
All

Problem conclusion

  • Resolution Summary:
A code fix is provided.

Delivered In:
5020500_13
5020603
5020601_7
5020602_4

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT15008
    • 

  • Reported component name
    STR B2B INTEGRA
    • 

  • Reported component ID
    5725D0600
    • 

  • Reported release
    525
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2016-04-28
    • 

  • Closed date
    2016-05-26
    • 

  • Last modified date
    2017-05-14
    • 





    

  • 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


    

  • R525  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            14 May 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback