To homepage To homepage
Solved

cdata for dynamics 365 for operation not able to refresh.

  • 13 August 2020
  • 7 replies
  • 120 views
E
Rank

I am working on a environment with TimExtender and Dynamics 365 for Operation.  First I must clear out ClientSecret and ClientAuthentication key before I can Authorize to d365.  After that i put in those keys and the session is started.  After a while the sessions is closed and I have to Authenticate myself all over again to be able to extract data form d365.

 

exept from logfiles>

2020-08-13T09.00.37.158+02:00 0 [Connection: 158] Executed connect: Error: AADSTS7000215: Invalid client secret is provided.
Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800
Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759
Timestamp: 2020-08-13 07:00:37Z.
2020-08-13T09.00.37.160+02:00 0 AADSTS7000215: Invalid client secret is provided.
Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800
Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759
Timestamp: 2020-08-13 07:00:37Z.
ffo190j.xa
at ffo190j.nna.C(ra , String )
at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )
at ffo190j.nnI.Y(nnG , BWE , Boolean )
at ffo190j.nnI.q(nnG , BWE , Boolean , Int32 )
at ffo190j.uZf.Q(BWE )
at ffo190j.BKf.b(Bj , BWL )
at ffo190j.BKf.l(Bj , BYE )
2020-08-13T09.00.37.161+02:00 0 [Connection: 158] Failed to open D365FinOp connection. Version: [19.0.7354.0]. Edition: [ADO.NET Provider .NET 4.0].
2020-08-13T09.00.37.161+02:00 0 [Connection: 158] Connection String: _persist_oauthaccesstoken="*****";_persist_oauthexpiresin="3599";_persist_oauthrefreshtoken="AQABAAAAAAAGV_bv21oQQ4ROqh0_1-tAl4pi1L2CXdG2pM_Cf-PvN53RbkkzHsERGEcfGzSJ5h5DTjiGESXReT4yx9feObErj1Glu1ePmyI814jDW0T92vfogcnOdfJubYxh5FnAfhcLgqsSsI4t0S2OD9mtzA0WGkK1l-TVumNQJMjCT3EPV8GAhZBzcCZP9yhPcHaBI5hhMJ6FDkG5FuBDtgv3qN9ZZfKVYvFYxyuD0Q5uQNVEAgYNIc7xB45QnhSpqAl7eJmZY07P8WFqK-oUumYQRvNkCWT0-L46jfglN1VnpjZWCHrX2fJ0c1Vb7Zi9qf6Hfgz4PgcHT8UbC8OuHRaXJAG8pA_NwmJrEpCnNz8SWJYfru_tH7hRvr_YYFLDCvZvnICLgUO3kIb3O5oojcnxDC16hQrbKAT6uiKYOE-7LOQpG5kMBZeK_1Qc74ITqEo6HP8qUbF3DR4PNTJQfvNX5btRPo6evhd6ASZ4-kPypik7yP7HDsWJU2WlpXFzeI_3Pp49ORsvbYqNpIGyiJ1_FBubAXBKKaSsxrUvJQ9tXfXTSM0SBhRZ-YSk7xYcX1aVeMwMKbK4ftF6Jv8656EuHTwv5fJLtS0bGliyuamU791Xqi3_S-szJ-FXTl0fjpBzZDll8c3T2aLu0WQNJZDJsZMX7HKKLAkKpb04T2NeGvR86VuXbs5daTJJWXYyTWZhAApf0V3fsuk4hijcVstw54N1r5TSMQZkeQ3KEseHXwJzNTKR1P-Vf1uC7ErHznW0g9mqLRgpOg2bqGEqYPpa05EMI38ySbUViqoJ22kowpqqHyWKAnDEc-VQ3TBHyksr3d5DwE1Gd_q49AvvfP8EUzih6KDgypKtNTkfoS-fpjISl1ABPqCX6vnL2pRjEF-TmSIeDhzNXMF6CO1Qsc-0uuvxPiyDX2fnHPFlzthD0StKxZrGdMkQEvO7jz8Zkvq71P7iT9HPersYuFbVZrIidLfJeP5F-ut5ZxBsI3sOsm1NMiJUMFdtY-FUOfMW44VxKwfFS5HW-cWQkk936PSnViq8sg1rBAg3DXfGdammPuZ8UNYcukB69aMzZdQ_BIRq4krLW7KFsv48nY1-c4EndIZxDhVl5kDlL0GYfRPL5A3hFiAA";_persist_token_timestamp="1597302036154";adfsserver="";autocache="False";cacheconnection="";cachelocation="c:\CData\D365FinOp Data Provider";cachemetadata="False";cacheprovider="";cachetolerance="600";callbackurl="";connectionlifetime="-1";crosscompany="True";edition="Online";expiresin="3599";firewallpassword="";firewallport="";firewallserver="";firewalltype="NONE";firewalluser="";includenavigationproperties="False";initiateoauth="REFRESH";location="c:\CData\D365FinOp Data Provider\Schema";logfile="C:\CData\D365FinOp Data Provider\LogFile.txt";maxlogfilecount="";maxlogfilesize="100MB";maxrows="-1";oauthaccesstoken="";oauthclientid="f1cc36f9-fc84-417c-bbaf-b05e3821a3b9";oauthclientsecret="*****";oauthgranttype="CODE";oauthrefreshtoken="AQABAAAAAAAGV_bv21oQQ4ROqh0_1-tAl4pi1L2CXdG2pM_Cf-PvN53RbkkzHsERGEcfGzSJ5h5DTjiGESXReT4yx9feObErj1Glu1ePmyI814jDW0T92vfogcnOdfJubYxh5FnAfhcLgqsSsI4t0S2OD9mtzA0WGkK1l-TVumNQJMjCT3EPV8GAhZBzcCZP9yhPcHaBI5hhMJ6FDkG5FuBDtgv3qN9ZZfKVYvFYxyuD0Q5uQNVEAgYNIc7xB45QnhSpqAl7eJmZY07P8WFqK-oUumYQRvNkCWT0-L46jfglN1VnpjZWCHrX2fJ0c1Vb7Zi9qf6Hfgz4PgcHT8UbC8OuHRaXJAG8pA_NwmJrEpCnNz8SWJYfru_tH7hRvr_YYFLDCvZvnICLgUO3kIb3O5oojcnxDC16hQrbKAT6uiKYOE-7LOQpG5kMBZeK_1Qc74ITqEo6HP8qUbF3DR4PNTJQfvNX5btRPo6evhd6ASZ4-kPypik7yP7HDsWJU2WlpXFzeI_3Pp49ORsvbYqNpIGyiJ1_FBubAXBKKaSsxrUvJQ9tXfXTSM0SBhRZ-YSk7xYcX1aVeMwMKbK4ftF6Jv8656EuHTwv5fJLtS0bGliyuamU791Xqi3_S-szJ-FXTl0fjpBzZDll8c3T2aLu0WQNJZDJsZMX7HKKLAkKpb04T2NeGvR86VuXbs5daTJJWXYyTWZhAApf0V3fsuk4hijcVstw54N1r5TSMQZkeQ3KEseHXwJzNTKR1P-Vf1uC7ErHznW0g9mqLRgpOg2bqGEqYPpa05EMI38ySbUViqoJ22kowpqqHyWKAnDEc-VQ3TBHyksr3d5DwE1Gd_q49AvvfP8EUzih6KDgypKtNTkfoS-fpjISl1ABPqCX6vnL2pRjEF-TmSIeDhzNXMF6CO1Qsc-0uuvxPiyDX2fnHPFlzthD0StKxZrGdMkQEvO7jz8Zkvq71P7iT9HPersYuFbVZrIidLfJeP5F-ut5ZxBsI3sOsm1NMiJUMFdtY-FUOfMW44VxKwfFS5HW-cWQkk936PSnViq8sg1rBAg3DXfGdammPuZ8UNYcukB69aMzZdQ_BIRq4krLW7KFsv48nY1-c4EndIZxDhVl5kDlL0GYfRPL5A3hFiAA";oauthsettingslocation="C:\CData\D365FinOp Data Provider\OAuthSettings.txt";oauthverifier="";offline="False";organizationurl="https://bama-uat.sandbox.operations.dynamics.com/";other="";poolidletimeout="";poolmaxsize="100";poolminsize="1";poolwaittime="";proxyauthscheme="BASIC";proxyautodetect="True";proxyexceptions="";proxypassword="";proxyport="80";proxyserver="";proxyssltype="AUTO";proxyuser="";pseudocolumns="";readonly="True";rtk="*****";sslservercert="";supportenhancedsql="True";tables="";tenant="";timeout="60";useclientsidepaging="True";useconnectionpooling="False";verbosity="1";views=""

Log from TimExtender>

[500] AADSTS7000215: Invalid client secret is provided.
Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800
Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759
Timestamp: 2020-08-13 07:00:37Z.

Details:

AADSTS7000215: Invalid client secret is provided. ...
Module: System.Data.CData.D365FinOp
ffo190j.xa
at ffo190j.nna.C(ra , String )
at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )
at ffo190j.nnI.Y(nnG , BWE , Boolean )
at ffo190j.nnI.q(nnG , BWE , Boolean , Int32 )
at ffo190j.uZf.Q(BWE )
at ffo190j.BKf.b(Bj , BWL )
at ffo190j.BKf.l(Bj , BYE )

AADSTS7000215: Invalid client secret is provided. ...
Module: System.Data.CData.D365FinOp
ffo190j.ra
at ffo190j.Vu.h(Int32 )
at ffo190j.Vu.r(wC , Boolean , Boolean )
at ffo190j.Vu.l(Gm )
at ffo190j.Vu.Connect()
at ffo190j.BEd.Connect()
at ffo190j.Tu.Connect()
at ffo190j.jf.Pb()
at ffo190j.jf.Pr()
at ffo190j.jf.ue()
at ffo190j.jn.ue()
at ffo190j.jc.Acquire(String , String , BmB )
at ffo190j.aW.Open()
at System.Data.CData.D365FinOp.D365FinOpConnection.Open()

[500] AADSTS7000215: Invalid client secret is provided. ...
Module: System.Data.CData.D365FinOp
System.Data.CData.D365FinOp.D365FinOpException
at System.Data.CData.D365FinOp.D365FinOpConnection.Open()
at TimeXtender.DataManager.DataSource_CData.CreateConnection()
at TimeXtender.DataManager.StepTransferSSISExecute.BulkCopySource(Boolean executeIncrementalLoad, DataSource dataSource, VariableResolveObject dynamicResolveObject)
at TimeXtender.DataManager.StepTransferSSISExecute.DoStageDataSource(Boolean isIncrementalAllowed, DataSource dataSource, StepSetup stepSetup, VariableResolveObject dynamicResolveObject)
at TimeXtender.DataManager.StepTransferSSISExecute.DoStage(StepSetup stepSetup, VariableResolveObject dynamicResolveObject)

 

icon

Best answer by Anonymous 18 August 2020, 11:45

View original

7 replies

Thomas Lind
Rank
Userlevel 6
Badge +5

Hi Gudmundur

I don't know what version of TimeXtender you are on, but in the current version, the tokens will be stored in a file.

So with the setup I have in my image, the next step is to click on Authorize OAuth. When done OAuthSettings.txt file will be filled with the tokens, instead of being stored in the setup itself.

The file will look like this.

As you can see it has timestamps and whenever they are expired the file will be updated with new ones. The last step after authorizing is to change the Initiate OAuth setting to REFRESH.

If you are in the newest version now. Try to reset the fields where the tokes are located and click on Authorize OAuth. Then check if the file has been created/updated with new tokens.

E
Rank

I have follow your recomendation to the letter and the OSetting file has been updated with new values.  I am not storing it in AppData but in folder on the C drife.

Even so I get Invalid ClientId error when I try to execute from Dynamics 365 when the session has ended.  TimExtender is not reading the refresh token from the Settings file, or there is something else wrong.

 

E
Rank

We are using TimExtender 20.5.5.64.  It would be great to get a solution for this soon.

A

Hi Gudmundur

Can I ask you to attach screen shot of the CData Data Source in TimeXtender, where all Connection String options are visible? (Except Client Id and Secret)

And possibly also a screen shot of the Azure App registration Certificates and Secret expiration dates in question?

Please let me know, if you would like to do an online session.

Kind Regards

Ole Engberg

E
Rank

 

E
Rank

Azure Certificates page:

 

A

Since it isn't possible to authenticate using client id and secret, the issue is probably in the Azure AD App Registration API permissions. Gudmundur investigates this and returns with his findings.

Reply


Terms and ConditionsCookie settings