The CreatorCon Call for Content is officially open! Get started here.

why child scheduled import is not running automatically once Parent import is completed??

KM SN
Tera Expert

I have created a scheduled data import set and then attached a data source (Note: but for time being I haven't created transform map for it) but its running and creating test executions but after it why the child scheduled data import is not running unable to find. Just let me have any idea over here.

 

Parent Scheduled data importParent Scheduled data importParent scheduled data import executionsParent scheduled data import executionschild scheduled data importchild scheduled data import

5 REPLIES 5

Dnyaneshwaree
Mega Sage

Hello @KM SN ,

Check that there is no issues occured during/for parent import completion or no things remaing to add for child import.
Please refer below articles if relatable:
https://www.servicenow.com/community/developer-forum/scheduled-import-quot-run-after-parent-quot-wit...
https://www.servicenow.com/community/developer-forum/imported-project-tasks-not-closing-when-childre...


Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru

It's not solving the problem that i am facing.

if you can see the scheduled import parent is getting triggered and running after its child scheduled import is not running even though parent is completed...what might be the reason I am looking into it need more help in this context.

Steven Watts2
Tera Guru

@KM SN 

 

Hi,

 

Did you work out what was causing the issue? I'm having a similar issue with the Crowdstrike data imports.

 

Steven

YahyaDouniali
Tera Contributor

When it comes to scheduled data imports in ServiceNow as you may already know, here’s how it works:

  1. Load Stage: Data is loaded into a temporary or staging table.
  2. Transform Stage: The data is transformed and pushed into the desired target table1.

Regarding your specific scenario with multiple scheduled data imports:

  • Location Data, which runs daily at 10 PM.
  • Warehouse Pambs, which runs after Location Data completes.

-> If you set child imports to run when the parent is completed, they won’t execute during the testing stage before setting up the transform map.



In other cases, when parent fails, you can force child to execute regardless of its parent’s status (success or failure). This happens when the import set property glide.scheduled_import.stop_on_error is set to 'false' (which is the default value). 
However, if parent encounters DataSourceExceptions or StreamDataSourceExceptions, both jobs need to run independently. see Schedule a data import - Support and Troubleshooting (servicenow.com)