POS Error Invalid Object Name

(0) Share

Report

Posted on by Community Member

HI Experts

One of our client is getting this error in POS system,Please give me any solution.

Error #-2147217865
Invalid Object name'##_ItemReserve_00002'
(Source:Microsoft OLE DB provider for SQL Server)
(SQL State:42s02)
(Native Error:208)

SET NOCOUNT ON
SELECT ISNULL(QuantityReserved,0) As QuantityReserved from [##_ItemReserve_00002]
where (EnterKey = ?) AND (ItemID=?)

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

onontri 100 on at

Like (0)

Report

I am receiving this same error - hope someone posts a response and advice to resolve - thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi experts suggest any solution to come out this problem,repeatedly we are getting this error

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

this is very serious problem, repeatedly POS throwing this error message.I hope someone give the solution for this.

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

Like (0)

Report

Is this RMS or MSPOS? Never seen it before, but we don't sell/support/endorse MSPOS.

Was this reply helpful? Yes No
onontri 100 on at

Like (0)

Report

RMS - I run Microsoft Dynamics RMS V2.0.0105

thanks - alfred

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

this is RMS only.when POS idle for some time then at the time billing we are getting this error.

Was this reply helpful? Yes No
Trent Bourgois on at

Like (0)

Report

Hello Damodar,

Is the client using 3rd party add-ins? If so, please disable them and let us know if the issue persists.

Was this reply helpful? Yes No
onontri 100 on at

Like (0)

Report

Trent - I am using Retail Realm for the CC processing - i cant disable the software because i wont be able to process sales - and, since the error message appears randomly, it would be very hard to isolate the time / steps that trigger the error -

alfred

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

Like (0)

Report

Alfred,

Retail Realm makes a couple of cc add-ons, is this the Mercury one?

But I don't think its the problem, the QuantityReserved is from the TransactionHoldEntry table. That is the one that one uses when one puts a transaction on Hold instead of Layaway and/or Backorder.

I would start by running a re-index and then a check in SO Admin | File | Connect | put in your password | Database | re-index and then run a Check

I don't see anything that jumps out at me with any of the HotFixes or Service Packs that fix this, but I would update to the latest version of RMS if possible, current verion is 2.0.0155 for SP4 and then there are 5 hotfixes to that to bring you to 2.0.0160

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No,Client is not using any 3rd party tools,only RMS installed in that system.

Was this reply helpful? Yes No