Skip to main content
Question

AZURE SQL non-spatial writing problems

D
Forum|alt.badge.img

Hi!

I am trying to write to a AZURE SQL non-spatial database, but I received the below error for just one of my layers.

"Microsoft Azure SQL Database Non-Spatial Writer: Failed to write a feature of type `dbo.door' to the database. Provider error `(-2147217887) Invalid character value for cast specification'. SQL Command `INSERT INTO dbo.[door] ([id], [category], [restriction], [ordinal], [name], [alias], [address_id]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'"

I've checked the datatypes to see if they match and they do along with the attributes. Could this be a geometry issue? I do not know what else to check for.

Thank you for any assistance!

David

3 replies

ravenkopelman
Safer
Forum|alt.badge.img+1
A workspace that showed the schema of the table being created plus a single sample feature that causes the error would be very helpful. Also curious if the JDBC non-spatial writer (available in FME 2018.1) does any better.

 

 

D
Forum|alt.badge.img
ravenkopelman wrote:
A workspace that showed the schema of the table being created plus a single sample feature that causes the error would be very helpful. Also curious if the JDBC non-spatial writer (available in FME 2018.1) does any better.

 

 

The problem has been resolved. I ended up testing by using the attributes that were already in the database to see if they could be written into the database, which they did. I then was able to find the problem child by changing each field and testing the upload. I think what the problem was there was an extra space at the end of the id field, which uses an UUID. When I added a new UUID, it went through.

 

 

Could an extra space at the end of the UUID code have caused the problem of not being entered into the SQL database?

 

 

I also tried the JDBC non-spatial writer and it did not resolve the error. I received an error code stating "SQL database Conversion failed when converting from a character string to uniqueidentifier."

 

 

Thanks,

 

David

 

ravenkopelman
Safer
Forum|alt.badge.img+1
david_prosack88 wrote:
The problem has been resolved. I ended up testing by using the attributes that were already in the database to see if they could be written into the database, which they did. I then was able to find the problem child by changing each field and testing the upload. I think what the problem was there was an extra space at the end of the id field, which uses an UUID. When I added a new UUID, it went through.

 

 

Could an extra space at the end of the UUID code have caused the problem of not being entered into the SQL database?

 

 

I also tried the JDBC non-spatial writer and it did not resolve the error. I received an error code stating "SQL database Conversion failed when converting from a character string to uniqueidentifier."

 

 

Thanks,

 

David

 

Yes, the extra space may have done it. Sorry for the trouble; we'll think about whether we can do better client side sanitizing in the future.

Reply


Helpful Members This Week

Community Stats

31,105
Posts
117,928
Replies
38,858
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.