+---------------------------------------------------------------------------+
Marketing: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

AMS_JCP_MODEL_BUILD module: AMS_JCP_MODEL_BUILD
+---------------------------------------------------------------------------+

Current system time is 01-MAY-2007 06:56:30

+---------------------------------------------------------------------------+

INFO:  Entered BuildModel:runProgram()
INFO:  Entered PropertyManager:loadProperties()
INFO:  Entered PropertyManager:init()
INFO:  Mining server user name: ODM
INFO:  Use DB Link Profile: null
INFO:  Is single installation: true
INFO:  db link: 
INFO:  Mining server URL: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
INFO:  Exiting PropertyManager:init()
INFO:  parameter name: Model ID, value: 10073
INFO:  parameter name: Positive Target Value, value: 1
INFO:  Exiting PropertyManager:loadProperties()
INFO:  DataMiningModel() ODM Engine Debug = Y
DEBUG: Entered DataMiningModel.loadProperties 
INFO:  DB LINK = 
INFO:  DataMiningModel() ModelID = 10073
INFO:  DataMiningModel() APPS Instance Name = GAMA
INFO:  ApplicableDataMiningModel() ScoreID = null
INFO:  DataMiningModel() ODM Engine Debug = Y
DEBUG: Entered DataMiningModel.loadProperties 
INFO:  DB LINK = 
INFO:  DataMiningModel() ModelID = 10073
INFO:  DataMiningModel() APPS Instance Name = GAMA
DEBUG: Entered login()
INFO:  Instantiated DataMiningServer  with jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama))) ODM
INFO:  Connection established  with DataMiningServer.
DEBUG: Exiting login()
DEBUG: Entered cleanupPreviousBuildResults()
DEBUG: Exiting cleanupPreviousBuildResults()
DEBUG: Entered NaiveBayesModel.cleanupPreviousBuildResults()
DEBUG: Entering NaiveBayesModel.dropBuildRelatedODMObjects()
DEBUG: Connection established with: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
DEBUG: Connection closed with: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
DEBUG: Exiting NaiveBayesModel.dropBuildRelatedODMObjects()
DEBUG: Exiting NaiveBayesModel.cleanupPreviousBuildResults()
DEBUG: Entered setupBuildEnvironment()
INFO:  In setupBuildEnvironment() - Preparing mining columns list.  Start Time = Tue May 01 06:57:41 CDT 2007
DEBUG: In setupBuildEnvironment() - SQL = SELECT column_name, data_type from ALL_TAB_COLUMNS WHERE table_name= ?    AND owner= ? 
DEBUG: In setupBuildEnvironment() - Is APPS connection null = oracle.jdbc.driver.OracleConnection@166aa18
DEBUG: In setupBuildEnvironment() - APPS Training data view name = AMS_DM_10073_TRAIN_V
DEBUG: m_hashMiningColumns.isEmpty: false
DEBUG: m_hashMiningColumns.keys: oracle.apps.ams.common.FastHashtable$FastHashtableEnumerator@530cf2
INFO:  setupBuildEnvironment - Time Taken to Get Mining Columns: 4 seconds
INFO:  setupBuildEnvironment - Mining Columns: {GENDER=VARCHAR2, OCCUPATION=VARCHAR2, NUMBER_OF_ADULTS=VARCHAR2, ESTIMATED_INCOME_CODE=VARCHAR2, STATE=VARCHAR2, SOURCE_ID=NUMBER, OWN_RENT_FLAG=VARCHAR2, HOUSEHOLD_STATUS=VARCHAR2, MARITAL_STATUS=VARCHAR2, AGE_RANGE=VARCHAR2, PROPERTY_TYPE=VARCHAR2, NEW_FIRST_NAME=VARCHAR2, LENGTH_OF_RESIDENCE=VARCHAR2, NEW_LAST_NAME=VARCHAR2, PRESENCE_OF_CHILDREN=VARCHAR2, TARGET_VALUE=VARCHAR2}
DEBUG: m_hashMiningColumns.isEmpty: false
DEBUG: m_hashMiningColumns.keys: oracle.apps.ams.common.FastHashtable$FastHashtableEnumerator@1bf3d87
INFO:  NaiveBayesModel.setupbuildEnvironment() Going to create Views OMO_GAMA_10073_B_V and OMO_GAMA_10073_T_V
DEBUG: Connection established with: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
INFO:  Created View for Input Training Data: OMO_GAMA_10073_B_V
INFO:  Created View for Input Test Data: OMO_GAMA_10073_T_V
DEBUG: NaiveBayesModel.setupBuildEnvironment() Finally Closing Connections
DEBUG: Connection closed with: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
DEBUG: Exiting setupBuildEnvironment()
DEBUG: Entered getAutoBinningAttributesData()
DEBUG: getAutoBinningAttributesData() is b2b customer profitability model? false
DEBUG: getAutoBinningAttributesData() Select Stmt = SELECT f.source_column_name, f.field_data_type, nvl(f.no_of_buckets,10) from   ams_list_src_fields f, ams_dm_models_all_b m, ams_dm_targets_b t WHERE m.model_id  = ?  AND t.target_id = m.target_id  AND (f.list_source_type_id = t.data_source_id OR f.list_source_type_id IN  (SELECT s.data_source_id from ams_dm_target_sources s, ams_list_src_types l  WHERE s.target_id = t.target_id and l.list_source_type_id = s.data_source_id and l.enabled_flag = 'Y'  and exists (select 1 from ams_list_src_type_assocs assoc where assoc.MASTER_SOURCE_TYPE_ID = t.data_source_id  and assoc.SUB_SOURCE_TYPE_ID = s.data_source_id and assoc.enabled_flag = 'Y'))  )  AND (f.auto_binning_flag = 'Y' or not exists (select 1 from ams_dm_bin_values b where f.list_source_field_id = b.source_field_id)  OR (nvl(f.auto_binning_flag,'N') = 'N' and not exists (select 1 from ams_dm_bin_values b where f.list_source_field_id = b.source_field_id and (b.bin_value is not null or b.start_value is not null or b.end_value is not null)))) AND f.analytics_flag = 'Y'  AND f.enabled_flag = 'Y' 
DEBUG: getAutoBinningAttributesData() Auto-Bin Attributes = {GENDER=VARCHAR2, OCCUPATION=VARCHAR2, ESTIMATED_INCOME_CODE=VARCHAR2, NUMBER_OF_ADULTS=VARCHAR2, STATE=VARCHAR2, OWN_RENT_FLAG=VARCHAR2, HOUSEHOLD_STATUS=VARCHAR2, MARITAL_STATUS=VARCHAR2, AGE_RANGE=VARCHAR2, PROPERTY_TYPE=VARCHAR2, NEW_FIRST_NAME=VARCHAR2, LENGTH_OF_RESIDENCE=VARCHAR2, NEW_LAST_NAME=VARCHAR2, PRESENCE_OF_CHILDREN=VARCHAR2}
DEBUG: getAutoBinningAttributesData() Auto-Bin Attributes Buckets = {GENDER=10, OCCUPATION=10, ESTIMATED_INCOME_CODE=10, NUMBER_OF_ADULTS=10, STATE=10, OWN_RENT_FLAG=10, HOUSEHOLD_STATUS=10, MARITAL_STATUS=10, AGE_RANGE=10, PROPERTY_TYPE=10, NEW_FIRST_NAME=10, LENGTH_OF_RESIDENCE=10, NEW_LAST_NAME=10, PRESENCE_OF_CHILDREN=10}
DEBUG: Exiting getAutoBinningAttributesData()
DEBUG: Entered performDiscretization() for BUILD
INFO:  Instantiated LocationAccessData using : ODM.OMO_GAMA_10073_B_V
INFO:  getPhysicalDataSpecification() Successfully created NonTransactionalDataSpecification
DEBUG: Exiting getPhysicalDataSpecification()
INFO:  Instantiated LocationAccessData using : ODM.OMO_B_GAMA_10073_B
INFO:  Instantiated LocationAccessData for output using ODM.OMO_B_GAMA_10073_B
DEBUG: Entered createBinBoundaryTables()
INFO:  createBinBoundaryTables() Number of Columns to bin: 14
DEBUG: [0] Key: GENDER Type: VARCHAR2 Buckets 10
DEBUG: [1] Key: OCCUPATION Type: VARCHAR2 Buckets 10
DEBUG: [2] Key: ESTIMATED_INCOME_CODE Type: VARCHAR2 Buckets 10
DEBUG: [3] Key: NUMBER_OF_ADULTS Type: VARCHAR2 Buckets 10
DEBUG: [4] Key: STATE Type: VARCHAR2 Buckets 10
DEBUG: [5] Key: OWN_RENT_FLAG Type: VARCHAR2 Buckets 10
DEBUG: [6] Key: HOUSEHOLD_STATUS Type: VARCHAR2 Buckets 10
DEBUG: [7] Key: MARITAL_STATUS Type: VARCHAR2 Buckets 10
DEBUG: [8] Key: AGE_RANGE Type: VARCHAR2 Buckets 10
DEBUG: [9] Key: PROPERTY_TYPE Type: VARCHAR2 Buckets 10
DEBUG: [10] Key: NEW_FIRST_NAME Type: VARCHAR2 Buckets 10
DEBUG: [11] Key: LENGTH_OF_RESIDENCE Type: VARCHAR2 Buckets 10
DEBUG: [12] Key: NEW_LAST_NAME Type: VARCHAR2 Buckets 10
DEBUG: [13] Key: PRESENCE_OF_CHILDREN Type: VARCHAR2 Buckets 10
DEBUG: Going to invoke createDiscretizationTables()
INFO:  Start Time Tue May 01 06:57:48 CDT 2007
INFO:  End Time Tue May 01 06:58:00 CDT 2007
INFO:  Successfully created bin boundary tables. Duration 12 seconds
DEBUG: Entered insertManualBinBoundaryRecords()
DEBUG: insertManualBinBoundaryRecords() is b2b customer profitability model? false
DEBUG: insertManualBinBoundaryRecords() Select Stmt = SELECT f.source_column_name, f.field_data_type, nvl(f.no_of_buckets,10),  b.bucket, b.bin_value, b.start_value, b.end_value  from   ams_list_src_fields f, ams_dm_models_all_b m, ams_dm_targets_b t, ams_dm_bin_values b WHERE m.model_id  = ?  AND t.target_id = m.target_id  AND  (f.list_source_type_id = t.data_source_id OR  f.list_source_type_id IN  (SELECT s.data_source_id from ams_dm_target_sources s, ams_list_src_types l  WHERE s.target_id = t.target_id and l.list_source_type_id = s.data_source_id and l.enabled_flag = 'Y'  and exists (select 1 from ams_list_src_type_assocs assoc where assoc.MASTER_SOURCE_TYPE_ID = t.data_source_id  and assoc.SUB_SOURCE_TYPE_ID = s.data_source_id and assoc.enabled_flag = 'Y')) )  AND f.list_source_field_id = b.source_field_id  AND nvl(f.auto_binning_flag,'N') = 'N'  AND f.analytics_flag = 'Y'  AND f.enabled_flag = 'Y'  AND NOT EXISTS (SELECT 1 from ams_dm_bin_values z where z.bin_value_id = b.bin_value_id and z.bin_value is null and z.start_value is null and z.end_value is null) 
DEBUG: Connection established with: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
DEBUG: Connection closed with: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=ORD.rithi.com)(PORT=1575)))(CONNECT_DATA=(SID=gama)))
DEBUG: Exiting insertManualBinBoundaryRecords()
DEBUG: Exiting createBinBoundaryTables()
INFO:  Going to discretize input data.
INFO:  Start Time Tue May 01 06:58:02 CDT 2007
INFO:  End Time Tue May 01 06:58:08 CDT 2007
INFO:  Successfully discretized input data. Duration 6 seconds
DEBUG: Exiting performDiscretization() 
DEBUG: Entered createMiningFunctionSettings() 
DEBUG: Entered getAttributeType() for attribute type - categorical
DEBUG: Entered getType() for class - class oracle.dmt.odm.AttributeType
DEBUG: getType() = oracle.dmt.odm.AttributeType@1b64e6a
DEBUG: Exiting getType() 
DEBUG: Entered getPreparationStatusObject Type = discretized
DEBUG: Got DataPreparationStatus object  class oracle.dmt.odm.DataPreparationStatus
DEBUG: Exiting getPreparationStatusObject
INFO:  Instantiated NaiveBayesSettings SingletonThreshold=  0.01 PairwiseThreshold= 0.01
INFO:  Instantiated LocationAccessData using : ODM.OMO_B_GAMA_10073_B
INFO:  getPhysicalDataSpecification() Successfully created NonTransactionalDataSpecification
DEBUG: Exiting getPhysicalDataSpecification()
DEBUG: Instantiated ClassificationFunctionSettings 
DEBUG: Entered getAttributeUsageObject Usage = supplementary
DEBUG: Got AttributeUsage object  class oracle.dmt.odm.AttributeUsage
DEBUG: Exiting getAttributeUsageObject
DEBUG: Adjusted attribute usage of SOURCE_ID to supplementary 
INFO:  Persisted MiningFunctionSettings. Name: OMO_GAMA_10073_MFS
DEBUG: Exiting createMiningFunctionSettings() 
DEBUG: Entered build() 
INFO:  Instantiated LocationAccessData using : ODM.OMO_B_GAMA_10073_B
INFO:  getPhysicalDataSpecification() Successfully created NonTransactionalDataSpecification
DEBUG: Exiting getPhysicalDataSpecification()
INFO:  Instantiated LocationAccessData using : ODM.OMO_B_GAMA_10073_B
INFO:  getPhysicalDataSpecification() Successfully created NonTransactionalDataSpecification
DEBUG: Exiting getPhysicalDataSpecification()
DEBUG: Successfully created MiningBuildTask.
INFO:  Successfully stored MiningBuildTask. Task Name = OMO_GAMA_10073_B_T
INFO:  Going to execute MinnigBuildTask.
INFO:  Start time: Tue May 01 06:58:12 CDT 2007
INFO:  Successfully submitted MiningBuildTask for execution.  Going to Wait for Completion