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.

[CR]

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. 

[CR]

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

[CR]

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

[CR]

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

[CR]

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
•