|
Group: Awaiting Activation
Last Active: Tue 4 Sep 2012
Posts: 2,
Visits: 4
|
Hello there
I have been tasked on retrieving orders from a Kartris cart into Sage Accounts and uploading stock levels from Sage the other way.
I can extract the order data OK but receive a SQL error;
"The transaction ended in the trigger. The batch has been aborted.
ERROR:Operation not allowed by user"
However, as I said the data seems OK.
I cannot seem to upload data directly into the tables to adjust stock levels without the same error, and cannot alter the table data directly in SQL Management Studio.
I suspect that this is because the database uses its triggers on data insert/update?
So my questions are;
- As long as the order data is extracted OK, which it appears to be, will this have any effect on the rest of the database integrity?
- Is there any way of uploading data directly (stock levels) without using the data tool that you supply?
Thanks for your time and I look forward to your reply.
|