Error enabling FSA Reporting
Article ID: 100011415
Updated On:
Description
Error Message
Excerpts from Dtrace:
1798 09:22:11.410 [11256] (w3wp) <1488> EV-M {REPORTINGSERVER.EN_US} SiteId = 1267D12D181EA0D45A1F6E3454071BDEA1d10000EVMail1, File server ='MBX1.ADVE2K13.LOCAL', DBserver = , DBName = , UserName =
1799 09:22:11.410 [11256] (w3wp) <1488> EV-H {REPORTINGSERVER.EN_US} Reporting is not configured yet.
1800 09:22:11.410 [11256] (w3wp) <1488> EV-H {REPORTINGSERVER.EN_US} Could not retrieve database information for file server ‘MBX1.ADVE2K13.LOCAL’
……….............................................................................................
1801 09:22:11.410 [8204] (mmc) <7976> EV:H In CCAUIReportingFSPropertiesPage::OnApply() failed to save scheduling information for fileserver = [MBX1] on database = [FSAReportingDatabase] on SQL server = [E2K13DC.ADVE2K13.LOCAL]
Excerpts from SQL Profiler :
UPDATE FSARC
SET Anon1 = CASE @UserName WHEN '' THEN NULL ELSE @UserName END,
Anon2 = CASE @Password WHEN '' THEN NULL ELSE @Password END
FROM FSAReportingConfiguration FSARC
LEFT OUTER JOIN
FSAReportingSite FSARS ON FSARC.FSAReportingConfigurationId = FSARS.FSAReportingConfigurationId
WHERE (@SiteEntryID IS NULL OR @SiteEntryID = FSARS.SiteEntryId)
FSARC: FSA Reporting Configuration Table
Cause
The FSAReportingConfiguration table may be empty possibly due to incorrect un-installation of FSA Reporting. This table should contain one row by default irrespective of whether File System Archiving is configured in the environment. Hence when the relevant Update Statement runs in SQL and tries to update the Anon1 and Anon2 with username and password it cannot complete the update as there is no row in this Table and thus the parameters cannot be entered.
Resolution
Please contact Veritas Technical Support for further assistance
Issue/Introduction
When entering Account and Password details in File Servers Properties | Reporting User Credentials tab, after clicking the Apply button the information disappears.
