Aron suggested checking the CSIDs matching the authority item to the parent authority. I checked the inAuthority field in the API output and inauthority in the persons_common table and they match for both the original and duplicate server. original: http://cspacedev.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ duplicate: http://cspacetest.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ (login:admin@movingimage.us passwd:Administrator) Next I checked if saving a person authority and a collectionobject record would work. The collectionobject saved but the person record didn't. Error report posted below. It looks like there's an app layer error getting returned. My guess is a bad pointer from the inaccessible person authority. - Jesse HTTP Status 400 - org.collectionspace.chain.controller.BadRequestException: UIException at org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:194) at org.collectionspace.chain.controller.TenantServlet.service(TenantServlet.java:237) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.collectionspace.chain.controller.filters.PerflogFilter.doFilter(PerflogFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.collectionspace.chain.controller.filters.CharSetFilter.doFilter(CharSetFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.collectionspace.csp.api.ui.UIException: Error in read at org.collectionspace.chain.csp.webui.main.WebUI.serviceRequest(WebUI.java:327) at org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:190) ... 20 more Caused by: java.lang.NullPointerException at org.collectionspace.chain.csp.persistence.services.XmlJsonConversion.convertToJson(XmlJsonConversion.java:839) at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:353) at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:294) at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.simpleRetrieveJSON(ConfiguredVocabStorage.java:284) at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.retrieveJSON(ConfiguredVocabStorage.java:267) at org.collectionspace.csp.helper.persistence.SplittingStorage.retrieveJSON(SplittingStorage.java:158) at org.collectionspace.chain.csp.persistence.services.ServicesStorage.retrieveJSON(ServicesStorage.java:63) at org.collectionspace.chain.csp.webui.authorities.VocabulariesRead.getJSON(VocabulariesRead.java:261) at org.collectionspace.chain.csp.webui.authorities.VocabulariesCreateUpdate.store_set(VocabulariesCreateUpdate.java:111) at org.collectionspace.chain.csp.webui.authorities.VocabulariesCreateUpdate.run(VocabulariesCreateUpdate.java:149) at org.collectionspace.chain.pathtrie.TrieNode.call_here(TrieNode.java:35) at org.collectionspace.chain.pathtrie.TrieNode.call(TrieNode.java:44) at org.collectionspace.chain.pathtrie.TrieNode.call(TrieNode.java:49) at org.collectionspace.chain.pathtrie.TrieNode.call(TrieNode.java:49) at org.collectionspace.chain.pathtrie.Trie.call(Trie.java:19) at org.collectionspace.chain.csp.webui.main.WebUI.serviceRequest(WebUI.java:322) ... 21 more

> It looks like there's an app layer error getting returned. My guess is > a bad pointer from the inaccessible person authority. What do you mean by this? I thought there might be two Default Person Authorities (shortIdentifier: person) but there appears to be only one. Is the app layer config identical to the original? Susan

You do need to have those persontest1 and persontest2 test person authorities created as well. On Feb 24, 2012, at 2:00 PM, Jesse Martinez wrote: > Aron suggested checking the CSIDs matching the authority item to the > parent authority. > > I checked the inAuthority field in the API output and inauthority in > the persons_common table and they match for both the original and > duplicate server. > > original: > http://cspacedev.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ > > duplicate: > http://cspacetest.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ > > (login:admin@movingimage.us passwd:Administrator) > > > Next I checked if saving a person authority and a collectionobject > record would work. The collectionobject saved but the person record > didn't. Error report posted below. > > It looks like there's an app layer error getting returned. My guess is > a bad pointer from the inaccessible person authority. > > > - Jesse > > > HTTP Status 400 - > org.collectionspace.chain.controller.BadRequestException: UIException > at org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:194) > at org.collectionspace.chain.controller.TenantServlet.service(TenantServlet.java:237) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.collectionspace.chain.controller.filters.PerflogFilter.doFilter(PerflogFilter.java:43) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.collectionspace.chain.controller.filters.CharSetFilter.doFilter(CharSetFilter.java:99) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > at java.lang.Thread.run(Thread.java:662) Caused by: > org.collectionspace.csp.api.ui.UIException: Error in read at > org.collectionspace.chain.csp.webui.main.WebUI.serviceRequest(WebUI.java:327) > at org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:190) > ... 20 more Caused by: java.lang.NullPointerException at > org.collectionspace.chain.csp.persistence.services.XmlJsonConversion.convertToJson(XmlJsonConversion.java:839) > at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:353) > at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:294) > at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.simpleRetrieveJSON(ConfiguredVocabStorage.java:284) > at org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.retrieveJSON(ConfiguredVocabStorage.java:267) > at org.collectionspace.csp.helper.persistence.SplittingStorage.retrieveJSON(SplittingStorage.java:158) > at org.collectionspace.chain.csp.persistence.services.ServicesStorage.retrieveJSON(ServicesStorage.java:63) > at org.collectionspace.chain.csp.webui.authorities.VocabulariesRead.getJSON(VocabulariesRead.java:261) > at org.collectionspace.chain.csp.webui.authorities.VocabulariesCreateUpdate.store_set(VocabulariesCreateUpdate.java:111) > at org.collectionspace.chain.csp.webui.authorities.VocabulariesCreateUpdate.run(VocabulariesCreateUpdate.java:149) > at org.collectionspace.chain.pathtrie.TrieNode.call_here(TrieNode.java:35) > at org.collectionspace.chain.pathtrie.TrieNode.call(TrieNode.java:44) > at org.collectionspace.chain.pathtrie.TrieNode.call(TrieNode.java:49) > at org.collectionspace.chain.pathtrie.TrieNode.call(TrieNode.java:49) > at org.collectionspace.chain.pathtrie.Trie.call(Trie.java:19) at > org.collectionspace.chain.csp.webui.main.WebUI.serviceRequest(WebUI.java:322) > ... 21 more > > _______________________________________________ > Work mailing list > Work@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/work_lists.collectionspace.org

The app configuration is identical. The service layer builds aren't binary exact - I rebuilt the service layer prior to replicating the db. The default authorities are identical since they're culled from the same db data. Check the cspacedev-services links from before to see the same default person authority on both servers. On Friday, February 24, 2012, Chris Hoffman wrote: > You do need to have those persontest1 and persontest2 test person > authorities created as well. > > > On Feb 24, 2012, at 2:00 PM, Jesse Martinez wrote: > > > Aron suggested checking the CSIDs matching the authority item to the > > parent authority. > > > > I checked the inAuthority field in the API output and inauthority in > > the persons_common table and they match for both the original and > > duplicate server. > > > > original: > > > http://cspacedev.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ > > > > duplicate: > > > http://cspacetest.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ > > > > (login:admin@movingimage.us passwd:Administrator) > > > > > > Next I checked if saving a person authority and a collectionobject > > record would work. The collectionobject saved but the person record > > didn't. Error report posted below. > > > > It looks like there's an app layer error getting returned. My guess is > > a bad pointer from the inaccessible person authority. > > > > > > - Jesse > > > > > > HTTP Status 400 - > > org.collectionspace.chain.controller.BadRequestException: UIException > > at > org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:194) > > at > org.collectionspace.chain.controller.TenantServlet.service(TenantServlet.java:237) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.collectionspace.chain.controller.filters.PerflogFilter.doFilter(PerflogFilter.java:43) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.collectionspace.chain.controller.filters.CharSetFilter.doFilter(CharSetFilter.java:99) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) > > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) > > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > > at java.lang.Thread.run(Thread.java:662) Caused by: > > org.collectionspace.csp.api.ui.UIException: Error in read at > > > org.collectionspace.chain.csp.webui.main.WebUI.serviceRequest(WebUI.java:327) > > at > org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:190) > > ... 20 more Caused by: java.lang.NullPointerException at > > > org.collectionspace.chain.csp.persistence.services.XmlJsonConversion.convertToJson(XmlJsonConversion.java:839) > > at > org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:353) > > at > org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:294) > > at > org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabS> > _______________________________________________ > > Work mailing list > > Work@lists.collectionspace.org <javascript:;> > > > http://lists.collectionspace.org/mailman/listinfo/work_lists.collectionspace.org > >

I found the true error here. When I built out the person authority schema on the second server I neglected to empty out the custom mmi person module's OSGI-INF and META-INF directories. (services/person/3rdparty/nuxeo-platform-cs-person-mmi/src/main/resources/) The template values weren't overriding the leftover files from person_commons and so my custom schema, while building and deploying correctly, wasn't actually being pushed out. This was causing my custom person record type, personTenant42, to be ignored by the services layer, which was causing all sorts of problems reading from the DB. Even though this was a easily avoidable mistake, it was a good exercise in testing how to replicate a cspace db and QA test it for integrity. - Jesse On Fri, Feb 24, 2012 at 6:33 PM, Jesse Martinez <jmartinez@movingimage.us> wrote: > The app configuration is identical. The service layer builds aren't binary > exact - I rebuilt the service layer prior to replicating the db. > The default authorities are identical since they're culled from the same db > data. Check the cspacedev-services links from before to see the same default > person authority on both servers. > > > On Friday, February 24, 2012, Chris Hoffman wrote: >> >> You do need to have those persontest1 and persontest2 test person >> authorities created as well. >> >> >> On Feb 24, 2012, at 2:00 PM, Jesse Martinez wrote: >> >> > Aron suggested checking the CSIDs matching the authority item to the >> > parent authority. >> > >> > I checked the inAuthority field in the API output and inauthority in >> > the persons_common table and they match for both the original and >> > duplicate server. >> > >> > original: >> > >> > http://cspacedev.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ >> > >> > duplicate: >> > >> > http://cspacetest.collectionspace.org:8180/cspace-services/personauthorities/acc60b93-3a09-47eb-bd8f/ >> > >> > (login:admin@movingimage.us passwd:Administrator) >> > >> > >> > Next I checked if saving a person authority and a collectionobject >> > record would work. The collectionobject saved but the person record >> > didn't. Error report posted below. >> > >> > It looks like there's an app layer error getting returned. My guess is >> > a bad pointer from the inaccessible person authority. >> > >> > >> > - Jesse >> > >> > >> > HTTP Status 400 - >> > org.collectionspace.chain.controller.BadRequestException: UIException >> > at >> > org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:194) >> > at >> > org.collectionspace.chain.controller.TenantServlet.service(TenantServlet.java:237) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at >> > >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > at >> > org.collectionspace.chain.controller.filters.PerflogFilter.doFilter(PerflogFilter.java:43) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > at >> > org.collectionspace.chain.controller.filters.CharSetFilter.doFilter(CharSetFilter.java:99) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> > at >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> > at >> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> > at >> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> > at >> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> > at >> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> > at >> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> > at >> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) >> > at >> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) >> > at >> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) >> > at >> > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> > at java.lang.Thread.run(Thread.java:662) Caused by: >> > org.collectionspace.csp.api.ui.UIException: Error in read at >> > >> > org.collectionspace.chain.csp.webui.main.WebUI.serviceRequest(WebUI.java:327) >> > at >> > org.collectionspace.chain.controller.TenantServlet.serviceWTenant(TenantServlet.java:190) >> > ... 20 more Caused by: java.lang.NullPointerException at >> > >> > org.collectionspace.chain.csp.persistence.services.XmlJsonConversion.convertToJson(XmlJsonConversion.java:839) >> > at >> > org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:353) >> > at >> > org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabStorage.get(ConfiguredVocabStorage.java:294) >> > at >> > org.collectionspace.chain.csp.persistence.services.vocab.ConfiguredVocabS> >> > _______________________________________________ >> >> > Work mailing list >> > Work@lists.collectionspace.org >> > >> > http://lists.collectionspace.org/mailman/listinfo/work_lists.collectionspace.org >> >