Welcome Guest. Sign in or Signup

1 Answers

No rows exist for the specified keys

Asked by: 7 views Component Interface

I have a Component Interface that I call from a Webservice to return some details of an Employee.
EMPLID is the only Find Key for the CI.
The Webservice used Basic Authentication and the permission list tagged to the user has full access to the CI.
Also, data corresponding to a particular employee is present in the system.

However, when the Webservice tries to invoke the CI, it throws and error: No rows exist for the specified keys.
How would you go about solving this issue?

Related Questions

1 Answers

  1. Best Answer


    Candidate on Apr 11, 2017 Reply

    I would first recheck that the data for the particular employee is present in the system or not.

    If data is available, the next point to check is the Search Record of the Component underlying the CI.
    I would check if it has keys like OPRCLASS or ROWSECCLASS. These are used for setting up Row-level security.
    If any of these are present, I would check the user’s User Profile to see what Primary Permission list / Row Security permission list they are having.

    The most common cause would be that the user’s Row-level security doesn’t allow access to the data pertaining to the particular employee.


    Warning: mysql_query(): No such file or directory in /home/psoft_adm/psoftsearch.com/interview-questions/wp-content/themes/Answers/library/includes/comment-rating.php on line 57

    Warning: mysql_query(): A link to the server could not be established in /home/psoft_adm/psoftsearch.com/interview-questions/wp-content/themes/Answers/library/includes/comment-rating.php on line 57

    Warning: mysql_query(): No such file or directory in /home/psoft_adm/psoftsearch.com/interview-questions/wp-content/themes/Answers/library/includes/comment-rating.php on line 64

    Warning: mysql_query(): A link to the server could not be established in /home/psoft_adm/psoftsearch.com/interview-questions/wp-content/themes/Answers/library/includes/comment-rating.php on line 64

    0 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question