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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Data Migrator Won't Update SQL Server Table
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Data Migrator Won't Update SQL Server Table
 Login/Join
 
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, 2016Reply With QuoteReport This Post
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: 32 | Registered: February 13, 2007Reply With QuoteReport This Post
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.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.