Missing Transfers in RMS - Microsoft Bug STILL

(0) Share

Report

Posted on by Community Member

H8171.HQMessageHQ.jpg"Automatically create inter store transfers" options checked in HQ Configuration

Secondly, we have the SQL which will fix this and have actually developed a tool with a user interface to simply this process for our end users.

My question is, why is the root cause of the issue still not fixed? It has been claimed to have been resolved in a previous hotfix (Prior to 2.0.0.126) and there has been no subsequent release note to indicate the issue is fixed. We have lodged several support cases with Microsoft and we are either told to upgrade to the latest service pack or they are unable to replicate the issue. I don't think it is being taken seriously.

It appears to be an issue with HQClient. Periodically, HQ Client does not populate the HQMessage table in HQ

This image shows the HQMessage table in the sending store. It has 2 records for attachmentid 6450 (The first 2 records) which is the InterStore Transfer. The other 2 records show a transfer which has been sucessfully downloaded to the receiving store. Aside from the obvious differences, these records are the same, from a logic point of view.

This next screen shows the HQ Client log for the time the HQMessage (Above) was sent to HQ. It has not logged any updates to the HQ Message table. In successful Inter Store Transfers, during the WS401 process, the HQClient Log clearly states when the HQMessage table has been updated.

And the final screen shows that there are no entries in the HQ Databases HQMessage table at all.

To me, this is a clear bug in the way HQClient is operating. And I can't be the only user, or reseller with a pissed off client. This particular client has 27 stores and they are finding 10 transfers a day not being uploaded correctly.

Microsoft - when will this issue be fixed, and is anyone else fed up of this situation?

Regards,

Matt

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Community Member on at

Like (0)

Report

Also, this happens on all varieties of SQL Server and Windows OS. This example was with Windows 7, SQL Express 2005 SP3 at Store and SQL Server 2008 at HQ.

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report

Matt,

You have sold hundreds of copies of RMS and this is your most pressing issue?

This has been discussed on the reseller sites many times. The first thing you need to check is that the clocks on each of the stores and HQ server is correct. Even being 10 seconds off will cause this problem. If the approving store's clock is 10 seconds behind of the recieving store, the effective time has already passed.

We suggest to our clients is to set the effective date/time is 15-30 minutes in later then the current time. That seems to solve most worksheet issues especially with so many stores involved.

Was this reply helpful? Yes No
Rick McKeon 990 on at

Like (0)

Report

What do you mean by "effective date/time?" Are you referring to the PC clock (ours are sync-ed with the server automatically) or something within the transfer? I have this problem also and have noticed it happens if both stores poll at the same time and the sending store's polling session finishes after the receiving store.

Was this reply helpful? Yes No
Dave B 20 on at

Like (0)

Report

Hello

Yes im a bit confused by this also? What do you mean affective date and time? There is only a option to adjust the effective date and time if you are using worksheets. Is this what you mean to set the effective date and time half an hour in advance in normal day to day use with normal worksheets as a matter of course

And just expanding on the auto created inter store transfers I can understand that timing is of most importance does this then point to the date/time stamp being the condition (Flag) for polling and not the worksheet status?

I wonder if anyone can help me fill these gaps in my knowledge

I will be really interested in your response

Thanks In advance

Dave B

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes - This is the most pressing issue. We have worked around many of the issues we have come across by developing addins and tools to work around things. But this one is a fundamental issue. We have one client where this is consistently happening throughout their 27 store estate. They are performing 5-6 transfers per store per day, and about 5 go missing. Its not unreasonable to expect RMS to handle these correctly, as having to sweep up behind RMS everyday when they have purchased the software which is supposed to work is adding to their HR costs.

THe effective date/time is also a non starter - HQ Client should be automatically processing and creating new WS 401s each hour in the setup they want. Its not possible to back/forward date/time these worksheets which are automatically created.

I have managed to recreate this issue twice following the same procedure however the third time I ran the same procedure it did not produce the problem. I know it is to do with the WS401s and I think it is to do with when there are more than 1 401 waiting to be processed - A manual one and an HQ Client created one, but need more time to test this theory.

Was this reply helpful? Yes No
Campbell Downie 70 on at

Like (0)

Report

Hi there

yes agreed this is an issue we have seen this also in a new client, we are a small new zealand reseller and our second HQ rollout has this issue and has caused massive inventory problems for our customer... stock has litterly left one store and never arrived at the second store and its thrown inventory values out all over the chain.

This is a bug and certainly is NOT fixed in any of the SP packs or hot fixes. We do need this looked at for certain.

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report

All,

Sorry, I was thinking worksheets when I said Effective Date. Transfers are Date Required.

If you look at the Purchase and the InventoryTransferLog tables (the tables that keeps track of POs and Transfers), you will see that the Date Transferred as well as Date (creation date) and Last Updated are counted to the second. If the clock is off, the time may have already passed if the remote computer's clock(s) are wrong.

Also, if one is creating a Transfer or worksheet while a 401 is running for that store, the worksheets and transfers can be whacked too.

Another thing to worry about, never ever change a PO or Transfer number. Let the system create the numbers. If you need more info about the transfer/PO, put it in the comments.

FWIW, we have over 200 bugs/annoyances internally logged for RMS. Remember that RMS has not had a HotFix for 13 months or a Service Pack for 20 months. The highly touted Feature Pack 1 was released 3 months ago, but did not include a single bug fix, it only introduced more buggy features. We are not recommending the installation of it at this time.

Was this reply helpful? Yes No
Campbell Downie 70 on at

Like (0)

Report

in addition to this we have also seen partial transfers...

what happens is some of the transfer comes through and whole sections of items are missing at the recieving store... so they leave store A but only half arrive at store B in the transfer... messy and very confusing...

regards

cam

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Matt,

I have this same issue. My setup consists of 14 stores, 2 warehouses(also set up as stores,) and an hq server. This occurs randomly to a degree...usually on days of heavy interstore transfer(several receiving transfer orders from to different stores never show up) but occassionally it will occur on just one transfer.

All of our stores and the HQ server sync their system clocks with the DC on the network. I've come across other posts in the forum which list all of the SQL scripts to try to locate and "FIX" these transfers.

I'm interested in this add on that you have for working on this issue. Please contact me with more info.

Thanks,

Chris

Was this reply helpful? Yes No
Keith.N on at

Like (0)

Report

Have you gone through the following KB article?

ArticleID: 911389.

You experience unexpected results when you try to process inventory transfers in Headquarters or in Store Operations

support.microsoft.com/.../911389

Was this reply helpful? Yes No