Page 1 of 1

Regarding sql error

Posted: Thu May 14, 2009 5:10 am
by gaurav.shetti
I had written a query within the sql block a simple fetch.
I had written the same logic on 2 pages(test and search). 1 which only contained the query (test) and the other which contains other logic in addition to this query logic(search).

In test, it fetches the result perfectly fine.
But in search, these are the parameters that were set after the sql was fired to the oracle database from vortex page


$ret :
QUERY: select case_url,title from t_case_detail_url where rownum<6 and case_element_id in(select case_element_id from t_Case_Detail_New where case_id='535798') ERROR: command sh returned exit code 1 - CASE_URL|TITLE/attachments/scmail/57493/case_535798_2967433_1.jpg|4thumbnail.jpg -


$ret.err :
nothing was returned here

$ret.stderr :
nothing was returned here

$err :
1

Regarding sql error

Posted: Thu May 14, 2009 5:37 am
by gaurav.shetti
a few more to add
$errnum :
118

$errmsg :
command sh returned exit code 1

$errfunc:
returned nothing

$errvfunc:
buildSqlClauses

Regarding sql error

Posted: Thu May 14, 2009 10:23 am
by mark
Hard to say without seeing the code, but basically the shell command you ran returned a 1 for exit code which usually indicates some kind of problem while running the script. Confirm the operation of the script you're calling.

Regarding sql error

Posted: Thu May 14, 2009 10:36 am
by gaurav.shetti
when i ran the script from unix i got the results without any issues. I also noticed that the errornum was returning a warning and not an error and the data was being fetched.
Can you tell me what 118 warning corresponds to ?

Regarding sql error

Posted: Thu May 14, 2009 10:36 am
by gaurav.shetti
errornum 118 corresponds to ? *

Regarding sql error

Posted: Thu May 14, 2009 10:44 am
by mark
118 is a warning level. Specifically regarding exec.
errmsg gives the details.

http://www.thunderstone.com/site/vortex ... rrors.html

Regarding sql error

Posted: Thu May 14, 2009 10:47 am
by gaurav.shetti
Well from the data given above .. particularly from no2. Can you tell me what can be the possible issues ?

Regarding sql error

Posted: Thu May 14, 2009 11:48 am
by gaurav.shetti
sorry i got it ... i was assuming buildSqlClauses was a standard warning from vortex. Its a module written by us. Got it