LinkedIn
Copied!

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.

Suggest Edit

Related Content

Have a question? Get answers now.

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