MSSQL reflection FAILS after 50 minutes

1

I have a relatively large query which keeps failing around the 50 minute mark. I dug out the stack trace and it seems to be related to the MSSQL JAR file. Here’s the error:

2019-05-16 21:04:35,368 [metadata-refresh-PDWDES] ERROR c.d.e.s.j.d.a.ArpDialect$ArpSchemaFetcher - Error retrieving all tables for PDWDES
com.microsoft.sqlserver.jdbc.SQLServerException: Parse error at line: 3, column: 20: Incorrect syntax near ‘table’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:859) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:759) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:243) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:218) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:688) ~[mssql-jdbc-7.0.0.jre8.jar:na]
at com.dremio.exec.store.jdbc.dialect.arp.ArpDialect$ArpSchemaFetcher$ArpJdbcDatasetMetadataIterable.(ArpDialect.java:90) ~[dremio-ce-jdbc-plugin-3.2.0-201905102005330382-0598733.jar:3.2.0-2019051$
at com.dremio.exec.store.jdbc.dialect.arp.ArpDialect$ArpSchemaFetcher.getTableHandles(ArpDialect.java:164) [dremio-ce-jdbc-plugin-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.store.jdbc.JdbcStoragePlugin.listDatasetHandles(JdbcStoragePlugin.java:276) [dremio-ce-jdbc-plugin-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.MetadataSynchronizer.getDatasetHandleListing(MetadataSynchronizer.java:159) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.MetadataSynchronizer.synchronizeDatasets(MetadataSynchronizer.java:175) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.MetadataSynchronizer.go(MetadataSynchronizer.java:124) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.SourceMetadataManager.refreshFull(SourceMetadataManager.java:398) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.SourceMetadataManager.doNextRefresh(SourceMetadataManager.java:301) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.SourceMetadataManager.access$400(SourceMetadataManager.java:75) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.exec.catalog.SourceMetadataManager$RefreshTask.run(SourceMetadataManager.java:498) [dremio-sabot-kernel-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.concurrent.RenamingRunnable.run(RenamingRunnable.java:36) [dremio-common-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.concurrent.SingletonRunnable.run(SingletonRunnable.java:41) [dremio-common-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.concurrent.SafeRunnable.run(SafeRunnable.java:40) [dremio-common-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at com.dremio.service.scheduler.LocalSchedulerService$CancellableTask.run(LocalSchedulerService.java:187) [dremio-services-scheduler-3.2.0-201905102005330382-0598733.jar:3.2.0-201905102005330382-0598733]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_212]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_212]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_212]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_212]

2

Hi @cramml,

Do you have an object in your database named table? Either a schema, catalog, or table?
Do you have any objects in your database that have spaces in the name as well, or possibly quotes in its identifier?

3

Hi @jduong, Thanks for the reply.

I don’t have any objects in the database named “table” I don’t know why that value is showing up in the error message.

4

If anyone has any other ideas, they will be welcomed. This problems persists.