SCCM Scheduled Import - Not Running Custom Data Source

[A Westervelt]

I've started customizing new data source imports for our SCCM integration, such as querying v_GS_PHYSICAL_MEMORY to create the Memory Modules in ServiceNow. However, we I added it to the OOB Scheduled Data Import, it keeps getting skipped over. There aren't any special conditions or scripts executing before/after, so I'm at a loss why this isn't running.

[jake_mckenna]

That does sound weird, and if you can provide any type of logs for this jdbc call either from the transform history table or the progress workers table that might indicate why?

[A Westervelt · Accepted solution]

Ah, I found it. It was actually running however the default links to SCCM transform and progress workers doesn't take in account for custom tables. I scratched the other one and rebuilt it to align more with the flow.

Old: u_sccm_2012v2_physical_memory

New: imp_sccm2012v2_physical_memory

[bradbird]

I created a custom data source and it also does not show up in the list for scheduled import.   Any help?

[kerwin63]

I am running into a similar issue. I created the data source and transform maps etc. I can run the datasource manually and it does get the data; however, it just sits there and stares back at me 😞 - meaning it does not run nor do the transform map field gets updated. It worked the day before. Any help is appreciated. 

Source table has the ,transform map, target,target record and import set run  fields (empty); but the data, from SCCM is there.

I noticed the default SCCM tables all have those fields populated.