At least 1 NUMERIC_FORMAT option(s) must be present in this group. (BODI-1116087)

[Former Member]

Hello,

I am getting an error while developing a job using cleansing package in BODS 4.1

[EIM Transform Source:CP_Test_DataCleanse]

Option Group Error(Option Group: Date Options 😞 At least 1 NUMERIC_FORMAT option(s) must be present in this group. (BODI-1116087)

Can anyone please let me konw what is the reason behind this error?

What can be done to resolve this issue?

Thanks,

Chetan

[paula_augedahl · Accepted solution]

Chetan,

It sounds as though the Data Cleanse transform is missing an option that is required. I  would suggest importing the base DataCleanse.atl file (see KBA 1425402 - How to import base transform - Data Services) and see if that resolves the issue.

I suspect it wil take care of it.  If not, I would suggest trying to drop a new Data Cleanse transform on the dataflow and set it up and try again.

Hope this is helpful,
Paula

[Former Member · Accepted solution]

Hi Paula,

Thanks, the issue is resolved now. BODS is no longer troubling me for NUMERIC FORMAT value .

Regards,

Chetan