Macola Screens slow to load.

[jake29]

This is kind of long, but I needed to sound this out...

About a year ago with the help of our VAR we migrated from NT/SQL7 to Win2003/SQL2000.

We had one show stopping issue where they forgot about having to update the macsql.cfg. Corrected and since then the system has been running about as well as can be expected. That was until last Sunday when the server that Macola had been running on started having problems.

Here is the interesting part that I am hoping someone may be able to shade some light on.

When the old server starting having the problems, I brought it down to run diagnostics.

Soon after we started to notice Macola was acting up.

PWE and SQL Explorer would load normally but some screens (PO/OE/AP) would load slowly, some depending on the screen will take from 30 to 60+ seconds to come up.

Now, I had just this week added some Flex code into the OE and PO screens and was thinking it was a change that I made. But it did not make sense. So I went into account who's screens do not have any of my code on them and the had the same issue.

Then I tried disabling and then finally uninstalling our AV. No change. Scanned over the Registry, shared Macola folder and looked at all ini and cfg that I could think of. I did not see anything, with my limited experience as out of the ordinary.

Pull Macola off the system. Deleted Reg entries, Shared Macola folder and macola.ini. Reinstalled. Same problem.

Now back the old server. Since moving Macola I put a clean install of W2k Advanced Server that I am using for File/Print and IIS. The server name and IP address are the same though.

After the move I went to all the workstation removed Macola (Delete Reg, Macola folder and .ini) uninstalled SQL 7. Installed SQL 2000 connectivity, Macola, Flex, ER5 CRW etc.. updated the MDAC to 2.8. and this is what is still running on all the clients today.

Another thing, the problem is only with systems that where on the network before the move. New systems that have refresh installs WinXp, Win2K, since do not have this problem.

I have since brought the old server back online and all the issues with slow loading screens have gone away.

I am thinking there is a pointer somewhere that is causing this.

Any ideas???

Thanks

 

[kscheeler]

It's in the registry. The hklm\software\macola key is just one of the keys that get written to when you do the Macola install. Flex writes to alot of other places like classes clsid. It probably has a unc path showing the path of the old server.

Do a search on the web for a program called filemon.exe and regmon.exe which shows all files accessed, updated, etc.. on the local computer. You can apply some filtering but it should show you which keys it is looking at.

Typically, deleting the hklm\software\macola key, the macola shared folder and the macola7.ini file and then reinstalling Macola / Flex will do the trick. In your case, you probably will have to edit the registry entries to clean up the keys if the above doesn't work.

Kevin Scheeler

 

[jake29]

I had actually run both of those and scanned the results quickly but nothing jumped out at me. I will run them again and post back with what I find.

Thanks