"Generate Occupant Features" Geoprocessing Tool & Error 00800

578
2
04-07-2021 05:54 AM
dky
by
New Contributor III

Hi,

Environment:
ArcGIS Pro 2.7 / Indoors (AIIM) database (with v2.6 schema updates applied) / Enterprise Portal 10.8.1 (Incl. Indoors Capabilities)

 

We're working through the Space Planner workflow; We've applied all of modifications to our database as per the "Prepare a map for use in Indoor Space Planner" guidance. 

For the "Generate Occupant Features" geoprocessing run, we're using:

  • Unit ID Field: Name
  • Occupant Id Field: KNOWNAS

We've pasted the same data to both the Units table and into the Excel data file, so there should be no problems with the join.

When we execute "Generate Occupant Features", we get the following error:

Failed to execute. Parameters are not valid.
ERROR 000800: The value is not a member of Input Occupant Table.
Failed to execute (ExcelToTable).
Failed to execute (GenerateOccupantFeatures).

 

The documentation for "Error 000800" is rather vague ... 

Description
The keyword used is not a member of the list of acceptable keywords.

Solution
Change the keyword to a member of the list provided. For more information on what each keyword signifies, review the tool's help.

 

Deducing from the full error message in Pro, the FailedToExecute indicates "ExcelToTable". 
So maybe it's something in the (Input Occupant Data) Excel file? 

Okay, but what does "value" mean (Column name or cell data)? 

The only columns in our Excel file are (all of) those specified here Load occupant data documentation.
So maybe it's something in the data? Last thing I can think of trying is to export the Excel file into a csv but really doubt that would be too helpful ... 

 

Any thoughts appreciated!

 

Thanks, 
Derek

 

0 Kudos
2 Replies
GauravJobanputra
Esri Contributor

Hi Derek,

Were you able to get this issue resolved?

- Gaurav

0 Kudos
m_neer
by
Occasional Contributor

Name or rather Names in some instances are reserved words for various applications, you could try changing out Name and see?  However, I'm leaning more towards a  issues where there is a cell value that has a special character within say a  hidden space of that nature possibly??  Best guess good luck.

0 Kudos