Posted By: Doug Volz "Access violation error at address" error for Query Reporter - 04/04/17 01:46 PM
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.
Posted By: Marco Kalter Re: "Access violation error at address" error for Query Reporter - 04/05/17 09:49 AM
Can you provide the complete message?
Posted By: Doug Volz Re: "Access violation error at address" error for Query Reporter - 04/08/17 09:51 PM
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
© Allround Automations forums