Data Management: Cognos Data Manager: Access VIOLATION

Often this error occurs without warning, somewhat randomly and usually with disastrous consequences to your ETL operation.  We recently experienced a random set of these and were able to track them down to the usage of the SQL SERVER BULK LOADER delivery module in the crashing fact builds.

It appears this loader struggles somewhat if you are delivering SMALL quantities of data using this delivery.

The fix is to simply change it to the Relational Table delivery and these particular Access Violation errors go away.  We have not experienced this issue with our loads that deliver a million rows or more.  Possibly the commit interval could have been lowered on the failing builds to increase reliability but, at less than 100000 rows the relational delivery operates just as effectively and more reliably.

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content