We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Need information related to request_exceptions table

randhir_kumar
New Contributor
New Contributor

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.

randhir_kumar_0-1691561791819.png

 

 

Thanks

 

8 REPLIES 8

sudeshjaiswal
Saviynt Employee
Saviynt Employee

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
New Contributor
New Contributor

Hi,

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

Thanks,

Randhir Kumar.

sudeshjaiswal
Saviynt Employee
Saviynt Employee

Hello @randhir_kumar,

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

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

randhir_kumar
New Contributor
New Contributor

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

Please find the screenshot below:

randhir_kumar_1-1691744073248.png

 

Thanks.

 

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

randhir_kumar
New Contributor
New Contributor

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
New Contributor
New Contributor

Hi,

We still looking for suggestions.