Feb 06, 2018 2:14:00 PM com.rapidminer.tools.I18N INFO: Set locale to en. Feb 06, 2018 2:14:01 PM com.rapidminer.core.license.ProductConstraintManager initialize INFO: Initializing license manager. Feb 06, 2018 2:14:01 PM com.rapidminer.core.license.ProductConstraintManager initialize INFO: Using default license location. Feb 06, 2018 2:14:01 PM com.rapidminer.core.license.ProductConstraintManager initialize INFO: Registering default product. Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Cloud Connectivity Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Cloud Execution Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Data Editor Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: H2O Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Operator Recommender Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Process Scheduling Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Advanced File Connectors Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Concurrency Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: JDBC Connectors Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Legacy Result Access Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Productivity Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Professional Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Remote Repository Feb 06, 2018 2:14:02 PM com.rapidminer.tools.plugin.Plugin registerPlugins INFO: Register plugin: Social Media Feb 06, 2018 2:14:03 PM com.rapidminer.tools.config.ConfigurationManager register INFO: Registered configurator Twitter Connection. Feb 06, 2018 2:14:03 PM com.rapidminer.tools.config.ConfigurationManager register INFO: Registered configurator Salesforce Connection. Feb 06, 2018 2:14:03 PM com.rapidminer.tools.config.ConfigurationManager register INFO: Registered configurator Amazon S3 Connection. Feb 06, 2018 2:14:03 PM com.rapidminer.tools.config.ConfigurationManager register INFO: Registered configurator Azure Blob Storage Connection. Feb 06, 2018 2:14:03 PM com.rapidminer.tools.config.ConfigurationManager register INFO: Registered configurator Dropbox Connection. Feb 06, 2018 2:14:05 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties WARNING: Missing database driver class name for ODBC Bridge (e.g. Access) Feb 06, 2018 2:14:05 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties WARNING: Missing database driver class name for Ingres Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Process Scheduling was loaded in 171ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Social Media was loaded in 172ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Productivity was loaded in 187ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Professional was loaded in 187ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Data Editor was loaded in 203ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Concurrency was loaded in 219ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Remote Repository was loaded in 234ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Legacy Result Access was loaded in 234ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Operator Recommender was loaded in 282ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Advanced File Connectors was loaded in 343ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Cloud Connectivity was loaded in 483ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension Cloud Execution was loaded in 515ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension H2O was loaded in 764ms. Feb 06, 2018 2:14:10 PM com.rapidminer.tools.plugin.Plugin initAll INFO: Extension JDBC Connectors was loaded in 4118ms. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Load configuration for Amazon S3 Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters INFO: No configuration file found for Amazon S3 Connection Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Loaded configurations for 0 objects of type Amazon S3 Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Load configuration for Azure Blob Storage Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters INFO: No configuration file found for Azure Blob Storage Connection Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Loaded configurations for 0 objects of type Azure Blob Storage Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Load configuration for Dropbox Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters INFO: No configuration file found for Dropbox Connection Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Loaded configurations for 0 objects of type Dropbox Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Load configuration for Salesforce Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters INFO: No configuration file found for Salesforce Connection Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Loaded configurations for 0 objects of type Salesforce Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Load configuration for Twitter Connection. Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters INFO: No configuration file found for Twitter Connection Feb 06, 2018 2:14:16 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration INFO: Loaded configurations for 0 objects of type Twitter Connection. Feb 06, 2018 2:14:20 PM com.rapidminer.deployment.update.client.MarketplaceUpdateManager$3 run INFO: Checking for updates. Feb 06, 2018 2:15:42 PM com.rapidminer.tools.ResultService init INFO: No filename given for result file, using stdout for logging results! Feb 06, 2018 2:15:42 PM com.rapidminer.Process execute INFO: Process starts Feb 06, 2018 2:15:42 PM com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler executeStatement INFO: Executing query: 'select d.jivexdir, max(d.bnr) as bnr, max(d.gnr) as gnr, min(d4.wert) as min_serien_datum, max(d4.wert) as max_serien_datum, max(d1.wert) as description, max(d6.wert) as alter_, -- min(d7.wert) as min_gewicht, -- max(d7.wert) as max_gewicht, avg(to_number(replace(coalesce(d2.wert,'0'),'.',','))) as avg_ctdi, max(to_number(replace(coalesce(d3.wert,'0'),'.',','))) as min_SliceLocation, min(to_number(replace(coalesce(d3.wert,'0'),'.',','))) as max_SliceLocation, avg(to_number(replace(coalesce(d2.wert,'0'),'.',','))) * (1 + max(abs(to_number(replace(coalesce(d3.wert,'0'),'.',',')))) - min(abs(to_number(replace(coalesce(d3.wert,'0'),'.',','))))) as DLP from tw_table d [...] removed!! [...] Feb 06, 2018 2:16:15 PM com.rapidminer.gui.ProcessThread run SEVERE: Process failed: Database error occurred: ORA-01722: invalid number com.rapidminer.operator.UserError: Database error occurred: ORA-01722: invalid number at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.getResultSet(DatabaseDataReader.java:115) at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.createExampleSet(DatabaseDataReader.java:122) at com.rapidminer.operator.io.AbstractExampleSource.read(AbstractExampleSource.java:49) at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.read(DatabaseDataReader.java:89) at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.read(DatabaseDataReader.java:73) at com.rapidminer.operator.io.AbstractReader.doWork(AbstractReader.java:126) at com.rapidminer.operator.Operator.execute(Operator.java:1004) at com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:77) at com.rapidminer.operator.ExecutionUnit$3.run(ExecutionUnit.java:812) at com.rapidminer.operator.ExecutionUnit$3.run(ExecutionUnit.java:807) at java.security.AccessController.doPrivileged(Native Method) at com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:807) at com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:428) at com.rapidminer.operator.Operator.execute(Operator.java:1004) at com.rapidminer.Process.execute(Process.java:1310) at com.rapidminer.Process.run(Process.java:1285) at com.rapidminer.Process.run(Process.java:1176) at com.rapidminer.Process.run(Process.java:1129) at com.rapidminer.Process.run(Process.java:1124) at com.rapidminer.Process.run(Process.java:1114) at com.rapidminer.gui.ProcessThread.run(ProcessThread.java:65) Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:762) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1309) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:422) at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.executeQuery(DatabaseHandler.java:1661) at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.executeStatement(DatabaseHandler.java:1228) at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.getResultSet(DatabaseDataReader.java:108) ... 20 more Feb 06, 2018 2:16:15 PM com.rapidminer.gui.ProcessThread logProcessTreeList SEVERE: Here: Feb 06, 2018 2:16:15 PM com.rapidminer.gui.ProcessThread logProcessTreeList SEVERE: Process[1] (Process) Feb 06, 2018 2:16:15 PM com.rapidminer.gui.ProcessThread logProcessTreeList SEVERE: subprocess 'Main Process' Feb 06, 2018 2:16:15 PM com.rapidminer.gui.ProcessThread logProcessTreeList SEVERE: ==> +- Read Database[1] (Read Database)