Support Article
Character missing in BLOB Data
Summary
Data in the Inshandle(1) and pxErrorList(1) columns is missing. The data in the pzpvStream column is in the BLOB format and does not populate the value in the correct format.
On executing the below query,
select PEGA_DATA.pr_read_from_stream('.InsHandles(1)', pzInsKey, pzPVStream) FROM PEGA_DATA.pr_sys_queues where PXOBJCLASS = 'System-Queue-Accounting' and rownum <2;
The result of the query is as below,
BARC-DATA-ACCONTTRANSACION F73162D7-2D1B-411-BEA-2427F238810,
However, this value is different when compared with the value in XML which is: BARC-DATA-ACCOUNTTRANSACTION F73162D7-2D1B-4311-BEEA-2427F2388109.
In this usecase, characters are missing in the database result (for example, in ACCOUNTTRANSACTION, U and T are missing. Similarly with 4311 etc.) The BLOB data is corrupted.
Database Detail
Database Product Name: Oracle
Database Product Version: Oracle Database 11g Release 11.1.0.0.0 - Production
Driver Name: Oracle JDBC driver
Driver Version: 11.1.0.6.0-Production
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
A defect in Pegasystems’ code or rules.
BLOB data was corrupted.
Resolution
As a local-change, perform the below steps to reinstall the User-defined Functions (UDF).
To manually install the UDFs, use the generateudf.bat or generateudf.sh script to install (or re-install) the UDFs in the installation media or scripts directory.
Prior to this, ensure that these functions are not partially installed before installing the UDFs (since the below steps are for a fresh installation). DROP FUNCTION YOURSCHEMA.pr_read_from_stream;
DROP FUNCTION YOURSCHEMA.pr_read_decimal_from_stream;
DROP FUNCTION YOURSCHEMA.pr_read_int_from_stream;
(For a split schema system, run the functions for both the Data Schema and the Rules Schema. If the functions are not present already, move to Step 1.)
- Confirm that setupDatabase.properties is set correctly (Database Connection URL, Username, Password, and Schema name(s).) The properties file is also in the /scripts directory.
- Run the generateudf.bat (or .sh as appropriate) with the '--action install --dbType YourDatabaseType' flags.
For example, when running the script on a Windows system for an Oracle database, this will be as below:
C:\PegaInstallationMedia\scripts> generateudf.bat --action install --dbType oracledate
For more information to validate if the UDFs are installed correctly (verify UDF installation), refer to: https://community.pega.com/knowledgebase/articles/understanding-and-troubleshooting-user-defined-functions#verify
Published May 11, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.