org.hibernate.HibernateException: Unable to locate named class org.openmrs.module.reporting.serializer.ReportingSerializer

Oh i see! Do you know the exact metadata causing this? That way i can load only such instead of whole 83MB :slight_smile:

Alright, now no need to to run my database (skip steps 1 and 2); after step 3 above and before restarting the standalone (step 4) run the following SQL onto the database and afterwards proceed to step 4;

INSERT INTO `patient_identifier_type` (`patient_identifier_type_id`, `name`, `description`, `format`, `check_digit`, `creator`, `date_created`, `required`, `format_description`, `validator`, `retired`, `retired_by`, `date_retired`, `retire_reason`, `uuid`, `location_behavior`, `uniqueness_behavior`) VALUES (NULL, 'TRACnet ID', 'Identifier type for HIV patients', '\\d{4}\\-\\d{6}', '0', '1', '2011-01-19 11:37:20', '0', '', '', '0', NULL, NULL, NULL, 'f7c2e4b6-6cb4-4ec2-8a06-0d7b50ed0571', NULL, NULL);

INSERT INTO `concept_class` (`concept_class_id`, `name`, `description`, `creator`, `date_created`, `retired`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES (16, 'Program', 'A treatment program', '1', '2006-08-16 02:04:09', '0', NULL, NULL, NULL, '3d72947a-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES(1482, 0, NULL, NULL, NULL, 4, 16, 0, 1, '2006-08-16 02:05:34', '', 1, '2006-09-27 20:33:54', NULL, NULL, NULL, '3cdb4962-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('1482', 'HIV PROGRAM', 'en', '1', '2006-08-16 02:05:34', NULL, '0', NULL, NULL, NULL, '3e1a9512-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
INSERT INTO `program` (`program_id`, `concept_id`, `creator`, `date_created`, `changed_by`, `date_changed`, `retired`, `name`, `description`, `uuid`, `outcomes_concept_id`) VALUES(2, 1482, 1, '2011-01-19 11:01:17', NULL, NULL, 0, 'HIV Program', 'The program for HIV patients', '5ea0ebfb-cec3-4cce-9479-58cf2ac5b7fa', NULL);

INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES (5497, '0', 'CD4', '', NULL, '1', '1', '0', '1', '2004-08-12 00:00:00', '', '1', '2012-08-16 14:02:19', NULL, NULL, NULL, '3ceda710-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('5497', 'CD4 COUNT', 'en', '1', '2004-08-12 00:00:00', NULL, '0', NULL, NULL, NULL, '3e3f6df6-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');


INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES ('856', '0', '', '', NULL, '1', '1', '0', '1', '2004-05-05 00:00:00', '', '1', '2009-11-12 14:50:26', NULL, NULL, NULL, '3cd4a882-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('856', 'HIV VIRAL LOAD', 'en', '1', '2004-05-05 00:00:00', NULL, '0', NULL, NULL, NULL, '3e129920-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');

INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES ('1085', '0', '', '', NULL, '4', '9', '1', '1', '2005-01-12 00:00:00', '', '1', '2012-06-15 08:12:59', NULL, NULL, NULL, '3cd72184-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('1085', 'ANTIRETROVIRAL DRUGS', 'en', '1', '2005-01-12 00:00:00', NULL, '0', NULL, NULL, NULL, '3e154044-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');

That’s all and you should have the error above

What platform version is your standalone running?

version 1.11.5

What error message gets displayed in the browser on running the standalone?

An error has occurred!

The following error happened somewhere on this page:
javax.servlet.jsp.JspException: org.hibernate.HibernateException: Unable to locate named class org.openmrs.module.reporting.serializer.ReportingSerializer 

(The full error stack trace output is in the source of this page.)

And how does your standalone stack trace look like?

http://pastebin.com/UPfuiiEf

Am failing to reproduce your problem. Did you just download a specific compiled version of the standalone? Or did you clone and build the standalone yourself? Give as much detail as you can. For your sql insertion statements, can you use foreign keys that are part of the standalone’s default data such that one does not get missing foreign keys for things like concept_id, etc? When you run the standalone for the first time, which option did you choose? etc

for those concepts in those SQL, i had to search through and confirmed them as missing in the standalone version i have used and that’s why i wrote those statements creating those specific ones that are missing by their IDS, i downloaded and used standalone version 2.2 from which i replaced the included modules with my above modules and ran as detailed in the above steps

here are the improved steps to reproduce this within a standalone instance

  1. Replace all modules within the standalone appdata/modules folder with; mohorderentrybridge-1.0.2-SNAPSHOT.omod,serialization.xstream-0.2.7.omod,htmlwidgets-1.7.2.omod,calculation-1.2.omod,mohtracportal-0.2.7-SNAPSHOT.omod,rwandasphstudyreports-1.0-SNAPSHOT.omod,reporting-0.9.7.omod. The three custom modules from the list can be downloaded from: https://goo.gl/SqQ9ae (~7MB)
  2. Run the following SQL against your Standalone database;
INSERT INTO `patient_identifier_type` (`patient_identifier_type_id`, `name`, `description`, `format`, `check_digit`, `creator`, `date_created`, `required`, `format_description`, `validator`, `retired`, `retired_by`, `date_retired`, `retire_reason`, `uuid`, `location_behavior`, `uniqueness_behavior`) VALUES (NULL, 'TRACnet ID', 'Identifier type for HIV patients', '\\d{4}\\-\\d{6}', '0', '1', '2011-01-19 11:37:20', '0', '', '', '0', NULL, NULL, NULL, 'f7c2e4b6-6cb4-4ec2-8a06-0d7b50ed0571', NULL, NULL);
INSERT INTO `concept_class` (`concept_class_id`, `name`, `description`, `creator`, `date_created`, `retired`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES (16, 'Program', 'A treatment program', '1', '2006-08-16 02:04:09', '0', NULL, NULL, NULL, '3d72947a-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES(1482, 0, NULL, NULL, NULL, 4, 16, 0, 1, '2006-08-16 02:05:34', '', 1, '2006-09-27 20:33:54', NULL, NULL, NULL, '3cdb4962-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('1482', 'HIV PROGRAM', 'en', '1', '2006-08-16 02:05:34', NULL, '0', NULL, NULL, NULL, '3e1a9512-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
INSERT INTO `program` (`program_id`, `concept_id`, `creator`, `date_created`, `changed_by`, `date_changed`, `retired`, `name`, `description`, `uuid`, `outcomes_concept_id`) VALUES(2, 1482, 1, '2011-01-19 11:01:17', NULL, NULL, 0, 'HIV Program', 'The program for HIV patients', '5ea0ebfb-cec3-4cce-9479-58cf2ac5b7fa', NULL);
INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES (5497, '0', 'CD4', '', NULL, '1', '1', '0', '1', '2004-08-12 00:00:00', '', '1', '2012-08-16 14:02:19', NULL, NULL, NULL, '3ceda710-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('5497', 'CD4 COUNT', 'en', '1', '2004-08-12 00:00:00', NULL, '0', NULL, NULL, NULL, '3e3f6df6-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES ('856', '0', '', '', NULL, '1', '1', '0', '1', '2004-05-05 00:00:00', '', '1', '2009-11-12 14:50:26', NULL, NULL, NULL, '3cd4a882-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('856', 'HIV VIRAL LOAD', 'en', '1', '2004-05-05 00:00:00', NULL, '0', NULL, NULL, NULL, '3e129920-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES ('1085', '0', '', '', NULL, '4', '9', '1', '1', '2005-01-12 00:00:00', '', '1', '2012-06-15 08:12:59', NULL, NULL, NULL, '3cd72184-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('1085', 'ANTIRETROVIRAL DRUGS', 'en', '1', '2005-01-12 00:00:00', NULL, '0', NULL, NULL, NULL, '3e154044-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
  1. Restart the standalone and you will be directed to the http://localhost:8081/openmrs-standalone/index.htm page which has the error

i like @dkayiwa’s way of prolonging this process of re-producing this for others to support or help out, here is a baby follow step to reproduce this in standalone 2.2;

  • Obtain a new compressed file for openmrs-standalone-2.2.zip and extract it, then delete all the modules included by running; rm appdata/modules/*
  • Replace the included 1.11.2 war file at tomcat/webapps/openmrs-standalone.war with a similarly renamed 1.11.5 or 1.11.6 war file
  • Modify the properties file to append &server.socket=/tmp/openmrs.sock to connection.url value
  • Add a file called mysql with the following content (Run nano mysql)
#!/bin/bash
password=`cat openmrs-standalone-runtime.properties | grep connection.password | awk -F= '{print $2}'`
database/bin/mysql -uopenmrs --password="$password" --socket=/tmp/openmrs.sock --max_allowed_packet=96M

And then make the file executable by running chmod +x mysql

  • Start the standalone by running java -jar openmrs-standalone.jar and run through OpenMRS maintenance mode to upgrade from platform 1.11.2 to 1.11.5
  • Run the above script by; ./mysql and in MySQL Client window run; use openmrs
  • Paste the code below in MySQL Client window/shell
INSERT INTO `patient_identifier_type` (`patient_identifier_type_id`, `name`, `description`, `format`, `check_digit`, `creator`, `date_created`, `required`, `format_description`, `validator`, `retired`, `retired_by`, `date_retired`, `retire_reason`, `uuid`, `location_behavior`, `uniqueness_behavior`) VALUES (NULL, 'TRACnet ID', 'Identifier type for HIV patients', '\\d{4}\\-\\d{6}', '0', '1', '2011-01-19 11:37:20', '0', '', '', '0', NULL, NULL, NULL, 'f7c2e4b6-6cb4-4ec2-8a06-0d7b50ed0571', NULL, NULL);

INSERT INTO `concept_class` (`concept_class_id`, `name`, `description`, `creator`, `date_created`, `retired`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES (16, 'Program', 'A treatment program', '1', '2006-08-16 02:04:09', '0', NULL, NULL, NULL, '3d72947a-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES(1482, 0, NULL, NULL, NULL, 4, 16, 0, 1, '2006-08-16 02:05:34', '', 1, '2006-09-27 20:33:54', NULL, NULL, NULL, '3cdb4962-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('1482', 'HIV PROGRAM', 'en', '1', '2006-08-16 02:05:34', NULL, '0', NULL, NULL, NULL, '3e1a9512-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
INSERT INTO `program` (`program_id`, `concept_id`, `creator`, `date_created`, `changed_by`, `date_changed`, `retired`, `name`, `description`, `uuid`, `outcomes_concept_id`) VALUES(2, 1482, 1, '2011-01-19 11:01:17', NULL, NULL, 0, 'HIV Program', 'The program for HIV patients', '5ea0ebfb-cec3-4cce-9479-58cf2ac5b7fa', NULL);

INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES (5497, '0', 'CD4', '', NULL, '1', '1', '0', '1', '2004-08-12 00:00:00', '', '1', '2012-08-16 14:02:19', NULL, NULL, NULL, '3ceda710-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('5497', 'CD4 COUNT', 'en', '1', '2004-08-12 00:00:00', NULL, '0', NULL, NULL, NULL, '3e3f6df6-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');

INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES ('856', '0', '', '', NULL, '1', '1', '0', '1', '2004-05-05 00:00:00', '', '1', '2009-11-12 14:50:26', NULL, NULL, NULL, '3cd4a882-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('856', 'HIV VIRAL LOAD', 'en', '1', '2004-05-05 00:00:00', NULL, '0', NULL, NULL, NULL, '3e129920-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');

INSERT INTO `concept` (`concept_id`, `retired`, `short_name`, `description`, `form_text`, `datatype_id`, `class_id`, `is_set`, `creator`, `date_created`, `version`, `changed_by`, `date_changed`, `retired_by`, `date_retired`, `retire_reason`, `uuid`) VALUES ('1085', '0', '', '', NULL, '4', '9', '1', '1', '2005-01-12 00:00:00', '', '1', '2012-06-15 08:12:59', NULL, NULL, NULL, '3cd72184-26fe-102b-80cb-0017a47871b2');
INSERT INTO `concept_name` (`concept_id`, `name`, `locale`, `creator`, `date_created`, `concept_name_id`, `voided`, `voided_by`, `date_voided`, `void_reason`, `uuid`, `concept_name_type`, `locale_preferred`) VALUES ('1085', 'ANTIRETROVIRAL DRUGS', 'en', '1', '2005-01-12 00:00:00', NULL, '0', NULL, NULL, NULL, '3e154044-26fe-102b-80cb-0017a47871b2', 'FULLY_SPECIFIED', '1');
  • Stop the standandalone by pressing Ctrl + C on terminal
  • Add these modules into appdata/modules folder; mohorderentrybridge-1.0.2-SNAPSHOT.omod,serialization.xstream-0.2.7.omod,htmlwidgets-1.7.2.omod,calculation-1.2.omod,mohtracportal-0.2.7-SNAPSHOT.omod,rwandasphstudyreports-1.0-SNAPSHOT.omod,reporting-0.9.7.omod. The three custom modules from the list can be downloaded from: https://goo.gl/SqQ9ae (~7MB)
  • Start the Standalone and if it doesn’t direct to the page with the error message, login and proceed to the next steps below
  • Click Reporting link from the header of openmrs legacy UI and if you see no available reports click Administration
  • Click on Execute Reports link under Rwanda SPH Study Reports section
  • Click on ART Monthly or Consultation Sheet Setup or Lost to Followup Patients report buttons back and forth once
  • Now clicking back on reporting link in the header should list those three reports
  • Now click on home link in the header and check the tomcat logs for the above error

@dkayiwa, do you think i can make it any better than it is now!

@k_joseph - looking at your module activator class here, could the problem simply be that you have the report setup code in the “willStart” method, but it should actually be in the “started” method?

Give this a shot and let us know if it helps…

Mike