Created by Salim Frontin on Feb 11, 2022
Purpose (problem description)

This page provides steps to troubleshoot the following DB2 analysis error.

Internal exception occurred during processing listener CDb2AnalyzerAction::process on instance JOB_DB2_ANALYZER #2 : access violation.

Observed in CAST AIP
Release
Yes/No
8.3.x(error) 
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(error)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(error)
CSS2(tick)
Step by Step scenario
  1. Use Delivery Manager Tool and deliver the source code.
  2. Run analysis.
Action Plan

This may happen in the following case: SYSTEM DSN for DB2 is 32-bit while you are using Cast-AIP 8.x.

  1. Remove the 32-bit SYSTEM DSN for DB2 and set up a 64-bit SYSTEM DSN for DB2.

  2. If DB2 Client is installed and if a 64-bit SYSTEM DSN is not added, then solution is to add a 64-bit SYSTEM DSN for each DB2 UDB server you want to analyze.

    Note

    For CAST 8.x, this should be done for 64 bit and not 32 bit

    JDBC connection is used in DMT and in CMS for connection validation. However ODBC connection is used by CMS during analysis, that is why if system DSN is not set, Analysis fails.
    For more detail on the 64 bit connection on CAST 8.x, refer to this page: Validate and configure RDBMS connection for DB2 UDB Analysis

  3. If issue is not solved, then contact CAST Support with the following Relevant input.

    Note

    Please note that even if the connection to DB2 UDB server has been tested with DMT or Cast-MS, it just means that server name and credentials are correct, but not necessarily the connection of the analyzer.  Indeed, DMT and CAST-MS connect through JDBC, whereas the analyser uses ODBC.

 Relevant input

  • Screenshots showing the error
  • Screenshots confirming the DB2 UDB connectivity and setup on the CAST analysis server
Notes/comments

Ticket # 9259

Related Pages