Database import (DBConcepts) creates wrong datatype in TIBCO BusinessEvents for data type Number(n,b) when b 0 .

Database import (DBConcepts) creates wrong datatype in TIBCO BusinessEvents for data type Number(n,b) when b 0 .

book

Article ID: KB0091128

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
Database import (DBConcepts) creates wrong datatype in TIBCO BusinessEvents for data type Number(n,b) when b > 0 .

Environment:
===========
TIBCO BusinessEvents 4.x
All Operating Systems


Symptoms:
=========
DBConcept property type incorrect in project:

database        BE
NUMBER(2)   ==> double (correct)
NUMBER(9,0) ==> double (correct)


NUMBER(9,2) ==> int (incorrect should be double)
        

Cause:
======
product issue CR BE-16951 exists.

Resolution:
========
Update the data type for the DBConcept in Studio after the import from int to double.

Issue/Introduction

Database import (DBConcepts) creates wrong datatype in TIBCO BusinessEvents for data type Number(n,b) when b 0 .