- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2023 02:36 PM
We leverage the Successfactors spoke to pull in the HR data from SF, this was working perfectly fine till last week without any issues.
Now, though it runs, it does pull all the data, it just pulls in 3000 odd records out of a total of 16000 records.
Has anyone experienced this kind of issue before, any pointers/guidance is greatly appreciated.
Regards, Kathir
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2023 06:19 AM
The issue has been solved, it was because the query Id was being truncated by ServiceNow. Hi Support fixed the issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 05:17 AM
No solution sorry however we're experiencing the same issue on Tokyo using the HRSD SuccessFactors integration, the integration currently pulls 2,999 records into the import set and then stops.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2023 06:19 AM
The issue has been solved, it was because the query Id was being truncated by ServiceNow. Hi Support fixed the issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2023 12:09 AM
Hi @Kathiravan Gnan I am facing the same issue, can you please post the solution for the truncated session id
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2023 09:11 AM
Nitish
If your session/Query id is getting truncated, this is what Hi Support provided as a fix, You will have to apply the fix to each of the pulls, the step below just mentions Retrieve Job History Including Secondary Assignments, but I applied it to Retrieve Worker Profiles and Retrieve Effective Worker profiles as well, and since then it is no longer truncating the session ID/Query ID.
1. In the ‘Retrieve Job History Including Secondary Assignments’ actions ‘Pagination Setup step’ add a pagination variable. Eg: Name - initSessionId, Next Value From - script
2. Add the below script in ‘Pagination Variables Script’ after line 2 -
if(variables.counter == 1) {
var sessionId = variables.querySessionId;
variables.initSessionId = sessionId;
}
3. In the ‘Script step’ add a new variable e.g: init_session_id and drag and drop the ‘initSessionId’ pill from the ‘Pagination Setup step’.
4. Then add the below line in the script after line 4
var initSessionId = inputs.init_session_id;
5. Replace the line
var envelope = qmEnvelope.replace('${querySessionId}', querySessionId);
with
var envelope = qmEnvelope.replace('${querySessionId}', initSessionId);