CDR Tickets

Issue Number 4045
Summary Change CAM Board Name - Update Vendor Filters
Created 2016-03-14 16:22:47
Issue Type Task
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2016-03-25 15:28:08
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.180771
Description

With the changes to the CAM Board name and summary type, updates to the vendor filters will also be needed.

Comment entered 2016-03-23 18:36:52 by Englisch, Volker (NIH/NCI) [C]

I am wondering if the document type name for the misc. documents will change as well? The name for the To Learn More document, for instance, is currently To learn more - CAM patient summary.

Comment entered 2016-03-24 16:16:51 by Juthe, Robin (NIH/NCI) [E]

As decided in our meeting today, yes, the misc doc type names are changing - see OCECDR-4047. Thanks.

Comment entered 2016-03-25 15:26:13 by Englisch, Volker (NIH/NCI) [C]

I've replaced all mention of CAM, cam, or Complementary and Alternative Medicine to the new IACT, iact, or Integrative, alternative, and complementary therapies. Only the URL to the old CAM summaries is still using cam.

Bob has made his changes and I ran a PublishPreview report on a few CAM summaries which all seemed to look identical to the documents on Cancer.gov in terms of all sections being displayed. A complete test will be run as part of the QC.
The following filter has been updated:

  • R13817: CDR000157 - Vendor Filter: Summary

Comment entered 2016-03-30 16:24:31 by Juthe, Robin (NIH/NCI) [E]

We are getting an error message when we run Pub Preview for any of the CAM summaries (we've tried Acupuncture HP [CDR445441] and High-Dose Vitamin C... HP [CDR742114] so far). Here's a copy of the error message from Acupuncture:

Error in PubPreview: HTTP error: 500 (Internal Server Error) (occurred at Wed Mar 30 16:23:16 2016) (<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>System.Web.Services.Protocols.SoapException: Server was unable to process request. --> System.Exception: CDRPreview web service error:There was error generating Preview html for template type Summary at 4:23:15 PM Error Message: Preview generation failed for document Id:445441 -> System.Exception: Preview generation failed for document Id:445441 -> NCI.WCM.CMSManager.CMSSoapException: Percussion Error in SaveItem. <ns1:PSErrorResultsFault xmlns:ns1="urn:www.percussion.com/6.0.0/faults"><ns1:Service>saveItems</ns1:Service><ns1:ServiceCall><ns1:Error><ns1:Id>661424963585</ns1:Id><ns1:PSError code="56" errorMessage="Failed to save item with id '1'. The underlying error was: An exception occurred while processing the internal request handler call: An error occurred processing the update submitted by session id 97ba81d492f90d98c34fc599a84540918ae25579. [1] 22001: Data truncation [2] 22001: String or binary data would be truncated. [3] 01000: The statement has been terminated. INSERT INTO Percussion.dbo.CT_PDQCANCERINFOSUMMARY (CONTENTID, REVISIONID, CDRID, SUMMARY_TYPE, AUDIENCE) VALUES ( ? , ? , ? , ? , ? )." stack="com.percussion.cms.PSCmsException: An exception occurred while processing the internal request handler call: An error occurred processing the update submitted by session id 97ba81d492f90d98c34fc599a84540918ae25579. [1] 22001: Data truncation [2] 22001: String or binary data would be truncated. [3] 01000: The statement has been terminated. INSERT INTO Percussion.dbo.CT_PDQCANCERINFOSUMMARY (CONTENTID, REVISIONID, CDRID, SUMMARY_TYPE, AUDIENCE) VALUES ( ? , ? , ? , ? , ? ) at com.percussion.cms.objectstore.server.PSServerItem.processUpdateAction(Unknown Source) at com.percussion.cms.objectstore.server.PSServerItem.saveAllFields(Unknown Source) at com.percussion.cms.objectstore.server.PSServerItem.save(Unknown Source) at com.percussion.cms.objectstore.server.PSServerItem.save(Unknown Source) at com.percussion.webservices.content.impl.PSContentWs.saveItems(Unknown Source) at com.percussion.webservices.content.ContentSOAPImpl.saveItems(Unknown Source) 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.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.percussion.webdav.PSWebDavRequestFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.percussion.servlets.PSSecurityFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.percussion.servlets.PSCharacterSetFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Unknown Source) " /></ns1:Error></ns1:ServiceCall></ns1:PSErrorResultsFault><ns2:exceptionName xmlns:ns2="http://xml.apache.org/axis/">com.percussion.webservices.faults.PSErrorResultsFault</ns2:exceptionName><ns3:hostname xmlns:ns3="http://xml.apache.org/axis/">nciws-q178-v</ns3:hostname> -> System.Web.Services.Protocols.SoapException at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at NCI.WCM.CMSManager.PercussionWebSvc.contentSOAP.SaveItems(SaveItemsRequest SaveItemsRequest) at NCI.WCM.CMSManager.CMS.PSWSUtils.SaveItem(contentSOAP contentSvc, PSItem[] item) — End of inner exception stack trace — at NCI.WCM.CMSManager.CMS.PSWSUtils.SaveItem(contentSOAP contentSvc, PSItem[] item) at NCI.WCM.CMSManager.CMS.CMSController.CreateItem(String contentType, Dictionary`2 newFieldValues, IEnumerable`1 childFieldList, String targetFolder, Action`1 invalidFieldnameHandler) at NCI.WCM.CMSManager.CMS.CMSController.CreateContentItemList(List`1 contentItems, Action`1 errorHandler) at GKManagers.CMSDocumentProcessing.CancerInfoSummaryProcessorStandard.CreateNewCancerInformationSummary(SummaryDocument document, String sitePath) at GKManagers.CMSDocumentProcessing.CancerInfoSummaryProcessorCommon.processDocumentInternal(Document documentObject, String sitePath) at GKManagers.CMSDocumentProcessing.CancerInfoSummaryProcessorCommon.ProcessDocument(Document documentObject, PercussionGuid& contentItemGuid) at GKPreviews.SummaryDocumentPreview.ProcessPreview(String& contentHtml, String& headerContent) — End of inner exception stack trace — at GKPreviews.SummaryDocumentPreview.ProcessPreview(String& contentHtml, String& headerContent) at CDRPreviewWS.CDRPreview.RenderSummaryHTML(XmlDocument document, String& headerHtml) at CDRPreviewWS.CDRPreview.ReturnHTML(XmlNode content, String template_type, String& headerHtml) — End of inner exception stack trace — at CDRPreviewWS.CDRPreview.ReturnHTML(XmlNode content, String template_type, String& headerHtml) at CDRPreviewWS.CDRPreview.ReturnXML(XmlNode content, String template_type) — End of inner exception stack trace --</faultstring><detail /></soap:Fault></soap:Body></soap:Envelope>)

Comment entered 2016-03-30 17:09:55 by Englisch, Volker (NIH/NCI) [C]

Please see my email from Tuesday around noon:

Please note that PublishPreview reports for the IACT/CAM summaries will currently fail on QA until the dependent Hermes release made it to QA (scheduled for April 1st.

The necessary database changes to accommodate the longer board name are part of the Hermes release and therefore cannot be tested on the QA tier at this time.

Comment entered 2016-03-30 17:11:15 by Juthe, Robin (NIH/NCI) [E]

Ah, that's right. Sorry! Thanks for reminding me 🙂

Comment entered 2016-04-01 14:30:30 by Englisch, Volker (NIH/NCI) [C]

The QA server has been updated and you're now able to run PP reports for IACT summaries.

Comment entered 2016-04-01 15:26:28 by Juthe, Robin (NIH/NCI) [E]

I'm marking this verified on QA; however, there are additional changes we are making to the misc doc type names - see OCECDR-4047. I assume we'll catch those with OCECDR-4068 in iteration 2.

Comment entered 2016-06-15 09:49:45 by Juthe, Robin (NIH/NCI) [E]

Verified on PROD.

Elapsed: 0:00:00.001705