Stream: JIRA/Confluence
Topic: typical issues with loading consolidated ballot to Jira
Eric Haas (Jan 20 2021 at 03:13):
emailed weebmaster as instructed but my cleaned up ballot is only loading a single row at a time. It would be faster to manually copy and paste the issues in at this rate... :-/
Lloyd McKenzie (Jan 20 2021 at 03:23):
What's happening when it fails after a load?
Eric Haas (Jan 20 2021 at 04:59):
after loading a single row and then instructing me to delete the row and all previous rows and after doing that two times I got this message:
75. Found multiple ballot submissions for user for this ballot - please contact webmaster@hl7.org.
java.lang.Exception: 75. Found multiple ballot submissions for user for this ballot - please contact webmaster@hl7.org.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:80)
at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:105)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:249)
at SpreadsheetLoader.loadIssues(Script5.groovy:1113)
at sun.reflect.GeneratedMethodAccessor23825.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.runtime.callsite.PlainObjectMetaMethodSite.doInvoke(PlainObjectMetaMethodSite.java:43)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:190)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:58)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:184)
at SpreadsheetLoader.processSpreadsheet(Script5.groovy:731)
at SpreadsheetLoader$processSpreadsheet$0.call(Unknown Source)
at Script5$_run_closure1.doCall(Script5.groovy:180)
at sun.reflect.GeneratedMethodAccessor23821.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:101)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:263)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1041)
at groovy.lang.Closure.call(Closure.java:405)
at com.onresolve.scriptrunner.runner.rest.common.UserCustomScriptEndpoint$_doEndpoint_closure2.doCall(UserCustomScriptEndpoint.groovy:195)
at com.onresolve.scriptrunner.runner.rest.common.UserCustomScriptEndpoint$_doEndpoint_closure2.doCall(UserCustomScriptEndpoint.groovy)
at sun.reflect.GeneratedMethodAccessor21296.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:101)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:263)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1041)
at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:37)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119)
at com.onresolve.scriptrunner.runner.diag.DiagnosticsManagerImpl$DiagnosticsExecutionHandlerImpl$_execute_closure1.doCall(DiagnosticsManagerImpl.groovy:350)
at com.onresolve.scriptrunner.runner.diag.DiagnosticsManagerImpl$DiagnosticsExecutionHandlerImpl$_execute_closure1.doCall(DiagnosticsManagerImpl.groovy)
at sun.reflect.GeneratedMethodAccessor21079.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:101)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:263)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1041)
at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:37)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:119)
at com.onresolve.scriptrunner.runner.ScriptExecutionRecorder.withRecording(ScriptExecutionRecorder.groovy:13)
at com.onresolve.scriptrunner.runner.ScriptExecutionRecorder$withRecording.call(Unknown Source)
at com.onresolve.scriptrunner.runner.diag.DiagnosticsManagerImpl$DiagnosticsExecutionHandlerImpl.execute(DiagnosticsManagerImpl.groovy:348)
at com.onresolve.scriptrunner.runner.rest.common.UserCustomScriptEndpoint.doEndpoint(UserCustomScriptEndpoint.groovy:220)
at com.onresolve.scriptrunner.runner.rest.common.UserCustomScriptEndpoint.postUserEndpoint(UserCustomScriptEndpoint.groovy:86)
at sun.reflect.GeneratedMethodAccessor23818.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker.lambda$_dispatch$0(DispatchProviderHelper.java:181)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.lambda$invokeMethodWithInterceptors$0(DispatchProviderHelper.java:81)
at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53)
at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept(ExpandInterceptor.java:42)
at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors(DispatchProviderHelper.java:106)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch(DispatchProviderHelper.java:180)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:160)
at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:829)
at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:70)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:43)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.lambda$doFilter$0(DelegatingPluginFilter.java:57)
at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal(RestServletUtilsUpdaterFilter.java:23)
at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter(RestServletUtilsUpdaterFilter.java:35)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.lambda$doFilter$0(DelegatingPluginFilter.java:57)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.lambda$doFilter$0(DelegatingPluginFilter.java:57)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.lambda$doFilter$0(DelegatingPluginFilter.java:57)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(C
Eric Haas (Jan 20 2021 at 05:04):
I wonder if due to non-sequential number in the comment number column?
Lloyd McKenzie (Jan 20 2021 at 05:10):
If the load fails, you have to remove all successfully imported comments from the spreadsheet before trying again. Did you do that?
Eric Haas (Jan 20 2021 at 08:41):
yes the first two rows but ill double check...
Eric Haas (Jan 20 2021 at 20:26):
here is the consolidated spreadsheet I am trying to load.... ballotcomments_FHIR_IG_CDex_R1_D2_2021JAN.xls
Eric Haas (Jan 20 2021 at 20:27):
the first two rows were deleted but it repeatedly is giving me the above error. I was able to clean it up successfully but after the first two entries is dead end.
Lloyd McKenzie (Jan 20 2021 at 20:28):
Setting all the pages to (NA) is not kosher. Why are you doing that?
Lloyd McKenzie (Jan 20 2021 at 20:28):
If there's a URL, you don't need one - the page should get populated from the URL.
Lloyd McKenzie (Jan 20 2021 at 20:29):
What is row 5 about?
Eric Haas (Jan 20 2021 at 20:29):
because I am not going to go though 70 + comments and find the page. It is more efficient to use the url and hunt down the page when i triage
Lloyd McKenzie (Jan 20 2021 at 20:30):
If the URL is there, drop the page
Eric Haas (Jan 20 2021 at 20:30):
row five was a ballot comment submitted in a spreadsheet.
Lloyd McKenzie (Jan 20 2021 at 20:31):
Why are you loading it? It's obviously noise...
Eric Haas (Jan 20 2021 at 20:32):
ok let me deleted and try again but I don't think that is the problem
Eric Haas (Jan 20 2021 at 20:37):
still getting the error above ...sigh ... I guess I'll start over
Eric Haas (Jan 20 2021 at 21:44):
ok second time around same error...
- Found multiple ballot submissions for user for this ballot - please contact webmaster@hl7.org.
java.lang.Exception: 75. Found multiple ballot submissions for user for this ballot - please contact webmaster@hl7.org.
is this a permissions thing?
Eric Haas (Jan 20 2021 at 21:45):
@Lloyd McKenzie here is the updated consolidated spreadsheet... can you try it?
Eric Haas (Jan 20 2021 at 21:45):
I am stuck
Lloyd McKenzie (Jan 21 2021 at 03:40):
@Eric Haas I deleted the duplicate ballot submissions (will have to do some digging to figure out how you created them - please save a copy of the original spreadsheet if you can). Try again
Eric Haas (Jan 21 2021 at 04:28):
@lloyd got this message...
78. Error processing row 3. Unable to validate feedback issue triage. All prior rows loaded correctly. For this row, the issue and ballot vote were successfully created, but there was an error in triaging the row. Triage will need to be performed manually to set the comment, resolution and/or resolution description. Please remove this row and all preceeding rows, then resubmit the spreadsheet. Error details:
The workflow operation with action id '61' does not exist in the workflow.
Eric Haas (Jan 21 2021 at 04:29):
went ahead and deleted row and tried again....
Eric Haas (Jan 21 2021 at 04:31):
and then this ...
78. Error processing row 3. Unable to validate feedback issue triage. All prior rows loaded correctly. For this row, the issue and ballot vote were successfully created, but there was an error in triaging the row. Triage will need to be performed manually to set the comment, resolution and/or resolution description. Please remove this row and all preceeding rows, then resubmit the spreadsheet. Error details:
The workflow operation with action id '61' does not exist in the workflow.
Eric Haas (Jan 21 2021 at 04:38):
and so on. this is ridiculous and costly but I will load a line at a time
Jean Duteau (Jan 21 2021 at 04:39):
or you could request help from HL7 like other projects have. I have a worker who can do the loading for you
Lloyd McKenzie (Jan 21 2021 at 06:05):
What it's saying is that it's not able to load the triaging information - it looks like something went wonky with the migration. If you import line by line, you'll be losing your triage data. I'll try to dig into what's happening tomorrow.
Eric Haas (Jan 21 2021 at 20:12):
never mind I just requested help for HL7 to do it.
Frank McKinney (Jan 21 2021 at 20:28):
I've cleaned up the issues found in previous upload attempts, and am now also hitting the 'unable to validate feedback issue triage' error. @Eric Haas or @Jean Duteau : Who at HL7 did you ask to help? Thx!
Eric Haas (Jan 21 2021 at 20:34):
@Frank McKinney here: https://confluence.hl7.org/display/HL7/Request+Help+Uploading+Ballot+Spreadsheets
Frank McKinney (Jan 21 2021 at 20:35):
Thanks Eric
Lloyd McKenzie (Jan 21 2021 at 21:07):
It's a general issue. I'll be working on it as soon as I'm done calls today.
Melva Peters (Jan 21 2021 at 21:36):
HL7 will support the upload of spreadsheets on a first come, first serve basis.
Eric Haas (Feb 01 2021 at 19:28):
@Jean Duteau @Lloyd McKenzie @Melva Peters if this issue is fixed and the CDEX has not been started ( its listed as in-progress) . I can load it myself. It has taken much longer that i though it would for the spreadsheet to get loaded.
Jean Duteau (Feb 01 2021 at 19:42):
@Eric Haas the resource has been working on US Core and MedMorph and we hit some new issues with those. The resource is working on CDeX right now and they should be imported today.
Eric Haas (Feb 01 2021 at 19:42):
OK
Jean Duteau (Feb 01 2021 at 19:43):
Frank's spreadsheet got loaded because he had fixed all of the issues. CDeX needs to be cleaned up first.
Eric Haas (Feb 01 2021 at 19:44):
I have a cleaned spreadsheet
Jean Duteau (Feb 01 2021 at 19:44):
really? the spreadsheets that were uploaded on the confluence site aren't clean
Eric Haas (Feb 01 2021 at 19:48):
i did not clean them since I thought that was going to be done. Honestly I would rather do it myself if the bug is fixed
Jean Duteau (Feb 01 2021 at 19:49):
well, the resource is half finished but it is up to you
Eric Haas (Feb 01 2021 at 19:50):
Ok if it that far along the might as well finish
Last updated: Apr 12 2022 at 19:14 UTC
