Frequently Asked Question
Stage table update failed on Netezza
Last Updated 9 years ago
Question:
I ran a profile targeting Netezza database stage object and load failed. Error message from the log file is "Stage update failed. ERROR: (2) This form of correlated query is not supported - consider rewriting". What could be the reason?
Answer:
This error occurs when the hash table is not in sync with the source/target object primary keys. Please make sure that the hash table contains the correct attributes for the primary key.
I ran a profile targeting Netezza database stage object and load failed. Error message from the log file is "Stage update failed. ERROR: (2) This form of correlated query is not supported - consider rewriting". What could be the reason?
Answer:
This error occurs when the hash table is not in sync with the source/target object primary keys. Please make sure that the hash table contains the correct attributes for the primary key.