XTraction does not load data when Data Source is Oracle

book

Article ID: 221905

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager - Xtraction CA Service Desk Manager

Issue/Introduction

When Oracle is Data Source, Xtraction does not load data as expected, even though the connection is successful in the Data Model Editor.

End-user sees the error message below:

Xtraction.Web.log shows:

2021-08-17 15:17:06,116 ERROR Xtraction.Web.API.Controllers.SqlDataEngineController - Failure
System.Data.OracleClient.OracleException (0x80131938): ORA-00942: table or view does not exist

Environment

CA Service Management 17.1 and higher

XTraction 2021.2 (and others)

Resolution

  1. Go to the Data Model Editor;
  2. Select Schema/Owner Editor;
  3. Check "Data Sources" and click on "Update".

Attachments