telosystools

Open full view…

Cannot get tables from meta-data !

esper
Thu, 29 Oct 2015 17:54:57 GMT

I'm having trouble generating my repository. I've entered in all of the necessary database details in the "Configuration" tab and everything tests successfully "OK". However, when I click on the "Meta-data" tab and hit the "Get schemas" button (or any other button), I get the following error: Cannot get tables from meta-data ! Exception com.microsoft.sqlserver.jdbc.SQLServerException : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. What could be the issue here? I'm connecting to a SQL Server database (10.50.6000) using the 4.2.6420.100 driver version. Any help would be appreciated.

Telosys Team
Fri, 30 Oct 2015 09:32:50 GMT

There's probably a peculiarity with SQL Server and JDBC meta-data to retieve the Schemas list. If you don't have Catalog or Schema just input "!" in the Catalog/Schema fields in the GUI. If you know what Schema you want to use input the schema name in the "Schema" field and try "Get tables" to retrieve all the tables belonging to this schema

esper
Fri, 30 Oct 2015 13:23:23 GMT

Thanks - that worked!