This content has been marked as final. Show 3 replies
Date data types are not acceptable as input for building models.
Data Miner automatically excludes them.
So you are left with just the target column.
You are getting the "ORA-20025: Invalid training data for model build." error due as a result of having no input columns for the model build.
Just add a transform node prior to the build node and transform the date to a string or to a number depending on whether you want it to be treated as a categorical or numerical input.
I made as you adviced.
When I transformed data to 2 columns: year [numeric], month [numeric] regression model is processed.
When I transformed data into 1 column: date_string [string] I have error:
Build failed due to ORA-20025: Invalid training data for model build. .
ORA-06512: przy "ODMRSYS.ODMR_ENGINE_MINING", linia 1037 ORA-06512: przy "ODMRSYS.ODMR_ENGINE_MINING", linia 3701
My data set is: date_string [varchar2] and value [numeric].
It seems that one column is not enough.....
The Build model nodes have a automatic input selection mode that will filter out columns that have poor statistics for predictive purposes.
So in your case, if auto is on, the Build node may be removing your only input column.
Turn off the automatic setting for the model and insure that the column is selected as input.