org.obiba.magma.MagmaRuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Action: test OPAL-226 Step: ========= 1) create fresh databases 'opal' and 'key' for opal 1.0.1 2) issue an upgrade 3) import a zip file with 1 completed interview exported from onyx1.6.4 cohort ontario (please check the attachment in OPAL-226) 4) show variable table list 5) export tables one by one to an excel file based on the listed tables Result: ========= in step 4), the listed tables shown as follows: opal-keys opal-keys.keys opal-data-ohs opal-data-ohs.Participants opal-data-ohs.CIPreliminaryQuestionnaire opal-data-ohs.BloodSamplesCollection opal-data-ohs.HealthQuestionnaireNurse opal-data-ohs.Weight opal-data-ohs.BoneDensity opal-data-ohs.SalivaSamplesCollection opal-data-ohs.BloodPressure opal-data-ohs.ArmSpan opal-data-ohs.SittingHeight opal-data-ohs.GripStrength opal-data-ohs.AnkleBrachial opal-data-ohs.UrineSamplesCollection opal-data-ohs.HealthQuestionnaireTouchScreen opal-data-ohs.Impedance418 opal-data-ohs.ConclusionQuestionnaire opal-data-ohs.Instruments opal-data-ohs.Consent opal-data-ohs.StandingHeight opal-data-ohs.Hips opal-data-ohs.Spirometry opal-data-ohs.Waist opal-data-ohs.Workstations opal-data in step 5), there're two cases when exporting tables to xlsx file: ==>case a) able to export as many as required tables when tables have regular number of columns (not big number more than 256) to a single excel file for example, adm@opal>export -o a.xlsx opal-data-ohs.SalivaSamplesCollection adm@opal>export -o a.xlsx opal-data-ohs.BloodPressue adm@opal>export -o a.xlsx opal-data-ohs.ArmSpan adm@opal>export -o a.xlsx opal-data-ohs.SittingHeight adm@opal>export -o a.xlsx opal-data-ohs.GripStrength adm@opal>export -o a.xlsx opal-data-ohs.AnkleBrachial adm@opal>export -o a.xlsx opal-data-ohs.UrineSamplesCollection here, no big number of columns to be exported in each table above, the process of export was very smooth. ==>case b) only able to export one or two tables with extra multiple columns to a single excel file in this datasource, there're 3 tables with extra multiple columns (more than 256): opal-data-ohs.CIPreliminaryQuestionnaire opal-data-ohs.HealthQuestionnaireTouchScreen opal-data-ohs.HealthQuestionnaireNurse it worked fine when continued exporting any one of the 3 tables to the existing 'a.xls' (generated in case a): adm@opal>export -o a.xlsx opal-data-ohs.CIPreliminaryQuestionnaire then, continued exporting second table with extra multiple columns to the same 'a.xls' adm@opal>export -o a.xlsx opal-data-ohs.HealthQuestionnaireTouchScreen occassionally, it worked. once this worked, continute exporting the 3rd table 'opal-data-ohs.HealthQuestionnaireNurse', it would definitely give the error as follows (if the second table couldn't be exported successfully, the generated error would be the same one): Error info: org.obiba.magma.MagmaRuntimeException: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException at org.obiba.magma.support.Initialisables.initialise(Initialisables.java:14) at org.obiba.magma.MagmaEngine.addDatasource(MagmaEngine.java:84) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.buildExcelDatasource(DefaultExportServiceImpl.java:110) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToExcelFile(DefaultExportServiceImpl.java:84) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy38.exportTablesToExcelFile(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:35) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:142) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:109) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:191) Caused by: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:61) at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:256) at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:196) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:172) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63) at org.obiba.magma.datasource.excel.ExcelDatasource.onInitialise(ExcelDatasource.java:84) at org.obiba.magma.support.AbstractDatasource.initialise(AbstractDatasource.java:80) at org.obiba.magma.support.Initialisables.initialise(Initialisables.java:10) ... 18 more Caused by: java.lang.reflect.InvocationTargetException 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 org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59) ... 25 more Caused by: java.io.IOException: error: Unexpected character encountered (lex state 9): '!' at org.apache.poi.xssf.model.SharedStringsTable.readFrom(SharedStringsTable.java:119) at org.apache.poi.xssf.model.SharedStringsTable.<init>(SharedStringsTable.java:97) ... 30 more
    via by Unknown author,
    • org.obiba.magma.MagmaRuntimeException: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException at org.obiba.magma.support.Initialisables.initialise(Initialisables.java:14) at org.obiba.magma.MagmaEngine.addDatasource(MagmaEngine.java:84) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.buildExcelDatasource(DefaultExportServiceImpl.java:110) at org.obiba.opal.core.service.impl.DefaultExportServiceImpl.exportTablesToExcelFile(DefaultExportServiceImpl.java:84) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy38.exportTablesToExcelFile(Unknown Source) at org.obiba.opal.cli.client.command.ExportCommand.execute(ExportCommand.java:35) at org.obiba.opal.cli.client.OpalConsole.prompt(OpalConsole.java:142) at org.obiba.opal.cli.client.OpalConsole.<init>(OpalConsole.java:109) at org.obiba.opal.cli.client.OpalConsole.main(OpalConsole.java:191) Caused by: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:61) at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:256) at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:196) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:172) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63) at org.obiba.magma.datasource.excel.ExcelDatasource.onInitialise(ExcelDatasource.java:84) at org.obiba.magma.support.AbstractDatasource.initialise(AbstractDatasource.java:80) at org.obiba.magma.support.Initialisables.initialise(Initialisables.java:10) ... 18 more Caused by: java.lang.reflect.InvocationTargetException 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 org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59) ... 25 more Caused by: java.io.IOException: error: Unexpected character encountered (lex state 9): '!' at org.apache.poi.xssf.model.SharedStringsTable.readFrom(SharedStringsTable.java:119) at org.apache.poi.xssf.model.SharedStringsTable.<init>(SharedStringsTable.java:97) ... 30 more
    No Bugmate found.