Description
When investigating issues relating to uploading the Report Templates for Enterprise Vault (EV) Compliance Accelerator (CA) and Discovery Accelerator (DA), it may be helpful to enable HTTP logging on the SQL Server Reporting Services (SSRS) server. The steps involve editing a configuration file on the SSRS server, running additional network traces and running a DTrace on the CA/DA server. Once the logs have been obtained, technical support can assist in reviewing the data.
Here are the steps:
1. Enable SQL Server Reporting Services (SSRS) HTTP logging:
1.1. Use File Explorer on the SSRS server to navigate to \Program Files\Microsoft SQL Server\MSRSn.Instance\Reporting Services\ReportServer\bin.
1.2. Use Notepad to modify the ReportingServicesService.exe.config file to add http:4 to the <RStrace> section of the ReportingServicesService.exe.config file.
1.2.1. Here is an example of the default <RStrace> section entries:
<RStrace>
<add name="FileName" value="ReportServerService_" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="appdomain, tid, time" />
<add name="TraceListeners" value="file" />
<add name="TraceFileMode" value="unique" />
<add name="Components" value="all:3" />
</RStrace>
1.2.2. Here is an example of a modified <RStrace> section to include all settings:
<RStrace>
<add name="FileName" value="ReportServerService_" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="tid, time" />
<add name="TraceListeners" value="debugwindow, file" />
<add name="TraceFileMode" value="unique" />
<add name="HttpTraceFileName" value="ReportServerService_HTTP_" />
<add name="HttpTraceSwitches" value="date,time,clientip,username,serverip,serverport,host,method,uristem,uriquery,protocolstatus,bytesreceived,timetaken,protocolversion,useragent,cookiereceived,cookiesent,referrer" />
<add name="Components" value="all:3,http:4" />
</RStrace>
1.2.3. Can copy the modified <RStrace> section above and paste into the </RStrace> section of the ReportingServicesService.exe.config. Can edit the entries to remove unneeded settings, but would recommend to leave as is to capture as much information as available.
1.3. Save the file and restart the SQL Server Reporting Services service.
1.4. Check the logs location on the SSRS server at \Program Files\Microsoft SQL Server\MSRSn.Instance\Reporting Services\LogFiles\. If the ReportServerService_HTTP_<timestamp>.log is not seen, open a web browser on the SSRS server and navigate to http://localhost/reportserver - the ReportServerService_HTTP_<timestamp>.log should then be created.
2. Optional logging. A network trace, such a WireShark and/or Fiddler, along with a Process Monitor (ProcMon) on the Accelerator server and SSRS server may provide additional information if networking/antivirus issues are suspected.
3. Prepare the Accelerator server:
3.1. Log on to the Accelerator server as the VSA.
3.2. Stop the Customer's Background Tasks (CBT) for all Customers to remove any unneeded background task data (Synchronisations, Searches, Exports, etc.) being captured by the DTrace:
3.2.1. Browse to the EVBAAdmin administration website, usually at http://localhost/evbbaadmin.
3.2.2. Expand the Accelerator server | Right-click the first Accelerator Customer | Properties | De-select Enable Customer's tasks | OK | Click on the Customer and monitor the Current Status pane until Customers tasks shows Stopped.
3.2.3. Repeat for each Customer.
3.2.4. Leave the EVBAAdmin website open.
3.3. Start a DTrace on the Accelerator Server:
3.3.1. Open an administrative Command Prompt and navigate to the EV installation folder.
3.3.2. Type: DTrace 1000000 [enter]
3.3.3. At the DT> prompt type: v [enter]
Note the ID number beside the process(es) to be traced. In this case: AcceleratorManager, AcceleratorService, w3wp.
3.3.4. At the DT> prompt type: set (process ID #) v y [enter] (For example: set 2 v y)
Repeat the Set command for any additional processes as required.
3.3.5. Add an Exclude Filter to exclude the EVSqlConnection.UpdateTimeOut entries:
3.3.5.1. At the DT> prompt type: Filter [enter]
3.3.5.2. At the DT Filter> prompt type: Clear Excludes [enter]
3.3.5.3. At the DT Filter> prompt type: Exclude EVSqlConnection.UpdateTimeOut [enter]
3.3.5.4. At the DT Filter> prompt type: exit [enter]
3.3.6. Enable DTrace logging by typing the following and replacing c:\dtrace.log with a location and filename for the log. The log must have a .log extension. At the DT> prompt type: log c:\dtrace.log [enter]
3.3.7. At the DT> prompt, leave the command line window open. The DTrace is now enabled. Let DTrace run as needed to capture the issue.
4. Start the templates upload:
4.1. Click on the Reporting Server button in the EVBAAdmin administration website to browse to the Reporting Server page.
4.2. Enter the information as follows:
4.2.1. Reporting Server Url: Specifies the URL of the virtual directory of the SQL reporting server. This is also listed in the SSRS Configuration Manager in the WebService URL section. An example would be: http://SQLServerName/ReportServer.
4.2.2. User Name: Enter the VSA name in the form domain\user_name.
4.2.3. Password: Enter the VSA password.
4.3. Click on Upload Reports.
4.4. Monitor the report templates upload until the message Upload successful appears. This can take some time as there are a large number of report templates that need to be uploaded/updated. If the message does not appear, monitor the DTrace for any issues and allow the logging to remain in place for a few minutes after issues are seen so as to log any additional data as available.
5. Stop logging, start the CBTs and capture the logs:
5.1. Stop DTrace logging:
5.1.1. Go to the DTrace command line window. At the DT> prompt type: quit [enter]
5.1.2. Respond accordingly to any additional prompts in order to save any logs and exit DTrace.
5.2. Stop HTTP logging by following the steps above to restore the default <RStrace> section entries in the ReportingServicesService.exe.config file, then save the file and restart the SQL Server Reporting Services service.
5.3. Stop any optional logging.
5.4. Start the Customer's Background Tasks for all Customers:
5.4.1. Browse to the EVBAAdmin administration website.
5.4.2. Expand the Accelerator server | Right-click the first Accelerator Customer | Properties | Select Enable Customer's tasks | OK | Click on the Customer and monitor the Current Status pane until Customers tasks shows Running.
5.4.3. Repeat for each Customer.
5.5 Obtain and review the following logs:
5.5.1. DTrace logs.
5.5.2. Latest logs from the SSRS server under \Program Files\Microsoft SQL Server\MSRSn.Instance\Reporting Services\LogFiles:
5.5.2.1. ReportServerService_HTTP_<timestamp>.log
5.5.2.2. ReportServerService_<timestamp>.log
5.5.2.3. Microsoft.ReportingServices.Portal.WebHost_<timestamp>.log
5.5.3. Any optional network trace/ProcMon logs as available.
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.