Frequently Asked Question
Concatenation of the string is too long.
Last Updated 8 years ago
Question:
My profile execution failed with error "Error writing data to pipe. ORA-01489: result of string concatenation is too long". What needs to done to resolve the issue?
Answer:
This is an internal oracle error. This occurs when all selected attributes are concatenated together before pushing data to pipe and when the result of the string is longer than what Oracle can handle. A2B supports and provides JDBC option of loading data into target database under profile object properties, which reads every attribute alone and individually. This is not optimal on target MPP databases like Netezza, Vertica and etc. However, it should resolve the issue.
My profile execution failed with error "Error writing data to pipe. ORA-01489: result of string concatenation is too long". What needs to done to resolve the issue?
Answer:
This is an internal oracle error. This occurs when all selected attributes are concatenated together before pushing data to pipe and when the result of the string is longer than what Oracle can handle. A2B supports and provides JDBC option of loading data into target database under profile object properties, which reads every attribute alone and individually. This is not optimal on target MPP databases like Netezza, Vertica and etc. However, it should resolve the issue.