Share
Report
30Has anyone experienced any rounding issues with the "CurySlsPrice" column in the “SOHeader” and/or “SOLine” tables (or with any other float columns for that matter)? We've seen this happen intermittently on SL 2011, where the number rounds up (e.g., 14.56 rounds to 15.00). We have 2 SL databases hosted on the same SQL Server that point to separate instances of Process Manager running on different boxes.
The only pattern we've been able to discern is, if an order is placed in one database and another order or two is submitted to the other database a few minutes later, we see the rounding issue in the latter order(s). Again, this is intermittent (so nearly impossible to reproduce), and the problem goes away after a few minutes.
We suspect that perhaps even though there are separate Process Managers for each database, if they are running concurrently against the same SQL Server instance, maybe a cursor isn't closing properly and the Process Manager thinks the column is an int instead of a float? Setting up a SQL Profiler trace shows the values getting written to the tables correctly upon order creation, and Process Manager updates the tables soon thereafter--and that's where the problem appears to be.
Thanks for any advice.
*This post is locked for comments
All responses (
Answers (
