Skip to main content
Solved

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

P
Do Gooder
Forum|alt.badge.img+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!

Best answer by Charith Epitawatta

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!

View original
Did this topic help you find an answer to your question?

6 replies

L
Superhero (Customer)
Forum|alt.badge.img+23
  • Link
  • Superhero (Customer)
  • 1169 replies
  • June 12, 2023

Hi @petersonlaurie 

did you grant the IAL in the permission set?

Does the QR work as usual?

 

Kind regards
P
Do Gooder
Forum|alt.badge.img+2
Link wrote:

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?

 

L
Superhero (Customer)
Forum|alt.badge.img+23
  • Link
  • Superhero (Customer)
  • 1169 replies
  • June 12, 2023

Hi @petersonlaurie 

user groups are not required.

Do they have access to this API? QUICK_REPORT_API.Get_Parameter_Info__

Kind regards
P
Do Gooder
Forum|alt.badge.img+2
Link wrote:

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
Ultimate Hero (Employee)
Forum|alt.badge.img+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
Do Gooder
Forum|alt.badge.img+2
Charith Epitawatta wrote:

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings