Rebuild ...zero records ...all files

[mystifying]

Hey! I am in need of some help yet again. We were having some problems with a customer file, so we thought we probably should start by rebuilding the data files. No matter what file we go to rebuild, it comes back with zero records. We have two companies and both are the same. A little background ...it is ver 7.6.100a using MS SQL 2000. One thing that has changed of recent (about 2 months ago), we moved Macola to a new server, Windows 2003 Server. No other problems and everything has seemed stable since the move (with the exception of this of course). Any ideas?

Thanks,
Stacy

 

[kscheeler]

Usually, if you get that message, someone has that table open. You would probably have to kick most people out of Macola to rebuild the customer or item tables since most progams open them up for their screens.

You can use the following query to see what tables are open and who has them open.

use msllockdb
select * from macopentables
go

sp_who

The sp_who will show you the user name that matches up with the sessionid


Kevin Scheeler

 

[dgillz]

Run a file validation report on the customer as well and see what errors if any are on the report.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[crystalreporting]

Permissions on the data folder(s)? Remember, even though the actual database is held within SQL, temp files, 'print to file' files and a number of others are held in the data folder(s) underneath MACSQL. For each company in MS/SQL, there should be a corresponding folder under MACSQL on your server. Macola's rebuild utilities (I presume that's what you are using) export to text, initialize the table, then import from text. The temporary text files are held in the folder(s) under MACSQL. If there's a permissions problem with these folder(s), or they don't exist - that could be your problem.

Peter Shirley

http://www.linkcorp.com

 

[mystifying]

Well, I tried again today and now I don't even get a report of zero records. It locks up before then and that screen stops responding althogether. Ack! I hope this doesn't mean things are THAT messed up in our files! Anyone had this happen before?

 

[dgillz]

Stacy,

Did you run the SQL query that Kevin suggested? Are you sure there are no open tables?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mystifying]

No, I didn't. I was shown once how to run a query, but it has been a while and I wasn't sure. But I was trying this morning (Sunday) on a day no one else was in the office and it was right after a fresh restart on the server, with no ghosts in the user file. Could there still be tables open in that circumstance?

 

[dgillz]

Not after you restarted the server.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mystifying]

Thanks for the help. I don't know what happened, but I tried again today and it acted like it was going to lock up, then it was like something broke loose and everything started working again. We rebuilt the data files and so far no more problems. Computers give me a headache some days.