Configuration issues during installation or after upgrade may result in reports not being displayed. These scenarios are mentioned below.
· Tomcat service is not running
· Reports URL not configured properly
· Reports not associated with a revenue center
· Improper database.properties values
The steps to check whether Tomcat service is running are as below.
1. In windows press the following two keyboard buttons simultaneously and release:
a. Windows Icon button
b. R
2. A search box will pop up on the bottom left corner
3. In the search box enter the value services.msc and press enter
4. The Services window will open
5. The list of installed services will be displayed and sorted alphabetically by name
6. In the list displayed in step 5, search for the service name “Apache Tomcat 7.0 Tomcat 7”
7. Check the status column for that row. The value in the status column should be “Running”
8. If the value in the Status column is blank, right-click on the service name Apache Tomcat 7.0 Tomcat 7 and then select Start on the right-click menu
9. Wait for the status column value to change to “Running”
10. Wait for a minute and then verify that the reports are visible
The steps to check whether the reports URL is configured properly are below.
11. Login to the CMS
12. On the home screen, select Settings icon
13. On the Settings screen, select the App Settings icon
14. On the App Settings screen, select CMS Icon
15. On the CMS Setting screen, select the User Interface tab
16. The Reports Login URL field should contain a proper URL, which points to the reports installed on the CMS machine. The format is as follows:
a. http://CMSIP:BIRTPORT/birt/reports.jsp
17. The value of CMSIP in step 6a should be the IP Address of CMS Server machine. The following values instead of CMSIP will result in the reports not being displayed when accessed from any other machine:
b. 127.0.0.1
c. localhost
18. The value of BIRTPORT should be the PORT through which Tomcat can be accessed. Usually the default value during installation is changed to 8180.
19. Execute steps 17 and 18 with correct values and then click the Save button
20. Logout of CMS by clicking on the Logout icon on the top right corner of the screen
21. Verify that the reports are now visible
Each revenue center has to be configured individually to display the reports. The steps to configure the same are below.
22. Execute steps 11-13
23. On the Setting screen select the Report Settings icon
24. The Report Settings screen contains two Panels. The Available Reports panel on the left displays a list of all the reports. The Associated Reports panel on the right displays a list of all the reports that are to be displayed for the revenue center to which the CMS login has occurred.
25. If the Associated Reports panel is blank no reports will be displayed to the user.
26. Select the reports that are to be displayed from the Available Reports panel and move them to the Associated Reports panel by clicking on the Right Arrow icon between the two panels
27. Click on the Save button
28. Logout of CMS by clicking on the Logout icon on the top right corner of the screen
29. Verify that the reports are now visible
The reports to be displayed access the data from the Postgres database which was installed as the first step of the Titbit installation process. If the database configuration of these values is not correct in the database.properties file of BIRT, then the reports will not be displayed. The steps to verify and rectify the same are below.
30. In windows press the following two keyboard buttons simultaneously and release:
a. Windows Icon button
b. R
31. A search box will pop up on the bottom left corner
32. In the search box enter the value services.msc and press enter
33. The Services window will open
34. The list of installed services will be displayed and sorted alphabetically by name
35. In the list displayed in step 5, search for the service name “Apache Tomcat 7.0 Tomcat 7”
36. Check the status column for that row.
37. If the value in the status column is blank, proceed to step 39
38. If the value in the Status column is Running, right-click on the service name Apache Tomcat 7.0 Tomcat 7 and then select Stop on the right-click menu. Wait for the status to be blank
39. Open windows explorer and navigate to the folder C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\birt
40. In this folder, search for the file named database.properties
41. Right click on the file name database.properties and select Edit from the right-click menu
42. The first line of the file will contain a value similar to the following
a. postgres_databaseName = jdbc:postgresql://localhost:5433/TITBIT
43. Contact the person who installed portgres or an administrator and verify that during installation the postgres port mentioned was 5433.
44. If the port mentioned during installation was not 5433 then replace that value with the new value provided. The rest of the values in 42a should be left untouched.
45. Save the file and then close the file
46. In the Services window right-click on the service name Apache Tomcat 7.0 Tomcat 7 and then select Start on the right-click menu.
47. Wait for the status column value to change to “Running”
Wait for a minute and then verify that the
reports are visible