How to Debug a Middle-tier Connection Problem in a Report Job

CAUTION:

The command to restart services should be issued only with the approval of an SAS IT Resource Management administrator.

Everyone using Gallery Manager might be affected by this action.

If your report job shows an error that appears to be related to a middle-tier connection problem, verify that the SAS Content Server and the Gallery Manager are available. To do so, perform these two steps:

Connect to the SAS Content Server Administrative Console at http://<YourMiddle-TierName>:<port number>/SASContentServer/dircontents.jsp?path=/sasdav. If you are not able to connect to the SAS Content Server Administrative Console, restart the managed servers that are associated with SAS Remote Services, the SAS Content Server, and the Gallery Manager in the Web application server.

Note: The names of these servers depend on the set up of the middle tier. They are typically named server1, server10, and so on.
Logon to Gallery Manager at http://<YourMiddle-TierName>:<port number>/ITRMGalleryManager. If you are not able to connect to Gallery Manager, then restart the server that is associated with the Gallery Manager.

If you had to restart any services, then rerun the report job. If you continue to see the same middle-tier connection errors after restarting the middle-tier connection services, then follow the steps below to continue debugging the middle tier. using a small, temporary report job.

Tip

To simplify debugging, perform these steps using a small, temporary report job.

Then run the jobs, save the logs, and contact the SAS Technical Support Division. For information about how to do so, see Technical Support.

If after restarting any services, you encounter a different type of error, then see Why Report Jobs Are Not Generating Reports.

In the SAS IT Resource Management client, open your IT data mart. Then navigate to the folder that contains the report job that caused the error.
Create a new report job in the same folder. Add any report definition from the original job.
Click the Code tab in the Job Editor. Click Code generation mode and select User written body.

Select the Code Generation Mode
Search through the SAS log for the following text:
```
/* setup */
%global ITRMErr;
%global ITRMDebug;
%global ITRMNoWebdavUpdate;
```
Add the following debugging statements after the previous %global ITRMNoWebdavUpdate; code.
```
/* Add debugging statement */
%let ITRMDebug=1;
/* Disable Gallery Manager communications */
%let ITRMNoWebdavUpdate=1;
```
Then, run the report job. Save the log.

Run the report job a second time with the following set of debugging statements:


/* Add debugging statement */
%let ITRMDebug=1;
/* Enable Gallery Manager communications */
%let ITRMNoWebdavUpdate=0;

Save the log and contact the SAS Technical Support Division. For information about how to do so, see Technical Support.