executing query error.

jaws1021
jaws1021 used Ask the Experts™
on
When I am at the Configure Data Source, right at the test query part I get this error

There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

The thing is when I execute query, it has giving me all the data I need.
Why I get this error?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
That happened to me as well  when I changed the stored procedure and re-configure the datasets.

What I did to solve that problem is to delete the table and query, then drag and drop the stored procedure to the dataset designer AGAIN
Sham HaqueSenior SAP CRM Consultant

Commented:
could you post your query and the underlying table(s) design?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial