To fix the SAV Reporting Server component issue you may need to keep it updated to the latest version.
Issue: SAV Reporting Console results in blank page.
Investigation and Fix:
After enabling debug logging, you find that SAV Reporting Server failing to connect to its DB with log#1 message.
The logs uploaded by reporting agents start queuing on server. After some troubleshooting, the error transform into second error given in log#2 for which Symantec has no fix but to upgrade application to the latest version.
However, the Reporting Server installer keeps on hanging forever (with log statement given in log#3) in all the attempts of repair install, remove install and upgrade install as well.
At this point, you can concluded that SAV Reporting Server application got corrupted and needs to be setup afresh. So, with the help of support you need to get all traces of SAV ‘Reporting Server’ as well as ‘Reporting Agent’ removed, reboot the server, and install them afresh.
After fresh install the default Reporting Server, admin account login may fail and even attempt to directly edit password in DB don’t work. You can manage to login to the Reporting Server using our another admin account named ‘root’ and then set new application password to ‘admin’ as well ‘root’ admin accounts. SAV Reporting Console then start working fine.
Debug Logs:
Log#1: Fatal error: Uncaught exception ‘com_exception’ with message ‘<b>Source:</b>
Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ”. The user is not associated with a trusted SQL Server connection.’ in C:Program FilesSymantecReporting ServerWebCommonado.php:20 Stack trace: #0 C:Program FilesSymantecReporting ServerWebCommonado.php(20): com->Open(‘DSN=Reporting’, ‘Reporting’, ‘mxQ:*Wvt,RdLV_b…’) #1 C:Program FilesSymantecReporting ServerWebCommonconnectdb.php(22): ado_connect(‘Reporting’, ‘Reporting’, ‘mxQ:*Wvt,RdLV_b…’, NULL, NULL) #2 C:Program FilesSymantecReporting ServerWebLoginLogin.php(10): connectnav() #3 {main} thrown in C:Program FilesSymantecReporting ServerWebCommonado.php on line 20
Log#2: error: Call to undefined function usleepW() in C:Program FilesSymantecReporting ServerWebCommonado.php on line 117
Log#3:
RemoveFiles: File: 6d676d7468796432_20100429062643_000000.INVENTORY, Directory: C:Program FilesSymantecReporting ServerUpload
MSI (s) (60:5C) [02:27:51:571]: Verifying accessibility of file: 6d676d7468796432_20100429062643_000000.INVENTORY
MSI (s) (60:5C) [02:27:51:587]: Executing op: FileRemove(,FileName=6d676d7468796432_20100429062743_000000.INVENTORY,,)
RemoveFiles: File: 6d676d7468796432_20100429062743_000000.INVENTORY, Directory: C:Program FilesSymantecReporting ServerUpload
MSI (s) (60:5C) [02:27:51:587]: Verifying accessibility of file: 6d676d7468796432_20100429062743_000000.INVENTORY
<
p>MSI (s) (60:5C) [02:27:51:587]: Executing op: FileRemove(,FileName=6d676d7468796432_20100429062842_000000.INVENTORY,,)
