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/groups/opt_out.
