Hi I'm new to Oracle Data Mining and I am using the SQL Developer GUI to do a few concept proofs. I was able to go through the tutorials successfully - however when I use my own data I am running into the following message on the Class Build node during the Test phase of the model build.
Test failed due to ORA-00910: specified length too long for its datatype .
ORA-06512: at "ODMRSYS.ODMR_ENGINE_MINING", line 1643 ORA-06512: at "ODMRSYS.ODMR_ENGINE_MINING", line 1986
Any ideas what might be wrong? What's the best way to find what's causing the error?
Any assistance anyone could provide would be greatly appreciated.
By default, we limit the target distinct count to <= 1000 for classification model build. But that can be adjusted in the ODMRSYS.ODMR$REPOSITORY_PROPERTIES property table (change the value in the MAX_TARGET_DISTINCT_COUNT property).
Please run this query and let us know the result:
select max(length(DX_NAME)) from pop_visit_info;
Is your dataset multi-bytes?
It help us to diagnose the problem if we can look at the specification of your workflow. If you can narrow down your workflow to a few nodes and post it here, we can take a closer look at it.
It seems your workflow contains 3 nodes (DATA_SOURCE, BUILD TEXT, CLASS BUILD). Since your data set contains many columns, the exported workflow could be quite sizable. Is it possible to save it to a Google Drive or Dropbox account and provide me a link to it? So I can download the workflow and try to reproduce the problem in house.