Support Article
Exposed Columns Not Recognized - Report Denition
SA-73184
Summary
Error occurs when running reports on a newly set up Azure cloud system with an MSSQL database which does not have User Defined Functions (UDF) installed. The reports are created on an existing Pega 7.3.1 system with an Oracle database and moved to a Product rule file. This generates the Data Definition Language (DDL) for the table definitions.
Error Messages
An error occurred on executing the query for the report definition - There was a problem getting a list: code: 4121 SQLState: S0001 Message: Cannot find either column "DATA" or the user-defined function or aggregate "DATA.pr_read_from_stream", or the name is ambiguous.
DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find either column "DATA" or the user-defined function or aggregate "DATA.pr_read_from_stream", or the name is ambiguous.
| SQL Code: 4121 | SQL State: S0001
Steps to Reproduce
- Build Pega 7.3.1 on an Oracle system and Pega 7.4 on Azure and MSSQL system.
- Create a Product rule from the implementation on Pega 7.3.1 and import the Product rule to the Pega 7.4 system.
- While performing this, download the DDL query and run it manually in the Pega 7.4 system.
- Create a report definition with exposed columns.
- Run the report definition.
Root Cause
An issue in the custom application code or rules.
The column and property names were different in terms of casing.
Resolution
Perform the following local-change:- Identify the affected tables.
- On the source system, for each affected table:
- Find all the Data-Admin-DB-Tables that refer to the same table.
- Update each table to use the exact same table name casing.
- Re-export the application from the source system.
- On the target system, drop the current tables (if the table is empty) or drop only the affected columns (if there are rows).
- Re-import the application on the target system.
- On the target system, run column population tools or re-save the instance to populate the correctly-cased columns for non-empty tables.
Published May 1, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.