I run the above reports in the following order
-
Visit Report. The bahmni-reports.log
gives
context [anonymous] 9:23 attribute sortByColumns isn't defined
-
Then I run Patient Information Report. The bahmni-reports.log
gives
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openmrs.concept_view' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2399)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2789)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at org.bahmni.reports.template.PatientReportTemplate.build(PatientReportTemplate.java:35)
at org.bahmni.reports.util.BahmniReportUtil.build(BahmniReportUtil.java:33)
at org.bahmni.reports.web.ReportGenerator.invoke(ReportGenerator.java:49)
at org.bahmni.reports.web.MainReportController.getReport(MainReportController.java:53)
at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
-
The Smoking History Report (which seems to work) The bahmni-report.log
gives
2017-03-10 11:57:29,916 INFO [bahmnireports][org.bahmni.webclients.openmrs.OpenMRSLoginAuthenticator] Executing request: GET http://localhost:8050/openmrs/ws/rest/v1/session HTTP/1.1 2017-03-10 11:57:30,555 INFO [bahmnireports][org.bahmni.webclients.openmrs.OpenMRSLoginAuthenticator] Authentication response: {"sessionId":"EC94B56C6370CB73EFFE67B238D5FD3C","authenticated":true,"user":{"uuid":"78999fca-12b1-11e6-827a-080027d2adbd","display":"reports-user","username":"reports-user","systemId":"Reports User","userProperties":{},"person":{"uuid":"7897cb04-12b1-11e6-827a-080027d2adbd","display":"Reports User","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/person/7897cb04-12b1-11e6-827a-080027d2adbd"}]},"privileges":[{"uuid":"d05118c6-2490-4d78-a41a-390e3596a215","display":"Get Visit Types","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/privilege/d05118c6-2490-4d78-a41a-390e3596a215"}]},{"uuid":"d05118c6-2490-4d78-a41a-390e3596a249","display":"Get Users","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/privilege/d05118c6-2490-4d78-a41a-390e3596a249"}]},{"uuid":"d05118c6-2490-4d78-a41a-390e3596a211","display":"Get Providers","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/privilege/d05118c6-2490-4d78-a41a-390e3596a211"}]},{"uuid":"d05118c6-2490-4d78-a41a-390e3596a231","display":"Get Concept Sources","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/privilege/d05118c6-2490-4d78-a41a-390e3596a231"}]},{"uuid":"d05118c6-2490-4d78-a41a-390e3596a251","display":"Get Concepts","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/privilege/d05118c6-2490-4d78-a41a-390e3596a251"}]}],"roles":[{"uuid":"e49ac8b6-d490-11e5-b193-0800270d80ce","display":"Emr-Reports","links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/role/e49ac8b6-d490-11e5-b193-0800270d80ce"}]}],"retired":false,"links":[{"rel":"self","uri":"http://192.168.33.10/openmrs/ws/rest/v1/user/78999fca-12b1-11e6-827a-080027d2adbd"},{"rel":"full","uri":"http://192.168.33.10/openmrs/ws/rest/v1/user/78999fca-12b1-11e6-827a-080027d2adbd?v=full"}],"resourceVersion":"1.8"}}
Any idea why the first 2 queries reports generate the following log ?
context [anonymous] 9:23 attribute sortByColumns isn't defined
and Table ‘openmrs.concept_view’ doesn’t exist`
I couldn’t find my concept_view in the mysql table. How can I restore it or recreate it ?