Getting closer:Now I'm getting this? What font should I use? I used one of the reports that came with space:2016-08-18 02:25:39,430 ERROR [http-bio-8180-exec-9] [org.collectionspace.services.report.ReportResource:499] org.collectionspace.services.report.ReportResource detail: net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "Arial" is not available to the JVM. See the Javadoc for more details.  -- message: Font "Arial" is not available to the JVM. See the Javadoc for more details.  -- Stack Trace:  --      net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "Arial" is not available to the JVM. See the Javadoc for more details.        at net.sf.jasperreports.engine.fonts.FontUtil.checkAwtFont(FontUtil.java:360)        at net.sf.jasperreports.engine.fill.SimpleTextLineWrapper.loadFont(SimpleTextLineWrapper.java:368)  ...first 4 lines. 75 more.

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

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

I updated the jrxml file, deleted the old record and added a new report, however, when the report came up, I still got the same error . I restarted the service and still got the same thing. I went into the reports folder and saw the .jasper file and the .jrxml file in this directory. However both still had the arial tag in there. Even though my new .jrxml file I referenced in the payload had SansSerif. I changed the jrxml file there and added another report with a different name, using the same payload the references the .jrxml file in my home directory, the same place my payload file was. Yet I still get the same error about the Arial font. Can I removed the reports and remove the .japser file and the .jrxml file in the report directory and add a new one or will that mess something up? 

On Wednesday, August 17, 2016 9:16 PM, Aron Roberts <aron@socrates.berkeley.edu> wrote:

Terrific!

This issue's comments a) offer a link to an article on installing the missing font and b) includes a 'diff' example on how to replace references to it with a generic font ('SansSerif').

Both options should get you past this error and allow you to display the report. The latter might be a bit simpler and/or faster. However, if you truly want Arial, as contrasted with whatever system-provided sans-serif font you might get instead, you can explore the font installation option.

On Wed, Aug 17, 2016 at 7:28 PM, toolhater toolhater@yahoo.com wrote:

Getting closer:Now I'm getting this? What font should I use? I used one of the reports that came with space:2016-08-18 02:25:39,430 ERROR [http-bio-8180-exec-9] [org.collectionspace.services. report.ReportResource:499] org.collectionspace.services. report.ReportResource detail: net.sf.jasperreports.engine. util.JRFontNotFoundException: Font "Arial" is not available to the JVM. See the Javadoc for more details.  -- message: Font "Arial" is not available to the JVM. See the Javadoc for more details.  -- Stack Trace:  --      net.sf.jasperreports.engine. util.JRFontNotFoundException: Font "Arial" is not available to the JVM. See the Javadoc for more details.        at net.sf.jasperreports.engine. fonts.FontUtil.checkAwtFont( FontUtil.java:360)        at net.sf.jasperreports.engine. fill.SimpleTextLineWrapper. loadFont( SimpleTextLineWrapper.java: 368)  ...first 4 lines. 75 more.

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

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.com<mailto:to olhater@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: e3d3ba2bddc47dec86e5bcb1c26191 0b
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< mailto: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< mailto:richard.millet@lyrasis. org><mailto:richard.millet@ lyrasis.org<mailto: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:ta lk-bounces@lists.> collectionspace.org<mailto:tal k-bounces@lists. collectionspace.org<mailto:tal k-bounces@lists. collectionspace.org>>> on behalf of toolhater <toolhater@yahoo.com<mailto:to olhater@yahoo.com><mailto:tool hater@yahoo.com<mailto:toolhat er@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 <mailto:Talk@lists. collectionspace.org><mailto:Ta lk@lists.collectionspace.org< mailto:Talk@lists. collectionspace.org>>
http://lists.collectionspace. <http://lists.collectionspace. /> org/mailman/listinfo/talk_ lists.collectionspace.org<http ://lists.collectionspace.org/ mailman/listinfo/talk_lists. collectionspace.org>