I am trying to provision offline POS in our retail store. We are currently using AX 2012 R2 CU9. When attempting to provision the offline DB with Retail DB utility it always get a timeout when it is starting to populate the DirPartyTable.__tracking table. We do probably have about a million records in this table. I have tried adding "Connect Timeout=900" to the Retail DB utility config file but this does not seem to make a difference as it times out after about 30 seconds. If I remove the DirPartyTable from the Offline scope the offline provisioning will complete with out any errors. But Offline is not usable without the DirPartyTable.
Below are the logs from the Retail DB utility as it times out. Any help is very much appreciated.