Focal Point
Insert/Update

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/9727019916

May 08, 2012, 11:42 AM
Madhumitha
Insert/Update
Hi

I am updating data from staging table to db2 table and set the target properties as "Insert/Update", If record exsits update the exsisting record
If record not exsits include the record.

But when i run the flow i am getting the below error

05/08/2012 08:35:16 (ICM18122) Request - __WCFEX (Owner: InfoBuild1) submitted.
05/08/2012 08:35:16 (ICM18742) dtravelagent_test1 type DB2 Existing target
05/08/2012 08:35:16 (ICM18429) Issuing PREPARE
05/08/2012 08:35:16 (ICM18743) Starting Load
05/08/2012 08:35:16 (ICM18682) Check set to : 0
05/08/2012 08:35:16 (FOC1400) SQLCODE IS -404 (HEX: FFFFFE6C)
05/08/2012 08:35:16 : [22001] Value for column or variable STATE too long.
05/08/2012 08:35:16 (FOC1740) EXECUTE ERROR : DTRAVELAGENT_TEST1
05/08/2012 08:35:16 (ICM18745) Commit forced at: 1 for 1 row(s)
05/08/2012 08:35:16 (ICM18041) -- stats for source file
05/08/2012 08:35:16 (ICM18516) 1 : Row(s) processed by job
05/08/2012 08:35:16 (ICM18519) 0 : Row(s) rejected due to format error
05/08/2012 08:35:16 (ICM18372) -- stats for target file: dtravelagent_test1
05/08/2012 08:35:16 (ICM18516) 1 : Row(s) processed by job
05/08/2012 08:35:16 (ICM18514) 1 : Row(s) accepted by target table
05/08/2012 08:35:16 (ICM18515) 0 : Row(s) inserted into target table
05/08/2012 08:35:16 (ICM18517) 0 : Row(s) updated in target table
05/08/2012 08:35:16 (ICM18518) 0 : Row(s) deleted from target table
05/08/2012 08:35:16 (ICM18520) 0 : Row(s) rejected due to validation errors
05/08/2012 08:35:16 (ICM18521) 0 : Row(s) rejected due to no match
05/08/2012 08:35:16 (ICM18522) 0 : Row(s) rejected because duplicate exist
05/08/2012 08:35:16 (ICM18808) 0 : Row(s) rejected due to DBMS error
05/08/2012 08:35:16 (ICM18744) Ending Load
05/08/2012 08:35:16 (ICM18040) Return Code = 1740
05/08/2012 08:35:16 (ICM18076) Request: __WCFEX - finished processing
05/08/2012 08:35:16 (ICM18007) CPU Time : 25

There is no duplicate records.

How i can fix this?

Thanks
Madhu
May 08, 2012, 02:55 PM
Dan Satchell
quote:
[22001] Value for column or variable STATE too long.

Did you verify that source values for STATE are not too long for the target column?


WebFOCUS 7.7.05
May 09, 2012, 02:22 AM
Madhumitha
Both source and target column format(A30v) is same.

if i change the target properties to delete all data and insert record from memory, its working fine all data's are inserted into the target table

for insert/update only i am getting the error

This message has been edited. Last edited by: Madhumitha,
May 09, 2012, 12:14 PM
Clif
The error is coming from the database, apparently db2, so be sure that column is actually described as VARCHAR(32).

When insert/update is used the source is matched against the key columns of the target. Is STATE one of the keys?
May 16, 2012, 11:42 PM
dhagen
Code page mismatch?


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott