IBM Support

PH45288: UNABLE TO CALL A MS SQL SERVER STORED PROCEDURE WITH ARGUMENT DEFINED AS VARBINARY DATATYPE AND DATA > 8000 BYTES

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

  • The IBM Transformation Extender (ITX) 10.0 and 10.1 Database
adapter (ODBC) fails to call a MicroSoft SQL Server Stored
Procedure when one of the datatypes is VARBINARY and the data
passed to this exceeds 8000 bytes. The VARBINARY column is set
to MAX.

The following error is found in the ITX database adapter trace
file:

<31905-1043865984-Tue Nov 9 11:42:30 2021>: Error in SQLExecute
Message: [Microsoft][ODBC Driver 17 for SQL Server]String data,
right truncation
SQL State: 22001

Local fix

  • ITXCQ - ITX00061321
PB / PB
Circumvention: None

Problem summary

  • Users Affected:
IBM Transformation Extender users inserting data of size >8000
into varbinary datatype of MS sql server table.

Problem Description:
Using the ODBC adapter, a map fails with the error message as
before - "String data, right truncation"

Platforms Affected:
All Unix

Problem conclusion

  • Fixed a problem with ODBC adapter and large data.

Applies to:
10.0.0.0, 10.0.3.0, 10.1.0.1, 10.1.1.0

Fixed in the next service packs and releases.

To obtain the fix for this APAR:

To see if the next service pack or product release is available,
check the IBM Transformation Extender Release Notes page:
https://www.ibm.com/support/docview.wss?uid=swg27008337

If the service pack or product release is available, download it
from Fix Central:
http://www.ibm.com/support/fixcentral/

If the service pack or product release is not available and you
require the APAR fix immediately, request a Limited Availability
Interim Fix (LAIF) by opening a case:
https://www.ibm.com/mysupport/

Prior to version 9.0.0, IBM Transformation Extender was called
IBM WebSphere Transformation Extender.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH45288
    • 

  • Reported component name
    ITX
    • 

  • Reported component ID
    5724Q2300
    • 

  • Reported release
    A10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-03-30
    • 

  • Closed date
    2022-05-26
    • 

  • Last modified date
    2022-10-05
    • 





    

  • 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
    ITX
    • 

  • Fixed component ID
    5724Q2300
    • 



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSVSD8","label":"Transformation Extender"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            05 October 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback