# MSSQL reflection FAILS after 50 minutes **URL:** \ **Category:** Uncategorized\ **Created:** [May 17, 2019, 3:00pm UTC](https://community.dremio.com/t/mssql-reflection-fails-after-50-minutes/3390 "2019-05-17T15:00:07Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![cramml](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cramml/32/1667_2.png) [@cramml](https://community.dremio.com/u/cramml)\ **Post date:** [May 17, 2019, 3:00pm UTC](https://community.dremio.com/t/mssql-reflection-fails-after-50-minutes/3390/1 "2019-05-17T15:00:07Z")
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] ---
**Author:** ![jduong](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jduong/32/21_2.png) [@jduong](https://community.dremio.com/u/jduong)\ **Post date:** [May 17, 2019, 4:14pm UTC](https://community.dremio.com/t/mssql-reflection-fails-after-50-minutes/3390/2 "2019-05-17T16:14:58Z")
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? ---
**Author:** ![cramml](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cramml/32/1667_2.png) [@cramml](https://community.dremio.com/u/cramml)\ **Post date:** [May 17, 2019, 5:52pm UTC](https://community.dremio.com/t/mssql-reflection-fails-after-50-minutes/3390/3 "2019-05-17T17:52:10Z")
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. ---
**Author:** ![cramml](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cramml/32/1667_2.png) [@cramml](https://community.dremio.com/u/cramml)\ **Post date:** [May 20, 2019, 1:10pm UTC](https://community.dremio.com/t/mssql-reflection-fails-after-50-minutes/3390/4 "2019-05-20T13:10:00Z")
If anyone has any other ideas, they will be welcomed. This problems persists.