has enyone encountered/resolved this problem? not sure why a view can be created but not a table. event log says 'workflow failed due to unexpected failure in the following nodes, please review if there were any unexpected core dumps: Output_3_5.
This is fixed in the Oracle Data Mining 11.2.03 release.
So you can upgrade your db to 126.96.36.199, or you can avoid having all three columns passed as input to the create table.
For example, you can use 2 Update Table nodes, each with the same input flow, and just edit the columns that are being updated so these columns are not being inserted at the same time.
Now if this is not the same issue you are running into, then we will need more information about what input the Create Table node is processing and if you are using any index or key options.
Regarding upper and lower limits. They can return null depending on the quality of the model build.
Here is a snippet from the ODM documentation.
The PREDICTION_BOUNDS function is for use only with generalized linear models. It returns an object with two NUMBER fields LOWER and UPPER. For a regression mining function, the bounds apply to value of the prediction. For a classification mining function, the bounds apply to the probability value. If the GLM was built using ridge regression, or if the covariance matrix is found to be singular during the build, then this function returns NULL for both fields.
GLM models do not automatically filter out attributes that may lead to the above condition. You will have to manually remove these attributes. Try just keeping the attributes with the highest coefficient values as a start and rebuilding the model.
To determine the version of the db that you are connected to, just run the following query in sql worksheet:
select * from v$version where banner like 'Oracle%';