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 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

  • Get RSS Feed

1 Answer

  • 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 comment
    10|10000 characters needed characters exceeded