Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDMEE - SQL Mapping Script ICP

athlon007Sep 11 2019 — edited Sep 13 2019

Hello,

I have following issue on source data and a mapping I have done. I hope you can help me with it.

I have the source ICP coming in as below:

52100010__60052

(There are two _ _ underscores)

My mapping script is doing the following (shorted version)

CASE

WHEN RIGHT(ICP,1) = '_' THEN ENTITYX

WHEN RIGHT(ICP,6) = 152010 THEN '7177'

ELSE ENTITYX

END

Now I would expect that the ELSE is going into effect, but I am gettin an error as per below:

FATAL AIF : Error in CommMap update TDATASET_T_TDATASEGW Traceback (most recent call last): File "<string>", line 1688, in update TDATASEG_T_TDATASEGW SQLDataException: java.sql.SQLDATAExceptio: [FMWGEN][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the nvarchar value '_60052' to data type int.

Can anybody help me with this error? I guess the SQL script should be amended somehow?

I would appreciate any help.

Thanks alot

Roman

This post has been answered by user6692921 on Sep 12 2019

Jump to Answer

Added on Sep 11 2019

#business-intelligence-applications, #financial-data-management, #performance-management-applications, #sql

2 comments

474 views