PURGE_RAW_DATA: retention period for raw data in the datawarehouse
- In Oracle DataWareHouse, the PURGE_RAW_DATA value is registered in days, and must always be greater than or equal to the NbDays_Purge value defined in the reporting.
reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)Callstack:
at NEWTEST/DWH_-_Datawarehouse/Settings/Parameterdata
MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException: reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée.
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptVar expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptVar.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Evaluate(DekiScriptAccess expr, DekiScriptExpressionEvaluationState state, Boolean evaluateProperties)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptAccess expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptAccess.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptCall expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptCall.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptSequence expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptSequence.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptReturnScope expr, DekiScriptExpressionEvaluationState state)
The PURGE_RAW_DATA parameter is not included in the stored procedure in the version DWH 2.2.0R1, the retention day is setup to 93 days.
This procedure is fixed in 2.2.1R6
- In SQL Server DataWareHouse, the PURGE_RAW_DATA value is registered in months, and must always be between 1 and 11 before V3.0.
The number entered is the number of months of raw data we will keep in the DataWareHouse.
PURGE_AGREG_DATA: retention period for daily average data in the datawarehouse (monthly is kept indefinitely)
In both Oracle/SQL server DataWareHouse : days
Purge DWH V3
if you need to purge objects in DWH without waiting for the scheduled job to run (it runs everyday at 02:00 AM)
Run the following query on NewtestData for SQL server:
update [dbo].[LogProcedure_Current]
set [LPR_StartTime] = NULL
WHERE [LPR_Procedure] = 'ps_SSIS_CheckJobPurge_SQL'
or for Oracle:
update [dbo].[LogProcedure_Current]
set [LPR_StartTime] = NULL
WHERE [LPR_Procedure] = 'ps_SSIS_CheckJobPurge_ORA'
Comments