Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Pega BIX DB extraction issue with Oracle schema

SA-26689

Summary



Unable to perform extract to Database using Business Intelligence Exchange (BIX). CSV and XML extractions are working fine.

Error Messages




2016-07-14 11:27:25,988 [fault (self-tuning)'] [ureAnalysis:01.01.01] ( internal.access.ExtractImpl) INFO - BIX Version : 7.1
2016-07-14 11:27:26,001 [fault (self-tuning)'] [ureAnalysis:01.01.01] ( internal.access.ExtractImpl) DEBUG - Table Name is:
2016-07-14 11:27:26,006 [fault (self-tuning)'] [ureAnalysis:01.01.01] ( internal.access.ExtractImpl) ERROR - : table doesn't exist in target Database: bopdv3
2016-07-14 11:27:26,033 [fault (self-tuning)'] [ureAnalysis:01.01.01] ( internal.access.ExtractImpl) INFO - PAL Statistics for BIX Extract run :


Steps to Reproduce



Not Applicable

Root Cause



User have similar use case in different environments, one environment it is working fine. Grants has been not provided to Oracle schema.

Resolution



Provide the grants to Oracle schema to resolve the issue.

Published August 24, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us