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

  • Question

  • 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

  • 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

  • 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
  • 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