Was this page helpful?

Job

     

    Error on step 8 Newtest OLAP Database Processing

    Review details problem

    Error log 

    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)

     

    See also

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    3497 view(s), 7 edit(s) and 6534 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments

    FileSizeDateAttached by 
     Log nrs_DataTransfer error.txt
    No description
    9.32 kB17:27, 31 Oct 2013cedActions