Date value suppressed and not sent to the SAP

Date value suppressed and not sent to the SAP

book

Article ID: KB0073944

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for SAP Solutions 7.x, 8.x

Description

If the data type is ABAP D in the SAP system, when sending a value to the SAP, the following WARN message may capture in the TIBCO ActiveMatrix BusinessWorks™ Plug-in for SAP Solutions and IBCO ActiveMatrix® Adapter for SAP.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for SAP Solutions 8.x: 
TIBCO-BW-PALETTE-SAP-401001: Unable to convert string "<value>" to date for <type> in <type>, data suppressed. 

IBCO ActiveMatrix® Adapter for SAP 7.x: 
AER3-970526 Unable to convert string "<value>" to date for <type> in <area>, data suppressed.

Issue/Introduction

Date value suppressed and not sent to the SAP

Environment

All supported systems

Resolution

In SAP the BABP type D must be an 8 character string in the YYYYMMDD format. The TIBCO ActiveMatrix BusinessWorks™ Plug-in for SAP Solutions and BCO ActiveMatrix® Adapter for SAP use SAP JCo library to communicate with SAP. IF the data type is D, JCo will validate if the input value is valid. If the value is not in the YYYYMMDD format, JCo will return a conversion exception.

In the earlier version of the IBCO ActiveMatrix® Adapter for SAP which was developed in C++. The C++ version of the SAP Adapter used the classic RFCSDK libraries and those libraries treated date fields as characters which mean that there was no validation. In order to maintain backward compatibility and not have errors that were not seen before, The TIBCO ActiveMatrix BusinessWorks™ Plug-in for SAP Solutions and IBCO ActiveMatrix® Adapter for SAP added a Warning message and did not send the invalid date field to SAP.