Jump to content

EspMethodCall::invoke: Operation[data::entityAddRecord] A database or query error occurred while inserting the primary record data into the database.


Recommended Posts

That will either mean that you've missed a mandatory field, or you've entered a "friendly" (e.g. text description) value where there should be a numeric value (i.e. the id)

Off the top of my head the operationalState would be a likely candidate, but I'd need to dig into the tables to be sure.

Link to comment
Share on other sites

... and I should be looking better next time to actually see the CSV has already been attached... oh, well...  I have my moments...

So... @Mark (ESC) it's the location type, operational state.... For example, in the CSV the operational state field has the value as "operational". The correspondent field in the assets table needs a numeric value. You can find this info (and other info about field types for assets) in admin tool:

image.png

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...