Need information related to request_exceptions table

[randhir_kumar]

Hi Team,

Need information related to the below column data as we can see the column type is longblob.

we want to convert this byte array to the actual file.

Please let me know what type of file is this.

Thanks

[sudeshjaiswal]

Hello @randhir_kumar,

No, You cannot convert directly bytearray into file, The Data is in object form which is further converted into byte.

[randhir_kumar]

Hi,

Is there any way we can use this column data to get the original file.

Thanks,

Randhir Kumar.

[sudeshjaiswal]

Hello @randhir_kumar,

You might get the data in file, but it wont be in readable format.

[rushikeshvartak]

select *,convert(re.soddetaildata using utf8) from request_exceptions

[randhir_kumar]

@rushikeshvartak we cannot see any data on executing the query.

Please find the screenshot below:

Thanks.

[rushikeshvartak]

You need to raise saviynt ticket to get data from database.

[randhir_kumar]

Hi Rushikesh,

We have raised an SR for this.

[#1662296] Need SOD related information : Customer Portal (freshdesk.com)

They suggested to follow up in Saviynt Forums.

[randhir_kumar]

Hi,

We still looking for suggestions.