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.