Retail - Data Exchange Sync Service - Exception when pushing to Store DB

Finance and Operations/AX Technical Forum
1

We are evaluating AX for Retail and when going through the “Retail POS deployment checklist” the proper sync messages get added to the IncomingMessages and OutgoingMessages table in the HQ Sync Database, but the jobs appear to not complete. The Store DB IncomingMessages and OutgoingMessages table only gets one record (A-1010) and nothing else after that.

On the HQ machine, the following exception is logged in the Windows Event Log:

2013.1.28 13:18:28:622 (3180) [1] CSysMgr::Main: EXCEPTION: System.ArgumentException: Invalid package number range.
at MessageDBDAL.MessageDBAccess.ReadRangeIncMsg(String serviceName, Int32 firstPackage, Int32 lastPackage, String jobID)
at CSysMgr.ReadRangeIncMsg(CSysMgr* , CMyArray* oIncArr, UInt32 nFirstPkt, UInt32 nLastPkt, basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >* sJobId)
at CSysMgr.CheckStatusQueue(CSysMgr* , CIncomingMsg* pNewMsg, UInt32* nTimeStmp)
at CSysMgr.ProcessWaiting(CSysMgr* )
at CSysMgr.Main(CSysMgr* )

I’m guessing the sudden abrupt end is due to this. Any thoughts?

Here are the first 11 OutgoingMessages on HQ

PackageNo ServiceName DestServiceName DestServerName DestPort ConnectString Status TryCount PasswordFld TimestampFld RemotePkg ErrorNo ServerMsg FinishedDateTime JobID CounterFld Forwarder MessageGUID CancelledByUser

1 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 9 1 1359408142 1 0 Forwarded to HOST1 2013-01-28 13:17:22.723 A-1010 0 HOST1 2C8BEB9D-6096-41CF-8580-CB7CFC0F0DC0 0

2 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 5 0 1359407834 0 0 No records 2013-01-28 13:17:22.327 A-1020 0 HOST1 2AA60DEE-F5CC-4FAB-93D5-812829110D81 0

3 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 5 0 1359407842 0 0 No records 2013-01-28 13:17:24.603 A-1040 0 HOST1 094E3B41-DB55-416C-9690-BB14D4583DE6 0

4 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 4 0 1359407842 0 0 2013-01-28 13:17:24.730 A-1060 0 HOST1 85362041-D8FB-4DB7-8E5A-0A02C9F48892 0

5 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 4 0 1359407842 0 0 2013-01-28 13:17:24.983 A-1070 0 HOST1 5741B6DF-DBE2-400C-A427-165035124E6C 0

6 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 4 0 1359407842 0 0 2013-01-28 13:17:25.120 A-1090 0 HOST1 88E79B81-F4C6-4E28-8C21-3B8ACB2CCA29 0

7 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 4 0 1359407842 0 0 2013-01-28 13:17:25.207 A-1095 0 HOST1 7F9FD5EB-4416-4E7D-90AD-400955BCF0B4 0

8 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 5 0 1359407842 0 0 No records 2013-01-28 13:17:25.243 A-1120 0 HOST1 58ADFD17-36F6-4E33-B1AC-E3485D4DC3CF 0

9 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 5 0 1359407842 0 0 No records 2013-01-28 13:17:25.283 A-1130 0 HOST1 36FC7005-D5D0-4829-9840-C4C86358C77D 0

10 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 5 0 1359407842 0 0 No records 2013-01-28 13:17:25.357 A-Redeploy 0 HOST1 6A70FA82-58CC-47C0-B9A6-44C6A54BA9C7 0

11 W2K8R2ENTSP1 HOST1 HOST1 16750 Application Name=Commerce Data Exchange Synch Service;Data Source=HOST1;Initial Catalog=StoreDB;Integrated Security=SSPI;TrustServerCertificate=True;|AX6Retail_SQL|1 0 0 1359407842 0 0 2013-01-28 13:17:22.497 N-1000 0 HOST1 D4D7C82A-591E-4603-8A54-488286C089DC 0

2

Chad,

I am having the exact same issue and this is the only post I have found on the interweb. Did you figure out what is going on here?

I’d love it if you could point me in the right direction…

Regards,

Simon

3

I blew away the messaging database and re-created it with the Service Settings tool. It now works.

Go figure…

4

That’s exactly what I had to do. I blew away the sync DB and the queue files on disk. Recreated the DB, and the issue vanished. Glad you were able to figure it out. I should have followed up on my posting here, prior. Sorry about that.

Cheers

5

Am having the same issue, plz help me out.

2013.3.29 7:59:20:715 (2256) [1] CSysMgr::Main: EXCEPTION: System.ArgumentException: Invalid package number range.

at MessageDBDAL.MessageDBAccess.ReadRangeIncMsg(String serviceName, Int32 firstPackage, Int32 lastPackage, String jobID)

at CSysMgr.ReadRangeIncMsg(CSysMgr* , CMyArray* oIncArr, UInt32 nFirstPkt, UInt32 nLastPkt, basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >* sJobId)

at CSysMgr.CheckStatusQueue(CSysMgr* , CIncomingMsg* pNewMsg, UInt32* nTimeStmp)

at CSysMgr.ProcessWaiting(CSysMgr* )

at CSysMgr.Main(CSysMgr* )