Skip to main content
Question

The Site object does not exist Error

  • Jun 21, 2021 4:07 PM UTC
  • 5 replies
  • 1098 views

Forum|alt.badge.img+7

I am doing a Migration Job to enter Accounting Preposting date in to the Pre_Accounting View.  I keep getting this “The Site object does not exist.” error.

Does anyone know the reason for the error.   I wish IFS error messages were a little more descriptive.

 

This topic has been closed for replies.

5 replies

Forum|alt.badge.img+28
  • Superhero (Customer)
  • Jun 21, 2021 4:44 PM UTC

Maybe check there are no blank rows at the end of your dataset that look like they are supposed to be migrated in, but are actually just null rows.  Depending on the file format, I’ve seen where deleting rows in the dataset, then trying to migrate will pick up the blanks.  You don’t intend for them to go, but they get read as part of the dataset.  I use the delete row function down below the dataset for a few hundred rows to make sure the end is clear.


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • Jun 23, 2021 3:21 PM UTC

There were no blank lines.  Here is the full error.  ORA-20111: Site.NOTEXIST2: The Site object does not exist.


Forum|alt.badge.img+16
  • Hero (Customer)
  • Jun 24, 2021 12:47 PM UTC

Perhaps it is a stupid question, but do you passing site value in your input data? Preposting should contain code part values, company and site (site field is called Contract)


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • Jun 24, 2021 12:55 PM UTC

I tried that and rec’d the same error.  In the table, there is Contract field, but it is null almost all the time.


Forum|alt.badge.img+16
  • Hero (Customer)
  • Jun 24, 2021 12:59 PM UTC

In IFS v. 7.5 I am using, there’s no company or contract field in the table behind pre_accounting view, but Contract and company passed as attributes in New_  function are taking important part in validation process. They are mandatory then...