Troubleshooting Invalid Service Errors

Choose from the following error messages and warnings:

Problem: Received the following error message:

Invalid Service: No SQL text specified for SQL statement operation <operation name>.

Solution: Verify that the SQL statement operation added contains valide SQL text.

Problem: Received the following error message:

Invalid Service: Name is empty.

Solution: All services must have a valid name.

Problem: Received the following warning:

Invalid Service: No result set specified for select statement in operation <operation name>.

Solution: SQL operations that contain select statements must have result sets.