Hello everybody,
My stores are set to connect once per hour. At that time, it processes the worksheet 401, and a new 401 is created automatically to run one hour later.
Basic scheduling of connection made by rms.
But once in a while, for one store only, it goes bad.
The DB connects ok, there is no time difference between HQ and store.
Then, the log shows a "error 3704 user does not have the permission when object is closed"
on the next line "an error occured while processing worksheet 0 at HQ"
I never heard of worksheet 0. The worksheet 401 that failed does not create another 401 automatically and the communication process is thus disrputed.
Does anyone here have a fix for that? Do you know what I can do, or what I can check?
Sincerely,