Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Seems to be fixed in 2.1.11. Thank you !

Le lundi 8 février 2016 09:12:10 UTC+1, Alain a écrit :
>
> Hi,
> Months after reporting this bug, there is still no fix published.
> The latest version (2.1.10) gives the following error:
> com.orientechnologies.orient.core.exception.OCommandExecutionException: 
> Error on execution of command:
>
> Please tell us if we can hope for a fix or we should look for a 
> replacement for OrientDB.
>
> Best regards,
>
>
> Le lundi 11 janvier 2016 09:53:18 UTC+1, Alain a écrit :
>>
>> Hi Luigi, 
>> Any news related to this bug ?
>>
>> Thanks,
>> Alain
>>
>> Le mardi 17 novembre 2015 00:42:54 UTC+1, Luigi Dell'Aquila a écrit :
>>>
>>> Hi Alain,
>>>
>>> a few days ago I fixed an issue that can be related to this, any chance 
>>> to try 2.1.x branch?
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>> 2015-11-16 15:17 GMT+01:00 Alain :
>>>
 Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon 
 ?

 Thanks in advance.


 Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :
>
> Just fyi, I updated the bug with the result of my tests with version 
> 2.1.3 and 2.1.4. The bug is still there (obviously since the bug is still 
> opened).
>
>
>
> Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :
>>
>> Hi Alain,
>>
>> thanks a lot, I'll check it soon
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-10-02 10:44 GMT+02:00 Alain :
>>
>>> Hi Luigi,
>>> I also noticed the problem and appended the bug 
>>> https://github.com/orientechnologies/orientdb/issues/4996 with my 
>>> case.
>>>
>>> Thank you,
>>>
>>>
>>> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :

 Hi Ravinder,

 I lost track of this, was it reported in the issue tracker?
 If not, could you please create an issue specifying the OrientDB 
 version where it still happens?

 Thanks

 Luigi


 2015-09-30 19:14 GMT+02:00 Ravinder Payal :

> is the bug shorted out is that exist even now i am also getting 
> the same problem.
>
> The problem may occur when any user added parenthesis in their 
> post that will be stored in orient db
>
>
> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin 
> wrote:
>>
>> Hi,
>>
>> I am working on this.
>>
>>
>> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
>> diego.m...@gmail.com> 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 <
 l.ga...@gmail.com> wrote:

> Hi,
> sorry it's pretty unreadeable. You should check if any ) is 
> missing somewhere.
>
> Lvc@
>
>
> On 18 February 2014 14:32, prabhat  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 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Hi,
Months after reporting this bug, there is still no fix published.
The latest version (2.1.10) gives the following error:
com.orientechnologies.orient.core.exception.OCommandExecutionException: 
Error on execution of command:

Please tell us if we can hope for a fix or we should look for a replacement 
for OrientDB.

Best regards,


Le lundi 11 janvier 2016 09:53:18 UTC+1, Alain a écrit :
>
> Hi Luigi, 
> Any news related to this bug ?
>
> Thanks,
> Alain
>
> Le mardi 17 novembre 2015 00:42:54 UTC+1, Luigi Dell'Aquila a écrit :
>>
>> Hi Alain,
>>
>> a few days ago I fixed an issue that can be related to this, any chance 
>> to try 2.1.x branch?
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-11-16 15:17 GMT+01:00 Alain :
>>
>>> Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon ?
>>>
>>> Thanks in advance.
>>>
>>>
>>> Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :

 Just fyi, I updated the bug with the result of my tests with version 
 2.1.3 and 2.1.4. The bug is still there (obviously since the bug is still 
 opened).



 Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :
>
> Hi Alain,
>
> thanks a lot, I'll check it soon
>
> Thanks
>
> Luigi
>
>
> 2015-10-02 10:44 GMT+02:00 Alain :
>
>> Hi Luigi,
>> I also noticed the problem and appended the bug 
>> https://github.com/orientechnologies/orientdb/issues/4996 with my 
>> case.
>>
>> Thank you,
>>
>>
>> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>>>
>>> Hi Ravinder,
>>>
>>> I lost track of this, was it reported in the issue tracker?
>>> If not, could you please create an issue specifying the OrientDB 
>>> version where it still happens?
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>>>
 is the bug shorted out is that exist even now i am also getting the 
 same problem.

 The problem may occur when any user added parenthesis in their post 
 that will be stored in orient db


 On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin 
 wrote:
>
> Hi,
>
> I am working on this.
>
>
> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
> diego.m...@gmail.com> 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 >> > wrote:
>>>
 Hi,
 sorry it's pretty unreadeable. You should check if any ) is 
 missing somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat  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\", 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Hi Luigi, 
Any news related to this bug ?

Thanks,
Alain

Le mardi 17 novembre 2015 00:42:54 UTC+1, Luigi Dell'Aquila a écrit :
>
> Hi Alain,
>
> a few days ago I fixed an issue that can be related to this, any chance to 
> try 2.1.x branch?
>
> Thanks
>
> Luigi
>
>
> 2015-11-16 15:17 GMT+01:00 Alain :
>
>> Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon ?
>>
>> Thanks in advance.
>>
>>
>> Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :
>>>
>>> Just fyi, I updated the bug with the result of my tests with version 
>>> 2.1.3 and 2.1.4. The bug is still there (obviously since the bug is still 
>>> opened).
>>>
>>>
>>>
>>> Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :

 Hi Alain,

 thanks a lot, I'll check it soon

 Thanks

 Luigi


 2015-10-02 10:44 GMT+02:00 Alain :

> Hi Luigi,
> I also noticed the problem and appended the bug 
> https://github.com/orientechnologies/orientdb/issues/4996 with my 
> case.
>
> Thank you,
>
>
> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>>
>> Hi Ravinder,
>>
>> I lost track of this, was it reported in the issue tracker?
>> If not, could you please create an issue specifying the OrientDB 
>> version where it still happens?
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>>
>>> is the bug shorted out is that exist even now i am also getting the 
>>> same problem.
>>>
>>> The problem may occur when any user added parenthesis in their post 
>>> that will be stored in orient db
>>>
>>>
>>> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin 
>>> wrote:

 Hi,

 I am working on this.


 On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
 diego.m...@gmail.com> 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  
>> wrote:
>>
>>> Hi,
>>> sorry it's pretty unreadeable. You should check if any ) is 
>>> missing somewhere.
>>>
>>> Lvc@
>>>
>>>
>>> On 18 February 2014 14:32, prabhat  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\", 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

I suppose the fix was not included in version 2.1.6 (I still get the error 
with this version) ?



Le mardi 17 novembre 2015 08:54:49 UTC+1, Alain a écrit :
>
> Hi Luigi,
> After a quick test, it seems the bug is fixed in the latest snapshot. I'm 
> waiting for the next official release in order to run more comprehensive 
> tests, but I feel confident.
>
> Thank you for your feedback !
>
> Alain
>
> Le mardi 17 novembre 2015 00:42:54 UTC+1, Luigi Dell'Aquila a écrit :
>>
>> Hi Alain,
>>
>> a few days ago I fixed an issue that can be related to this, any chance 
>> to try 2.1.x branch?
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-11-16 15:17 GMT+01:00 Alain :
>>
>>> Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon ?
>>>
>>> Thanks in advance.
>>>
>>>
>>> Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :

 Just fyi, I updated the bug with the result of my tests with version 
 2.1.3 and 2.1.4. The bug is still there (obviously since the bug is still 
 opened).



 Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :
>
> Hi Alain,
>
> thanks a lot, I'll check it soon
>
> Thanks
>
> Luigi
>
>
> 2015-10-02 10:44 GMT+02:00 Alain :
>
>> Hi Luigi,
>> I also noticed the problem and appended the bug 
>> https://github.com/orientechnologies/orientdb/issues/4996 with my 
>> case.
>>
>> Thank you,
>>
>>
>> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>>>
>>> Hi Ravinder,
>>>
>>> I lost track of this, was it reported in the issue tracker?
>>> If not, could you please create an issue specifying the OrientDB 
>>> version where it still happens?
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>>>
 is the bug shorted out is that exist even now i am also getting the 
 same problem.

 The problem may occur when any user added parenthesis in their post 
 that will be stored in orient db


 On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin 
 wrote:
>
> Hi,
>
> I am working on this.
>
>
> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
> diego.m...@gmail.com> 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 >> > wrote:
>>>
 Hi,
 sorry it's pretty unreadeable. You should check if any ) is 
 missing somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat  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\" 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon ?

Thanks in advance.

Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :
>
> Just fyi, I updated the bug with the result of my tests with version 2.1.3 
> and 2.1.4. The bug is still there (obviously since the bug is still opened).
>
>
>
> Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :
>>
>> Hi Alain,
>>
>> thanks a lot, I'll check it soon
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-10-02 10:44 GMT+02:00 Alain :
>>
>>> Hi Luigi,
>>> I also noticed the problem and appended the bug 
>>> https://github.com/orientechnologies/orientdb/issues/4996 with my case.
>>>
>>> Thank you,
>>>
>>>
>>> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :

 Hi Ravinder,

 I lost track of this, was it reported in the issue tracker?
 If not, could you please create an issue specifying the OrientDB 
 version where it still happens?

 Thanks

 Luigi


 2015-09-30 19:14 GMT+02:00 Ravinder Payal :

> is the bug shorted out is that exist even now i am also getting the 
> same problem.
>
> The problem may occur when any user added parenthesis in their post 
> that will be stored in orient db
>
>
> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin wrote:
>>
>> Hi,
>>
>> I am working on this.
>>
>>
>> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
>> diego.m...@gmail.com> 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  
 wrote:

> Hi,
> sorry it's pretty unreadeable. You should check if any ) is 
> missing somewhere.
>
> Lvc@
>
>
> On 18 February 2014 14:32, prabhat  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.\", 

Re: [orientdb] Error on parsing query Found invalid ) character

[Luigi Dell'Aquila]

Hi Alain,

a few days ago I fixed an issue that can be related to this, any chance to
try 2.1.x branch?

Thanks

Luigi


2015-11-16 15:17 GMT+01:00 Alain :

> Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon ?
>
> Thanks in advance.
>
>
> Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :
>>
>> Just fyi, I updated the bug with the result of my tests with version
>> 2.1.3 and 2.1.4. The bug is still there (obviously since the bug is still
>> opened).
>>
>>
>>
>> Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :
>>>
>>> Hi Alain,
>>>
>>> thanks a lot, I'll check it soon
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>> 2015-10-02 10:44 GMT+02:00 Alain :
>>>
 Hi Luigi,
 I also noticed the problem and appended the bug
 https://github.com/orientechnologies/orientdb/issues/4996 with my case.

 Thank you,


 Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>
> Hi Ravinder,
>
> I lost track of this, was it reported in the issue tracker?
> If not, could you please create an issue specifying the OrientDB
> version where it still happens?
>
> Thanks
>
> Luigi
>
>
> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>
>> is the bug shorted out is that exist even now i am also getting the
>> same problem.
>>
>> The problem may occur when any user added parenthesis in their post
>> that will be stored in orient db
>>
>>
>> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin
>> wrote:
>>>
>>> Hi,
>>>
>>> I am working on this.
>>>
>>>
>>> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
>>> diego.m...@gmail.com> 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 
> wrote:
>
>> Hi,
>> sorry it's pretty unreadeable. You should check if any ) is
>> missing somewhere.
>>
>> Lvc@
>>
>>
>> On 18 February 2014 14:32, prabhat  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\", 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Hi Luigi,
After a quick test, it seems the bug is fixed in the latest snapshot. I'm 
waiting for the next official release in order to run more comprehensive 
tests, but I feel confident.

Thank you for your feedback !

Alain

Le mardi 17 novembre 2015 00:42:54 UTC+1, Luigi Dell'Aquila a écrit :
>
> Hi Alain,
>
> a few days ago I fixed an issue that can be related to this, any chance to 
> try 2.1.x branch?
>
> Thanks
>
> Luigi
>
>
> 2015-11-16 15:17 GMT+01:00 Alain :
>
>> Fyi, the bug is still existing in 2.1.5. Any plan on working on it soon ?
>>
>> Thanks in advance.
>>
>>
>> Le mercredi 14 octobre 2015 12:25:19 UTC+2, Alain a écrit :
>>>
>>> Just fyi, I updated the bug with the result of my tests with version 
>>> 2.1.3 and 2.1.4. The bug is still there (obviously since the bug is still 
>>> opened).
>>>
>>>
>>>
>>> Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :

 Hi Alain,

 thanks a lot, I'll check it soon

 Thanks

 Luigi


 2015-10-02 10:44 GMT+02:00 Alain :

> Hi Luigi,
> I also noticed the problem and appended the bug 
> https://github.com/orientechnologies/orientdb/issues/4996 with my 
> case.
>
> Thank you,
>
>
> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>>
>> Hi Ravinder,
>>
>> I lost track of this, was it reported in the issue tracker?
>> If not, could you please create an issue specifying the OrientDB 
>> version where it still happens?
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>>
>>> is the bug shorted out is that exist even now i am also getting the 
>>> same problem.
>>>
>>> The problem may occur when any user added parenthesis in their post 
>>> that will be stored in orient db
>>>
>>>
>>> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin 
>>> wrote:

 Hi,

 I am working on this.


 On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli <
 diego.m...@gmail.com> 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  
>> wrote:
>>
>>> Hi,
>>> sorry it's pretty unreadeable. You should check if any ) is 
>>> missing somewhere.
>>>
>>> Lvc@
>>>
>>>
>>> On 18 February 2014 14:32, prabhat  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\" : 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Just fyi, I updated the bug with the result of my tests with version 2.1.3 
and 2.1.4. The bug is still there (obviously since the bug is still opened).



Le vendredi 2 octobre 2015 11:01:47 UTC+2, Luigi Dell'Aquila a écrit :
>
> Hi Alain,
>
> thanks a lot, I'll check it soon
>
> Thanks
>
> Luigi
>
>
> 2015-10-02 10:44 GMT+02:00 Alain :
>
>> Hi Luigi,
>> I also noticed the problem and appended the bug 
>> https://github.com/orientechnologies/orientdb/issues/4996 with my case.
>>
>> Thank you,
>>
>>
>> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>>>
>>> Hi Ravinder,
>>>
>>> I lost track of this, was it reported in the issue tracker?
>>> If not, could you please create an issue specifying the OrientDB version 
>>> where it still happens?
>>>
>>> Thanks
>>>
>>> Luigi
>>>
>>>
>>> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>>>
 is the bug shorted out is that exist even now i am also getting the 
 same problem.

 The problem may occur when any user added parenthesis in their post 
 that will be stored in orient db


 On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin wrote:
>
> Hi,
>
> I am working on this.
>
>
> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli  > 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  
>>> wrote:
>>>
 Hi,
 sorry it's pretty unreadeable. You should check if any ) is missing 
 somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat  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\" }, { 

Re: [orientdb] Error on parsing query Found invalid ) character

[Alain]

Hi Luigi,
I also noticed the problem and appended the 
bug https://github.com/orientechnologies/orientdb/issues/4996 with my case.

Thank you,


Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>
> Hi Ravinder,
>
> I lost track of this, was it reported in the issue tracker?
> If not, could you please create an issue specifying the OrientDB version 
> where it still happens?
>
> Thanks
>
> Luigi
>
>
> 2015-09-30 19:14 GMT+02:00 Ravinder Payal  >:
>
>> is the bug shorted out is that exist even now i am also getting the same 
>> problem.
>>
>> The problem may occur when any user added parenthesis in their post that 
>> will be stored in orient db
>>
>>
>> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin wrote:
>>>
>>> Hi,
>>>
>>> I am working on this.
>>>
>>>
>>> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli  
>>> 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  
> wrote:
>
>> Hi,
>> sorry it's pretty unreadeable. You should check if any ) is missing 
>> somewhere.
>>
>> Lvc@
>>
>>
>> On 18 February 2014 14:32, prabhat  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\" : 
>>> 

Re: [orientdb] Error on parsing query Found invalid ) character

[Luigi Dell'Aquila]

Hi Alain,

thanks a lot, I'll check it soon

Thanks

Luigi


2015-10-02 10:44 GMT+02:00 Alain :

> Hi Luigi,
> I also noticed the problem and appended the bug
> https://github.com/orientechnologies/orientdb/issues/4996 with my case.
>
> Thank you,
>
>
> Le jeudi 1 octobre 2015 06:58:54 UTC+2, Luigi Dell'Aquila a écrit :
>>
>> Hi Ravinder,
>>
>> I lost track of this, was it reported in the issue tracker?
>> If not, could you please create an issue specifying the OrientDB version
>> where it still happens?
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2015-09-30 19:14 GMT+02:00 Ravinder Payal :
>>
>>> is the bug shorted out is that exist even now i am also getting the same
>>> problem.
>>>
>>> The problem may occur when any user added parenthesis in their post that
>>> will be stored in orient db
>>>
>>>
>>> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin wrote:

 Hi,

 I am working on this.


 On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli 
 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 
>> wrote:
>>
>>> Hi,
>>> sorry it's pretty unreadeable. You should check if any ) is missing
>>> somewhere.
>>>
>>> Lvc@
>>>
>>>
>>> On 18 February 2014 14:32, prabhat  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\", 

Re: [orientdb] Error on parsing query Found invalid ) character

[Luigi Dell'Aquila]

Hi Ravinder,

I lost track of this, was it reported in the issue tracker?
If not, could you please create an issue specifying the OrientDB version
where it still happens?

Thanks

Luigi


2015-09-30 19:14 GMT+02:00 Ravinder Payal :

> is the bug shorted out is that exist even now i am also getting the same
> problem.
>
> The problem may occur when any user added parenthesis in their post that
> will be stored in orient db
>
>
> On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin wrote:
>>
>> Hi,
>>
>> I am working on this.
>>
>>
>> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli 
>> 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 
 wrote:

> Hi,
> sorry it's pretty unreadeable. You should check if any ) is missing
> somewhere.
>
> Lvc@
>
>
> On 18 February 2014 14:32, prabhat  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\" : 
>> 

Re: [orientdb] Error on parsing query Found invalid ) character

[Ravinder Payal]

is the bug shorted out is that exist even now i am also getting the same 
problem.

The problem may occur when any user added parenthesis in their post that 
will be stored in orient db


On Monday, March 24, 2014 at 8:54:35 PM UTC+5:30, Andrey Lomakin wrote:
>
> Hi,
>
> I am working on this.
>
>
> On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli  > 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  wrote:
>>>
 Hi,
 sorry it's pretty unreadeable. You should check if any ) is missing 
 somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat  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\", 

Re: [orientdb] Error on parsing query Found invalid ) character

[Diego Martelli]

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 l.ga...@gmail.comjavascript:
  wrote:

 Hi,
 sorry it's pretty unreadeable. You should check if any ) is missing 
 somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat prab...@gmail.com javascript: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 

Re: [orientdb] Error on parsing query Found invalid ) character

[Andrey Lomakin]

Hi,

I am working on this.


On Mon, Mar 24, 2014 at 12:40 PM, Diego Martelli
diego.marte...@gmail.comwrote:

 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 l.ga...@gmail.com wrote:

  Hi,
 sorry it's pretty unreadeable. You should check if any ) is missing
 somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat prab...@gmail.com 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\ }, {
 

Re: [orientdb] Error on parsing query Found invalid ) character

[Luca Garulli]

What query?

Lvc@


On 18 February 2014 14:25, Shishya prabha...@gmail.com 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 orient-database+unsubscr...@googlegroups.com.
 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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [orientdb] Error on parsing query Found invalid ) character

[prabhat]

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\ }, { 

Re: [orientdb] Error on parsing query Found invalid ) character

[Luca Garulli]

Hi,
sorry it's pretty unreadeable. You should check if any ) is missing
somewhere.

Lvc@


On 18 February 2014 14:32, prabhat prabha...@gmail.com 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\, 

Re: [orientdb] Error on parsing query Found invalid ) character

[prabhat]

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 l.garu...@gmail.com wrote:

 Hi,
 sorry it's pretty unreadeable. You should check if any ) is missing
 somewhere.

 Lvc@


 On 18 February 2014 14:32, prabhat prabha...@gmail.com 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\ :