Support Article
Connect SQL adds 'UNKNOWN_COLUMN_0' error in clipboard
SA-30690
Summary
When using Connect-SQL to retrieve data from external HP SQL/MX non stop database, an error message is added to the Clipboard page ResultsPage.pxResults(1):
.UNKNOWN_COLUMN_0: Column number 0 has an invalid name.
SQL is executed successfully and values are mapped to the clipboard irrespective of the above message in the clipboard.
Error Messages
Error in the Clipoboard page 'UNKNOWN_COLUMN_0: Column number 0 has an invalid name.'
Steps to Reproduce
Connect to SQLMX database with a select query and the result is not populated correctly
Root Cause
A third-party product issue. as per the jdbc type 4 driver specification, getColumnLabel() should return the column name but it is not. code changes are made at engine level to retrieve column name using 'getColumnName()' if 'getColumnLabel()' returns empty.
Resolution
Apply HFIX-30295
Published November 22, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.