DBMS0008: Unavailable pr_read_stream function
Pega Predictive Diagnostic Cloud™ (PDC) creates a DBMS0008 event when an application tries to use the pr_read_from_stream function but fails because the function is either not defined or not available.
Reason for the event
The pr_read_from_stream function is a user-defined function (UDF) for reading from the pzPVStream column. The function resides and runs in the database server, as opposed to running in the Pega Platform™ JVM. The primary purpose of this function and its related functions is to enhance the Pega Platform reporting mechanism. By using the function, the end user can avoid optimizing, that is exposing, properties. For more information about optimizing properties, see Planning for property optimization.
When an application tries to use the pr_read_from_stream function but fails because the function is either not defined or not available, Pega Platform™ reports an exception that PDC identifies by the following text: ERROR: function pegadata.pr_read_from_stream. PDC parses the exception to find the name of the faulty report. If the name of the report is unknown, then PDC uses the activity and step to identify and correlate similar issues. For every report, or activity and step, that fails due to the unavailable pr_read_from_stream function, PDC creates a DBMS0008 event and a corresponding Unavailable pr_read_stream_function case.
Exceptions while accessing pr_read* functions typically have the following root causes:
- The database system is not configured to support the functions.
- An application uses the functions incorrectly.
These exceptions require immediate investigation and remediation.
Example message text
ERROR: function pegadata.pr_read_from_stream
Recommended next steps
To resolve DBMS0008 issues, revise the configuration of the faulty report. Update the report to not use unexposed properties, or expose the properties that the report references. If the issue persists, engage a database administrator (DBA) to fix the function.