Skip to Content
0

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

Aug 24, 2017 at 01:24 PM

74

avatar image

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.

10 |10000 characters needed characters left 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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

vara prasad Puram Aug 31, 2017 at 08:32 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded