Skip to Content

SAP HANA Job is failing with InternalError: dberror(Connection.prepareCall)

Hi Friends,

I have created Job in SAP HANA to run the procedure, and the same job is scheduled to run every day.But it is failing with the below error.

InternalError: dberror(Connection.prepareCall): 258 - insufficient privilege: Not authorized (line 5 position 1 in /Test_job/run_test_job.xsjs)

My Run_test_job.xsjs file contains the followin code

function My_Test()

{

var query = "{CALL ProcedureName}";

var conn = $.db.getConnection();

var pcall = conn.prepareCall(query);

pcall.execute();

pcall.close();

conn.commit();

conn.close();

}

I have the following roles assigned to me.

sap.hana.xs.admin.roles::JobAdministrator

sap.hana.xs.admin.roles::HTTPDestAdministrator

But still I am getting error.Could you please some one provide me,what exactly the issue is and how to fix the this issue.

Regards,

VaraPrasad.

Add a comment
10|10000 characters needed characters exceeded

  • Does the user which is used to run the job has the privileges to execute the procedure? The roles that you have listed are only for job administration and http destination administration, but they don't give the user the rights to execute your procedure.

    Regards,
    Florian

Related questions

1 Answer

  • Posted on Aug 31, 2017 at 08:32 AM

    Hi Florian,

    I have been searching for the role which will enable me to run the job in XS job engine. But I couldn't able find it.

    Could you please specify the role which enable to run job.

    Regards,

    VaraPrasad.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.