View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005958 | SymmetricDS Pro | Bug | public | 2023-08-17 19:57 | 2023-08-17 20:17 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.8 | ||||
| Target Version | 3.14.9 | Fixed in Version | 3.14.9 | ||
| Summary | 0005958: SQLServerException when using the SQL Server Azure bulk loader with Azure cloud storage | ||||
| Description | When using the SQL Server Azure bulk loader with Azure cloud storage, the below SQLServerException can occur. It attempts to run a bulk insert statement using the [table name].csv file, but in Azure cloud storage, the file's name is [table name].csv.create. Unable to run the bulk insert command against Azure. SQL executed: BULK INSERT [table name] FROM '[table name].csv' WITH (DATA_SOURCE = 'SymmetricDSExternalDataSource', FORMAT = 'CSV', FIELDQUOTE = '¿', FIELDTERMINATOR='&|*', ROWTERMINATOR='"|"', CODEPAGE='65001'); StackTraceKey.init [SQLServerException:1036296129] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot bulk load. The file "[table name].csv" does not exist or you don't have file access rights. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7785) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3793) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:775) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) at com.jumpmind.symmetric.db.bulk.b.a(MsSqlAzureBulkDatabaseWriter.java:183) at com.jumpmind.symmetric.db.bulk.a.h(CloudBulkDatabaseWriter.java:345) at com.jumpmind.symmetric.db.bulk.a.end(CloudBulkDatabaseWriter.java:226) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.end(NestedDataWriter.java:66) at org.jumpmind.symmetric.io.data.writer.TransformWriter.end(TransformWriter.java:463) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:166) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:108) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1069) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1045) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-08-17 19:57 | emiller | New Issue | |
| 2023-08-17 19:57 | emiller | Status | new => assigned |
| 2023-08-17 19:57 | emiller | Assigned To | => emiller |
| 2023-08-17 20:17 | emiller | Status | assigned => resolved |
| 2023-08-17 20:17 | emiller | Resolution | open => fixed |
| 2023-08-17 20:17 | emiller | Fixed in Version | => 3.14.9 |
| 2023-08-25 20:13 | admin | Status | resolved => closed |