Wiki

Scale Your Enterprise

User Tools

Site Tools


kb:kb_item_274

KB Item 274

Product

SAP BUSINESS ONE

Product Version (if applicable)

None Defined

Issue

Unable to insert records into table/perform table updates

Symptom

Internal error occurred (245) [Message 131-183]

Cause

SQL Data Type Conversion Error

Resolution Notes

This issue is commonly caused by SQL code that is added into the SBO_SP_TransactionNotification or SBO_SP_PostTransactionNotice stored procedures.

Incorrect: @object_type = 17

Correct: @object_type = `17`

It is necessary to use ` ` for the @object_type variable as this is of data type nvarchar. Therefore, the @object_type coult be either numeric or text (i.e. `17` or `TWBS_TABLE_1`)

KB Type

Solution

Item Date

28 Oct 2015

kb/kb_item_274.txt · Last modified: 2019/01/24 09:44 (external edit)