You’re offline. This is a read only version of the page.
We are in the process of migrating from Microsoft Point Of Sale 2.0 to Microsoft RMS 2.0.
Migrating the data has so-far been reasonably simple. The issue we are having is the POS 2.0 Item.Description column in the database was nvarchar(128), in RMS it has been reduced to 30 characters. I have tried altering the column length in the RMS database to 128 and everything I've tested continues to work with 2 exceptions:
1) Recalling held transactions works, putting them back on Hold does not, the transaction disappears when this is attempted. With items on a transaction containing Description field where there are 30 characters or less it works properly, it is only with a transaction containing items that have Descriptions longer than 30 characters this fails silently.
2) Tendering a transaction containing an item where the Description field containing more than 30 characters fails, 30 or less it succeeds. The On failure a dialog box opens with the message: "Run-time error '-2147217887 (80040e21)': Multiple step operation generated errors. Check each status variable. Clicking OK exits RMS
So is there an error log that would provide any insight into why this is happening? I realize extending the the length of the Item.Description and TransactionHoldEntry.Description Columns from 30 chars to 128 is ultimately what is causing the failure. Is there a better way of extending that column length?
I have attempted to use SQL Profiler to track down if the problem is a query error but both scenarios; success and failure on #2 look the same.
Any help or suggestions are greatly appreciated.
Jim
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
