Hi, 
I tried making one of the reports available for the fcart client but when I try to access it, I get this error:2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-82016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-8setCharset(): UTF-8setCharset(): UTF-8setCharset(): UTF-8setCharset(): UTF-8setCharset(): UTF-82016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException  -- message: null  -- Stack Trace:  --      javax.naming.NamingException        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)  ...first 4 lines. 56 more.
2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException  -- message: null  -- Stack Trace:  --      javax.naming.NamingException        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)  ...first 4 lines. 56 more.

Any idea what might be going on here? 

I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace-services/reports/<your_CSID_goes_here>

Thanks,

Richard

From: Talk talk-bounces@lists.collectionspace.org on behalf of toolhater toolhater@yahoo.com
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
...first 4 lines. 56 more.

Any idea what might be going on here?

Here is what I get back:<?xml version="1.0" encoding="UTF-8"?><document name="reports"><ns2:collectionspace_core xmlns:ns2="http://collectionspace.org/collectionspace_core/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><createdAt>2016-08-09T09:43:22.315Z</createdAt><updatedBy>admin@fcart.collectionspace.org</updatedBy><createdBy>admin@fcart.collectionspace.org</createdBy><workflowState>project</workflowState><tenantId>1000</tenantId><refName>urn:cspace:fcart.collectionspace.org:reports:id(588363a5-6aab-40b7-be8f)</refName><uri>/reports/588363a5-6aab-40b7-be8f</uri><updatedAt>2016-08-09T09:43:22.315Z</updatedAt></ns2:collectionspace_core><ns2:reports_common xmlns:ns2="http://collectionspace.org/services/report" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><notes>This is an Acquisition report.</notes><filename>Acq_List_Basic.jasper</filename><forDocTypes><forDocType>Acquisition</forDocType></forDocTypes><supportsGroup>false</supportsGroup><name>Acquisition Report PDF</name><supportsSingleDoc>true</supportsSingleDoc><outputMIME>application/pdf</outputMIME><supportsDocList>false</supportsDocList><supportsNoContext>true</supportsNoContext></ns2:reports_common><ns2:account_permission xmlns:ns2="http://collectionspace.org/services/authorization"><account><accountId>2a5309e4-8b8c-4aad-9cd9-04511b94c245</accountId><screenName>Administrator</screenName><userId>admin@fcart.collectionspace.org</userId><tenantId>1000</tenantId></account></ns2:account_permission></document>

On Monday, August 15, 2016 6:33 PM, Richard Millet <richard.millet@lyrasis.org> wrote:

I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace-services/reports/<your_CSID_goes_here>

Thanks,

Richard

From: Talk talk-bounces@lists.collectionspace.org on behalf of toolhater toolhater@yahoo.com
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
  ...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
  ...first 4 lines. 56 more.

Any idea what might be going on here?

I also tried to login with the account through the command line with the password in the settings and I got in fine. I'm wondering if there is somewhere the password might be put in with quotes. When I run env | grep DB I get the passwords returned with quotes. Is that correct? root@ip-172-30-0-248:/home/ubuntu# psql -U reader_default -h localhost -d postgresPassword for user reader_default:psql (9.3.13)SSL connection (cipher: DHE-RSA-AES256-GCM-SHA384, bits: 256)Type "help" for help.

On Monday, August 15, 2016 6:54 PM, Aron Roberts <aron@socrates.berkeley.edu> wrote:

Hi Chris,

  Although the error message, "Attempt to logout when Nuxeo login context was null" appears to be a secondary one, we've seen it crop up, for instance, when a) there's been an out of memory error in Tomcat and/or b) when there's an error attempting to access database storage. (The code involved is attempting to make a database connection and failing.)

  While might well be some more specific errors visible in logs around either of these occurrences, perhaps try this first? If you happen to get an error (rather than a list of report records) from the GET request that Richard suggested, does stopping and restarting the CollectionSpace server resolve this issue? And if not, can you verify (via pgAdmin3, psql, or otherwise) that you can successfully connect to the database, in the same manner that you did when testing your report queries?

Aron

On Mon, Aug 15, 2016 at 6:33 PM, Richard Millet richard.millet@lyrasis.org wrote:

I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace- services/reports/<your_CSID_ goes_here>

Thanks,

Richard

From: Talk <talk-bounces@lists. collectionspace.org> on behalf of toolhater toolhater@yahoo.com
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services. report.ReportResource:499] org.collectionspace.services. report.ReportResource detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
  ...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain. csp.persistence.services. connection.ReturnedDocument: 38] POST failed:  detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
  ...first 4 lines. 56 more.

Any idea what might be going on here?

Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace. org/mailman/listinfo/talk_ lists.collectionspace.org

I restarted Tomcat and I saw these warnings and I'm wondering if they might be the problem. The report I am trying to run is supposed to show a PDF:2016-08-16 07:29:15,045 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: pdftohtml (command pdftohtml not found in system path. You need to install pdftohtml)2016-08-16 07:29:15,056 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: wpd2text (command wpd2text not found in system path. You need to install wpd2text (deb: libwpd-tools)  http://libwpd.sourceforge.net/download.html)2016-08-16 07:29:16,000 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:231] Unknown component 'OSGI-INF/layouts-contrib.xml' referenced by bundle 'org.collectionspace.publicitem'. Check the MANIFEST.MF2016-08-16 07:29:16,001 ERROR [localhost-startStop-1] [org.nuxeo.runtime.api.Framework:496]2016-08-16 07:29:21,231 WARN  [Thread-5] [org.nuxeo.ecm.platform.convert.ooomanager.OOoManagerComponent:226] OpenOffice was not found, JOD Converter won't be available: officeHome doesn't exist or is not a directory:2016-08-16 07:29:21,354 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:552] Nuxeo Platform Started

And here is the log after I run the report:INFO: Deployment of web application directory /usr/local/share/apache-tomcat-7.0.57/webapps/examples has finished in 1,459 msAug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol startINFO: Starting ProtocolHandler ["http-bio-8180"]Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol startINFO: Starting ProtocolHandler ["ajp-bio-8009"]Aug 16, 2016 7:29:43 AM org.apache.catalina.startup.Catalina startINFO: Server startup in 42263 ms2016-08-16 07:41:09,071 WARN  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml2016-08-16 07:41:09,120 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml2016-08-16 07:41:09,750 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$2016-08-16 07:41:09,829 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml2016-08-16 07:41:09,876 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml2016-08-16 07:41:09,961 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml2016-08-16 07:41:10,019 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml2016-08-16 07:41:18,208 WARN  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml2016-08-16 07:41:18,211 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml2016-08-16 07:41:18,582 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$2016-08-16 07:41:18,625 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml2016-08-16 07:41:18,667 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml2016-08-16 07:41:18,755 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml2016-08-16 07:41:18,819 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xmlCould not get session from CSPACESESSID cookie with value: e3d3ba2bddc47dec86e5bcb1c261910b2016-08-16 07:41:25,151 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-82016-08-16 07:41:27,558 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-8setCharset(): UTF-8Warning: Could not get charToByteConverterClass!setCharset(): UTF-82016-08-16 07:41:50,718 WARN  [http-bio-8180-exec-6] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-82016-08-16 07:41:50,981 WARN  [http-bio-8180-exec-7] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-82016-08-16 07:41:51,147 WARN  [http-bio-8180-exec-2] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was nullsetCharset(): UTF-82016-08-16 07:42:00,077 ERROR [http-bio-8180-exec-2] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException  -- message: null  -- Stack Trace:  --      javax.naming.NamingException        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)  ...first 4 lines. 56 more.
2016-08-16 07:42:00,079 ERROR [http-bio-8180-exec-11] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException  -- message: null  -- Stack Trace:  --      javax.naming.NamingException        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)  ...first 4 lines. 56 more.

On Monday, August 15, 2016 6:54 PM, Aron Roberts <aron@socrates.berkeley.edu> wrote:

Hi Chris,

  Although the error message, "Attempt to logout when Nuxeo login context was null" appears to be a secondary one, we've seen it crop up, for instance, when a) there's been an out of memory error in Tomcat and/or b) when there's an error attempting to access database storage. (The code involved is attempting to make a database connection and failing.)

  While might well be some more specific errors visible in logs around either of these occurrences, perhaps try this first? If you happen to get an error (rather than a list of report records) from the GET request that Richard suggested, does stopping and restarting the CollectionSpace server resolve this issue? And if not, can you verify (via pgAdmin3, psql, or otherwise) that you can successfully connect to the database, in the same manner that you did when testing your report queries?

Aron

On Mon, Aug 15, 2016 at 6:33 PM, Richard Millet richard.millet@lyrasis.org wrote:

I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace- services/reports/<your_CSID_ goes_here>

Thanks,

Richard

From: Talk <talk-bounces@lists. collectionspace.org> on behalf of toolhater toolhater@yahoo.com
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services. report.ReportResource:499] org.collectionspace.services. report.ReportResource detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
  ...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain. csp.persistence.services. connection.ReturnedDocument: 38] POST failed:  detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
  ...first 4 lines. 56 more.

Any idea what might be going on here?

Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace. org/mailman/listinfo/talk_ lists.collectionspace.org

Chris,

It looks like the read-only database account/role that is used to run reports may be missing, have the wrong credentials, or hasn't been granted access to the database.  In your Tomcat folder (${CSPACE_JEESERVER_HOME}), look for two copies of the file "context.xml" at these paths:

apache-tomcat-7.0.57\webapps\cspace-services\META-INF\context.xml
apache-tomcat-7.0.57\webapps\cspace-services\WEB-INF\classes\context.xml

These files should be identical copies.  So in each you should see an XML element <Resource name="jdbc/NuxeoReaderDS">.  This XML element should contain the credentials for the read-only database account which is used to run reports.  Verify these credentials are correct and that you can gain read-only access to the fcart_default database through a tool like psql.  For example,

psql -U reader_default -d fcart_default

If you use the pgAdmin III tool, you should see grants on the fcart_default database that look something like this:

GRANT CONNECT, TEMPORARY ON DATABASE bonsai_default TO public;
GRANT ALL ON DATABASE bonsai_default TO nuxeo_default;
GRANT CONNECT ON DATABASE bonsai_default TO reader_default;

The environment variable DB_READER_PASSWORD is what should have been used for the reader_default postgres role to create the "context.xml" file when you ran the 'ant deploy' command.  Since you recently ran an 'ant undeploy deploy' to fix your other problem, I'm guessing the "context.xml" files are in good shape.  Perhaps the database grants are wrong or have change since you were making direct database changes?

Let us know what you learn.

-Richard

From: toolhater toolhater@yahoo.com
Sent: Tuesday, August 16, 2016 12:44 AM
To: Aron Roberts
Cc: Richard Millet; CollectionSpace Talk List
Subject: Re: [Talk] error trying to access report in fcart tenant

I restarted Tomcat and I saw these warnings and I'm wondering if they might be the problem. The report I am trying to run is supposed to show a PDF:
2016-08-16 07:29:15,045 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: pdftohtml (command pdftohtml not found in system path. You need to install pdftohtml)
2016-08-16 07:29:15,056 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: wpd2text (command wpd2text not found in system path. You need to install wpd2text (deb: libwpd-tools)  http://libwpd.sourceforge.net/download.html)
2016-08-16 07:29:16,000 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:231] Unknown component 'OSGI-INF/layouts-contrib.xml' referenced by bundle 'org.collectionspace.publicitem'. Check the MANIFEST.MF
2016-08-16 07:29:16,001 ERROR [localhost-startStop-1] [org.nuxeo.runtime.api.Framework:496]
2016-08-16 07:29:21,231 WARN  [Thread-5] [org.nuxeo.ecm.platform.convert.ooomanager.OOoManagerComponent:226] OpenOffice was not found, JOD Converter won't be available: officeHome doesn't exist or is not a directory:
2016-08-16 07:29:21,354 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:552] Nuxeo Platform Started

And here is the log after I run the report:
INFO: Deployment of web application directory /usr/local/share/apache-tomcat-7.0.57/webapps/examples has finished in 1,459 ms
Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8180"]
Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Aug 16, 2016 7:29:43 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 42263 ms
2016-08-16 07:41:09,071 WARN  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml
2016-08-16 07:41:09,120 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml
2016-08-16 07:41:09,750 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$
2016-08-16 07:41:09,829 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml
2016-08-16 07:41:09,876 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml
2016-08-16 07:41:09,961 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml
2016-08-16 07:41:10,019 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml
2016-08-16 07:41:18,208 WARN  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml
2016-08-16 07:41:18,211 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml
2016-08-16 07:41:18,582 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$
2016-08-16 07:41:18,625 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml
2016-08-16 07:41:18,667 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml
2016-08-16 07:41:18,755 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml
2016-08-16 07:41:18,819 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml
Could not get session from CSPACESESSID cookie with value: e3d3ba2bddc47dec86e5bcb1c261910b
2016-08-16 07:41:25,151 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:27,558 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
Warning: Could not get charToByteConverterClass!
setCharset(): UTF-8
2016-08-16 07:41:50,718 WARN  [http-bio-8180-exec-6] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:50,981 WARN  [http-bio-8180-exec-7] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:51,147 WARN  [http-bio-8180-exec-2] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:42:00,077 ERROR [http-bio-8180-exec-2] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
...first 4 lines. 56 more.

2016-08-16 07:42:00,079 ERROR [http-bio-8180-exec-11] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
...first 4 lines. 56 more.

On Monday, August 15, 2016 6:54 PM, Aron Roberts aron@socrates.berkeley.edu wrote:

Hi Chris,

Although the error message, "Attempt to logout when Nuxeo login context was null" appears to be a secondary one, we've seen it crop up, for instance, when a) there's been an out of memory error in Tomcat and/or b) when there's an error attempting to access database storage. (The code involved is attempting to make a database connection and failing.)

While might well be some more specific errors visible in logs around either of these occurrences, perhaps try this first? If you happen to get an error (rather than a list of report records) from the GET request that Richard suggested, does stopping and restarting the CollectionSpace server resolve this issue? And if not, can you verify (via pgAdmin3, psql, or otherwise) that you can successfully connect to the database, in the same manner that you did when testing your report queries?

Aron

On Mon, Aug 15, 2016 at 6:33 PM, Richard Millet <richard.millet@lyrasis.orgmailto:richard.millet@lyrasis.org> wrote:
I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace- services/reports/http://localhost:8180/cspace-services/reports/<your_CSID_ goes_here>

Thanks,

Richard

From: Talk <talk-bounces@lists. collectionspace.orgmailto:talk-bounces@lists.collectionspace.org> on behalf of toolhater <toolhater@yahoo.commailto:toolhater@yahoo.com>
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services. report.ReportResource:499] org.collectionspace.services. report.ReportResource detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain. csp.persistence.services. connection.ReturnedDocument: 38] POST failed:  detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
...first 4 lines. 56 more.

Any idea what might be going on here?

Talk mailing list
Talk@lists.collectionspace.orgmailto:Talk@lists.collectionspace.org
http://lists.collectionspace. org/mailman/listinfo/talk_ lists.collectionspace.orghttp://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

I found the files you were talking about and the password did in fact have an extra set of quotes like this: "“samplepassword”". 
All my exports in the bash file were like this:export DB_NUXEO_PASSWORD=“sample”export DB_CSPACE_PASSWORD=“sample”export DB_READER_PASSWORD=“sample”

Also, both context.xml files are like this. When I run the env | grep DB command all the passwords have just one quote. However, the DB_CSADMIN_PASSWORD does NOT have quotes. 
Should I leave out the quotes and underlay/redeploy? I'll wait to hear back from you. guys 

On Tuesday, August 16, 2016 9:40 AM, Richard Millet <richard.millet@lyrasis.org> wrote:

Chris,

It looks like the read-only database account/role that is used to run reports may be missing, have the wrong credentials, or hasn't been granted access to the database.  In your Tomcat folder (${CSPACE_JEESERVER_HOME}), look for two copies of the file "context.xml" at these paths:

apache-tomcat-7.0.57\webapps\cspace-services\META-INF\context.xml
apache-tomcat-7.0.57\webapps\cspace-services\WEB-INF\classes\context.xml

These files should be identical copies.  So in each you should see an XML element <Resource name="jdbc/NuxeoReaderDS">.  This XML element should contain the credentials for the read-only database account which is used to run reports.  Verify these credentials are correct and that you can gain read-only access to the fcart_default database through a tool like psql.  For example,

psql -U reader_default -d fcart_default

If you use the pgAdmin III tool, you should see grants on the fcart_default database that look something like this:

GRANT CONNECT, TEMPORARY ON DATABASE bonsai_default TO public;
GRANT ALL ON DATABASE bonsai_default TO nuxeo_default;
GRANT CONNECT ON DATABASE bonsai_default TO reader_default;

The environment variable DB_READER_PASSWORD is what should have been used for the reader_default postgres role to create the "context.xml" file when you ran the 'ant deploy' command.  Since you recently ran an 'ant undeploy deploy' to fix your other problem, I'm guessing the "context.xml" files are in good shape.  Perhaps the database grants are wrong or have change since you were making direct database changes?

Let us know what you learn.

-Richard

From: toolhater toolhater@yahoo.com
Sent: Tuesday, August 16, 2016 12:44 AM
To: Aron Roberts
Cc: Richard Millet; CollectionSpace Talk List
Subject: Re: [Talk] error trying to access report in fcart tenant

I restarted Tomcat and I saw these warnings and I'm wondering if they might be the problem. The report I am trying to run is supposed to show a PDF:
2016-08-16 07:29:15,045 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: pdftohtml (command pdftohtml not found in system path. You need to install pdftohtml)
2016-08-16 07:29:15,056 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: wpd2text (command wpd2text not found in system path. You need to install wpd2text (deb: libwpd-tools)  http://libwpd.sourceforge.net/download.html)
2016-08-16 07:29:16,000 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:231] Unknown component 'OSGI-INF/layouts-contrib.xml' referenced by bundle 'org.collectionspace.publicitem'. Check the MANIFEST.MF
2016-08-16 07:29:16,001 ERROR [localhost-startStop-1] [org.nuxeo.runtime.api.Framework:496]
2016-08-16 07:29:21,231 WARN  [Thread-5] [org.nuxeo.ecm.platform.convert.ooomanager.OOoManagerComponent:226] OpenOffice was not found, JOD Converter won't be available: officeHome doesn't exist or is not a directory:
2016-08-16 07:29:21,354 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:552] Nuxeo Platform Started

And here is the log after I run the report:
INFO: Deployment of web application directory /usr/local/share/apache-tomcat-7.0.57/webapps/examples has finished in 1,459 ms
Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8180"]
Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Aug 16, 2016 7:29:43 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 42263 ms
2016-08-16 07:41:09,071 WARN  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml
2016-08-16 07:41:09,120 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml
2016-08-16 07:41:09,750 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$
2016-08-16 07:41:09,829 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml
2016-08-16 07:41:09,876 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml
2016-08-16 07:41:09,961 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml
2016-08-16 07:41:10,019 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml
2016-08-16 07:41:18,208 WARN  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml
2016-08-16 07:41:18,211 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml
2016-08-16 07:41:18,582 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$
2016-08-16 07:41:18,625 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml
2016-08-16 07:41:18,667 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml
2016-08-16 07:41:18,755 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml
2016-08-16 07:41:18,819 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml
Could not get session from CSPACESESSID cookie with value: e3d3ba2bddc47dec86e5bcb1c261910b
2016-08-16 07:41:25,151 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:27,558 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
Warning: Could not get charToByteConverterClass!
setCharset(): UTF-8
2016-08-16 07:41:50,718 WARN  [http-bio-8180-exec-6] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:50,981 WARN  [http-bio-8180-exec-7] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:51,147 WARN  [http-bio-8180-exec-2] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:42:00,077 ERROR [http-bio-8180-exec-2] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
  ...first 4 lines. 56 more.

2016-08-16 07:42:00,079 ERROR [http-bio-8180-exec-11] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
        at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
  ...first 4 lines. 56 more.

On Monday, August 15, 2016 6:54 PM, Aron Roberts aron@socrates.berkeley.edu wrote:

Hi Chris,

  Although the error message, "Attempt to logout when Nuxeo login context was null" appears to be a secondary one, we've seen it crop up, for instance, when a) there's been an out of memory error in Tomcat and/or b) when there's an error attempting to access database storage. (The code involved is attempting to make a database connection and failing.)

  While might well be some more specific errors visible in logs around either of these occurrences, perhaps try this first? If you happen to get an error (rather than a list of report records) from the GET request that Richard suggested, does stopping and restarting the CollectionSpace server resolve this issue? And if not, can you verify (via pgAdmin3, psql, or otherwise) that you can successfully connect to the database, in the same manner that you did when testing your report queries?

Aron

On Mon, Aug 15, 2016 at 6:33 PM, Richard Millet <richard.millet@lyrasis.orgmailto:richard.millet@lyrasis.org> wrote:
I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace- services/reports/http://localhost:8180/cspace-services/reports/<your_CSID_ goes_here>

Thanks,

Richard

From: Talk <talk-bounces@lists. collectionspace.orgmailto:talk-bounces@lists.collectionspace.org> on behalf of toolhater <toolhater@yahoo.commailto:toolhater@yahoo.com>
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services. report.ReportResource:499] org.collectionspace.services. report.ReportResource detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
  ...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain. csp.persistence.services. connection.ReturnedDocument: 38] POST failed:  detail: javax.naming.NamingException
  -- message: null
  -- Stack Trace:
  --      javax.naming.NamingException
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
        at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
  ...first 4 lines. 56 more.

Any idea what might be going on here?

Talk mailing list
Talk@lists.collectionspace.orgmailto:Talk@lists.collectionspace.org
http://lists.collectionspace. org/mailman/listinfo/talk_ lists.collectionspace.orghttp://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

When you run a 'env | grep DB', there should be no quotes in any of the values.  So yes, make sure there are no quotes and re-run the 'ant undeploy deploy' command.

From: toolhater toolhater@yahoo.com
Sent: Tuesday, August 16, 2016 2:13 PM
To: Richard Millet; Aron Roberts
Cc: CollectionSpace Talk List
Subject: Re: [Talk] error trying to access report in fcart tenant

I found the files you were talking about and the password did in fact have an extra set of quotes like this: "“samplepassword”".

All my exports in the bash file were like this:
export DB_NUXEO_PASSWORD=“sample”
export DB_CSPACE_PASSWORD=“sample”
export DB_READER_PASSWORD=“sample”

Also, both context.xml files are like this. When I run the env | grep DB command all the passwords have just one quote. However, the DB_CSADMIN_PASSWORD does NOT have quotes.

Should I leave out the quotes and underlay/redeploy? I'll wait to hear back from you. guys

On Tuesday, August 16, 2016 9:40 AM, Richard Millet richard.millet@lyrasis.org wrote:

Chris,

It looks like the read-only database account/role that is used to run reports may be missing, have the wrong credentials, or hasn't been granted access to the database.  In your Tomcat folder (${CSPACE_JEESERVER_HOME}), look for two copies of the file "context.xml" at these paths:

apache-tomcat-7.0.57\webapps\cspace-services\META-INF\context.xml
apache-tomcat-7.0.57\webapps\cspace-services\WEB-INF\classes\context.xml

These files should be identical copies.  So in each you should see an XML element <Resource name="jdbc/NuxeoReaderDS">.  This XML element should contain the credentials for the read-only database account which is used to run reports.  Verify these credentials are correct and that you can gain read-only access to the fcart_default database through a tool like psql.  For example,

psql -U reader_default -d fcart_default

If you use the pgAdmin III tool, you should see grants on the fcart_default database that look something like this:

GRANT CONNECT, TEMPORARY ON DATABASE bonsai_default TO public;
GRANT ALL ON DATABASE bonsai_default TO nuxeo_default;
GRANT CONNECT ON DATABASE bonsai_default TO reader_default;

The environment variable DB_READER_PASSWORD is what should have been used for the reader_default postgres role to create the "context.xml" file when you ran the 'ant deploy' command.  Since you recently ran an 'ant undeploy deploy' to fix your other problem, I'm guessing the "context.xml" files are in good shape.  Perhaps the database grants are wrong or have change since you were making direct database changes?

Let us know what you learn.

-Richard

From: toolhater <toolhater@yahoo.commailto:toolhater@yahoo.com>
Sent: Tuesday, August 16, 2016 12:44 AM
To: Aron Roberts
Cc: Richard Millet; CollectionSpace Talk List
Subject: Re: [Talk] error trying to access report in fcart tenant

I restarted Tomcat and I saw these warnings and I'm wondering if they might be the problem. The report I am trying to run is supposed to show a PDF:
2016-08-16 07:29:15,045 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: pdftohtml (command pdftohtml not found in system path. You need to install pdftohtml)
2016-08-16 07:29:15,056 WARN  [localhost-startStop-1] [org.nuxeo.ecm.platform.commandline.executor.service.CommandLineExecutorComponent:127] Command not available: wpd2text (command wpd2text not found in system path. You need to install wpd2text (deb: libwpd-tools)  http://libwpd.sourceforge.net/download.html)
2016-08-16 07:29:16,000 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:231] Unknown component 'OSGI-INF/layouts-contrib.xml' referenced by bundle 'org.collectionspace.publicitem'. Check the MANIFEST.MF
2016-08-16 07:29:16,001 ERROR [localhost-startStop-1] [org.nuxeo.runtime.api.Framework:496]
2016-08-16 07:29:21,231 WARN  [Thread-5] [org.nuxeo.ecm.platform.convert.ooomanager.OOoManagerComponent:226] OpenOffice was not found, JOD Converter won't be available: officeHome doesn't exist or is not a directory:
2016-08-16 07:29:21,354 ERROR [localhost-startStop-1] [org.nuxeo.runtime.osgi.OSGiRuntimeService:552] Nuxeo Platform Started

And here is the log after I run the report:
INFO: Deployment of web application directory /usr/local/share/apache-tomcat-7.0.57/webapps/examples has finished in 1,459 ms
Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8180"]
Aug 16, 2016 7:29:43 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Aug 16, 2016 7:29:43 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 42263 ms
2016-08-16 07:41:09,071 WARN  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml
2016-08-16 07:41:09,120 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml
2016-08-16 07:41:09,750 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$
2016-08-16 07:41:09,829 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml
2016-08-16 07:41:09,876 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml
2016-08-16 07:41:09,961 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml
2016-08-16 07:41:10,019 INFO  [http-bio-8180-exec-3] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml
2016-08-16 07:41:18,208 WARN  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:412] Source file for "Include" tag could not be found: local-fcart-settings.xml
2016-08-16 07:41:18,211 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-settings.xml_local-fcart-settings.xml-.xml
2016-08-16 07:41:18,582 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-collectionobject.xml_extensions/variablemedia-collectionobject.xml_extensions/fineart-collectionobject.xml_extensions/fcart$
2016-08-16 07:41:18,625 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-conditioncheck.xml_extensions/variablemedia-procedure-conditioncheck.xml-.xml
2016-08-16 07:41:18,667 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-procedure-media.xml_extensions/fcart-profile-procedure-media.xml-.xml
2016-08-16 07:41:18,755 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-authority-concept.xml_extensions/fineart-authority-concept.xml-.xml
2016-08-16 07:41:18,819 INFO  [http-bio-8180-exec-2] [org.collectionspace.chain.csp.config.impl.parser.AssemblingContentHandler:172] XMLMerge results were written to file: /usr/local/share/apache-tomcat-7.0.57/temp/merged-app-config-8512299560100454172/merged-base-other-dimension.xml_extensions/fcart-profile-other-dimension.xml-.xml
Could not get session from CSPACESESSID cookie with value: e3d3ba2bddc47dec86e5bcb1c261910b
2016-08-16 07:41:25,151 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:27,558 WARN  [http-bio-8180-exec-10] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
Warning: Could not get charToByteConverterClass!
setCharset(): UTF-8
2016-08-16 07:41:50,718 WARN  [http-bio-8180-exec-6] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:50,981 WARN  [http-bio-8180-exec-7] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:41:51,147 WARN  [http-bio-8180-exec-2] [org.collectionspace.services.common.security.SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-16 07:42:00,077 ERROR [http-bio-8180-exec-2] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
...first 4 lines. 56 more.

2016-08-16 07:42:00,079 ERROR [http-bio-8180-exec-11] [org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:38] POST failed:  detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.getConnection(ReportDocumentModelHandler.java:407)
at org.collectionspace.services.report.nuxeo.ReportDocumentModelHandler.buildReportResult(ReportDocumentModelHandler.java:263)
...first 4 lines. 56 more.

On Monday, August 15, 2016 6:54 PM, Aron Roberts <aron@socrates.berkeley.edumailto:aron@socrates.berkeley.edu> wrote:

Hi Chris,

Although the error message, "Attempt to logout when Nuxeo login context was null" appears to be a secondary one, we've seen it crop up, for instance, when a) there's been an out of memory error in Tomcat and/or b) when there's an error attempting to access database storage. (The code involved is attempting to make a database connection and failing.)

While might well be some more specific errors visible in logs around either of these occurrences, perhaps try this first? If you happen to get an error (rather than a list of report records) from the GET request that Richard suggested, does stopping and restarting the CollectionSpace server resolve this issue? And if not, can you verify (via pgAdmin3, psql, or otherwise) that you can successfully connect to the database, in the same manner that you did when testing your report queries?

Aron

On Mon, Aug 15, 2016 at 6:33 PM, Richard Millet <richard.millet@lyrasis.orgmailto:richard.millet@lyrasis.org<mailto:richard.millet@lyrasis.orgmailto:richard.millet@lyrasis.org>> wrote:
I need a little more info before I can help you.

Did you successfully POST the report to the Reports service?  If so, what is the XML from a GET call like this (using the CSID of the successful POST):

http://localhost:8180/cspace- services/reports/http://localhost:8180/cspace-services/reports/<your_CSID_ goes_here>

Thanks,

Richard

From: Talk <talk-bounces@lists.mailto:talk-bounces@lists. collectionspace.org<mailto:talk-bounces@lists.collectionspace.orgmailto:talk-bounces@lists.collectionspace.org>> on behalf of toolhater <toolhater@yahoo.commailto:toolhater@yahoo.com<mailto:toolhater@yahoo.commailto:toolhater@yahoo.com>>
Sent: Monday, August 15, 2016 4:21 PM
To: CollectionSpace Talk List
Subject: [Talk] error trying to access report in fcart tenant

Hi,

I tried making one of the reports available for the fcart client but when I try to access it, I get this error:
2016-08-15 23:16:11,912 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
2016-08-15 23:16:13,998 WARN  [http-bio-8180-exec-5] [org.collectionspace.services. common.security. SecurityInterceptor:359] Attempt to logout when Nuxeo login context was null
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
setCharset(): UTF-8
2016-08-15 23:17:00,625 ERROR [http-bio-8180-exec-6] [org.collectionspace.services. report.ReportResource:499] org.collectionspace.services. report.ReportResource detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
...first 4 lines. 56 more.

2016-08-15 23:17:00,627 ERROR [http-bio-8180-exec-5] [org.collectionspace.chain. csp.persistence.services. connection.ReturnedDocument: 38] POST failed:  detail: javax.naming.NamingException
-- message: null
-- Stack Trace:
--      javax.naming.NamingException
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. getConnection( ReportDocumentModelHandler. java:407)
at org.collectionspace.services. report.nuxeo. ReportDocumentModelHandler. buildReportResult( ReportDocumentModelHandler. java:263)
...first 4 lines. 56 more.

Any idea what might be going on here?

Talk mailing list
Talk@lists.collectionspace.orgmailto:Talk@lists.collectionspace.org<mailto:Talk@lists.collectionspace.orgmailto:Talk@lists.collectionspace.org>
http://lists.collectionspace. http://lists.collectionspace./ org/mailman/listinfo/talk_ lists.collectionspace.orghttp://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org