P6 locks up or is very slow when loading schedule
I have a BIG issue. I have been running P6.2 standalone for two years with SQL. Yesterday, I could not open P6 at all. I reloaded SQL, I reloaded P6, and I verified my database configuration. Now, I can open P6 but my small schedules take very long (5 minutes) and my large schedules 4000+ tasks dont load at all. P6 just sits there acting like its loading but does nothing. I received an error message yesterday about "shared memory". has anyone encountered this problem before? Any solutions?
Thanks!
I realize that this is years after this string was started; but I have used the fix suggested by Keyel and it has solved my problem. My loading time has gone down from 15-20 mins to about 5-10 seconds.
Thanks
I manage to try this in one of our PC and this http://primaveratools.com/Portals/PrimaveraTools/activeforums_Attach/001_slow_performance_P6.pdf works perfectly. Just use the windows authentication instead of the sql server authentication since our P6 is on a stand alone version. hope this helps.
Cheers,
Keyel
Chris, Have you tried this http://primaveratools.com/Portals/PrimaveraTools/activeforums_Attach/001_slow_performance_P6.pdf? I cant try it since it needs an "SA" account and I have to ask our IT to do it for me. If you can try this and it helps, please provide feedback so we can suggest that this is a solution. BTW, in the forum where I found it, it says that it has to be redone every time the system slows down on loading again.
Regards,
Keyel
Rodel, I am having the same problem as with Chris. I have checked the Primavera background agent and verified that it is running and that it starts automatically. Question is, is there a way to verify that the Symon and Damon are actually running, or better yet can we make it run everyday instead of weekly?
Keyel
Chis, I think I have the same problem as you have. We are running on a stand alone version of P6 6.1 on a 2.66 Ghz intel quad core with 4 GB of RAM running windows 7 32 bit. Our project having 9000+ activities loads but it takes about 20 minutes to load. Have you found a solution yet?
Keyel
Yes it can, refer to your Primavera Admin Guide. I believed Damon run every Saturday by default.
It might be and your memory is not enough. It will not compact immediately. Cleaning will be done weekly so I’m not sure when the last run was. Observe for one week if still the same otherwise consult your IT to change the settings to daily and once it run smoothly change it back to weekly.
Note: Background agent is running I think because you said you just reinstall SQL again which just update the driver and run which means does not clean up the system.
Chris, another suggestion is creates another database and run using another database. You might find that new database is running fine. You can access any of these databases anytime.
Thank you for your response. My Background agent is running. However, I restarted it and the problem remains. Could my database just be too big?
Check if Primavera Background Agent is running. (Select Start-> Settings-> Control Panel-> Administrative Tools-> Services. Look for Primavera Background Agent and double click. Click start if the status is not started. Also set Start up Type to Automatic.) The use of this service is to run SYMON (System Monitor)run daily and DAMON run weekly(Data Monitor). These two programs running in the background to clean up system and data (i.e. log files, caches, deleted files and recorded action for undo’s) If Background Agent is not running then PC will slow down and memory will be full.
Hope this help.
Replies