Qdabra Database Accelerator

Re: data conversion

brandon.gill — Fri, 19 Mar 2010 19:14:40 GMT

It appears to be the trigger on the table. If I disable the trigger then the shred is successful. Thanks for you help!

Re: data conversion

Jim Cantwell — Fri, 19 Mar 2010 18:26:23 GMT

This is probably unrelated, but based on the attached PDF, you do not have a primary key defined on the table. You have CORNO marked as the Key in mapping, so the table will need to be updated to define the primary key.

Can you attach the content of the xml which is failing ?

Re: data conversion

Jimmy — Fri, 19 Mar 2010 18:14:09 GMT

If the trigger fails, then the whole transaction will be rolled back and the insert will fail as a result. Is the trigger attempting to use the CCN field value as an int in some way?

Re: data conversion

brandon.gill — Fri, 19 Mar 2010 18:04:59 GMT

Yes, on the SQL server I have a trigger, however, the data is never inserted into the table for the trigger to fire.

Re: data conversion

ErnestoM — Fri, 19 Mar 2010 18:00:09 GMT

Do you have a trigger on the CCN field that writes the data to another table?

Re: data conversion

brandon.gill — Fri, 19 Mar 2010 17:55:22 GMT

Yes, I am sure it is the CCN field. I removed it from the mapping and the shredding/reshredding works fine. If I remove the Ledger field the shred/reshred fails. I changed the ledger from an int to a string and it still fails. I deleted the field and added a new field with a new name, remapped it and it still fails. I don't know why there would be a conversion of a string to an int happening on that field.

Re: data conversion

Jimmy — Fri, 19 Mar 2010 17:19:04 GMT

Are you entirely sure that it's not the ledger column that's causing the overflow? Is its value in any way related to the CCN field?

The maximum value for an int is 2147483647, which explains why 1234567890 works and 7430500002 doesn't.

data conversion

brandon.gill — Fri, 19 Mar 2010 17:05:28 GMT

I have a field in a form that is setup as a string type. In my database the field is an nvarchar(max). When the field is shredded to the database and contains numbers like 123457890 it works fine. When I submit the numbers 7430500002 I get the message:

The conversion of the nvarchar value '7430500002' overflowed an int column. Maximum integer value exceeded.

This is odd because no data conversion should be taking place and why is the 10 number OK for 1234567890 and not 7430500002.

Attached is a pdf with screen shots that show the DAT database mapping, IP text properties box and the SQL database table design. This is just a generic filed no rules/data validation/code/etc attached.