|
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.
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
Hi Snowy100
Kartris has triggers to protect the data from casual modification. I've added a KB with more info here:
http://www.kartris.com/Knowledgebase/Trigger-errors-when-modifying-data-in-the-database-tables__k-44.aspx
So to answer your questions:
1. As long as you read the data ok, I think the trigger error shouldn't be anything to worry about
2. You can just run the sproc to disable all triggers before you run any updates on data in the tables.
Note that over time, the triggers will be reenabled as sprocs run operations on the various tables in normal usage (because the last step is always to reenable the trigger). So you will need to turn off triggers each time before your operations.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
Group: Awaiting Activation
Last Active: Tue 4 Sep 2012
Posts: 2,
Visits: 4
|
Thanks for that - I need to disable the relevant triggers on the order table in order to update the O_SentToQB field from a vb.net aspx page.
Is there a stored procedure to do this already please?
If not, what would the best way be to achieve this?
Thanks again
|