IBM Support

IT00358: FAULTING APPLICATION ANSERVER.EXE, VERSION 5.2.0.22, FAULTING MODULE KERNEL32.DLL, VERSION 5.2.3790.5069

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

  • Increased db activity, including failed Inserts to tables,
causing ANserver to crash. Surrounding context is Lookup_tb
insert and truncation of Notification: String or binary data
would be truncated. in function AddNotifyLogEntry

Local fix

  • STRRTC 412386
MAH/MAH
Circumvention: None

Problem summary

  • Customers running GSW 5.2, 5.3, & 5.3.1

3-1-203 'PK_Lookup_tb'. Cannot insert duplicate key in object
'dbo.Lookup_tb'.

Problem conclusion

  • Resolution Summary:

This is a mapping issue and the customer will need to fix their
map.  As a fix for this we are providing
a more informative error message that will precede the ODBC
error in this case that will tell the customer that they are
either trying to create a primary key in the lookup_tb that
already exists.  Or that they are trying to perform an update
on one of the primary key fields in the table.  As part of the
update error we will display the key value as it is and the
new value they are trying to insert as part of the update.  The
two new error messages are displayed below

Insert Into Lookup Table: "Primary Key already exists in
Lookup_tb, exiting insert: PartnerKey = %s, TableName = %s,
Item = %s", LookUp.m_PartnerKEY, LookUp.m_TableName,
LookUp.m_Item

Update Lookup Table:  "Cannot perform an update on the Primary
key fields in Lookup_tb. PartnerKey = %s, update value = %s,
TableName = %s, update value = %s, Item = %s, update value =
%s", PrtnrKEY, LookUp.m_PartnerKEY, TableName,
LookUp.m_TableName,
Code, LookUp.m_Item

Delivered In:
5.2.0.26
5.3.0.8
5.3.1.4

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT00358
    • 

  • Reported component name
    STR GENTRAN MS
    • 

  • Reported component ID
    5725D0903
    • 

  • Reported release
    520
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-03-17
    • 

  • Closed date
    2014-08-27
    • 

  • Last modified date
    2014-08-27
    • 





    

  • 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 GENTRAN MS
    • 

  • Fixed component ID
    5725D0903
    • 



Applicable component levels


    

  • R520  PSY
       UP
    • 

  • R530  PSY
       UP
    • 

  • R531  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS6V3G","label":"Sterling Gentran:Server for Microsoft Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2","Edition":"","Line of Business":{"code":"","label":""}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            27 August 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback