Developer forum

Forum » Development » User Destination Activity

User Destination Activity


Reply
Is the 'User Destination' activity flawed in the 19.0.1.8 version.

I have the 19.0.1.9 version on my local mashine, and been developing some activitys to import some users, at the end of my pipeline i use the standart User Destination activity, at it works perfect.

But on the clients version it fails with the error:
12:40 PM User destination Error processing XML or executing SQL: Must declare the scalar variable "@Identifier".

Here's an example of the XML passed to the User Destination activity:

<Users>
    <User>
        <AccessUserID>11105318</AccessUserID>
        <AccessUserParentID />
        <AccessUserUserName>11105318</AccessUserUserName>
        <AccessUserPassword>xxxxxx</AccessUserPassword>
        <AccessUserName>L&amp;K Björkman Försälgnings AB</AccessUserName>
        <AccessUserDepartment />
        <AccessUserEmail />
        <AccessUserPhone>11105318</AccessUserPhone>
        <AccessUserFax />
        <AccessUserType>5</AccessUserType>
        <AccessUserValidFrom />
        <AccessUserValidTo />
        <AccessUserPages />
        <AccessUserAreas />
        <AccessUserSettings />
        <AccessUserModules />
        <AccessUserInformation />
        <AccessUserMyFolder />
        <AccessUserAddress>Örtugsgatan 68</AccessUserAddress>
        <AccessUserAddress2 />
        <AccessUserZip />
        <AccessUserCity>S-603 79 Norrköping</AccessUserCity>
        <AccessUserCountry>SWEDEN</AccessUserCountry>
        <AccessUserJobTitle />
        <AccessUserCompany>L&amp;K Björkman Försälgnings AB</AccessUserCompany>
        <AccessUserPhonePriv />
        <AccessUserMobile />
        <AccessUserCustomerNumber />
        <AccessUserRedirectOnLogin />
        <AccessUserCurrencyCharacter />
        <AccessUserRead />
        <AccessUserAdsiMap />
        <AccessUserPasswordDate />
        <AccessUserLastName />
        <AccessUserMiddleName />
        <AccessUserActive>True</AccessUserActive>
        <AccessUserBusiness />
        <AccessUserInitials />
        <AccessUserComment />
        <AccessUserLevel />
        <AccessUserInheritAddress />
        <AccessUserWeb />
        <AccessUserSort />
        <AccessUserStatus />
        <AccessUserStatusBegin />
        <AccessUserStatusEnd />
        <AccessUserStatusComment />
        <AccessUserEditorConfigurationID />
        <AccessUserHideStat />
        <AccessUserGroups>
            <GroupID GroupName="@19387@" />
        </AccessUserGroups>
        <AccessUserInformationFields />
    </User>
</Users>

Replies

 
Nicolai Høeg Pedersen
Reply
Last change of that activity is 7/8-2009 - released with 19.0.0.0.

It sounds more like a database issue - could you check if the AccessUser table has auto increament on its primary key (AccessUserID)?

 

You must be logged in to post in the forum