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>,
Windows, All Outputs
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.
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.
|Powered by Social Strata|