advoco-connect-education-network-logo-wh
How Training Works
Infor EAM Training Courses
Pricing
Sign Up
Member Login
To see this working, head to your live site.
  • Categories
  • All Posts
  • My Posts
jhobor
Jun 29, 2020

What would cause "no data found" error?

in Ask the EAM Community

In our TRN environment, I have created a couple of test records. I created a System, Position, and an Asset. I was able to link the Position to the System, but when I tried to link the Asset to the Position, I received the following error "no data found". I've been creating systems, positions, and assets for years, so I'm not doing anything any differently, so I'm at a loss as to why I'm receiving this error.

1 answer0 replies
1
Becca Spilka
Jul 07, 2020

The "no data found" error occurs due to an issue with one or more of the flex business rules. The flex statement is attempting to pull a query, and the query is not pulling any data. This then throws the "no data found" error.


If it is throwing this error, and you think the flex should be pulling data, then you want to go back and check over your queries. If you know that it should not be pulling data, and you do not want to see this error in those cases, you can add an exception to the flex. This looks like:


EXCEPTION

WHEN no_data_found THEN

NULL;


This means that whenever no data is found by the select statement, the flex rule will simply end instead of throwing the error.