"Access violation error at address" error for Query Reporter - Allround Automations forums

Register Log In

Forums Products Query Reporter "Access violation error at address" error for Query Reporter

Print Thread

"Access violation error at address" error for Query Reporter #56278 04/04/17 01:46 PM
Joined: Aug 2015 Posts: 10 U.S., Washington State Doug Volz OP Member
OP Doug Volz Member Joined: Aug 2015 Posts: 10 U.S., Washington State	What is the cause of this error? Is it data related? Amount of SGA available for a length SQL report? Using Query Reporter version 3.3.1.350, Oracle Client 12c Enterprise Edition Release 12.1.0.2.0. 2018 OATUG Associate Presenter of the Year 2018 OATUG Group of the Year - Cost Management Group 2014 OATUG Member of the Year

Re: "Access violation error at address" error for Query Reporter Doug Volz #56284 04/05/17 09:49 AM
Joined: Aug 1999 Posts: 22,211 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,211	Can you provide the complete message? Marco Kalter Allround Automations

Re: "Access violation error at address" error for Query Reporter Marco Kalter #56322 04/08/17 09:51 PM
Joined: Aug 2015 Posts: 10 U.S., Washington State Doug Volz OP Member
OP Doug Volz Member Joined: Aug 2015 Posts: 10 U.S., Washington State	Hi Marco, I figured it out ... memory issues with the Database at Go Live. I initially thought it was special characters in the Item Number Descriptions (mtl_system_items_b.description column). As when I commented out the Item Description column in my query, the SQL ran OK. But after a lengthy backup over this weekend, my SQL queries work just fine, with no changes ... even without using TRANSLATE or REGEXP_REPLACE on the item master description columns. The DBAs must have allocated more SGA memory or similar resource adjustments. Thanks, Doug Volz 2018 OATUG Associate Presenter of the Year 2018 OATUG Group of the Year - Cost Management Group 2014 OATUG Member of the Year

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.116s Queries: 15 (0.068s) Memory: 2.5008 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-05-08 01:12:44 UTC
Valid HTML 5 and Valid CSS