Skip to main content
Answer

Odd Import Scenario Failure Situation

  • May 21, 2025
  • 2 replies
  • 80 views

Hi

I have an import scenario that imports/updates existing customers in the system. Its fairly complex with a lot of lines.  Its been working well for weeks.

Suddenly it stopped working and I get the dreaded “Object not set to an instance of an object” error.  That’s often a very hard error to diagnose.

I did the standard things to try to debug it.  Set the import to break on error.  Deactivated all but require field lines in the import scenario.  Visually checked every line of data mentioned in the import scenario.  Nothing looks wrong.

First thing that I found odd…  I thought to delete the scenario to just recreate it one bit at time to test it incrementally, but it won’t let me delete it.  

Second thing I noted… if I simply open the customer record that it fails and stops on, it will succeed in the next ‘Import by Scenario’ on that line.  For example, it fails on line 1 with the error mentioned before.  I open that customer’s existing record in the system without making any changes to it, saving it, etc.  Then I run the scenario again.  It succeeds on that first customer, then fails on the second customer.  Open the second customer, it works for them on the next run and fails on the third.  And so on…

I recreated the index for customers on a whim.  That has no effect.

Anybody have any ideas on what might be happening there?

Thank you!

 

Best answer by darylbowman

Has there been any changes to customizations?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • May 22, 2025

Has there been any changes to customizations?


  • Author
  • Freshman II
  • May 28, 2025

Thank you, I didn’t think of that!  We do have a consultant that did some work for us and didn’t tell me he had updated our customization.  And broke things…