https://stackoverflow.com/questions/39894654/prepared-statement-error-java-sql-sqlexception-parameter-index-out-of-range-1
[ https://www.bizcubed.com.au/ | ] Diego Mainou Product Manager M. +61 415 152 091 E. [ mailto:[email protected] | [email protected] ] [ https://www.bizcubed.com.au/ | www.bizcubed.com.au ] [ https://www.bizcubed.com.au/ | ] From: "Rob Burgess" <[email protected]> To: "users" <[email protected]> Sent: Monday, 25 September, 2023 7:14:32 AM Subject: The index 1 is out of range error Hi I'm trying to import data from a CSV file into a SQL Server 2022 table. My PDI 9.3 transformation works without error using a CSV file import and Table output action. Using the same settings in HOP 2.5.0 (2023-06-08 07.58.35) I get these errors and no data imports: 2023/09/25 09:43:59 - Insert products.0 - Error setting value #1 [String(75)<binary-string>] on prepared statement 2023/09/25 09:43:59 - Insert products.0 - The index 1 is out of range. 2023/09/25 09:43:59 - Insert products.0 - 2023/09/25 09:43:59 - Insert products.0 - 2023/09/25 09:43:59 - Insert products.0 - 2023/09/25 09:43:59 - Insert products.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.writeToTable(TableOutput.java:383) 2023/09/25 09:43:59 - Insert products.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.processRow(TableOutput.java:117) 2023/09/25 09:43:59 - Insert products.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) 2023/09/25 09:43:59 - Insert products.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2023/09/25 09:43:59 - Insert products.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: How do I resolve this issue? Thanks Rob
