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

Apr 09, 2005 7 Replies
M

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'



Vote
Twitter Facebook LinkedIn
A

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

Antonio

Vote
Twitter Facebook LinkedIn
M

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.

Vote
Twitter Facebook LinkedIn
M

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.

Vote
Twitter Facebook LinkedIn
A

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

It's same for HeadQuarters..

Antonio

Vote
Twitter Facebook LinkedIn
A

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

Antonio

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required