E-PG: Pivot Grid Inconsistent Error: Generic Error While Executing The Query Datasource. (268,91) with PS Query data Source that contains a LONG data type. (Doc ID 2529921.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Symptoms

Encountering  below error when upon drilling down to the pivot grid results with a PS Query data Source that contains a LONG data type.
Clicking “Detailed View” will result to the below generic error. However, when try to view the data again, data will be successfully displayed.

ERROR

-----------------------

Generic error while executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:ExecuteDrillDn PCPC:128267 Statement:2063

Called from:PTPG_WORKREC1.PTPG_CHART_DETAIL.FieldChange Statement:19

or 

Encountering the error when attempting to create a Pivot Grid (in Pivot Grid Wizard) with a PS Query data Source that contains a LONG data type.

ERROR

-----------------------

Generic error while executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:ExecuteChart PCPC:107091 Statement:1760

Called from:PTPG_WIZ_DISP.Activate Statement:422.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.