I think one error in a {sql, javascript, groovy} function causes an error
in all functions in the same language.
The "previous commands I ran from the Browse tab" part is perplexing but
here is what I would do for debugging:
1) test a non-javascript function to see if it works.
2)
comment out all the javascript functions
check if a new simple function works.
if it works, uncomment the javascript functions one by one to find the one
with the error.
hope this helps.
On Tuesday, November 24, 2015 at 5:03:46 PM UTC-8, Ricardo A. Pasquini
wrote:
>
> Dear all,
> Hope you can help me with an error message that appears when executing
> functions from the Functions' Manager in Studio.
> In the last days I have written several functions in Javascript that I was
> executing nicely from Studio, but suddently it stopped working.
> No matter which Function I execute, I am obtaining exactly the same "Bad
> Request error". The error message is showing some previous commands I ran
> from the Browse tab, with no reference at all to the actual Function.
> In order to show the problem, I wrote the simplest function as an example:
>
>
>
>
> <https://lh3.googleusercontent.com/-XdR1UpohV3o/VlUHIg7HA6I/AAAAAAAABQE/r3VABtccXSA/s1600/error400b.JPG>
>
> Here is the detail of the error, which include some previous querys I ran
> from the Browse tab.
>
> {
> "errors": [
> {
> "code": 400,
> "reason": "Bad request",
> "content": "ScriptManager: error <eval>:58:7 Expected ; but
> found yearmonth\r\nselect yearmonth.substring(0, 4), yearmonth.right(2)
> from yearmonth\r\n ^ in <eval> at line number 58 at column number
> 7.\nFunction randomedges(nombreclase,nombreclaseedges):\n\n 53: \n 54:
> //selection of months\n 55: var text=\"insert into yearmonth from select
> from (select from (select distinct(createdat1.format('yyyy-MM')) as
> yearmonth from Rolein) order by yearmonth)\";\n 56: var
> yearmonth=g.command(\"sql\",text);\n 57: \n 58: >>> select
> yearmonth.substring(0, 4), yearmonth.right(2) from yearmonth\n 59: \n 60:
> g.command(\"sql\",\"UPDATE yearmonth SET year=yearmonth.substring(0,
> 4)\")\n 61: g.command(\"sql\",\"UPDATE yearmonth SET
> month=yearmonth.right(2)\")\n 62: \n 63: }\n"
> }
> ]
> }
>
>
> If the problem is somewhat related with the ScriptManager, is there a way
> to reset it in someway? I have already restarted my browser, also tried by
> restarting the server, but the problem remains.
> Thanks in advance,
> Ricardo
>
--
---
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.
