My writer is configured as follows:
Feature operation: Insert
Table Handling: Use existing
The translation log claims that all of my features have been written, and the data inspector shows them fine, but it just won't populate my table.
Thanks!
My writer is configured as follows:
Feature operation: Insert
Table Handling: Use existing
The translation log claims that all of my features have been written, and the data inspector shows them fine, but it just won't populate my table.
Thanks!
WARN |MS SQL Server (Spatial) Writer: Could not commit row locally. Provider error 'Description: Unspecified error'. Try turning off 'Bulk Insert'
Firstly check whether the every feature follows constraints of the existing table.
e.g. "not null", "primary key", "foreign key", "unique", "check".
Takashi
Just had this. The error message didn't provide much detail into what was going on but was able to narrow it down. In my case it was a smallint (not Null) field in SQL that we were trying to pass '' (eg blank) to. @SteveAtSafe
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.