Wednesday, July 24, 2013

AX2012 R2 : Synchronize Table – Failed to create a session

Hi All

Today during a DB Sync compare at the end the follow error:

Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics

The code in error was on class SysSetupInstaller Method loadAllData on RunAs command.

After some investigation, I have found on Table USERINFO two records with ADMIN ID ( I have two Partitions ) where the first one had a wrong SID !
After update with the right SID, the Sync process finished with success.

See also AX2012 R2 : DB Sync – Failed to create a session

Enjoy !

4 comments:

Ira Siva said...

Hello,
P0001 job is running for 10 stores.
1. sometime pulling the sales transactions from Retail POS
2. sometime don't.
3. Sometime disappear without any record/history in the upload Session
4. sometime pull only partial data
can someone give us solution please..
regards
Ira Siva

Anonymous said...

I have the same error while synchronizing, but absolutely no problems with Sid. Another idea?

Anonymous said...

i am having a issue , i ran P job , file are in upload folder and in DB it is showing the record with status "2" but i am not getting any information into upload session link .
do you have any clue ?

Anonymous said...

We are encountering the same issue, the data from Store DB was partially pulled.

Have you resolved this issue?