Error during Text Mining execution [Data Mining System Error ORA-12988: ]
858241Apr 28 2011 — edited May 4 2011Hi,
When I run dmkmdemo.java sample program with the below code (starts with <code>) snippet from ODM 11g bundle, I see this below error (starts with <error> - I've created user dmuser, run the scripts):
<code>
public static void prepareData() throws JDMException
{
System.out.println("---------------------------------------------------");
System.out.println("--- Prepare Data ---");
System.out.println("---------------------------------------------------");
String inputDataURI = null;
String outputDataURI = null;
OraTransformationTask xformTask = null;
// 1. Prepare build data
inputDataURI = "MINING_BUILD_TEXT";
outputDataURI = "mining_build_nested_text";
//NESTED_TABLE_BUILD_TEXT
// Create OraTextTransform
OraTextTransform txtXform = (OraTextTransformImpl)m_textXformFactory.create(
inputDataURI, // name of the input data set
outputDataURI, // name of the transformation result
"CUST_ID", // Case id column
new String[] { "COMMENTS" } ); // Text column names
// Create transformation task
System.out.println("sanku *** JDM transformation");
xformTask = m_xformTaskFactory.create(txtXform);
txtXform.setTextColumnList( new String[] { "COMMENTS" }); // for nested column list
executeTask(xformTask, "kmPrepareBuildTask_jdm");
</code>
<error>
kmPrepareBuildTask_jdm is started, please wait. kmPrepareBuildTask_jdm is failed.
Failure Description: ORA-40101: Data Mining System Error ORA-40101: Data Mining System Error ORA-12988: cannot drop column from table owned by SYS
ORA-06512: at "SYS.DBMS_JDM_INTERNAL", line 2772
--
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_JDM_INTERNAL", line 3000
--
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_JDM_INTERNAL", line 3021
ORA-06512: at line 1
</error>
Any pointers or help here please? Thanks.
Sanjeev