Hop Version: 2.1.0 JDBC: sqljdbc_10.2.1.0 Windows Server 2016 Standard (German) Dear community, I succeeded in connecting to SQL Server 2016 with SQL Server Native connection. In Hop database explorer I can browse tables of source database. When selecting a table, eg. table "d_products" in schema "iscdwh" and Then I am asked "Do you want to include the field-names in the SQL?" > Yes An error occured: Couldn't get field info from [SELECT * from [[iscdwh]].d_products Kein schließendes Anführungszeichen nach der Zeichenfolge "[iscdwh].d_products". >>> When executing again pressing button "Preview" I get full error, see below. >>> Note: there are two opening and two closing brackets displayed in message. Please assist to get this working. Thanks and regards Stefan Full error: 2022/12/22 07:08:49 - Preview pipeline for Table input - Executing this pipeline using the Local Pipeline Engine with run configuration 'local' 2022/12/22 07:08:49 - Preview pipeline for Table input - Execution started for pipeline [Preview pipeline for Table input] 2022/12/22 07:08:49 - Table input.0 - ERROR: Unexpected error 2022/12/22 07:08:49 - Table input.0 - ERROR: org.apache.hop.core.exception.HopDatabaseException: 2022/12/22 07:08:49 - Table input.0 - An error occurred executing SQL: 2022/12/22 07:08:49 - Table input.0 - SELECT * 2022/12/22 07:08:49 - Table input.0 - FROM [[iscdwh]].d_products 2022/12/22 07:08:49 - Table input.0 - 2022/12/22 07:08:49 - Table input.0 - Kein schließendes Anführungszeichen nach der Zeichenfolge "[iscdwh].d_products 2022/12/22 07:08:49 - Table input.0 - ". 2022/12/22 07:08:49 - Table input.0 - 2022/12/22 07:08:49 - Table input.0 - at org.apache.hop.core.database.Database.openQuery(Database.java:1538) 2022/12/22 07:08:49 - Table input.0 - at org.apache.hop.pipeline.transforms.tableinput.TableInput.doQuery(TableInput.java:240) 2022/12/22 07:08:49 - Table input.0 - at org.apache.hop.pipeline.transforms.tableinput.TableInput.processRow(TableInput.java:142) 2022/12/22 07:08:49 - Table input.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:51) 2022/12/22 07:08:49 - Table input.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2022/12/22 07:08:49 - Table input.0 - Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Kein schließendes Anführungszeichen nach der Zeichenfolge "[iscdwh].d_products 2022/12/22 07:08:49 - Table input.0 - ". 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7730) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3786) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) 2022/12/22 07:08:49 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:724) 2022/12/22 07:08:49 - Table input.0 - at org.apache.hop.core.database.Database.openQuery(Database.java:1527) 2022/12/22 07:08:49 - Table input.0 - ... 4 more 2022/12/22 07:08:49 - Table input.0 - Finished reading query, closing connection. 2022/12/22 07:08:49 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2022/12/22 07:08:49 - Preview pipeline for Table input - Pipeline detected one or more transforms with errors. 2022/12/22 07:08:49 - Preview pipeline for Table input - Pipeline is killing the other transforms! 2022/12/22 07:08:49 - Preview pipeline for Table input - Pipeline duration : 0.049 seconds [ 0.049" ] 2022/12/22 07:08:49 - Preview pipeline for Table input - Execution finished on a local pipeline engine with run configuration 'local'
