Successfactors spoke is not pulling all records

Kathiravan Gnan
Kilo Expert

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

1 ACCEPTED SOLUTION

Kathiravan Gnan
Kilo Expert

The issue has been solved, it was because the query Id was being truncated by ServiceNow. Hi Support fixed the issue

View solution in original post

4 REPLIES 4

maggj
Tera Contributor

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.

Kathiravan Gnan
Kilo Expert

The issue has been solved, it was because the query Id was being truncated by ServiceNow. Hi Support fixed the issue

Nitish Goel
Tera Contributor

Hi @Kathiravan Gnan I am facing the same issue, can you please post the solution for the truncated session id

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);