Data Source Test Load 20 Records/Load all records Fails with error.

[MuskanJ45326756]

Hi Team,

We have Intune integration setup for updating 'Last Activity' field of Hardware table but when I am performing test load 20 records/Load all records on Intune Data source, I am getting error "Cannot invoke "org.apache.poi.hssf.usermodel.HSSFSheet.getLastRowNum()" because "this.fSheet" is null" due to which data is not getting transformed in Hardware table (before running test load it was working fine).

Currently, we have a REST API for last activity field and we are calling the REST API via schedule job. So, I have checked REST API and Schedule job and those are working fine. I can see the data flow is happening in staging table but transformation is not happening due to above error.

Have you encountered this before or aware about this issue in ServiceNow ?

Regards,

Muskan Jain

[Ankur Bawiskar]

@MuskanJ45326756 

when was the last time it worked?

Did something change after that? platform upgrade etc?

The error says some sheet is null

How is the data loaded to staging table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MuskanJ45326756]

Till 5th Feb it worked fine in PROD instance after that we ran test load for checking if we are getting the same error or not as we are having in UAT..

No, we have not made any changes in PROD environment.

Yes but temporary sheet is created via schedule job for data load

through schedule job.

Regards,

Muskan

[Ankur Bawiskar]

@MuskanJ45326756 

try to replicate it in lower instance so that you can debug.

I believe issue is with the sheet which is getting attached to the data source and hence it's not able to load the data into staging table.

Did you check the script which brings/attaches the file is working fine?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MuskanJ45326756]

Yes this issue happened in lower instance then we tried test load in PROD and we got the same error in PROD even though we haven't done any changes on PROD and from next day it has stopped working.

But the same sheet/script is working fine till 5th and we have not made a single change in PROD.

Yes, script is fine. No change in the script has been made by us.