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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Data Migrator Won't Update SQL Server Table

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Data Migrator Won't Update SQL Server Table
 Login/Join
 
RMM
Silver Member
posted
I very much doubt anyone will be able to help me with this issue, but it's worth a shot.

I have a table, we will call it Rebate table, in SQL Server that doesn't want to get updated. I have a process flow in Data Migrator that takes a few staging tables and combines them to create the Rebate table. The staging tables have the correct data. When I run the query that builds the Rebate table in a SQL Server instance, it provides the correct results, but when you look at the Rebate table in its current state it shows incomplete data. The process flow to build this Rebate table is in a flow that truncates the table before it inserts records from memory. I am not sure why table can't get updated. It does have an index, but I disabled it and tried to then update it, but that didn't work also. The log files don't say much either

I'm am stumped as of right now and any help would be appreciate. Has anyone ever run into something similar to this?

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows, All Outputs
 
Posts: 47 | Registered: February 02, 2016Report This Post
Marina
Silver Member
posted Hide Post
Hello,
Have you tried a different load method, such as 'insert/update' for example, to test your results?
There might be a few reasons why the Rebate table is not updated. Please open a hottrack case for your problem, and upload your flow (.fex file) and the related synonyms (.acx and .mas files) to the case. Our Customer Support team will be able then to perform a better analysis and to provide a solution to your problem.

Thanks.
 
Posts: 37 | Registered: February 13, 2007Report This Post
Clif
Guru
posted Hide Post
There's not much to go on here without the log. The log for the flow should contain an error message from SQL Server.

Without the log we can only guess. However when you use insert record from memory if there are any constraint violations, not just unique index but also not null or any user constraints, then the entire block is rejected.

As Marina suggests testing with load type insert/update may be helpful since then processing is a row-at-a-time.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Data Migrator Won't Update SQL Server Table

Copyright © 1996-2020 Information Builders