component { className = org.jetel.component.TextTableWriter; typ e = TEXT_TABLE_WRITER; } component { className = org.jetel.component.XmlXPathReader; name = XMLXPathReader; type = XML_XPATH_READER; } component { className = org.jetel.component.XMLExtract; name = X MLExtract; type = XML_EXTRACT; } component { className = org.jetel.component.JsonExtract; name = JSONExtract; type = JSON_EXTRACT; } component { className = org.jetel.component.XmlReader; name = XM LReader; type = XML_READER; } component { className = org.jetel.component.SpeedLimiter; name = SpeedLimiter; type = SPEED_LIMITER; } component { className = org.jetel.component.SpeedLimiter; name = Sleep; type = SLEEP; } component { className = org.jetel.component.JavaExecute; name = JavaExecute; type = JAVA_EXECUTE; } component { className = org.jetel.component.GenericComponent; na me = CustomJavaReader; type = GENERIC_READER; } component { className = org.jetel.component.GenericComponent; na me = CustomJavaWriter; type = GENERIC_WRITER; } component { className = org.jetel.component.GenericComponent; na me = CustomJavaTransformer; type = GENERIC_TRANSFORMER; } component { className = org.jetel.component.GenericComponent; na me = CustomJavaComponent; type = GENERIC_COMPONENT; } component { className = org.jetel.component.XmlWriter; name = XM LWriter (deprecated); type = XML_WRITER; } component { className = org.jetel.component.ExtXmlWriter; name = XMLWriter; type = EXT_XML_WRITER; } component { className = org.jetel.component.XSLDataTransformer; name = XSLTransformer; type = XSL_TRANSFORMER; } metadata { id = UniversalDataReader_Error; } metadata { id = HTTPConnector_Request; } metadata { id = HTTPConnector_Response; } metadata { id = HTTPConnector_Error; } metadata { id = RunGraph_Input; } metadata { id = RunGraph_Output; } DEBUG [main] - Plugin org.jetel.bulkloader loaded. id - org.jetel.bulkloader version - 4.7.0 provider-name - Javlin a.s. component { className = org.jetel.component.OracleDataWriter; na me = OracleDataWriter; type = ORACLE_DATA_WRITER; } component { className = org.jetel.component.DB2DataWriter; name = DB2DataWriter; type = DB2_DATA_WRITER; } component { className = org.jetel.component.InformixDataWriter; name = InformixDataWriter; type = INFORMIX_DATA_WRITER; } component { className = org.jetel.component.MsSqlDataWriter; nam e = MSSQLDataWriter; type = MS_SQL_DATA_WRITER; } component { className = org.jetel.component.MysqlDataWriter; nam e = MySQLDataWriter; type = MYSQL_DATA_WRITER; } component { className = org.jetel.component.PostgreSqlDataWriter ; name = PostgreSQLDataWriter; type = POSTGRESQL_DATA_WRITER; } component { className = org.jetel.component.InfobrightDataWriter ; name = InfobrightDataWriter; type = INFOBRIGHT_DATA_WRITER; } DEBUG [main] - Plugin org.jetel.hadoop loaded. id - org.jetel.hadoop version - 4.7.0 provider-name - Javlin a.s. connection { className = org.jetel.hadoop.connection.HadoopConne ction; type = HADOOP; } component { className = org.jetel.hadoop.component.HadoopWriter; name = HadoopWriter; type = HADOOP_WRITER; } component { className = org.jetel.hadoop.component.HadoopReader; name = HadoopReader; type = HADOOP_READER; } urlResolver { className = org.jetel.hadoop.service.filesystem.Ha doopPathResolver; type = HADOOP_HDFS; } DEBUG [main] - Plugin org.jetel.smb2 loaded. id - org.jetel.smb2 version - 4.7.0 provider-name - Javlin a.s. urlResolver { className = org.jetel.util.protocols.smb2.SMB2Path Resolver; type = SMB2; } DEBUG [main] - Plugin com.cloveretl.tableau.TableauWriter loaded. id - com.cloveretl.tableau.TableauWriter version - 4.7.0 provider-name - Javlin, a.s. component { className = com.cloveretl.tableau.TableauWriter; nam e = TableauWriter; type = TABLEAU_WRITER; } DEBUG [main] - Plugin org.jetel.thirdparty loaded. id - org.jetel.thirdparty version - 4.7.0 provider-name - Javlin a.s. component { className = org.jetel.component.Filter; name = Filte r; type = FILTER; } component { className = com.linagora.component.LdapReader; name = LDAPReader; type = LDAP_READER; } component { className = com.linagora.component.LdapWriter; name = LDAPWriter; type = LDAP_WRITER; } INFO [main] - Graph definition file: migration.grf INFO [main] - Checking graph configuration... INFO [main] - Graph configuration is valid. INFO [main] - Graph initialization (migration) INFO [main] - Initializing connection: INFO [main] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverIm pl@7c6908d7]:jndi[null]:url[jdbc:mysql://192.168.1.82:3306/fakturama_server]:use r[fakturama_server] ... OK INFO [main] - Initializing connection: INFO [main] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverIm pl@3c9754d8]:jndi[null]:url[jdbc:hsqldb:hsql:P:\Geld verdienen\Office\Auftragsbe arbeitung\Fakturama2\Database\Database]:user[sa] ... OK INFO [main] - Initializing phase 0 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - DB_EXECUTE0 ...OK INFO [main] - Phase 0 initialized successfully. INFO [main] - Initializing phase 1 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - CATEGORY ...OK DEBUG [main] - DBOUTPUT_TABLE ...OK INFO [main] - Phase 1 initialized successfully. INFO [main] - Initializing phase 2 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - DBOUTPUT_TABLE2 ...OK DEBUG [main] - VAT ...OK INFO [main] - Phase 2 initialized successfully. INFO [main] - Initializing phase 3 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - DBOUTPUT_TABLE1 ...OK DEBUG [main] - PRODUCT ...OK INFO [main] - Phase 3 initialized successfully. INFO [main] - Initializing phase 4 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - DBOUTPUT_TABLE3 ...OK DEBUG [main] - ITEMACCOUNTTYPE ...OK INFO [main] - Phase 4 initialized successfully. INFO [main] - Initializing phase 5 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - DBOUTPUT_TABLE12 ...OK DEBUG [main] - PRODUCTBLOCKPRICE ...OK INFO [main] - Phase 5 initialized successfully. INFO [main] - Initializing phase 6 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - ADDRESS ...OK DEBUG [main] - DBOUTPUT_TABLE11 ...OK INFO [main] - Phase 6 initialized successfully. INFO [main] - Initializing phase 7 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - BANKACCOUNT ...OK DEBUG [main] - DBOUTPUT_TABLE10 ...OK INFO [main] - Phase 7 initialized successfully. INFO [main] - Initializing phase 8 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - CEFACTCODE ...OK DEBUG [main] - DBOUTPUT_TABLE4 ...OK INFO [main] - Phase 8 initialized successfully. INFO [main] - Initializing phase 9 DEBUG [main] - Initializing edges DEBUG [main] - All edges initialized successfully. DEBUG [main] - Initializing nodes DEBUG [main] - DBOUTPUT_TABLE5 ...OK DEBUG [main] - PAYMENT ...OK INFO [main] - Phase 9 initialized successfully. DEBUG [main] - register MBean with name:org.jetel.graph.runtime:type=CLOVERJMX_1 516149394050_0 DEBUG [WatchDog] - Watchdog thread is running DEBUG [WatchDog_0] - Job execution type: ETL_GRAPH INFO [WatchDog_0] - Job parameters: INFO [WatchDog_0] - Runtime classpath: [] DEBUG [WatchDog_0] - Graph runtime context: {fastPropagateExecution=false, valid ateRequiredParameters=false, password=null, skipCheckConfig=false, debugDirector y=C:\Users\Peter\AppData\Local\Temp\, parentRunId=null, logLevel=null, compileCl assPath=[], edgeDebugging=true, synchronizedRun=false, clusterNodeId=null, conte xtURL=null, runId=0, trackingInterval=5000, calculateNoMetadata=false, waitForJM XClient=false, additionProperties={}, jobUrl=file:migration.grf, classLoaderCach ing=false, runtimeClassPath=[], batchMode=true, parentGraphInputPortsConnected=n ull, jobType=ETL_GRAPH, useJMX=true, verboseMode=false, dictionaryContent={ }, strictGraphFactorization=true, deamon=false, executionType=null, transactionMode =false, parentGraphOutputPortsConnected=null, executionLabel=null, executionGrou p=null} INFO [WatchDog_0] - Pre-execute initialization of connection: INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDr iverImpl@7c6908d7]:jndi[null]:url[jdbc:mysql://192.168.1.82:3306/fakturama_serve r]:user[fakturama_server] ... OK INFO [WatchDog_0] - Pre-execute initialization of connection: INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDr iverImpl@3c9754d8]:jndi[null]:url[jdbc:hsqldb:hsql:P:\Geld verdienen\Office\Auft ragsbearbeitung\Fakturama2\Database\Database]:user[sa] ... OK DEBUG [WatchDog_0] - GraphEdge [Edge0] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge2] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge1] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge3] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge12] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge11] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge10] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge20] : DIRECT DEBUG [WatchDog_0] - GraphEdge [Edge21] : DIRECT INFO [WatchDog_0] - Starting up all nodes in phase [0] DEBUG [WatchDog_0] - DB_EXECUTE0 ... starting DEBUG [WatchDog_0] - All components are ready to start. INFO [WatchDog_0] - Successfully started all nodes in phase! DEBUG [DB_EXECUTE0_0] - Opening input file D:\TEMP\HSQL2MYSQL4FAK\cleanup_target db.sql ERROR [DB_EXECUTE0_0] - Error when executing statement: ALTER TABLE `FKT_ADDRESS ` DROP FOREIGN KEY FK_FKT_ADDRESS_CONTACT_ADDRESSES ERROR [WatchDog_0] - Component [DBExecute:DB_EXECUTE0] finished with status ERRO R. Error on rename of './fakturama_server/FKT_ADDRESS' to './fakturama_server/#sql 2-3a0c-2c4' (errno: 152) ERROR [WatchDog_0] - Error details: org.jetel.exception.JetelRuntimeException: Component [DBExecute:DB_EXECUTE0] fin ished with status ERROR. at org.jetel.graph.Node.createNodeException(Node.java:641) at org.jetel.graph.Node.run(Node.java:608) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Error on rename of './fakturama_server/FKT_ADD RESS' to './fakturama_server/#sql2-3a0c-2c4' (errno: 152) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725) at org.jetel.component.DBExecute.execute(DBExecute.java:604) at org.jetel.graph.Node.run(Node.java:568) ... 1 more DEBUG [WatchDog_0] - Phase 0 post-execution DEBUG [WatchDog_0] - Edges post-execution DEBUG [WatchDog_0] - Edges post-execution success. DEBUG [WatchDog_0] - Components post-execution DEBUG [WatchDog_0] - DB_EXECUTE0 ...OK DEBUG [WatchDog_0] - Phase 0 post-execution succeeded. INFO [WatchDog_0] - Execution of phase [0] finished with error - elapsed time(s ec): 0 ERROR [WatchDog_0] - Phase finished with error - stopping job run INFO [WatchDog_0] - Post-execute finalization of connection: INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDr iverImpl@7c6908d7]:jndi[null]:url[jdbc:mysql://192.168.1.82:3306/fakturama_serve r]:user[fakturama_server] ... OK INFO [WatchDog_0] - Post-execute finalization of connection: INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDr iverImpl@3c9754d8]:jndi[null]:url[jdbc:hsqldb:hsql:P:\Geld verdienen\Office\Auft ragsbearbeitung\Fakturama2\Database\Database]:user[sa] ... OK INFO [WatchDog_0] - -----------------------** Summary of Phases execution **--- ------------------ INFO [WatchDog_0] - Phase# Finished Status RunTime(sec) M emoryAllocation(KB) INFO [WatchDog_0] - 0 ERROR 0 17800 INFO [WatchDog_0] - 1 N/A 0 0 INFO [WatchDog_0] - 2 N/A 0 0 INFO [WatchDog_0] - 3 N/A 0 0 INFO [WatchDog_0] - 4 N/A 0 0 INFO [WatchDog_0] - 5 N/A 0 0 INFO [WatchDog_0] - 6 N/A 0 0 INFO [WatchDog_0] - 7 N/A 0 0 INFO [WatchDog_0] - 8 N/A 0 0 INFO [WatchDog_0] - 9 N/A 0 0 INFO [WatchDog_0] - ------------------------------** End of Summary **--------- ------------------ INFO [WatchDog_0] - WatchDog thread finished - total execution time: 0 (sec) DEBUG [WatchDog_0] - unregister MBean with name: org.jetel.graph.runtime:type=CL OVERJMX_1516149394050_0 INFO [main] - Freeing graph resources. ERROR [main] - --------------------------------------------- Error details -------------------- -------------------------- Component [DBExecute:DB_EXECUTE0] finished with status ERROR. Error on rename of './fakturama_server/FKT_ADDRESS' to './fakturama_server/#s ql2-3a0c-2c4' (errno: 152) -------------------------------------------------------------------------------- -------------------------- ERROR [main] - Execution of graph failed ! D:\TEMP\HSQL2MYSQL4FAK>