topic Re: Stored Process output display issue in IDP in Developers

Stored Process output display issue in IDP

rajiv436 — Mon, 02 May 2016 06:49:27 GMT

Hi Friends, I'm facing a problem with stored processes in IDP, it doesn't displays the output and generating below mentioned errors. Can you please help me. NOTE: Writing HTML Body file: sashtml.htm ERROR: File is in use, /SASCONF/conf93/Lev1/SASApp/sashtml.htm. ERROR: No body file. HTML output will not be created. NOTE: The SAS System stopped processing this step because of errors.

Re: Stored Process output display issue in IDP

Timmy2383 — Mon, 02 May 2016 10:56:41 GMT

Did you select "streaming" as the output type on the execution tab of the stores process?

Are you using the %stpbegin and %stpend macros? I believe if either of these are true and you have any Html ODS statements in your code then it will create a conflict.

Can you share your stored process code?

Re: Stored Process output display issue in IDP

rajiv436 — Mon, 02 May 2016 12:09:22 GMT

Hi Timmy,

Stream option is enabled and I used %stpbegin and %stpend in my stored process program. In EG its working fine and generating output, but when I access through with Information delivery portal, it gives me such error msg. Find the screen shots also.

Here I've attached my Stored process code.

Re: Stored Process output display issue in IDP

Timmy2383 — Mon, 02 May 2016 13:49:50 GMT

I think the problem might be that with the STREAM option selected and running on the stored process server in the IDP it defaults to HTML output (ODS HTML), but then you're explicitly trying to use ODS TAGSETS.MSOFFICE2k when the listing is already in use for HTML.

Are you trying to make it create a file that the user downloads? If so, I believe you need to change your approach a bit. Check out pages 17-18 of this paper http://support.sas.com/resources/papers/proceedings15/SAS1700-2015.pdf.