Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Insert/Update
 Login/Join
 
Gold member
posted
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
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
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,
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
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?
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Code page mismatch?


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1096 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.