Summary:
This article troubleshoots an error that occurs when running a report after upgrading to 4.6.6.
Symptoms:
When a user runs a report on Data Warehouse after upgrading to 4.6.6, they receive the following error message:
Missing attribute GL_Detail_F_Trans.TimePeriod
RETRIEVE
[None_GL_Detail_F_Trans_TimePeriod] : MAX([GL_Detail_F_Trans].[TimePeriod], ORDER), [Sum_GL_Detail_F_Trans_Value1#RFC12M] : SUM([GL_Detail_F_Trans].[Value1](RFC12M))
CONDITION
(
[d_Scenario].[Code] IN ('ACT') )
AND
(
[d_dim0].[Code] IN ('22000')
)
AND
(
[Period].[PeriodId] IN ('201812')
)
OneStop.Framework.RqlParser.RqlException: Missing attribute GL_Detail_F_Trans.TimePeriod
at OneStop.Framework.Engine.RqlQuery.GetSql(ReportEnvironment env, DatabaseConnection conn, RParser parser)
at OneStop.Framework.Engine.RqlQuery.ProcessCommand[T](ReportEnvironment env, Func`5 dataRetriever)
at OneStop.Framework.Engine.RqlQuery.GetRawData(ReportEnvironment env)
at OneStop.Framework.Engine.TableSource.GetData(ReportEnvironment env)
at OneStop.Framework.Engine.Selection.SelectionGroup.DoQuery(SourceEnvironment senv)
at OneStop.Framework.Engine.Selection.GroupMapping.FetchData()
at OneStop.Framework.Engine.Selection.InstanceMatrix..ctor(SourceEnvironment senv,
efinitionItemCollection items, Boolean generateDrilldown)
at OneStop.Facade.Execute.BuildLayout(ReportEnvironment env, LayoutDefinition ld, Boolean
enerateDrilldown)
at OneStop.Facade.Execute.GetInstance(ReportEnvironment env, ExcelMapping exmap, String title,
tring sheet, Boolean generateDrilldown)
at OneStop.Facade.Execute.
at System.Linq.Enumerable.
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at System.Collections.Generic.List`1.AddRange(IEnumerable`1 collection)
at OneStop.Facade.Execute.ExecuteReport(ReportDefinition def, ParameterValueCollection values,
oolean generateDrilldown, String dictionaryName, Boolean checkLookup)
at OneStop.Facade.Reporting.ExecuteReport(String reportId, ParameterValueCollection values, String dictionaryName, String clientIPAddress, Boolean checkLookup)
at OneStop.Facade.Reporting.ExecuteReport(String reportId, ParameterValueCollection values, String ictionaryName, Boolean checkLookup)
at OneStop.StandaloneAdapter.ReportEngine.
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at OneStop.Toolkit.Threading.ExtendedBackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Causes:
The field was originally pulled from an incorrect dimension causing this error.
Resolution:
Redrag the period to replace this GL detail period that is causing the error from all groupings and filters in layout editor and any other place on the report that would cause it.
Properties:
Report Designer 4.6