Toad World® Forums

Strange error when generating the report


#1

I am having a strange issue when generating a report from a query result. I am using TDA 3.0.0 base edition.

I execute a script in the editor then try to send the results to Data Report Designer. I encounter the following error message:

Error converting data. Could not convert to .Net type
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

If I create a table from the results, there are three columns maked Not Null. Once I made all of them Nullable, I can send the data to the Report Designer without any problem.

Any anyone help with the issue as I still need to generate the report from the query instead of the table?

Thanks
Yuheng


#2

When you have a result set we convert the results to common .net data types. This seems like a data driven error Can you export the results to an excel file and post? We would need this data to recreate the problem.

If you dont’ want to post you can send in private email.

dpeabody@quest.com

P.S. What is your connection type?


#3

Dear Debbie,

Thanks for your reply. I have used both Direct connection and Oracle Client connection, but the error is the same. I have just sent you an email with the data.

Best
Yuheng