Error with "Get SQL statement" and preview from SQL Server

[Stefan Illwitzer <si...@gmx.net>]

 
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'