IT47113: 'STRING DATA, RIGHT TRUNCATION' ERROR WHILE INVOKING SQL SERVER STORED PROCEDURE

APAR status

• Closed as program error.

Error description

• Invoking a Microsoft SQL Server stored procedure with an INOUT
  parameter by passing a NULL value from a Compute Node can result
  in a '[Microsoft][SQL Server Native Client 11.0] String data,
  right truncation' error.
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM App Connect Enterprise V12.0 and V13.0 using
  the Microsoft SQL Server stored procedure with an INOUT
  parameter.
  
  
  Platforms affected:
  LinuxX64, LinuxPPCLE64, AIX, LinuxZ64
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  Invoking a Microsoft SQL Server stored procedure with an INOUT
  parameter by passing a NULL value from a Compute Node may result
  in a '[Microsoft][SQL Server Native Client 11.0] String data,
  right truncation' error.
  

Problem conclusion

• The product now correctly invokes the Microsoft SQL Server
  stored procedure that includes an INOUT parameter.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version   Maintenance Level
  v12.0      12.0.12.12
  v13.0      13.0.3.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

• 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

  APP CONNECT ENT

• Fixed component ID

  5724J0570

Applicable component levels