000033864 - Unexpected error encountered creating new or saving existing reports in RSA Archer 5.5.x with Offline Access enabled.

Document created by RSA Customer Support Employee on Aug 25, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033864
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.5.x

 
IssueUnexpected Error encountered while creating new reports or saving existing reports .
Report save failed with the error Invalid object name 'tblreportbasetranslation_tracking' generated in Archer.w3wp.YYYYMMDD.xml logs.

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
        <EventID>0</EventID>
        <Type>3</Type>
        <SubType Name="Error">0</SubType>
        <Level>2</Level>
        <TimeCreated SystemTime="YYYY-MM-DDThh:mm:ss.xxxxxxxZ" />
        <Source Name="Archer.Web" />
        <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
        <Execution ProcessName="w3wp" ProcessID="3836" ThreadID="55" />
        <AssemblyVersion>5.5.30300.1010</AssemblyVersion>
        <Channel />
        <Computer>SERVER</Computer>
    </System>
    <ApplicationData>
        <TraceData>
            <DataItem>
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>Archer.Web</TraceIdentifier>
                    <LogReferenceId>082316-224144-2884</LogReferenceId>
                    <Description>Invalid object name 'tblreportbasetranslation_tracking'.
SQL statement: usp_update_report_base @userToken = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', @reportBaseId = 6440, @reportName = 'ReportName', @reportDesc = '&lt;p&gt;Report Description &lt;/p&gt;', @dateDisplayFormat = '', @maxRecordCount = , @pageSize = 50, @showCriteriaHeading = False, @timeZoneId = , @formatTypeId = 1, @expandDetailedView = False, @refreshRate = 0, @filterCriteriaId = 3207, @keywords = '', @reportTypeId = 2, @isStatistical = False, @showStatisticalSummary = False, @drillInReportBaseId = , @url = '', @includeEmptyGroups = , @reportDisplayType = , @statviewType = , @date = 'M/DD/YYYY hh:mm:ss PM', @hideFromIviewReportListing = False, @hideFromMasterReportListing = False, @calendarDisplayId = , @cacheEnabled = False, @cacheDuration = , @fixedheader = False, @isResultEditable = False</Description>

                    <AppDomain>/LM/W3SVC/1/ROOT/Archer-1-131164517009939584</AppDomain>
                    <ContextData>
                        <BaseUrl>https://SERVER/Archer/SearchContent/Search.aspx</BaseUrl>
                        <view>Report</view>
                        <Report>ReportId: 6440, ReportName: In Process Action Plan by Risks, ReportType: SearchBased</Report>
                        <Module>ModuleId: 152, ModuleName: Risk Inventory, ModuleStatus: ActiveInProduction, ModuleType: Application</Module>
                        <frameWidthHeight>1066,695</frameWidthHeight>
                    </ContextData>
                    <Exception>
                        <ExceptionType>ArcherTech.Kernel.Utility.Data.ArcherDbException, ArcherTech.Kernel, Version=5.5.30300.1010, Culture=neutral, PublicKeyToken=null</ExceptionType>
                        <Message>Invalid object name 'tblreportbasetranslation_tracking'.
SQL statement: usp_update_report_base @userToken = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', @reportBaseId = 6440, @reportName = 'ReportName', @reportDesc = '&lt;p&gt;Report Description &lt;/p&gt;', @dateDisplayFormat = '', @maxRecordCount = , @pageSize = 50, @showCriteriaHeading = False, @timeZoneId = , @formatTypeId = 1, @expandDetailedView = False, @refreshRate = 0, @filterCriteriaId = 3207, @keywords = '', @reportTypeId = 2, @isStatistical = False, @showStatisticalSummary = False, @drillInReportBaseId = , @url = '', @includeEmptyGroups = , @reportDisplayType = , @statviewType = , @date = 'M/DD/YYYY hh:mm:ss PM', @hideFromIviewReportListing = False, @hideFromMasterReportListing = False, @calendarDisplayId = , @cacheEnabled = False, @cacheDuration = , @fixedheader = False, @isResultEditable = False</Message>

                        <Source>ArcherTech.Kernel</Source>
                        <StackTrace>   at ArcherTech.Kernel.Utility.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap)
   at ArcherTech.Kernel.Utility.Data.ArcherSqlDatabase.ExecuteNonQuery(DbCommand command)
   at ArcherTech.Kernel.DataSource.Db.SearchReportDataSource.Update(Report report, SearchReportBase searchReportBase, IList`1 changeset)
   at ArcherTech.Kernel.Brokers.SearchReportBroker.Save(Report report, SearchReportBase searchReportBase, SearchReportSaveOptions saveOptions)
   at ArcherTech.Kernel.Managers.SearchReportManager.Save(SessionContext sessionContext, Report report, SearchReportBase reportBase)
   at ArcherTech.Web.Modules.SearchContent.Views.SearchSaveReportPresenter.Save()
   at Security2000.SearchContent.SearchSaveReport.ApplySave()
   at Security2000.SearchContent.Search.SaveReport(Object sender, EventArgs e)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</StackTrace>
                    </Exception>
                </TraceRecord>
            </DataItem>
        </TraceData>
    </ApplicationData>
</E2ETraceEvent>

 
CauseTables names with '*_tracking' appended relates to RSA Archer Offline Access. If RSA Archer is not installed intended for Offline Access, enabling this feature may cause issues described within this article. 
For example, 'tblreportbasetranslation_tracking' would be a table created for RSA Archer Offline Access to support the regular 'tblreportbasetranslation' table within the Archer database.
Resolution
  1. Open Archer Control Panel (ACP)
  2. Select the Instance
User-added image

  1. Under General tab, scroll down and locate Offline Access configuration.
  2. Ensure Enable Offline Access configuration is not enabled.
User-added image

  1. Un-check the option then click on Save
User-added image
NotesFor full details on installing RSA Archer Offline Access, please refer to the installation guide for more details.
Note: The installation process for Offline Access is separate from the RSA Archer GRC installation.
RSA Archer 5.5.4 Installation Guide
https://community.rsa.com/docs/DOC-41248

Attachments

    Outcomes