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
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] - ----------------------** Final tracking Log for phase [0] *
*---------------------
INFO  [WatchDog_0] - Time: 28/05/20 21:43:34
INFO  [WatchDog_0] - Node                   ID        Port       #Records
 #KB  aRec/s   aKB/s
INFO  [WatchDog_0] - -----------------------------------------------------------
----------------------
INFO  [WatchDog_0] - DBExecute              DB_EXECUTE0
         FINISHED_OK
INFO  [WatchDog_0] -  %cpu:0
INFO  [WatchDog_0] - ---------------------------------** End of Log **----------
----------------------
INFO  [WatchDog_0] - Execution of phase [0] successfully finished - elapsed time
(sec): 0
INFO  [WatchDog_0] - Starting up all nodes in phase [1]
DEBUG [WatchDog_0] - CATEGORY ... starting
DEBUG [WatchDog_0] - DBOUTPUT_TABLE ... starting
DEBUG [WatchDog_0] - All components are ready to start.
INFO  [WatchDog_0] - Successfully started all nodes in phase!
FATAL [CATEGORY_0] - could not reopen database
org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqld
b.persist.LockFile@505f857a[file =null, exists=false, locked=false, valid=false,
 ] method: setPath reason: java.io.IOException: Die Syntax f³r den Dateinamen, V
erzeichnisnamen oder die Datentrõgerbezeichnung ist falsch
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
        at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
        at org.hsqldb.persist.Logger.open(Unknown Source)
        at org.hsqldb.Database.reopen(Unknown Source)
        at org.hsqldb.Database.open(Unknown Source)
        at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
        at org.hsqldb.DatabaseManager.newSession(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at org.jetel.connection.jdbc.specific.impl.AbstractJdbcSpecific.connect(
AbstractJdbcSpecific.java:111)
        at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnect
ionImpl.java:901)
        at org.jetel.connection.jdbc.DBConnectionImpl.connect(DBConnectionImpl.j
ava:926)
        at org.jetel.connection.jdbc.DBConnectionImpl.getConnection(DBConnection
Impl.java:362)
        at org.jetel.component.DBInputTable.processSqlQuery(DBInputTable.java:35
4)
        at org.jetel.component.DBInputTable.execute(DBInputTable.java:305)
        at org.jetel.graph.Node.run(Node.java:568)
        at java.lang.Thread.run(Unknown Source)
ERROR [CATEGORY_0] - Error when executing statement: select * from FKT_CATEGORY
ERROR [WatchDog_0] - Component [Category:CATEGORY] finished with status ERROR. (
Out0: 0 recs)
 Cannot connect to the DB: Database lock acquisition failure: lockFile: org.hsql
db.persist.LockFile@505f857a[file =null, exists=false, locked=false, valid=false
, ] method: setPath reason: java.io.IOException: Die Syntax f³r den Dateinamen,
Verzeichnisnamen oder die Datentrõgerbezeichnung ist falsch
ERROR [WatchDog_0] - Error details:
org.jetel.exception.JetelRuntimeException: Component [Category:CATEGORY] finishe
d with status ERROR. (Out0: 0 recs)
        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: org.jetel.exception.JetelRuntimeException: Cannot connect to the DB:
Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@505f857
a[file =null, exists=false, locked=false, valid=false, ] method: setPath reason:
 java.io.IOException: Die Syntax f³r den Dateinamen, Verzeichnisnamen oder die D
atentrõgerbezeichnung ist falsch
        at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnect
ionImpl.java:903)
        at org.jetel.connection.jdbc.DBConnectionImpl.connect(DBConnectionImpl.j
ava:926)
        at org.jetel.connection.jdbc.DBConnectionImpl.getConnection(DBConnection
Impl.java:362)
        at org.jetel.component.DBInputTable.processSqlQuery(DBInputTable.java:35
4)
        at org.jetel.component.DBInputTable.execute(DBInputTable.java:305)
        at org.jetel.graph.Node.run(Node.java:568)
        ... 1 more
Caused by: java.sql.SQLException: Database lock acquisition failure: lockFile: o
rg.hsqldb.persist.LockFile@505f857a[file =null, exists=false, locked=false, vali
d=false, ] method: setPath reason: java.io.IOException: Die Syntax f³r den Datei
namen, Verzeichnisnamen oder die Datentrõgerbezeichnung ist falsch
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at org.jetel.connection.jdbc.specific.impl.AbstractJdbcSpecific.connect(
AbstractJdbcSpecific.java:111)
        at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnect
ionImpl.java:901)
        ... 6 more
Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile
: org.hsqldb.persist.LockFile@505f857a[file =null, exists=false, locked=false, v
alid=false, ] method: setPath reason: java.io.IOException: Die Syntax f³r den Da
teinamen, Verzeichnisnamen oder die Datentrõgerbezeichnung ist falsch
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
        at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
        at org.hsqldb.persist.Logger.open(Unknown Source)
        at org.hsqldb.Database.reopen(Unknown Source)
        at org.hsqldb.Database.open(Unknown Source)
        at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
        at org.hsqldb.DatabaseManager.newSession(Unknown Source)
        ... 11 more

DEBUG [WatchDog_0] - Phase 1 post-execution
DEBUG [WatchDog_0] - Edges post-execution
DEBUG [WatchDog_0] - Edges post-execution success.
DEBUG [WatchDog_0] - Components post-execution
DEBUG [WatchDog_0] -    CATEGORY ...OK
DEBUG [WatchDog_0] -    DBOUTPUT_TABLE ...OK
DEBUG [WatchDog_0] - Phase 1 post-execution succeeded.
INFO  [WatchDog_0] - Execution of phase [1] 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                 FINISHED_OK                        0
        17304
INFO  [WatchDog_0] - 1                 ERROR                              0
        22477
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 [Category:CATEGORY] finished with status ERROR. (Out0: 0 recs)
   Cannot connect to the DB: Database lock acquisition failure: lockFile: org.hs
qldb.persist.LockFile@505f857a[file =null, exists=false, locked=false, valid=fal
se, ] method: setPath reason: java.io.IOException: Die Syntax f³r den Dateinamen
, Verzeichnisnamen oder die Datentrõgerbezeichnung ist falsch
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------------------
ERROR [main] - Execution of graph failed !

D:\TEMP\HSQL2MYSQL4FAK>