HELP : Problem running the Oracle9i Data Mining samples

From: Vincent Dervaux <vdervaux_at_microresearch.be>
Date: 12 Mar 2002 05:09:14 -0800
Message-ID: <5095daa9.0203120509.622fae46@posting.google.com>

Hello,

I've tried to run the AssociationRules sample (Java source code) for about 1 week now, and I've always got the same error message : ORA-00905: Missing keyword
The login to the DMS is OK, the boundary objects were correctly formed and the discretization tables were correctly created, but the error just happened after that step!

Here is the layout :

---

Completed MiningServer login
Formed bin boundary objects: census_2d_build Created discretization tables for: census_2d_build

Received an exception in main: ORA-00905: Keyword missing ORA-06512: à "ODM.ODM_MINING_TRANSFORMATION", ligne 1617 ORA-06512: à ligne 1

java.sql.SQLException: ORA-00905: Keyword missing ORA-06512: à "ODM.ODM_MINING_TRANSFORMATION", ligne 1617 ORA-06512: à ligne 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) 
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) 
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) 
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) 
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:487)
at oracle.dmt.odm.transformation.Transformation.discretize(Transformation.java:607)
at Sample_Discretization.performCensusBinningFor2D(Sample_Discretization.java:190)

at Sample_AssociationRules.performDiscretization(Sample_AssociationRules.java:203) at Sample_AssociationRules.main(Sample_AssociationRules.java:129) Logging out of MiningServer.

The problem seems to be in the Transformation.discretize function. I've tried to run the sample for transactional data specification and it WORKS fine, so what's the problem with non-transactional? Any idea?

Here is the input data file :

---

################# DATA MINING SERVER ################ 

### MiningServer details

miningServer.url=jdbc:oracle:thin:@mars:1521:newmad9 
miningServer.userName=ODM 
miningServer.password=ODMPW 
##################################################### 


################### INPUT TABLE ######################### 

### Data to be used for build
# Possible values for type: transactional, nonTransactional

buildData.type=nonTransactional 
buildData.tableName=CENSUS_2D_BUILD 
buildData.schemaName=ODM_MTR 
############################################################ 

############### NOT USED IN MY CASE ######################## 

# Used ONLY when buildData.type above is set to "transactional"

transactionalData.sequenceId=SEQ_ID 
transactionalData.attributeName=ANAME 
transactionalData.valueName=VALUE 
################################################################ 

#################### DISCRETIZATION ########################### 

### Specify if discretization is needed discretization.perform=yes
# Read only if discretization.perform is set to "yes"
discretization.discretizationNumericTableName=NUM_TEMP_AR discretization.discretizationCategoricalTableName=CAT_TEMP_AR
# Schema where discretization tables will be created
discretization.discretizationSchemaName=ODM
# Name of the output view

discretization.binnedBuildDataTableName=CENSUS_BUILD_BINNED_AR
# Schema where output view will be created
discretization.binnedBuildDataSchemaName=ODM

############################################################### 

############# SETTINGS ################ 

### AssociationRules function settings

associationRules.minimumSupport=0.01 
associationRules.minimumConfidence=0 
associationRules.maximumRuleLength=2 
####################################### 

############################# RESULTS
#################################

### Names for resulting MiningFunctionSettings and AssociationRulesModel
associationRulesOutput.miningSettingsName=Sample_AR_MFS_1 associationRulesOutput.modelName=Sample_AR_Model_1

#########################################################################

I really need some help

In advance, thanks for all

Vincent Dervaux Received on Tue Mar 12 2002 - 07:09:14 CST