Table of contents
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:
Comments