Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us