1. Home
  2. Point-Of-Sale Software
  3. HQClient Error: <> Error -2147467259: Location:....

HQClient Error: <<ExecuteCommand>> Error -2147467259: Location:....

Out of no where I'm getting this error message in HQClient in one of my locations. I don't know if this is related but a interstore transfer request was sent and it keeps creating 2 blank transfer-outs and 1 blank transfer-in. Also the software firewall gave me a weird message stating mmgs.exe windows messenger was doing something with the HQclient so do you want to approve yes or no. Can someone help me decipher the error? Thanks...

Error -2147467259: Location: recbase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 240 INSERT INTO[PurchaseOrderEntry](ItemDescription],[LastUpdated], [QuantityRecievedToDate],Purchaseord

then below it....

Error 3251: Object or provider is not capable of performing requested operation. (Unhandled Error, state='9'

Reply to
Matt
Loading thread data ...

Check database integrity (HQ and SO) and verify that two database has same collation...

Antonio

Reply to
Antonio Mazzeo

Hi Antonio...how does one go about doing that?

Reply to
Matt

Hey Antonio, I checked Admin for HQ and SO and they are both using the same collation. However when I check database integrity on the store giving me the problem, I get this error message:

Error -2147212576: Object ID 1927677915, index ID 4: Page (1:3996) could not be processed. See other errors for details.

Much like all of RMS's error messages, I am unable to even begin deciphering what that means.

The store has not polled in days...anyone got any ideas? Thank you.

Reply to
Matt

Got a little desperate and decided to take a shot in the dark and re-indexed the database in store operations admin and it seems to have done the trick... The only thing I'd like to know now is why this happened and why did re-indexing fix the problem.

Reply to
Matt

Store Operation Administrator (and HQ Admin).. Connect to database.. Database | Check..

It's same for HeadQuarters..

Antonio

Reply to
Antonio Mazzeo

Do you have SQL Server 2000 Desktop Engine or another version?? Please check the log of server..

Antonio

Reply to
Antonio Mazzeo

Reply to
Travonna Scales

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.