- UNIFYBroker Forum
-
Bugs
Invalid column name for DB Connector when the column name has a hyphen
I have configured an IdB 5.0.4 DB connector for a SQL table. It is complaining about a column with a "-" in the name:
"Invalid column name 'NUWorkflow'. Invalid column name 'GUID'."
In fact the column name is 'NUWorkflow-GUID' which has been successfully identified by the schema retrieval.
Answer
Hi Carol,
Could you be more specific about it complaining? Which operation is failing and where is the error displayed? I've just tested this locally with a SQL table containing the column [NUWorkflow-GUID] and was able import entities up to the adapter level and then fetch them via LDAP.
It's when I try to run a Full Import of the connector. The error is displayed in the IdB UI, on the connector page.
Thanks for the clarification. As I said I can't reproduce this locally, and I can't even find the error message anywhere in the source code. Does the error appear in the logs as well? Could you please attach part or all of the relevant logs, or barring that a screenshot/photo of the error on the UI?
My mistake! I also used the column name in the WHERE clauses and didn't put square brackets around it. Thanks for testing!
Customer support service by UserEcho
My mistake! I also used the column name in the WHERE clauses and didn't put square brackets around it. Thanks for testing!