Severe COM/ADO Error in MacMSS.dll 1

[leishad]

Macola 7.6.3 MSSQL - this is the first of many error messages I get when trying to run Physical Count Select (also with Cycle Count Select) it always appears to stop at the same item_no) and then I get a barage of error messages.

This first message seems the most important, it is very long so I will list enough here that someone might be able to give me a direction:
-------------------
Severe COM/ADO error occured in MacMss.dll(ver.1.0.35.9)
DB Provider Error: Native Error number:644
Error number:0x80004005
Could not find the index entry RID .......in index page(1:37468), index ID 4, database 'DATA'
---------------------------
Any assistance appreciated

 

[abaldwin]

Is this happening on only one machine or all your machines?


Check a couple of things.

1. Insure that the shortcut you are running macola from is pointing to a mapped drive such as m:\macsql.......and not a unc drive mapping such as \\macolasvr\macsql.....

2. Insure that you do not have any files or folders in your macola root directory that start with "DATA" except the folders for your data companies.

3. Check the macsql.cfg file in your macola root directory. Should look something like this

SQL_INFO]
Companies_Installed=3
[Company_000]
Name=Demo Data
Server=macolasvr
Database=demodata
Lockdb=MSLLockDB
FRL=False
[Company_002]
Name=Company Live
Server=macolasvr
Database=Data_02
Lockdb=MSLLockDB
FRL=False
[Company_024]
Name=2004 GL
Server=macolasvr
Database=DATA_24
Lockdb=MSLLockDB
FRL=False
[MSL]
MacMSSPacketSize=32767
MacMSSCursorCacheSize=100
MacMSSRowCountSize=-10000
MacMSSCursorLocation=Server
MacMSSUseParamSQL=Yes
MacMSSUsePreparedSQL=Yes
MacMSSUseSrvForSingletonSelects=Yes
MacMSSRowCountGrowthFactor=5
MacMSSRowCountFloor=5
MacMSSUseMSLCache=No
MacMSSUseThreadForMSLCacheWrites=No
[English]
Server=macolasql
Database=Screens
LockDB=msllockdb

Insure that you have the smae number of company entries (anotated as the information between the [] brackets and the lines right below it for the same number of companies that is listed in the Comanies_Installed= line.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[leishad]

It is happening on all machines.

 

[leishad]

The items that you mention to check seem to be as expected.(my config file doesn't have [msl]items)

 

[NEmacGuy]

Guess you have windows XP ? Do you have the reg fix for widnows XP and long running processes loaded on the workstations ?

TCPIP Parameter

 

[keain]

Based on the message, the table's index is corrupt. It will need to be rebuilt, but could also be symptomatic of a deeper hardware issue. You may want to download the SQL Server I/O Stress Simulator from Microsoft's website and run it.

 

[keain]

The msl entries are not necessary. They are pre-7.6.100 requirements. Anything newer does not need them.

 

[leishad]

Thank-you. The rebuild of the IMINVLOC & IMITMIDX files took care of it!