HANA XSJOB Error - Type [40136] Required object does not exist or exists multiple times

[Former Member]

Dear Friends,

I am facing below error while activating a XSJOB only in a particular sub-package ( Say PK_A ) whereas am able to activate it without any issues in any other package.

DescriptionResourcePathLocationType [40136] Required object does not exist or exists multiple times

I see someone faced same issue in SDN but no solution provided and that is being archived https://archive.sap.com/discussions/thread/3665995

Thanks

Siva

[pfefferf]

Hello Siva,

can you please add more details to the question. E.g. your xsjob file, are you trying to use a XSJS function or a procedure (catalog or repository), the package structure including xsaccess and xsapp file placements ...

Thx,
Florian

[Former Member]

Hi Florian, I am trying to schedule a xsjob for a stored procedure .This procedure and xsjob are created as repository artifacts ( not via project explorer ) , so there were no xsaccess, xsapp files in my package.

Thanks

Siva

[former_member295909]

Did you find a solution to your issue? We are running into the same problem for one xsjob when we upgraded from HANA 1.0 SPS10 to SPS12. The error pointed to missing schema in the xsjob file. We trying adding schema name before the procedure or as a separate line but neither methods worked. We haven't tried public synonym yet.

We got this error trying to activate the xsjob.

"Required object does not exist: either specify 'schema' in xsjob or provide a public synonym as job action"

[former_member716706]

In the "action" section where you write the path try to put . instead of : after the top package

this work
Z_SURVEY.JobXSJS:ZJOB.xsjs::create

this doesn't work
Z_SURVEY:JobXSJS:ZJOB.xsjs::create