Issue | Unexpected 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 = '<p>Report Description </p>', @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 = '<p>Report Description </p>', @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> |