Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

Azure DevOps Integration – "Import Work Items" Not Bringing in Older User Stories

athavichith
Mega Sage

Hi everyone,

 

We've recently integrated Azure DevOps with ServiceNow using the out‑of‑box ADO integration. The connection is working, and I'm able to use Import Work Items, but I'm noticing an odd limitation.

It seems ServiceNow is only importing Azure DevOps work items (User Stories) that have been recently updated. Any older items—especially those from years ago that haven’t been touched—are not being pulled in during the import.

athavichith_0-1783529401625.png

 

 

 

Has anyone run into a similar issue?

1 ACCEPTED SOLUTION

Vikram Reddy
Tera Guru

Hey @athavichith,

 

Before chasing a "recent vs old" theory, look again at the screenshot you posted: ADOREQ0001218 shows Insert Count 0, Update Count 0, and Failed Count 1,838 against a Total count of 1,838. That is not a partial skip of the older stories, that is every single work item in that request failing. So the actual question isn't why old items get filtered out, it's why that whole batch is erroring.

A few things worth checking before assuming it's a recency filter:

  • Import Request Pages: open one of the IRQP records under that request (IRQP0001388 etc.) and see if there's an actual error message logged against the failed rows, not just the count.
  • Correlation records: if any of these older stories were previously imported, deleted, or re-pointed to a different project, a leftover correlation entry on the Azure DevOps integration side can block re-insert of that same work item ID.
  • Field mapping: check whether the older items carry State, Area Path, or Iteration Path values that have since been renamed or retired in Azure DevOps, that will fail validation on insert even though the field mapping itself looks fine.
  • sys_log: filter around the Completed timestamp on the import request to catch the underlying exception for the failed rows.

If the mapping and logs come back clean, the fix that's worked for others stuck in this exact spot is deregistering the Azure DevOps connection and re-registering it, that clears the correlation records and forces a clean full re-import instead of a partial one.

Share the error text from one of those failed rows and I can narrow it down further.

 

Thank you,
Vikram Karety
Octigo Solutions INC

View solution in original post

3 REPLIES 3

Vikram Reddy
Tera Guru

Hey @athavichith,

 

Before chasing a "recent vs old" theory, look again at the screenshot you posted: ADOREQ0001218 shows Insert Count 0, Update Count 0, and Failed Count 1,838 against a Total count of 1,838. That is not a partial skip of the older stories, that is every single work item in that request failing. So the actual question isn't why old items get filtered out, it's why that whole batch is erroring.

A few things worth checking before assuming it's a recency filter:

  • Import Request Pages: open one of the IRQP records under that request (IRQP0001388 etc.) and see if there's an actual error message logged against the failed rows, not just the count.
  • Correlation records: if any of these older stories were previously imported, deleted, or re-pointed to a different project, a leftover correlation entry on the Azure DevOps integration side can block re-insert of that same work item ID.
  • Field mapping: check whether the older items carry State, Area Path, or Iteration Path values that have since been renamed or retired in Azure DevOps, that will fail validation on insert even though the field mapping itself looks fine.
  • sys_log: filter around the Completed timestamp on the import request to catch the underlying exception for the failed rows.

If the mapping and logs come back clean, the fix that's worked for others stuck in this exact spot is deregistering the Azure DevOps connection and re-registering it, that clears the correlation records and forces a clean full re-import instead of a partial one.

Share the error text from one of those failed rows and I can narrow it down further.

 

Thank you,
Vikram Karety
Octigo Solutions INC

Hey Vikram,

The correlation records was the case on my issue. On a previous import, in the external identifier table, the reference value was empty. But I got it resolved. Thanks. 

Tanushree Maiti
Tera Patron

Hi @athavichith 

 

Refer: 

Importing historical data for DevOps tools 

Import work items from Azure DevOps to Agile Development 2.0 

 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti