Solved

Export to Excel - "Stream was not readable" error (IAL? permissions?)

  • 12 June 2023
  • 6 replies
  • 381 views
P
Rank
Badge +2

We’re in IFS APP10 and a quick report (SQL) of which the source is an IAL 

(i.e

SELECT … 

FROM IFSINFO.C_SOME_IAL

WHERE ...) 

fails to export to excel. When clicked on the function, it shows the quick report execution dialog to enter parameters and then shows the error when pressed ok

 

 

This quick report

This does not happen to another standard quick report for example with permission to “IFS_ALL” but even if “IFS_ALL” is granted to this report, it still gives the same error.

Our other quick reports done without using IALs do not give this error, therefore I believe the IAL is not readable to the Export to Excel function.

Questions:

  1. Is this a permission issue ( with the quick report or IAL or Both?)
  2. If so, which exact permissions need to be granted to make the stream readable?

Thanks in advance!

icon

Best answer by Charith Epitawatta 14 June 2023, 00:11

View original

6 replies

Link
Rank
Userlevel 7
Badge +22

Hi @petersonlaurie 

did you grant the IAL in the permission set?

Does the QR work as usual?

 

Kind regards
P
Rank
Badge +2

Hi @petersonlaurie 

did you grant the IAL in the permission set?

Does the QR work as usual?

 

Thank you fort the response.

Yes the QR works for the intended users and the internal Admins. The QR itself is only granted for the internal end user group and the internal admin group. The IAL is also only granted to these permission sets.
 

Does any IFS user group need permission to the IAL to be able to read it and do the excel export?

 

Link
Rank
Userlevel 7
Badge +22

Hi @petersonlaurie 

user groups are not required.

Do they have access to this API? QUICK_REPORT_API.Get_Parameter_Info__

Kind regards
P
Rank
Badge +2

Hi @petersonlaurie 

user groups are not required.

Do they have access to this API? QUICK_REPORT_API.Get_Parameter_Info__

Yes confirmed, has access to it.
 

 

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @petersonlaurie,

There is a bug related to exporting Quick Reports to Excel which throws the “Stream was not readable” error and it is fixed in IFSAPP10 UPD20. 

Bug ID - 165684

The error occurs for Quick Reports with parameters. Could you share your Quick Report SQL for reference? 

Hope this helps!

Charith - https://charith.xyz
P
Rank
Badge +2

Hi @petersonlaurie,

There is a bug related to exporting Quick Reports to Excel which throws the “Stream was not readable” error and it is fixed in IFSAPP10 UPD20. 

Bug ID - 165684

The error occurs for Quick Reports with parameters. Could you share your Quick Report SQL for reference? 

Hope this helps!

Hi Charith, 

 

Thank you for the find. I did some trials and yes it is not the IAL but the parameters that bring this issue. We’ll get this bug fix applied. thank you very much for all your effort!

Reply


Terms & ConditionsCookie settings