Hi Vince,
Many thanks for the tip. I was not aware of such options. The stored processes that I am running gives the output
1. Description page (keywords, location, name...)
2. SAS execution options page. I am choosing yes here to turn on the log.
3. Client specific prompt page which needs a few inputs.
#3 is being built by a javascript code which is embedded inside a data _null_/put statements combination. So, I included the html code you gave me to show the log.
Now what happens is that I briefly get the log on the browser window and then it changes back to the
http://sas.client.com:8080/SASStoredProcess/do? URL without giving me my Excel output.
I am including the entire log here since I am not sure which parts are most relevant.
>>> Using previous session context
>>> Using username ... in domain DefaultAuth
>>> Repository Foundation
>>> Parameter file
/ebiz/sas/WebSphere61dev/AppServer/installedApps/c1_sas_dev/SASStoredProcess_war.ear/SASStoredProcess.war/
Params.config
>>> Stored Process Input Parameters:
_debug = log,trace
_domain = DefaultAuth
_grafloc = /sasweb/graph
_htcook = JSESSIONID=0000hWT-kIbdQ-xNKsBmeuvbMdd:14sdi9m9g
_htua = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727;
.NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.1)
_program = //Foundation/BIP Tree/ReportStudio/.../ha_completion_weekly
_repository = Foundation
_reqmeth = POST
_rmtaddr = 10.84.133.14
_rmthost = 10.84.133.14
_srvname = sasdev.uhc.com
_srvport = 8080
_url = /SASStoredProcess/do
_username = ...
_version = Version 9.1.3 (Build 354)
format = Excel
refresh_submit = 1
startdate = 01/01/2011
>>> Servlet Session Data:
Servlet Session ID: hWT-kIbdQ-xNKsBmeuvbMdd
Counter: 18
Creation Time: Tue Feb 15 14:31:05 CST 2011
Last Accessed Time: Tue Feb 15 14:58:05 CST 2011
Servlet Session Timeout: 900
>>> User context
>>> Using PathUrl SBIP://Foundation/BIP Tree/ReportStudio/..../ha_completion_weekly(StoredProcess)
>>> Creating Stored Process Object
>>> Got Stored Process //Foundation/BIP Tree/ReportStudio/.../ha_completion_weekly
Name: ha_completion_weekly
Directory: /sasdev/.../Release2
File Name: ha_completion_weekly.sas
Description: HA Completion Weekly
>>> Setting stored process parameters
>>> Executing stored process object
>>> Getting _webout return stream
>>> Getting return headers
Content-disposition: attachment; filename=HA_Completion_Weekly.xls
Content-type: application/vnd.ms-excel
>>> Opening return data stream
>>> Starting return data read
ioprptsp ioprptsp 2011-02-15T14:57:50 2011-02-15T14:57:50 SAS Institute Inc.
http://www.sas.com
9.01.01M3P02022006