Hi,
I have a 3 Box environment (one SQL Box and 2 AOS Box) One AOS has DIXF running in it. Sometimes the DIXF stops running and when I look at logs it says " Cannot insert data into DMF* table. Error accessing database.".
Since this is unexpected error, DIXF goes into waiting state.
I did check the event log in SQL Box. I find an error for AX-Util (Copied the full error below). I am not sure what is causing this. I believe this causes the DIXF error above. I do not though find any other error in evnet log.
I have no idea what could be the reason. I am using AX 2012 R2 with CU7. Any suggestion on what this is / what is causing it or how to resolve would be helpful.
One point to note : We have changed both the AOS service and DIXF service account from network service account to an domain administrator account (in services.msc). We gave db_owner access to all the databases (ProdDB, ProdDB_Moldel and baseline database). Not sure if this might be causing this.
The full error on event log is below:
AXUtil operation failed : Validating Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=0; [Login] initialization=0; authentication=0; [Post-Login] complete=14998; Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=0; [Login] initialization=0; authentication=0; [Post-Login] complete=14998; The wait operation timed out Server: 172.XX.X.XX Database: DynamicsAXDB_model Layer: Model: Schema: 1.9 AXUtil version: 6.2.1000.4051 Executed by: Administrator
- Girija
*This post is locked for comments
I have the same question (0)