Question

1
Replies
129
Views
ManishaV8998 Member since 2017 1 post
Tech Mahindra
Posted: 1 year ago
Last activity: 1 year 10 months ago
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 :

  1. 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

Data Integration
Moderation Team has archived post
Share this page LinkedIn