Job

Modified 12:10, 8 Jan 2014 by ced | Page History

1. Error on step 8 Newtest OLAP Database Processing
1. 1.1. Review details problem
  1. 1.1.1. Solution(s)
2. "User::RefDataValue" differs from the current variable typ
1. 2.1. Review details problem
  1. 2.1.1. Solution(s)
3. See also

Error on step 8 Newtest OLAP Database Processing

Review details problem

Solution(s)

Check if there is no bind error on Newtest schema for the user NewtestDWH.
Reset the schema Newtest and remove sysadmin rights of the NewtestDWH database because this user is already owner of the database.
sysadmin can overload the default schema (dbo) and create the error.

"User::RefDataValue" differs from the current variable typ

Review details problem

Context: 221R3

The Job nrs_Date Transfer is failing with these errors:

Executed as user: Z011094\SYSTEM. ...ion 9.00.5000.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:00:21 Error: 2012-10-26 11:00:36.27 Code: 0xC001F009 Source: Reporting_DataTransfer Description: The type of the value being assigned to variable "User::RefDataValue" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. End Error Error: 2012-10-26 11:00:36.27 Code: 0xC002F309 Source: Check time for Processing Execute SQL Task Description: An error occurred while assigning a value to variable "RefDataValue": "The type of the value being assigned to variable "User::RefDataValue" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.". End Error DTExec: The package execution returned DTSER_FAILURE (... The package execution fa... The step failed.

Solution(s)

Install the NRS R4

Fix ps_NEP_CheckOlapProcessing:

reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)

Callstack:
    at NEWTEST/NRS_-_Reporting/Troubleshooting/Job

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)

Table of contents

Job

Table of contents

Error on step 8 Newtest OLAP Database Processing

Review details problem

Solution(s)

"User::RefDataValue" differs from the current variable typ

Review details problem

Solution(s)

See also

Comments

Attachments

Table of contents