- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
FDMEE - SQL Mapping Script ICP
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:
(There are two _ _ underscores)
My mapping script is doing the following (shorted version)
WHEN RIGHT(ICP,1) = '_' THEN ENTITYX
WHEN RIGHT(ICP,6) = 152010 THEN '7177'
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.