How Training Works
Infor EAM Training Courses
Pricing
Sign Up
Member Login
To see this working, head to your live site.
  1. Connector Community
  2. Ask the EAM Community
  3. What would cause "no data found" error?
Search
jhobor
Jun 29, 2020

What would cause "no data found" error?

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 7, 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.

Login to the Connect Education Network
advoco-connect-education-network-logo-fa

LEARN MORE

How Training Works
Infor EAM Training Courses
Pricing

SIGN UP

Start Your Free Trial
How to Sign Up
Enter Token Code

CONTACT

ADDITIONAL RESOURCES

Contact Advoco
Connect - Annual User Conference
Cancel
Advoco
Testimonials
FAQ