Hello everyone, I was trying to import organization, but I'm getting some problems, I think because of POSTing incorrect payload. Please have a look at the attachment, it is request payload I did. After that import, requesting following page /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= Throws exception We've encountered an error retrieving search results. Please try again:Error parsing JSONNo displayNames found! And no organizations shown at all. I tried to clear tables (organizations_common and orgtermgroup) to recover the situation, but the page still has same exception. Questions. 1) Why this happened? What field exactly is missing from request? 2) What is the best way to clear whole database and start freshly? Thanks, Tigran

   <inAuthority>79c7ae8c-c4dc-46b4-ad00</inAuthority>

Hi Tigran, I’m not absolutely sure, but I think you might need to specify the CSID of the organization authority that you’re trying to import the record into, e.g., : > <inAuthority>79c7ae8c-c4dc-46b4-ad00</inAuthority> You should be able to get the CSID by making a call to the services layer such as https://yourserveraddress/cspace-services/orgauthorities <https://yourserveraddress/cspace-services/orgauthorities> I hope this helps! Regards, Chris UC Berkeley > On May 8, 2016, at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> wrote: > > Hello everyone, > > I was trying to import organization, but I'm getting some problems, I think because of POSTing incorrect payload. > > Please have a look at the attachment, it is request payload I did. > > After that import, requesting following page > /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= > > Throws exception > We've encountered an error retrieving search results. Please try again:Error parsing JSONNo displayNames found! > > And no organizations shown at all. > > I tried to clear tables (organizations_common and orgtermgroup) to recover the situation, but the page still has same exception. > > Questions. > 1) Why this happened? What field exactly is missing from request? > 2) What is the best way to clear whole database and start freshly? > > Thanks, > Tigran > <organization.xml>_______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

   <inAuthority>79c7ae8c-c4dc-46b4-ad00</inAuthority>

Hey Chris, Yep I did call with <inAuthority> field in it. But it fails, because whole organization related functionality seems broken due to data corruption (I guess). So as a first step, I need to clear database. But I don't understand how to do it yet. Thanks for help, Tigran On Mon, May 9, 2016 at 10:16 PM, Chris Hoffman <chris_h@berkeley.edu> wrote: > Hi Tigran, > > I’m not absolutely sure, but I think you might need to specify the CSID of > the organization authority that you’re trying to import the record into, > e.g., : > > <inAuthority>79c7ae8c-c4dc-46b4-ad00</inAuthority> > > > You should be able to get the CSID by making a call to the services layer > such as > > https://yourserveraddress/cspace-services/orgauthorities > > I hope this helps! > Regards, > Chris > UC Berkeley > > > On May 8, 2016, at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> wrote: > > Hello everyone, > > I was trying to import organization, but I'm getting some problems, I > think because of POSTing incorrect payload. > > Please have a look at the attachment, it is request payload I did. > > After that import, requesting following page > > /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= > > Throws exception > We've encountered an error retrieving search results. Please try > again:Error parsing JSONNo displayNames found! > > And no organizations shown at all. > > I tried to clear tables (organizations_common and orgtermgroup) to recover > the situation, but the page still has same exception. > > Questions. > 1) Why this happened? What field exactly is missing from request? > 2) What is the best way to clear whole database and start freshly? > > Thanks, > Tigran > <organization.xml>_______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > > >

Hi Tigran, If you want to clear the whole database, drop it. The name of the database depends on the profile you're using. It looks like you're using the fcart profile, so that would be DROP DATABASE fcart_default The database will be recreated the next time you start CSpace. If you only want to clear organization records, delete from hierarchy. The delete will cascade to all the other necessary tables. To delete all organizations: DELETE FROM hierarchy WHERE primarytype = 'Organization' Ray On Sun, May 8, 2016 at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> wrote: > Hello everyone, > > I was trying to import organization, but I'm getting some problems, I > think because of POSTing incorrect payload. > > Please have a look at the attachment, it is request payload I did. > > After that import, requesting following page > > /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= > > Throws exception > We've encountered an error retrieving search results. Please try > again:Error parsing JSONNo displayNames found! > > And no organizations shown at all. > > I tried to clear tables (organizations_common and orgtermgroup) to recover > the situation, but the page still has same exception. > > Questions. > 1) Why this happened? What field exactly is missing from request? > 2) What is the best way to clear whole database and start freshly? > > Thanks, > Tigran > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > >

Unfortunately recreating database does not fix the error (I also initialized data after dropping). I still get "We've encountered an error retrieving search results. Please try again:Error parsing JSONNo displayNames found!" when accessing this page: http://ec2-54-197-111-5.compute-1.amazonaws.com:8180/collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= And no organization results are shown. What could be the problem? On Tue, May 10, 2016 at 12:18 AM, Ray Lee <rhlee@berkeley.edu> wrote: > Hi Tigran, > If you want to clear the whole database, drop it. The name of the database > depends on the profile you're using. It looks like you're using the fcart > profile, so that would be > > DROP DATABASE fcart_default > > The database will be recreated the next time you start CSpace. > > If you only want to clear organization records, delete from hierarchy. The > delete will cascade to all the other necessary tables. To delete all > organizations: > > DELETE FROM hierarchy WHERE primarytype = 'Organization' > > Ray > > > On Sun, May 8, 2016 at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> > wrote: > >> Hello everyone, >> >> I was trying to import organization, but I'm getting some problems, I >> think because of POSTing incorrect payload. >> >> Please have a look at the attachment, it is request payload I did. >> >> After that import, requesting following page >> >> /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= >> >> Throws exception >> We've encountered an error retrieving search results. Please try >> again:Error parsing JSONNo displayNames found! >> >> And no organizations shown at all. >> >> I tried to clear tables (organizations_common and orgtermgroup) to >> recover the situation, but the page still has same exception. >> >> Questions. >> 1) Why this happened? What field exactly is missing from request? >> 2) What is the best way to clear whole database and start freshly? >> >> Thanks, >> Tigran >> >> _______________________________________________ >> Talk mailing list >> Talk@lists.collectionspace.org >> >> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >> >> >

But this time I'm able to make POST requests to organization. And here is output of organization list call. http://prntscr.com/b2in1n On Tue, May 10, 2016 at 11:54 PM, Tigran Tokmajyan <toktikweb@gmail.com> wrote: > Unfortunately recreating database does not fix the error (I also > initialized data after dropping). > > I still get "We've encountered an error retrieving search results. Please > try again:Error parsing JSONNo displayNames found!" when accessing this > page: > http://ec2-54-197-111-5.compute-1.amazonaws.com:8180/collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= > > And no organization results are shown. > > What could be the problem? > > On Tue, May 10, 2016 at 12:18 AM, Ray Lee <rhlee@berkeley.edu> wrote: > >> Hi Tigran, >> If you want to clear the whole database, drop it. The name of the >> database depends on the profile you're using. It looks like you're using >> the fcart profile, so that would be >> >> DROP DATABASE fcart_default >> >> The database will be recreated the next time you start CSpace. >> >> If you only want to clear organization records, delete from hierarchy. >> The delete will cascade to all the other necessary tables. To delete all >> organizations: >> >> DELETE FROM hierarchy WHERE primarytype = 'Organization' >> >> Ray >> >> >> On Sun, May 8, 2016 at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> >> wrote: >> >>> Hello everyone, >>> >>> I was trying to import organization, but I'm getting some problems, I >>> think because of POSTing incorrect payload. >>> >>> Please have a look at the attachment, it is request payload I did. >>> >>> After that import, requesting following page >>> >>> /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= >>> >>> Throws exception >>> We've encountered an error retrieving search results. Please try >>> again:Error parsing JSONNo displayNames found! >>> >>> And no organizations shown at all. >>> >>> I tried to clear tables (organizations_common and orgtermgroup) to >>> recover the situation, but the page still has same exception. >>> >>> Questions. >>> 1) Why this happened? What field exactly is missing from request? >>> 2) What is the best way to clear whole database and start freshly? >>> >>> Thanks, >>> Tigran >>> >>> _______________________________________________ >>> Talk mailing list >>> Talk@lists.collectionspace.org >>> >>> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >>> >>> >> >

>From a look at some internal project correspondence 'way back from 2012, there's a hint that one possible cause of the "Error parsing JSONNo displayNames found!" error message might be the presence of an authority record, at least one of whose term display names consists only of whitespace (such as a single space character, for example). If that's still a potentially relevant cause, perhaps a query like this, when made within the relevant tenant's database (such as 'fcart-default', if 'fcart' is the tenant relevant to your current work) might help you find such record(s)? fcart_default=# select '[' || termdisplayname || ']' from orgtermgroup order by termdisplayname; ?column? ------------------------- [A New Test Org] [Test another Org] [Test My Authority1] ... On Tue, May 10, 2016 at 1:02 PM, Tigran Tokmajyan <toktikweb@gmail.com> wrote: > But this time I'm able to make POST requests to organization. And here is > output of organization list call. > > http://prntscr.com/b2in1n > > On Tue, May 10, 2016 at 11:54 PM, Tigran Tokmajyan <toktikweb@gmail.com> > wrote: > >> Unfortunately recreating database does not fix the error (I also >> initialized data after dropping). >> >> I still get "We've encountered an error retrieving search results. Please >> try again:Error parsing JSONNo displayNames found!" when accessing this >> page: >> http://ec2-54-197-111-5.compute-1.amazonaws.com:8180/collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= >> >> And no organization results are shown. >> >> What could be the problem? >> >> On Tue, May 10, 2016 at 12:18 AM, Ray Lee <rhlee@berkeley.edu> wrote: >> >>> Hi Tigran, >>> If you want to clear the whole database, drop it. The name of the >>> database depends on the profile you're using. It looks like you're using >>> the fcart profile, so that would be >>> >>> DROP DATABASE fcart_default >>> >>> The database will be recreated the next time you start CSpace. >>> >>> If you only want to clear organization records, delete from hierarchy. >>> The delete will cascade to all the other necessary tables. To delete all >>> organizations: >>> >>> DELETE FROM hierarchy WHERE primarytype = 'Organization' >>> >>> Ray >>> >>> >>> On Sun, May 8, 2016 at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> >>> wrote: >>> >>>> Hello everyone, >>>> >>>> I was trying to import organization, but I'm getting some problems, I >>>> think because of POSTing incorrect payload. >>>> >>>> Please have a look at the attachment, it is request payload I did. >>>> >>>> After that import, requesting following page >>>> >>>> /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= >>>> >>>> Throws exception >>>> We've encountered an error retrieving search results. Please try >>>> again:Error parsing JSONNo displayNames found! >>>> >>>> And no organizations shown at all. >>>> >>>> I tried to clear tables (organizations_common and orgtermgroup) to >>>> recover the situation, but the page still has same exception. >>>> >>>> Questions. >>>> 1) Why this happened? What field exactly is missing from request? >>>> 2) What is the best way to clear whole database and start freshly? >>>> >>>> Thanks, >>>> Tigran >>>> >>>> _______________________________________________ >>>> Talk mailing list >>>> Talk@lists.collectionspace.org >>>> >>>> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >>>> >>>> >>> >> > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > >

Here is output of that query. [Example Museum, Berkeley, CA] [Example Museum, Berkeley, CA] [Nanaikapono Elementary School] [Test] [Test] [Yerevan] I don't see that kind of record. On Wed, May 11, 2016 at 12:26 AM, Aron Roberts <aron@socrates.berkeley.edu> wrote: > From a look at some internal project correspondence 'way back from 2012, > there's a hint that one possible cause of the "Error parsing JSONNo > displayNames found!" error message might be the presence of an authority > record, at least one of whose term display names consists only of > whitespace (such as a single space character, for example). > > If that's still a potentially relevant cause, perhaps a query like this, > when made within the relevant tenant's database (such as 'fcart-default', > if 'fcart' is the tenant relevant to your current work) might help you find > such record(s)? > > fcart_default=# select '[' || termdisplayname || ']' from orgtermgroup > order by termdisplayname; > ?column? > ------------------------- > [A New Test Org] > [Test another Org] > [Test My Authority1] > ... > > On Tue, May 10, 2016 at 1:02 PM, Tigran Tokmajyan <toktikweb@gmail.com> > wrote: > >> But this time I'm able to make POST requests to organization. And here is >> output of organization list call. >> >> http://prntscr.com/b2in1n >> >> On Tue, May 10, 2016 at 11:54 PM, Tigran Tokmajyan <toktikweb@gmail.com> >> wrote: >> >>> Unfortunately recreating database does not fix the error (I also >>> initialized data after dropping). >>> >>> I still get "We've encountered an error retrieving search results. >>> Please try again:Error parsing JSONNo displayNames found!" when accessing >>> this page: >>> http://ec2-54-197-111-5.compute-1.amazonaws.com:8180/collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= >>> >>> And no organization results are shown. >>> >>> What could be the problem? >>> >>> On Tue, May 10, 2016 at 12:18 AM, Ray Lee <rhlee@berkeley.edu> wrote: >>> >>>> Hi Tigran, >>>> If you want to clear the whole database, drop it. The name of the >>>> database depends on the profile you're using. It looks like you're using >>>> the fcart profile, so that would be >>>> >>>> DROP DATABASE fcart_default >>>> >>>> The database will be recreated the next time you start CSpace. >>>> >>>> If you only want to clear organization records, delete from hierarchy. >>>> The delete will cascade to all the other necessary tables. To delete all >>>> organizations: >>>> >>>> DELETE FROM hierarchy WHERE primarytype = 'Organization' >>>> >>>> Ray >>>> >>>> >>>> On Sun, May 8, 2016 at 6:03 AM, Tigran Tokmajyan <toktikweb@gmail.com> >>>> wrote: >>>> >>>>> Hello everyone, >>>>> >>>>> I was trying to import organization, but I'm getting some problems, I >>>>> think because of POSTing incorrect payload. >>>>> >>>>> Please have a look at the attachment, it is request payload I did. >>>>> >>>>> After that import, requesting following page >>>>> >>>>> /collectionspace/ui/fcart/html/findedit.html?recordtype=organization&vocab=all&keywords= >>>>> >>>>> Throws exception >>>>> We've encountered an error retrieving search results. Please try >>>>> again:Error parsing JSONNo displayNames found! >>>>> >>>>> And no organizations shown at all. >>>>> >>>>> I tried to clear tables (organizations_common and orgtermgroup) to >>>>> recover the situation, but the page still has same exception. >>>>> >>>>> Questions. >>>>> 1) Why this happened? What field exactly is missing from request? >>>>> 2) What is the best way to clear whole database and start freshly? >>>>> >>>>> Thanks, >>>>> Tigran >>>>> >>>>> _______________________________________________ >>>>> Talk mailing list >>>>> Talk@lists.collectionspace.org >>>>> >>>>> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >>>>> >>>>> >>>> >>> >> >> _______________________________________________ >> Talk mailing list >> Talk@lists.collectionspace.org >> >> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >> >> >