Hi,
I've noticed, one of my stores is not properly complete the worksheet. It's only happening when Worksheet 401 is backdated.
When I check the Headquarter Server Application, it processes for 2 mins and it gives me the Error message and closes the connection. And when I look at HQ Client at store side, it showing it is processing the worksheet but it look like it just not doing anything.
I have run Check: no errors and Reindex. NO LUCK.
Tried to create and restore DB and NO LUCK.
Tried to use different Headquarter Server Application Port NO LUCK.
Tried to reinstall HQ Client NO LUCK.
Tried to installed MS SQL Server 2005 Express SP4 NO LUCK.
Tried to installed MS SQL Server 2008 R2 Express NO LUCK.
Every night I have to delete the 401 worksheets that are hanging and create a new worksheet to receive full sales data show up in HQ.
Here's the SPEC.
OS Win7 Pro.
i5
8GB Memory
250SSD
Microsoft 2008R2 SQL Server Express
Any advice will be very helpful!
Thank you!
*This post is locked for comments