Error -2147217887 "Multiple-step OLE DB operation generated errors" [RESOLVED]
S
Suzy Davis
started a topic
over 9 years ago
Site using apps Engine with the 'write to SQL DB' function produces this error intermittently.
Tried to replicate it a few times, on different PCs, but all seemed to be writing to the SQL DB and the local Excel register.
I googled, and while there were some suggestions that the error might be caused by empty fields (null values) being passed - I didn't want to muck around with the code unless I could replicate the error.
I then found a post that suggested the error could be caused by the length of string being written to the DB.
Ran another proposal with a long title (over 50 characters) - got the error. Yay.
I checked with the DB guy and all string fields were set to a maximum of 50 characters. The proposal title field on this occasion was over 50 - so we changed all 'Document Informtion' fields to MAX in the DB.
Suzy Davis
Site using apps Engine with the 'write to SQL DB' function produces this error intermittently.
Tried to replicate it a few times, on different PCs, but all seemed to be writing to the SQL DB and the local Excel register.
I googled, and while there were some suggestions that the error might be caused by empty fields (null values) being passed - I didn't want to muck around with the code unless I could replicate the error.
I then found a post that suggested the error could be caused by the length of string being written to the DB.
Ran another proposal with a long title (over 50 characters) - got the error. Yay.
I checked with the DB guy and all string fields were set to a maximum of 50 characters. The proposal title field on this occasion was over 50 - so we changed all 'Document Informtion' fields to MAX in the DB.
Tested - no error.