Hi, I am working on this.
On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <[email protected]>wrote: > I have the same problem looking for ")" character in a text by gremlin in > REST on 161 version. > > g.V('@class', 'Comment').filter { it.text.contains(")")}.text > > > this is the full error: System.Exception: DB Error:InternalServerError. > Msg:com.orientechnologies.orient.core.exception.OSerializationException: > Found invalid ) character. Ensure it is opened and closed correctly. > > Il giorno martedì 18 febbraio 2014 15:02:09 UTC+1, Shishya ha scritto: >> >> No, Its all correct actually. There is all correct syntaxes. It works >> fine in studio. But gives this error in massiveinsert. >> >> >> Prabhat Kumar Singh >> >> >> >> On Tue, Feb 18, 2014 at 7:29 PM, Luca Garulli <[email protected]> wrote: >> >>> Hi, >>> sorry it's pretty unreadeable. You should check if any ) is missing >>> somewhere. >>> >>> Lvc@ >>> >>> >>> On 18 February 2014 14:32, prabhat <[email protected]> wrote: >>> >>>> This query works fine in console, but fails in bulk >>>> >>>> INSERT INTO US_simplified_data (patent_id, national_class, title, >>>> status, time_stamp, kind, iso_date, ipc_version, inventors, >>>> international_class, further_national_class, further_international_class, >>>> date, country, citations, assignees, applicants, abstract) VALUES (' >>>> 06428505','604 80','In-line IV drug delivery pack with controllable >>>> dilution','not found','1028592000','B1','2002-08-06T00:00:00Z','7','[ >>>> { \"city\" : \"Napa\", \"first_name\" : \"Michael A.\", \"last_name\" : >>>> \"Taylor\", \"name\" : \"Michael A. Taylor\", \"country\" : \"not found\", >>>> \"pincode\" : \"not found\", \"state\" : \"CA\" } ]','A61M 514','[ \"604 >>>> 83\", \"604 85\" ]','[]','20020806','US','[ { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"Iversen et al.\", \"patent_id\" : >>>> \"3276458\", \"date\" : \"19661000\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Huppen\", \"patent_id\" : \"3517816\", \"date\" : \"19700600\", \"class\" >>>> : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Herrmann\", \"patent_id\" : \"3730349\", \"date\" : >>>> \"19730500\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"Akcasu\", \"patent_id\" : >>>> \"4070289\", \"date\" : \"19780100\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Harris, Jr.\", \"patent_id\" : \"4160727\", \"date\" : \"19790700\", >>>> \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not >>>> found\", \"inventor_name\" : \"Keil\", \"patent_id\" : \"4231872\", >>>> \"date\" : \"19801100\", \"class\" : \"not found\" }, { \"kind\" : \"A\", >>>> \"country\" : \"not found\", \"inventor_name\" : \"Berry, III et al.\", >>>> \"patent_id\" : \"4280912\", \"date\" : \"19810700\", \"class\" : \"not >>>> found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Hart\", \"patent_id\" : \"4396383\", \"date\" : >>>> \"19830800\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"Lyons\", \"patent_id\" : >>>> \"4458733\", \"date\" : \"19840700\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Kaufman\", \"patent_id\" : \"4484920\", \"date\" : \"19841100\", >>>> \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not >>>> found\", \"inventor_name\" : \"Bohman et al.\", \"patent_id\" : >>>> \"4507114\", \"date\" : \"19850300\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Theeuwes\", \"patent_id\" : \"4511351\", \"date\" : \"19850400\", >>>> \"class\" : \"604246\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Wolfe et al.\", \"patent_id\" : \"4533348\", \"date\" >>>> : \"19850800\", \"class\" : \"137268\" }, { \"kind\" : \"A\", \"country\" : >>>> \"not found\", \"inventor_name\" : \"Geller\", \"patent_id\" : \"4534757\", >>>> \"date\" : \"19850800\", \"class\" : \"604126\" }, { \"kind\" : \"A\", >>>> \"country\" : \"not found\", \"inventor_name\" : \"Moss\", \"patent_id\" : >>>> \"4576603\", \"date\" : \"19860300\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Makinen et al.\", \"patent_id\" : \"4648978\", \"date\" : \"19870300\", >>>> \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not >>>> found\", \"inventor_name\" : \"Berglund et al.\", \"patent_id\" : >>>> \"4695272\", \"date\" : \"19870900\", \"class\" : \"604252\" }, { \"kind\" >>>> : \"A\", \"country\" : \"not found\", \"inventor_name\" : \"Matsuzaki et >>>> al.\", \"patent_id\" : \"4698153\", \"date\" : \"19871000\", \"class\" : >>>> \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Hambleton et al.\", \"patent_id\" : \"4784763\", >>>> \"date\" : \"19881100\", \"class\" : \"not found\" }, { \"kind\" : \"A\", >>>> \"country\" : \"not found\", \"inventor_name\" : \"Trasen\", \"patent_id\" >>>> : \"4810388\", \"date\" : \"19890300\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : \"Taylor >>>> et al.\", \"patent_id\" : \"4871463\", \"date\" : \"19891000\", \"class\" : >>>> \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Sumnitsch\", \"patent_id\" : \"4903717\", \"date\" : >>>> \"19900200\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"Ikeda\", \"patent_id\" : >>>> \"4994056\", \"date\" : \"19910200\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : \"Bosko >>>> et al.\", \"patent_id\" : \"5004535\", \"date\" : \"19910400\", \"class\" : >>>> \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Jha et al.\", \"patent_id\" : \"5032265\", \"date\" : >>>> \"19910700\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"Marius et al.\", \"patent_id\" : >>>> \"5059317\", \"date\" : \"19911000\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"McElveen, Jr. et al.\", \"patent_id\" : \"5163922\", \"date\" : >>>> \"19921100\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"Taylor\", \"patent_id\" : >>>> \"5259954\", \"date\" : \"19931100\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Berglund\", \"patent_id\" : \"5395323\", \"date\" : \"19950300\", >>>> \"class\" : \"604 84\" }, { \"kind\" : \"A\", \"country\" : \"not found\", >>>> \"inventor_name\" : \"Morris\", \"patent_id\" : \"5429603\", \"date\" : >>>> \"19950700\", \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" >>>> : \"not found\", \"inventor_name\" : \"O\'Neil et al.\", \"patent_id\" : >>>> \"5637087\", \"date\" : \"19970600\", \"class\" : \"not found\" }, { >>>> \"kind\" : \"A\", \"country\" : \"not found\", \"inventor_name\" : >>>> \"Michaels, Jr.\", \"patent_id\" : \"5685846\", \"date\" : \"19971100\", >>>> \"class\" : \"not found\" }, { \"kind\" : \"A\", \"country\" : \"not >>>> found\", \"inventor_name\" : \"Taylor\", \"patent_id\" : \"5725777\", >>>> \"date\" : \"19980300\", \"class\" : \"210232\" } ]','[ { \"city\" : >>>> \"Napa\", \"name\" : \"PrisMedical Corporation\", \"country\" : \"not >>>> found\" } ]','[]','An in-line drug delivery pack that connects in-line with >>>> an intravenous line and allows for the mixing of diluent with a drug >>>> reagent to be delivered to the patient. An internal drug bed bypass >>>> mechanism is tailored to apportion diluent flow between the bypass and the >>>> drug bed. The apportionment is selected to achieve a solution concentration >>>> suitable for IV administration as the dried reagent is dissolved. Thus, >>>> both dissolution and precisely tailored dilution are performed in the same >>>> simple device.' ) >>>> >>>> Prabhat Kumar Singh >>>> >>>> >>>> >>>> On Tue, Feb 18, 2014 at 6:59 PM, Luca Garulli <[email protected]>wrote: >>>> >>>>> What query? >>>>> >>>>> Lvc@ >>>>> >>>>> >>>>> On 18 February 2014 14:25, Shishya <[email protected]> wrote: >>>>> >>>>>> Luca, >>>>>> >>>>>> even though I add a space after the ), I get the same error. >>>>>> Any workarounds please >>>>>> >>>>>> regards >>>>>> >>>>>> >>>>>> On Thursday, October 11, 2012 5:00:59 PM UTC+5:30, >>>>>> Meerkatzenwildschwein wrote: >>>>>>> >>>>>>> I've changed this as you described. Now it works. Thanks! >>>>>>> >>>>>> -- >>>>>> >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "OrientDB" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>> >>>>> -- >>>>> >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "OrientDB" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>>>> topic/orient-database/N33PMS9uzAc/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>> >>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "OrientDB" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "OrientDB" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>> topic/orient-database/N33PMS9uzAc/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Best regards, Andrey Lomakin. Orient Technologies the Company behind OrientDB -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
