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!
Writing to existing SQL Server table
Hello. I have a workbench that reads an XML and splits it into attributes with their values (with one spatial attribute). I am trying to write this data to an existing, empty SQL Server table. If I set the writer to create a new table, it runs fine, but I can't seem to get it to populate my existing table. The workspace runs, and passes with warnings, but when I go to my SQL Server table it is still empty. Any ideas?
the first warning i get is this:
WARN |MS SQL Server (Spatial) Writer: Could not commit row locally. Provider error 'Description: Unspecified error'. Try turning off 'Bulk Insert'
Userlevel 2
+17
- Contributor
- 7538 replies
-
27 June 2015
Hi,
Firstly check whether the every feature follows constraints of the existing table.
e.g. "not null", "primary key", "foreign key", "unique", "check".
Takashi
Userlevel 1
+12
- Contributor
- 218 replies
-
9 November 2016
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
+3
- Contributor
- 109 replies
-
29 September 2021
Just had the same issue. Turned out I had a value > 1000 when the field was set as numeric 5.2. Changed it to numeric 7.2, and the error message no longer occurred.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.