Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
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: 53 | Registered: September 30, 2008Report 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, 2007Report 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: 53 | Registered: September 30, 2008Report 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?


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report 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: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders