PH49094: DESIGN STUDIO CRASH WHEN ADAPTER COMMAND LINE LENGTH EXCEEDS 2048 CHARACTERS

APAR status

• Closed as program error.

Error description

• When using the IBM Transformation Extender (ITX) Design Studio
  and entering an adapter command line that exceeds the maximum
  allowed (2048 characters) the Design Studio may crash.  The
  adapter in use can vary, but the result is the same.
  
  For example, the following JDBC adapter command line exceeds
  2048 bytes and results in the failure:
  
  -URL jdbc:db2://127.0.0.1:60000/dlwf -USER user1 -PASSWORD
  secret -QRY "SELECT field100, field101, field102, field103,
  field104, field105, field106, field107, field108, field109,
  field110, field111, field112, field113, field114, field115,
  field116, field117, field118, field119, field120, field121,
  field122, field123, field124, field125, field126, field127,
  field128, field129, field130, field131, field132, field133,
  field134, field135, field136, field137, field138, field139,
  field140, field141, field142, field143, field144, field145,
  field146, field147, field148, field149, field150, field151,
  field152, field153, field154, field155, field156, field157,
  field158, field159, field160, field161, field162, field163,
  field164, field165, field166, field167, field168, field169,
  field170, field171, field172, field173, field174, field175,
  field176, field177, field178, field179, field180, field181,
  field182, field183, field184, field185, field186, field187,
  field188, field189, field190, field191, field192, field193,
  field194, field195, field196, field197, field198, field199,
  field200, field201, field202, field203, field204, field205,
  field206, field207, field208, field209, field210, field211,
  field212, field213, field214, field215, field216, field217,
  field218, field219, field220, field221, field222, field223,
  field224, field225, field226, field227, field228, field229,
  field230, field231, field232, field233, field234, field235,
  field236, field237, field238, field239, field240, field241,
  field242, field243, field244, field245, field246, field247,
  field248, field249, field250, field251, field252, field253,
  field254, field255, field256, field257, field258, field259,
  field260, field261, field262, field263, field264, field265,
  field266, field267, field268, field269, field270, field271,
  field272, field273, field274, field275, field276, field277,
  field278, field279, field280, field281, field282, field283,
  field284, field285, field286, field287, field288, field289,
  field290, field291, field292, field293, field294, field295,
  field296, field297, field298, field299, field300 from Test1" -TV
  -AS 0 -QTY * -LSN 0 -CHARSET UTF-8
  
  The following alternative example JDBC Adapter commaond line
  using the -QUERYFILE command parameter can be used to reduce the
  command line length to less than 2048 bytes in order to avoid
  the problem:
  
  -URL jdbc:db2://127.0.0.1:60000/dlwf -USER user1 -PASSWORD
  secret -QUERYFILE query_in_a_file.txt -TV -AS 0 -QTY * -LSN 0
  -CHARSET UTF-8
  

Local fix

• ITXCQ - ITX00061516
  PB / PB
  Circumvention: Use adapter command options to pass in file
  containing large data where this option is available (i.e. JDBC
  adapter -QUERYFILE command parameter)
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using Design Studio
  
  Problem Description:
  Design Studio crashes or hangs when the adapter command line
  exceeds the maximum allowed (2KB) in the map card settings.
  
  Platforms Affected:
  Windows
  

Problem conclusion

• Fixed a problem with Design Studio where it does not crash when
  the JDBC (or any) adapter command line exceeds the maximum
  allowed (2KB) in the map's card settings.
  
  Applies to:
  9.0.0.5, 10.0.0.0, 10.0.3.1, 10.1.0.2, 10.1.1.1
  
  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 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