ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
XTraction does not load data when Data Source is Oracle
Article ID: 221905
CA Service Management - Service Desk Manager
CA Service Desk Manager - Xtraction
CA Service Desk Manager
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:
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
CA Service Management 17.1 and higher
XTraction 2021.2 (and others)
- Go to the Data Model Editor;
- Select Schema/Owner Editor;
- Check "Data Sources" and click on "Update".