SAP adapter throws “BADMSGFORMAT” error while using fixed N.x data type with JRE version 1.5.0 and transport as RV.

SAP adapter throws “BADMSGFORMAT” error while using fixed N.x data type with JRE version 1.5.0 and transport as RV.

book

Article ID: KB0094357

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for SAP Solutions -
Not Applicable -

Description

Description:
SAP adapter throws “BADMSGFORMAT” error while using fixed N.x data type with JRE version 1.5.0 and transport as RV.

Symptom:
=======
SAP adapter throws “BADMSGFORMAT” error while using fixed N.x data type with JRE version 1.5.0 and transport as RV.

Cause
====
The BW process, when using JRE 1.5, converts the data in a fixed N.M field into exponential format when the number of places after the decimal point is greater than 6 . For e.g. if the data being sent is 0.000000000, BW converts this data into 0E-9. This data is not understood by the adapter as it expects 0.000000000.

This issue occurs due to the behavior change of BigDecimal.toString method between JRE1.4 and JRE1.5.

Impact:
======
Loss of functionality.

Workaround:
=========
a) Change the data type of the Fixed N.x field to char N in designer.
b) Also, this issue does not exist with JMS transport. If feasible, please change transport to JMS.

Resolution:
=========
This issue has been fixed in TIBCO ActiveMatrix BusinessWorks™ 5.7.2.
Symptoms:

Cause:

Issue/Introduction

SAP adapter throws “BADMSGFORMAT” error while using fixed N.x data type with JRE version 1.5.0 and transport as RV.