SRT

The page features FAQ questions and answers with appropriate links.

Documents

1. Why can’t we search documents?
2. Are my documents encrypted in the database?

MySQL

1. After setting maxConnections in my db_en_US.properties file, MySQL (or Tomcat) tells me I’ve reached the maximum number of connections and it’s lower than my property. Why?
2. When saving a large entry to my report, I received an error stating I had exceeded the amount of memory available. Why?
3. I get an error message saying “timeout value is negative” when trying to hit the login page. What’s wrong?

Suggestions

1. Do my suggestions go anywhere?

Bugzilla

Q:1 Why can’t we search documents?

Due to the various security constraints, it’s not possible to put an index on the documents as-of-yet. An Oracle database could implement fulltext searching, but it would not honor the various dynamic constraints you establish. Currently, MySQL does not have a similar indexing mechanism. Third-party tools do not allow interjection of your constraints as well. We will continue to monitor available technologies and provide search capabilities when feasible.

Q:2 Are my documents encrypted in the database?

We do not presently encrypt documents stored in the database. The reason for this is the high amount of overhead placed on saving and loading an encrypted document. We are, however, open to requests and suggestions as to the viability (and/or perceived necessity) of such an option.

Back to Top

Dashboard

Q:1 After setting maxConnections in my db_en_US.properties file, MySQL (or Tomcat) tells me I’ve reached the maximum number of connections and it’s lower than my property. Why?

You may need to set the MySQL property “max_connections” to zero (for unlimited connections) or to the same value you set the maxConnections property. On Windows, you can do this in your my.ini file.

Q:2 Why include both the Classic and the Portal view? Can’t I just use the Portal view?

MySQL has a default maximum packet size of 1M. If you are entering large reports (perhaps citing a source), you may need to increase the “max_allowed_packet” size in your my.ini file. If it doesn’t exist, add it to the .ini file and use a larger setting, e.g. 20M or 32M or as appropriate for your largest updates.

Q:3 I get an error message saying “timeout value is negative” when trying to hit the login page. What’s wrong?

If you see something like the following:
java.lang.IllegalArgumentException: timeout value is negative java.lang.Object.wait(Native Method)
com.wmpnj.statusreports.components.ConnectionPool.getConn(ConnectionPool.java:191)
com.wmpnj.statusreports.components.ConnectionPool.getConn(ConnectionPool.java:206)
com.wmpnj.statusreports.components.ConnectionPool.getConnection(ConnectionPool.java:174)
com.wmpnj.statusreports.authentication.Login.doPost(Login.java:83)
com.wmpnj.statusreports.authentication.Login.doGet(Login.java:62)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

check your db_en_US.properties file. The most probable cause for this is that you have mistyped some part of the jdbc connection URL, such as the database instance name.

Back to Top

Suggestions

Q:1 Do my suggestions go anywhere?

Like your status reports, the Suggestions are for your internal use unless you decide to release them. Thus, by default, a Suggestion is not e-mailed or communicated to anyone in any way. We will be adding an option allowing you to determine if you wish to automatically notify someone and, if so, whom you want e-mailed.

Back to Top