Getting Error code: 17012 when querying data from Oracle database

ANNE LORRAINE-Oracle

I am preparing a dataset and getting this error code: 17012. No more details showed about this error.

Harriet Huang-Oracle

Hi @ANNE LORRAINE-Oracle

Here is a similar issue to yours. Kindly check if your columns have special characters or spaces, and the column name length, like more than 30 characters and so on.

If that does not work for you, please click the Show Details and share the detail error.

https://community.oracle.com/products/oracleanalytics/discussion/20979/how-can-i-dismiss-the-profiling-error-message-in-data-preparation

SteveF-Oracle

Hi @ANNE LORRAINE-Oracle

Which product are you using?

Oracle Analytic Cloud?

Oracle Analytics Server 2024? 2023?

Mostafa Morsy-Oracle

@ANNE LORRAINE-Oracle

Can you do a small test for me instead of drag and drop columns from Schema can you Create a Manual Query and type query which you tested in your SQL Developer or any other tool and sure it is working and test the Manual Query and let me know if this works for you

If above did not work can you check the columns by create 1 column at a time (using Manual Query) and see if it works till you get a column which causing the problem maybe a data issue but let us take it step by step

What is the back-end DB?