RMS 1.2 Database connection lost, application will be closed.

While doing year end inventory we have come across the following errors and the software closes.

---------------- Store Operations Business Rules Database connection lost, application will be closed Error #-214746759 Connection Failure (Source:Microsoft OLE DB Provider for SQL Server) (Sql State: 08501) (NativeError:0) No Help file available

SELECT GETDATE() AS CurrentDateTime

------------

Store Operations Business Rules the index entry for row ID was not found in index ID 3, of table 453576654, in database 'Gallery_live'. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: HY000) (NativeError: 8646) No Help file available UPDATE Item SET LastCounter = CASE WHEN CountTime IS NULL THEN Last Counted ELSE CounTime END FROM ##PhysicalInventoryScratch_0_1 INNER JOIN Item.ID = ##PhysicalInventroyScratch_0_1.ItemID

----------------

The computer is a IBM 4910-32m VIA Nehemiah chip @1.19ghz

380mb

History... The system worked fine last year for year end reconciliation. I added a different network card because the built in one was not reliable.

-----------------

Any ideas on solving this problem would be great.

Submitted via EggHeadCafe - Software Developer Portal of Choice SQL Server - Insert Record And Get New ID

formatting link

Reply to
Damion Knight
Loading thread data ...

It looks like you need to do a re-index from the RMS Administrator.

Reply to
Michael

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.