Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/08/2024 09:00 PM - edited 06/08/2024 09:00 PM
I created an access import job (ApplicationDataImportJob-Single Threaded) using the following API and JSON.
The job has been created successfully, but when I run the job it's status does not get updated. I can see in the log that it is calling Salesforce API and fetching and processing the entitlements but the status don't get updated after it's done. If I put this job as part of a trigger chain job, the trigger chain job completes successfully. I have also created account import job using the same API. Only difference other than the name is that the value for "accountsoraccess" is set to accounts. That Job runs fine. Furthermore, if I manually create an access import job using the same security system and connection, it works perfectly. I am not sure why it is not working. Requesting for help on this. This is what the job details look like. On the surface this looks fine but the status is not updated and last run date is not populated.
Solved! Go to Solution.
06/09/2024 09:50 PM
06/10/2024 01:36 AM
06/10/2024 07:34 PM
06/11/2024 02:05 AM
The tables for job details are not accessible in EIC 24.3. qrtz_triggers, qrtz_job_details, qrtz_fired_triggers tables are not available for queries from the data analyzer. How do I see what the db has stored?
06/11/2024 02:34 AM
Furthermore, Running the job created through API does not create any entry in the ecmimportjob table.
06/11/2024 05:26 AM
Create analytics report and validate
06/11/2024 11:59 PM
I have checked the result of the analytics report. The jobs created through "createTrigger" certainly contained lot less data than the ones created through UI. After much trial and error I was able to use the "/createUpdateTrigger" API to create and run the jobs successfully. These jobs contained more data than the ones created through "/createTrigger" API. Below is the json payload for "/createUpdateTrigger" API that worked for me:
Here are the job details data from the analytics report. createTrigger API notably only stored what I passed in the valueMap field.
06/12/2024 12:04 AM
Please share in text format and postman screenshot if possible
06/12/2024 12:14 AM
# CREATE/UPDATE JOB/TRIGGERS
{{URL}}/{{path}}/createUpdateTrigger
[
{
"triggers": [{
"valueMap": {
"CONNECTION": "Salesforce DEV Non Privilege",
"connectiontype": "SalesForce",
"connectionid": 241,
"fullorincremental": "full",
"accountsoraccess": "access",
"securitysystems": ["SS_Salesforce_DEV_Non_Privilege"]
},
"triggername": "Import_Salesforce_DEV_Access_Non_Privilege",
"group": "GRAILS_JOBS",
"jobname": "SapImportJob",
"jobgroup": "DATA",
"cronexpression": "0 33 14 * * ? 2099"
}
]
}
]