How can I dismiss the profiling error message in Data Preparation?

Question

Creating a dataset using Oracle DB tables.  After creating the Definition and clicking OK, I'm getting an error

There was an error profiling your dataset.  Click the Profile button to run the profile again.  Error code = 17010

Clicking Profile gives the same error.  I've disabled the Toggle Quality Tiles and Use Sample Data options in the lower right corner.   However, I can't dismiss the profile error and move to the Data Preparation screen.  I'm stuck at the error message can't save or edit.

Luis E. Rivas -Oracle · Accepted Answer

@Jim English-Oracle - what is most likely the cause of the error is reserved words in the object names.  Have you tried going to the ADW connection and going to the advanced tab and selecting Double Quotes as the quoting identifier and trying again? The issue should be resolved after this - let me know if it doesn't.

User_90353 · Accepted Answer

Hello,

I had the same problem. I tried removing special characters or spaces first, but that didn't help. What finally helped was that I adjusted the length of the column names. Apparently there is some limitation from Oracle. I hope this helps someone.

Cheers!

Jakub