Usage Note 31101: An error might occur in SAS® Data Integration Studio when you attempt to retrieve the log
If you run a process that generates very large log or output content, you might receive an error window that contains one of the the following messages:
An error occurred while attempting to retrieve the log:
or
An error occurred while attempting to retrieve the output:
This error indicates that the size of the log or output is too large to be retrieved and displayed within the Log or Output tab. As a result, the Log or Output tab will contain no information when it is selected.
Some possible solutions are as follows.
- Increase the amount of memory available for the client by increasing the setting of the -Xmx option in the etlstudio.ini file that is found in the SAS Data Integration Studio installation folder on your client machine. For example, the default setting for this option is 512m, so you can edit this file and try increasing the -Xmx setting to 768m or 1024m (assuming your client machine has the available physical memory). Increasing the available memory might not resolve this issue.
- Run the job in batch mode instead of interactively from with SAS Data Integration Studio:
- Save and close the job.
- Select and highlight the job in the Inventory or Custom tab.
- Right-click to display the pop-up menu.
- Select Scheduling...
- Make appropriate selections and complete the job deployment process.
- Run the deployed job in batch mode. This can be accomplished using Schedule Manager in SAS® Management Console or by directly executing the deployed job in batch mode on the workspace server.
- Use the PRINTTO procedure to redirect the log and output to a physical file on the workspace server. The following is one example of how this can be accomplished:
- Open properties on the job.
- Go to the Pre and Post Process tab.
- Select the Pre Processing check box.
- Enter a value in the Name: field for Pre Processing.
- Select the Pre Processing Edit... button
- Make the appropriate modifications to the WINPREFIX and UNIXPREFIX macro variable definitions in the following code, and then place it in the Edit Source Code window:
/* NOTE: The user executing the job must have write access to the paths specified below */
%let winprefix=c:\public\logfiles\; /* Replace with valid path on Windows Server */
%let unixprefix=~userid/logfiles/; /* Replace with valid path on Unix Server */
Data _null_;
if "&sysscp"="WIN" then prefix="&winprefix";
else prefix="&unixprefix";
year=put(DATE(), year.);
month=put(DATE(), month.);
day=put(DATE(), day.);
time=tranwrd(put(time(), time.),':','_');
logpath=catx("_","&pathprefix",year,month,day,time,"&sysuserid","&sysjobid")||".log";
call symput('logfile',logpath);
outputpath=catx("_","&pathprefix",year,month,day,time,"&sysuserid","&sysjobid")||".lst";
call symput('outputfile',outputpath);
run;
proc printto log="&logfile" list="&outputfile";
run;
- Select OK to save the Pre Processing code.
- Next select the Post Processing check box.
- Enter a value in the Name field for Post Processing.
- Select the Post Processing Edit... button.
- Place the following code in the Edit Source Code window:
proc printto;
run;
- Select OK to save the Post Processing code.
- Select OK to save the job properties.
- Run the job and view the log and output files that have been generated on the server.
Operating System and Release Information
SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS1M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS1M0 | |
Windows Vista | 4.2 | | 9.2 TS1M0 | |
Windows Vista for x64 | 4.2 | | 9.2 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
SAS® Data Integration Studio might report the following error, "An error occurred while attempting to retrieve the log:", when the size of the log is too large to load and display.
Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> Procedures ==> PRINTTO
|
Date Modified: | 2008-02-12 15:06:06 |
Date Created: | 2008-02-05 07:49:13 |