Good Morning All,
I need some help. We are using SQL stored procedures to parse an inbound XML file. This process has been working for some time and working very well. This past weekend, we installed cumulative PTF C9116730 onto our IBM I system (V7R3M0) , did not change our code base on either our SQL stored Procedures or our Web Portal. We are all of a sudden getting an CPF5035 error reason Code 20 and it is Intermittent.
CPF5035 reason code 20 -> Data Mapping Error on Member XXXXX
20 - A field that is not null capable could not be set to null
Here is my SQL Statement:
DECLARE CSR_SHIPPER CURSOR FOR
SELECT S . *
FROM
XMLTABLE ('$s' PASSING PARAMSHPMTXML as "s"
COLUMNS
SHPR_COMP_CODE CHAR (10) PATH '//ShipperCompanyCode',
SHPR_COMP_NAME CHAR (35) PATH '//ShipperCompanyName',
SHPR_ADDRESS1 CHAR (35) PATH '//ShipperAddress1',
SHPR_ADDRESS2 CHAR (35) PATH '//ShipperAddress2',
SHPR_ADDRESS3 CHAR (35) PATH '//ShipperAddress3',
SHPR_CITY CHAR (19) PATH '//ShipperCity',
SHPR_STATE CHAR (2) PATH '//ShipperState',
SHPR_ZIP_CDE CHAR (10) PATH '//ShipperZipCode',
SHPR_COUNTRY CHAR (2) PATH '//ShipperCountryCode',
SHPR_CONTACT CHAR (35) PATH '//ShipperContact',
SHPR_PHONE_NBR CHAR (12) PATH '//ShipperPhoneNumber',
SHPR_FAX_NBR CHAR (12) PATH '//ShipperFaxNumber',
SHPR_EML_ADR CHAR (50) PATH '//ShipperEmailAddress',
SHPR_REF_NBR CHAR (25) PATH '//ShipperReferenceNumber',
SHPR_ADDRESS_BOOK CHAR(5) path '//AddShipperToAddressBook'
) as S
FETCH FIRST 1 ROW ONLY;
Most Times (as an example) Shipper Address 2 tag is normally <ShipperAddress2 />
This was working before. Just checking if it could be related to the PTF load.
Thanks for your help All!
Thanks,
Steve
Steven Bennett
Senior Systems Analyst
AIT Worldwide Logistics, Inc.
Chicago, Illinois, USA
Office: +1 (630)766-8300 / Ext: 6472
Fax: +1 (630) 250-3708
www.aitworldwide.com
our people deliver.®
**********************************************************************************************************************
This electronic message transmission contains information from AIT Worldwide Logistics, Inc. and is confidential
and/or legally privileged and shall remain the property of AIT Worldwide Logistics, its subsidiaries, affiliates
and parent companies. The information is intended only for the use by the designated person(s) named above. If you
are not the intended recipient, any disclosure, copying, distribution or use of or any other action or reliance based
on the contents of this information is strictly prohibited. If you received this electronic transmission in error,
please notify the sender listed above.
Global services provided by AIT Worldwide Logistics are subject to the applicable terms and conditions published at
http://www.aitworldwide.com/terms-and-conditions.
**********************************************************************************************************************
midrange.com
