PH39019: LOAD FAILS WITH UNMATCHED SHIFT-OUT DETECTED IN DELIMITED DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When trying to load data from a delimited dataset into a table
  in IDAA, the first 175000 rows or so was loaded but it hit an
  "unmatched shift-out detected in delimited data" error.
  Selecting with a limit of 175000 works.
  Selecting the data from the virtual table in data studio failed
  with the same mismatch error. SQL with count(*) on the number
  of records in the virtual table also failed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Load fails with unmatched shift-out     *
  *                      detected in delimited data              *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  Load fails with unmatched shift-out detected in delimited data
  

Problem conclusion

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:

Modules/Macros

• HLV$471E HLV$471M HLV$484E HLV$484M HLV$485E HLV$485M HLV$491E
  HLV$491M HLV$4A1E HLV$4A1M HLV$4A2E HLV$4A2M HLV$4A3E HLV$4A3M
  HLV$4A4E HLV$4A4M HLV$4A5E HLV$4A5M HLV$4A6E HLV$4A6M HLV$4A7E
  HLV$4A7M HLV$4A8E HLV$4A8M HLV$4A9E HLV$4A9M HLV$4B1E HLV$4B1M
  HLV$4C1E HLV$4C1M HLV$4D1E HLV$4D1M HLV$4E2E HLV$4E2M HLV$4E3E
  HLV$4E3M HLV$4F1E HLV$4F1M HLV$4F2E HLV$4F2M HLV$4F3E HLV$4F3M
  HLV$4F4E HLV$4F4M HLV$4F5E HLV$4F5M HLV$4F6E HLV$4F6M HLV$4F7E
  HLV$4F7M HLV$4F9E HLV$4F9M HLV$4FBE HLV$4FBM HLV$4FCE HLV$4FCM
  HLV$4FEE HLV$4FEM HLV$4FFE HLV$4FFM HLV$K710 HLV$K711 HLV$K712
  HLV$K840 HLV$K841 HLV$K842 HLV$K850 HLV$K851 HLV$K852 HLV$K853
  HLV$K854 HLV$K855 HLV$K856 HLV$K857 HLV$K858 HLV$K910 HLV$K911
  HLV$K912 HLV$K913 HLV$KA10 HLV$KA11 HLV$KA12 HLV$KA20 HLV$KA21
  HLV$KA22 HLV$KA23 HLV$KA30 HLV$KA31 HLV$KA40 HLV$KA41 HLV$KA42
  HLV$KA43 HLV$KA44 HLV$KA45 HLV$KA46 HLV$KA47 HLV$KA48 HLV$KA49
  HLV$KA4A HLV$KA50 HLV$KA51 HLV$KA52 HLV$KA53 HLV$KA54 HLV$KA55
  HLV$KA60 HLV$KA61 HLV$KA62 HLV$KA63 HLV$KA70 HLV$KA71 HLV$KA72
  HLV$KA73 HLV$KA74 HLV$KA80 HLV$KA81 HLV$KA82 HLV$KA83 HLV$KA84
  HLV$KA85 HLV$KA90 HLV$KA91 HLV$KA92 HLV$KA93 HLV$KA94 HLV$KB10
  HLV$KB11 HLV$KC10 HLV$KC11 HLV$KC12 HLV$KC13 HLV$KD10 HLV$KD11
  HLV$KD12 HLV$KE20 HLV$KE21 HLV$KE22 HLV$KE23 HLV$KE30 HLV$KE31
  HLV$KE32 HLV$KE33 HLV$KE34 HLV$KE35 HLV$KE36 HLV$KF10 HLV$KF11
  HLV$KF12 HLV$KF20 HLV$KF21 HLV$KF22 HLV$KF30 HLV$KF31 HLV$KF32
  HLV$KF40 HLV$KF41 HLV$KF42 HLV$KF50 HLV$KF51 HLV$KF52 HLV$KF60
  HLV$KF61 HLV$KF62 HLV$KF70 HLV$KF71 HLV$KF72 HLV$KF90 HLV$KF91
  HLV$KF92 HLV$KFB0 HLV$KFB1 HLV$KFB2 HLV$KFC0 HLV$KFC1 HLV$KFC2
  HLV$KFE0 HLV$KFE1 HLV$KFE2 HLV$KFE3 HLV$KFE4 HLV$KFE5 HLV$KFF0
  HLV$KFF1 HLVBIN   HLVSQ29D HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD
  HLVSQ2BN HLVSQ2CD HLVSQ2CN HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N
  HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD
  HLVSQLDN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI77212

     UP21/09/22 P F109

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.