Question
TCS
TCS
IN
TCS
Posted: Nov 27, 2018
Last activity: Dec 13, 2018
Last activity: 13 Dec 2018 11:47 EST
Closed
Facing Java exception BadStreamDataException: Problem decompressing a storage stream while executing a query in toad
Hi I am facing an issue while executing query in toad. I sucesfully executed same query in other DB instances, but for Prod instance I am facing below error.Also I attached the screenshot of the error
ORA-29532: Java call terminated by uncaught Java exception: com.pega.pegarules.data.internal.clipboard.directstream.BadStreamDataException: Problem decompressing a storage stream
Query :
- SELECT pr_read_from_stream ('.CreatorWorkGroup', "A".pzInsKey, "A".pzPVStream) AS CreatorWorkGroup ,
PZINSKEY ,PYID,
PXCREATEDATETIME,PYSTATUSWORK
FROM Table A
where PYSTATUSWORK IN('Open-')
and UPPER(pr_read_from_stream ('.CreatorWorkGroup', "A".pzInsKey, "A".pzPVStream)) like '%PID%' ORDER BY PXCREATEDATETIME DESC