Skip to Content
avatar image
Former Member

new $.hdb interface in sp9

Hello,

while working with new $.hdb  interface i am getting following error message, any idea what is the issue.

$.hdb.Connection.executeQuery: SQL error. NR: 402, ERROR: the user was already dropped before query execution at ptime/query/checker/query_check.cc:193

sample code:

try

{

var conn = $.hdb.getConnection();

  var query = "select * from  TST.TBLUSER";

  var results=conn.executeQuery(query);

  $.response.setBody(JSON.stringify(results));

}

catch(e)

{

  $.response.setBody(e.message);

}

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 07, 2015 at 01:13 PM

    I don't see anything wrong with that code. I've only ever experienced that particular error when the sessions crashes during execution - which would be a low level system problem.  Have you check the xsengine or indexserver trace to see if there is some system level problem?  Have you tried it with a different table? 

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Thomas,

      Right now it's working but some times i am facing this problem, no idea what's exactly the issue and when it will stops working.

      thanks for your response...!

      Regards,

      Harish

  • avatar image
    Former Member
    Jan 13, 2016 at 10:48 AM

    Hi,

    I'm suddenly getting this error as well but I haven't changed anything in my code. I already tried with a simple test:

    var con = $.hdb.getConnection();

    var query = 'select * from "TAO.API"."tao.api.data::Map.Node"'

    var res = con.executeQuery(query);

    (...)

    The error shown is:

    Failed to execute action: Error: $.hdb.Connection.executeQuery: SQL error. NR: 402, ERROR: the user was already dropped before query execution at ptime/query/checker/query_check.cc:192

    Anyone got an idea?

    Best regards

    Juergen

    Add comment
    10|10000 characters needed characters exceeded