Hi everyone. Every time I view journal or produce any report on my system it hangs. What could be the problem, the dbsize is 35gb and logfile is 768kb. Have tried to reindex the db witjout success. Any help please, urgently
*This post is locked for comments
RMS Versions end in four digits not two.
The Database size limitation for SQL 2008 R2 is 4 GB.
The Database size limitation for SQL 2008 R2 Express is 10 GB.
The database size limit for SQL Standard (Full SQL) or Enterprise is unlimited so as you have suggested the database size is 35 GB my first instinct is you must have a full SQL version is that correct?
When you are running the reports are you getting the same lag on the server where the reports are hosted?
1. If so, then you do not have SQL Configured correctly on this machine (because 35 GB) is not a very big database size.
2. You may not have set inbound and outbound rules for RMS and Port 1443 through Windows Firewall or any third party security software you are using other than MS to allow the reports to cache and communicate between RMS and SQL.
3. You may want to start a SQL trace (since this is full) and run reports to see if the trace shows some indications as to what within the data may be contributing to the lag.
4. I would first focus on getting the server configured and tested so that it runs reports as it should then move to the other machines.
5. Connect to the sample database (s setting that up takes just a few minutes) then run some reports see if you get the same lag (again just on the server).
6. Update RMS to something other than 2.01 as all RMS customers by now with the new PCI requirements for 2012 should be minimally be on 2.0.2000.
7. Asking for help on the forums is a good idea, doing so with an environment that isn't being maintained with current versions of RMS for whatever reason seems a bit redundant? Since the lag you may experiencing? May have been addressed in a new version of RMS or may have been corrected if you had used the new PCI compliance and setup recommendations which are included in the RMS 2.0.2000 download/update which if memory serves was released almost 4 years ago.
You're a little behind, you may want to address that first?
Just a thought.
hi Robert, thanks for your response
Am using rms version 2.01
SQL SERVR 2008 r2
it hangs when i produce tender summary report, but basically any report, even for just a single day sales report. and when trying to search journal its worse
Have tried reindexing the database but wouldnt improve
You have the issue on the machine hosting the database or from machines connected to the database.
1. What version of RMS?
2. What Version of SQL? What Service pack?
3. You have lag or hanging during any other processes or procedures?
4. Did the issue recently start or did it start after an update or upgrade to your environment?
We will need a bit more information I believe in order to assist you with this, thanks.
which report are you running and what are the parameters? With a database that size it could simply by the report query is taking a long time to return results.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (