API runJobTrigger returns 500 Internal Server Error

[oscar-am]

Hello!

I am trying to run the /v5/runJobTrigger endpoint with the following body:

{
    "jobgroup": "DATA",
    "triggername": "ActiveDirectory_Accounts_Import_Full",
    "jobname": "ApplicationDataImportJob",
    "createJobIfNotExists": "false"
}

I found the values for these in the ecmimportjob table in Saviynt: 

Full screenshot from Postman:

What could be the issue?

[dgandhi]

Can you try {{path}} - Use api/v5

[oscar-am]

Thanks for your reply, The full url path is set up correctly.

{{base_url}} in my case is a variable, and it contains everything i.e., https://mycompany.saviyntcloud.com/ECM/api

So that is not the issue I think.

[Raghu]

it should be like below auth and url

[oscar-am]

Yes, I have authorization set up correctly, and the path is also correct.

{{base_url}} in my case is a variable, and it contains everything i.e., https://mycompany.saviyntcloud.com/ECM/api

[rushikeshvartak]

ECM keyword missing in url 

{{URL}}/ECM/{{path}}/runJobTrigger

Refer https://forums.saviynt.com/t5/identity-governance/how-to-run-job-trigger-via-rest-api-correctly/m-p/...

[oscar-am]

{{base_url}} in my case is a variable, and it contains everything i.e., https://mycompany.saviyntcloud.com/ECM/api

So that is not the issue I think.

[rushikeshvartak]

There should be v5 also

Please share curl command [Refer https://codingnconcepts.com/postman/how-to-generate-curl-command-from-postman/ ]

[oscar-am]

Yes the v5 is there as shown in the screenshot.

Here's the curl command:
curl --location 'https://****.saviyntcloud.com/ECM/api/v5/runJobTrigger' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer *****; token_type=Bearer; user_name=***' \
--data '{
"jobgroup": "DATA",
"triggername": "ActiveDirectory_Accounts_Import_Full",
"jobname": "ApplicationDataImportJob",
"createJobIfNotExists": "false"
}'

[rushikeshvartak]

{
"jobgroup": "DATA",
"triggername": "ActiveDirectory_Accounts_Import_Full",
"jobname": "SapImportJob"
}

job name is wrong please fix

[oscar-am]

Tried changing jobname to "SapImportJob" and I'm getting the following response:

[rushikeshvartak]

Job Name is not correct/exists in system / Are you connecting to correct instance ?

[oscar-am]

I think so... according to other forum posts it seems like I have the correct values. Even tried creating a Account Import (Single Threaded) as I saw that Multi Threaded was not supported for the API. 

Will raise a ticket, thanks for all your help!

[rushikeshvartak]

Check logs

[oscar-am]

I can add that running this POST request to the same endpoint works:

So I think I might have wrong jobgroup or triggername or jobname. 

[Raghu]

think so you added v5 right, and mismatch group.

anyway you got the solution, Great thank you..!

[oscar-am]

My original problem statement still stands, but maybe I should rephrase myself. How do I find the correct attributes:

jobname, jobgroup, triggername

[Raghu]

above your 1 statement query is right , am using same and used result in payload nd getting status '200'.

try below query check analytic report any diff above field name

select qt.trigger_name,qt.job_name,qt.job_group from qrtz_cron_triggers qcr inner join qrtz_triggers qt on qt.trigger_name=qcr.trigger_name

[oscar-am]

Running your command I get:

Which is the same as running it in the data analyzer on table ecmimportjob:

So I am still stuck with the values:

{

"jobgroup": "DATA",

"triggername": "ActiveDirectory_Accounts_Import_Full",

"jobname": "ApplicationDataImportJob",

"createJobIfNotExists": "false"

}

which results in 500 response 😞 Is this a bug on Saviynts side or something else?

[PremMahadikar]

Hi @oscar-am ,

Its working for me, can you try below:

{
"jobgroup": "DATA",
"triggername": "ActiveDirectory_Accounts_Import_Full",
"jobname": "SapImportJob"
}

If this reply answers your question, please consider selecting Accept As Solution and hit kudos.

[oscar-am]

Don't see how that's relevant since we have a different jobname. Maybe I'm failing to understand what's needed.

[rushikeshvartak]

Jobname is internal category of jobs

[Raghu]

yes as per schema name it should work, my system it working. re-import api dump and check it.

[oscar-am]

What do you mean with "re-import api dump and check it", thanks

[Raghu]

Saviynt Api re-configured or just dump saviynt api document to your postman set again env nd check it

[rushikeshvartak]

• Open https://documenter.getpostman.com/view/23973797/2sA2xe4u5R
• Click on Run in Postman
• 
• Select Postman for windows
• 
• Click Open Postman 
• And Import
• 

[jsatish]

@arushi2403 - Even i tried the same, but it's giving the same error. 

If jobname = SapImportJob it's failing with trigger name not found. But triggername is valid

Regards,
SJ

[rushikeshvartak]

Whats error in logs

[jsatish]

@rushikeshvartak  - Looks like issue is with 24.1. But the same is working fine in 24.4

To add additional validation jobname will be "ApplicationDataImportJob" for "Application Data Import (Multi Threaded)" type and SapImportJob for "Application Data Import (SingleThreaded)"

[rushikeshvartak]

Yes as mentioned it works after 24.4 +