Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Dynamics CRM + SSIS + Cozyroc: The security token could not be authenticated or authorized. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi all,

    I'm working on a data migration project using Cozyroc SSIS+ 1.6 SR-3. The process involves the creation of Contacts and their activities coming from a legacy system - SQL Server Database. The package is very simple 2 Data Flow Tasks, one for Contacts using OLDB Source and Dynamics CRM Destination and another Data Flow Task for phonecalls using the same OLDB Source and Dynamics CRM Destination. 

    After I tested the mappings with 100 to 500 records I proceeded to make a more realistic test and I tried to insert up to 10,000 records. That failed with the error:

    [Destinatoion WRCTESTDEV [44]] Error: An error occurred with the following error message: "System.ServiceModel.Security.MessageSecurityException: An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. ---> System.ServiceModel.FaultException: ID3242: The security token could not be authenticated or authorized.
       --- End of inner exception stack trace ---

    At the beginning I thought it was some plugins running on create of Contacts but I disabled them and I got the contacts created faster. Then I ran another test to create 10,000 contacts and their phonecalls - around 68,000 records - and that failed again. After many other tests I got to the point where I can create 10,000 contacts and about 30,000 phonecalls but something I found is the Package errors out after 8 hours and 5 minutes of running. 

    My CRM version is 2013 with IFD.

    Ricardo Barona Application Developer

    Friday, May 22, 2015 3:53 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    It sounds like the CRM Destination is authenticating at the start of the package, and then never re-authenticating. With IFD, a user needs to reauthenticate within a given timeout period, which is configured in ADFS.

    It's worth asking Cozyroc if they have an option to reauthenticate; if not you'd either have to limit your package so that it is never likely to take as long as 8 hours, or you can change the timeout in ADFS - see http://cognettacloud.com/?p=383

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, May 22, 2015 4:10 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    It sounds like the CRM Destination is authenticating at the start of the package, and then never re-authenticating. With IFD, a user needs to reauthenticate within a given timeout period, which is configured in ADFS.

    It's worth asking Cozyroc if they have an option to reauthenticate; if not you'd either have to limit your package so that it is never likely to take as long as 8 hours, or you can change the timeout in ADFS - see http://cognettacloud.com/?p=383

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, May 22, 2015 4:10 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    That make sense. I will give it a try and will let you know. 

    Thanks!

    Ricardo Barona Application Developer

    Friday, May 22, 2015 4:29 PM