Benachrichtigungen

Alles entfernen

Fehler bei Migration von HSQL zu MariaDB unter Fakturama 2.1.3c

Seite 2 / 2 Zurück

Hilfe bei Installation und Bedienung

Letzter Beitrag von Polli vor 2 Wochen

18 Beiträge

3 Benutzer

0 Likes

183 Aufrufe

RSS

Polli

(@polli)

Active Member

Beigetreten: vor 1 Jahr

Beiträge: 10

Topic starter 20. April 2024 21:54

Ich konnte bisher mit keiner Methode eine erfolgreiche Migration durchführen. Es kommt immer wieder besagter Fehler. Bin da leider etwas hilflos. Aber vielleicht gibt es ja bald eine Lösung die funktioniert.

AntwortZitat

rheydenr

(@rheydenr)

Forum-Admin Registered

Beigetreten: vor 11 Jahren

Beiträge: 4314

20. April 2024 22:50

Moin, ich hab's jetzt endlich nochmal testen können. Also, folgendes Vorgehen:

auf der DOS-Kommandozeile in das Verzeichnis wechseln, wo Du das Migrationstool hin installiert hast
sicherstellen, daß irgendwo Java 8 installiert ist
dort checken, ob Java 8 aktiv ist --> "java -version" als Kommando absetzen
Falls hier nichts mit "Java 8" kommt, muß der Pfad angepaßt werden:
set PATH="c:\Program Files\Java\jdk1.8\bin";%PATH%
JAVA_HOME auf die alte Java8-Version setzen:
set JAVA_HOME=c:\Program Files\Java\jdk1.8
die Database-URL lautet bei mir:dbURL="jdbc:hsqldb:/temp/tmpfakt/daten-1/Database/Database"
==> man muß natürlich auch auf demselben Laufwerk unterwegs sein wo auch die Datenbank liegt (ich finde gerade nicht die Syntax, wie man auch den Laufwerksbuchstaben angeben kann, mit dem Pipe-Symbol geht das irgendwie nicht)
ich mußte in der cleanup_targetdb.sql noch die ersten paar Zeilen löschen (die fangen alle mit "ALTER..." an). Das müßtest Du allerdings erst mal ausprobieren, ggf. ist dieser Schritt auch überflüssig.
dann wie in der Anleitung beschrieben "bin\clover migration.grf" losschicken

Die letzten paar Zeilen sehen dann ungefähr so aus:

INFO [WatchDog_0] - WatchDog thread finished - total execution time: 0 (sec)
DEBUG [WatchDog_0] - unregister MBean with name: org.jetel.graph.runtime:type=CLOVERJMX_1516149394050_0
INFO [main] - Freeing graph resources.
INFO [main] - Execution of graph successful !

Kannst Du das mal ausprobieren?

Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?

AntwortZitat

Polli

(@polli)

Active Member

Beigetreten: vor 1 Jahr

Beiträge: 10

Topic starter 21. April 2024 08:36

Moin

@rheydnr Ich hatte nun einen Teilerfolg. Ich habe mit MySQL5 zunächst keine Verbindung aufbauen können. Dies habe ich nun lösen können. Unter MySQL5 hat die Migration nun zum Teil auch funktioniert. Es wurden leider nicht alle Daten übernommen. Einzig meine Produkte und Adressen wurden migriert. Wobei nur die Produkte angezeigt werden. Die Adressen werden nicht angezeigt obwohl sie in der Datenbank vorhanden sind. Alle anderen Daten sind nicht übernommen worden. Fehlermeldungen sehe ich eigentlich keine im Log. Habe ich vielleicht irgendetwas übersehen?

Hier das Log

Spoiler

Migration Log

C:\h2m>bin\clover migration.grf

CLOVER_HOME=C:\h2m\bin\.\..

CLOVER_CMD_LINE_ARGS=migration.grf

JAVA_CMD_LINE_ARGS=

USER_CLASSPATH=

"java.exe" -classpath ";;C:\h2m\bin\;;;C:\h2m\bin\.\../lib/annotations.jar;C:\h2m\bin\.\../lib/aws-java-sdk-core-1.11.75.jar;C:\h2m\bin\.\../lib/aws-java-sdk-kms-1.11.75.jar;C:\h2m\bin\.\../lib/aws-java-sdk-LICENSE.txt;C:\h2m\bin\.\../lib/aws-java-sdk-s3-1.11.75.jar;C:\h2m\bin\.\../lib/cloveretl.engine.jar;C:\h2m\bin\.\../lib/commons-cli-1.2.jar;C:\h2m\bin\.\../lib/commons-codec-1.10.jar;C:\h2m\bin\.\../lib/commons-collections-3.2.2.jar;C:\h2m\bin\.\../lib/commons-collections4-4.1.jar;C:\h2m\bin\.\../lib/commons-compress-1.7.jar;C:\h2m\bin\.\../lib/commons-configuration-1.10.jar;C:\h2m\bin\.\../lib/commons-io-2.2.jar;C:\h2m\bin\.\../lib/commons-lang-2.6.jar;C:\h2m\bin\.\../lib/commons-lang3-3.4.jar;C:\h2m\bin\.\../lib/commons-LICENSE.txt;C:\h2m\bin\.\../lib/commons-logging-1.2.jar;C:\h2m\bin\.\../lib/commons-net-3.3.jar;C:\h2m\bin\.\../lib/commons-pool-1.6.jar;C:\h2m\bin\.\../lib/dom4j-1.6.1.jar;C:\h2m\bin\.\../lib/ftp4j-1.7.2.jar;C:\h2m\bin\.\../lib/ftp4j-LICENSE.txt;C:\h2m\bin\.\../lib/httpclient-4.5.2.jar;C:\h2m\bin\.\../lib/httpclient-LICENSE.txt;C:\h2m\bin\.\../lib/httpcore-4.4.4.jar;C:\h2m\bin\.\../lib/httpcore-LICENSE.txt;C:\h2m\bin\.\../lib/httpmime-4.5.2.jar;C:\h2m\bin\.\../lib/httpmime-LICENSE.txt;C:\h2m\bin\.\../lib/icu4j-52_1.jar;C:\h2m\bin\.\../lib/icu4j-LICENSE.html;C:\h2m\bin\.\../lib/icu4j-unicode-LICENSE.txt;C:\h2m\bin\.\../lib/jackson-annotations-2.5.3.jar;C:\h2m\bin\.\../lib/jackson-core-2.5.3.jar;C:\h2m\bin\.\../lib/jackson-databind-2.5.3.jar;C:\h2m\bin\.\../lib/javolution.jar;C:\h2m\bin\.\../lib/jaxen-1.1.6.jar;C:\h2m\bin\.\../lib/jcifs-1.3.17.jar;C:\h2m\bin\.\../lib/jms.jar;C:\h2m\bin\.\../lib/joda-time-2.8.1.jar;C:\h2m\bin\.\../lib/jsch-0.1.54.jar;C:\h2m\bin\.\../lib/jxl.jar;C:\h2m\bin\.\../lib/log4j-1.2.17.jar;C:\h2m\bin\.\../lib/lz4-1.3.0.jar;C:\h2m\bin\.\../lib/poi-3.12-20150511.jar;C:\h2m\bin\.\../lib/poi-ooxml-3.12-20150511.jar;C:\h2m\bin\.\../lib/poi-ooxml-schemas-3.12-20150511.jar;C:\h2m\bin\.\../lib/sardine-5.0.2.jar;C:\h2m\bin\.\../lib/signpost-commonshttp4-1.2.1.2.jar;C:\h2m\bin\.\../lib/signpost-core-1.2.1.2.jar;C:\h2m\bin\.\../lib/slf4j-api-1.7.2.jar;C:\h2m\bin\.\../lib/slf4j-log4j12-1.7.2.jar;C:\h2m\bin\.\../lib/truezip-driver-file-7.7.5.jar;C:\h2m\bin\.\../lib/truezip-driver-zip-7.7.5.jar;C:\h2m\bin\.\../lib/truezip-file-7.7.5.jar;C:\h2m\bin\.\../lib/truezip-kernel-7.7.5.jar;C:\h2m\bin\.\../lib/truezip-path-7.7.5.jar;C:\h2m\bin\.\../lib/truezip-swing-7.7.5.jar;C:\h2m\bin\.\../lib/xmlbeans-2.5.0-modified-for-WSC.jar;C:\h2m\bin\.\../lib/XmlSchema-1.4.7-modified-for-WSC.jar;C:\h2m\bin\.\../lib/XmlSchema-LICENSE.txt" "-Dclover.home=C:\h2m\bin\.\.." org.jetel.main.runGraph -plugins "C:\h2m\bin\.\..\plugins" migration.grf

INFO [main] - Running with CloverETL version 4.7.0 build#010 compiled 10/10/2017 12:07:19

INFO [main] - Running on 12 CPU(s), OS Windows 11, architecture x86, max available memory for JVM 253.440 KB

INFO [main] - Running on Java(TM) SE Runtime Environment, 1.8.0_411, Oracle Corporation (JRE - runtime compilation is not available!)

INFO [main] - Loading default properties from: defaultProperties

DEBUG [main] - Plugin org.jetel.connection loaded.

id - org.jetel.connection

version - 4.7.0

provider-name - Javlin a.s.

connection { className = org.jetel.connection.jdbc.DBConnectionImpl; type = JDBC; }

connection { className = org.jetel.connection.jms.JmsConnection; type = JMS; }

DEBUG [main] - Plugin org.jetel.ctlfunction loaded.

id - org.jetel.ctlfunction

version - 4.7.0

provider-name - Javlin a.s.

ctlfunction { libraryName = math; className = org.jetel.ctl.extensions.MathLib; }

ctlfunction { libraryName = date; className = org.jetel.ctl.extensions.DateLib; }

ctlfunction { libraryName = string; className = org.jetel.ctl.extensions.StringLib; }

ctlfunction { libraryName = convert; className = org.jetel.ctl.extensions.ConvertLib; }

ctlfunction { libraryName = container; className = org.jetel.ctl.extensions.ContainerLib; }

ctlfunction { libraryName = random; className = org.jetel.ctl.extensions.RandomLib; }

ctlfunction { libraryName = util; className = org.jetel.ctl.extensions.UtilLib; }

ctlfunction { libraryName = dynamic; className = org.jetel.ctl.extensions.DynamicLib; }

ctlfunction { libraryName = string; className = org.jetel.ctl.extensions.StringLibExt; }

ctlfunction { libraryName = mapping; className = org.jetel.ctl.extensions.MappingLib; }

ctlfunction { libraryName = dynamic; className = org.jetel.ctl.extensions.DynamicLibExt; }

DEBUG [main] - Plugin org.jetel.engine loaded.

id - org.jetel.engine

version - 4.7.0

provider-name - Javlin a.s.

dictionaryType { className = org.jetel.graph.dictionary.StringDictionaryType; type = string; }

dictionaryType { className = org.jetel.graph.dictionary.ObjectDictionaryType; type = object; }

dictionaryType { className = org.jetel.graph.dictionary.ReadableChannelDictionaryType; type = readable.channel; }

dictionaryType { className = org.jetel.graph.dictionary.WritableChannelDictionaryType; type = writable.channel; }

dictionaryType { className = org.jetel.graph.dictionary.IntegerDictionaryType; type = integer; }

dictionaryType { className = org.jetel.graph.dictionary.LongDictionaryType; type = long; }

dictionaryType { className = org.jetel.graph.dictionary.DecimalDictionaryType; type = decimal; }

dictionaryType { className = org.jetel.graph.dictionary.NumberDictionaryType; type = number; }

dictionaryType { className = org.jetel.graph.dictionary.DateDictionaryType; type = date; }

dictionaryType { className = org.jetel.graph.dictionary.BooleanDictionaryType; type = boolean; }

dictionaryType { className = org.jetel.graph.dictionary.ByteDictionaryType; type = byte; }

dictionaryType { className = org.jetel.graph.dictionary.ListDictionaryType; type = list; }

dictionaryType { className = org.jetel.graph.dictionary.MapDictionaryType; type = map; }

tlCompiler { className = org.jetel.ctl.TLCompiler; type = simple.compiler; }

ctlfunction { libraryName = record; className = org.jetel.ctl.extensions.IntegralLib; }

urlResolver { className = org.jetel.util.file.SMBPathResolver; type = SMB; }

urlResolver { className = org.jetel.util.protocols.amazon.S3PathResolver; type = S3; }

authorityProxy { className = org.jetel.graph.runtime.PrimitiveAuthorityProxy; type = PrimitiveAuthorityProxy; priority = 0; }

DEBUG [main] - Plugin org.jetel.jdbc loaded.

id - org.jetel.jdbc

version - 4.8.0.

provider-name - Javlin a.s.

jdbcSpecific { database = GENERIC; name = Generic; class = org.jetel.connection.jdbc.specific.impl.DefaultJdbcSpecific; }

jdbcSpecific { database = HSQLDB; name = HSQLDB; class = org.jetel.connection.jdbc.specific.impl.DefaultJdbcSpecific; }

jdbcSpecific { database = REDSHIFT; name = Amazon Redshift; class = org.jetel.connection.jdbc.specific.impl.RedshiftSpecific; }

jdbcSpecific { database = DB2; name = DB2; class = org.jetel.connection.jdbc.specific.impl.DB2Specific; }

jdbcSpecific { database = DERBY; name = Derby; class = org.jetel.connection.jdbc.specific.impl.DerbySpecific; productName = Apache Derby; }

jdbcSpecific { database = EXASOLUTION; name = EXASolution; class = org.jetel.connection.jdbc.specific.impl.ExasolSpecific; }

jdbcSpecific { database = FIREBIRD; name = Firebird; class = org.jetel.connection.jdbc.specific.impl.FirebirdSpecific; }

jdbcSpecific { database = GENERICODBC; name = Generic ODBC; class = org.jetel.connection.jdbc.specific.impl.GenericODBCSpecific; }

jdbcSpecific { database = HIVE; name = Hive; class = org.jetel.connection.jdbc.specific.impl.HiveSpecific; }

jdbcSpecific { database = INFORMIX; name = Informix; class = org.jetel.connection.jdbc.specific.impl.InformixSpecific; }

jdbcSpecific { database = MSACCESS; name = Microsoft Access ODBC; class = org.jetel.connection.jdbc.specific.impl.MSAccessSpecific; }

jdbcSpecific { database = MSACCESSJAVA; name = Microsoft Access; class = org.jetel.connection.jdbc.specific.impl.MSAccessPureJavaSpecific; }

jdbcSpecific { database = MSSQL; name = MS SQL Server 2008-2012; class = org.jetel.connection.jdbc.specific.impl.MSSQLSpecific; productName = Microsoft SQL Server; }

jdbcSpecific { database = MSSQL2005; name = MS SQL Server 2000-2005; class = org.jetel.connection.jdbc.specific.impl.MSSQLSpecific2005; }

jdbcSpecific { database = MYSQL; name = MySQL; class = org.jetel.connection.jdbc.specific.impl.MySQLSpecific; productName = MySQL; }

jdbcSpecific { database = ORACLE; name = Oracle; class = org.jetel.connection.jdbc.specific.impl.OracleSpecific; productName = Oracle; }

jdbcSpecific { database = PERVASIVE; name = Pervasive; class = org.jetel.connection.jdbc.specific.impl.PervasiveSpecific; }

jdbcSpecific { database = POSTGRE; name = PostgreSQL; class = org.jetel.connection.jdbc.specific.impl.PostgreSpecific; }

jdbcSpecific { database = SYBASE; name = Sybase; class = org.jetel.connection.jdbc.specific.impl.SybaseSpecific; }

jdbcSpecific { database = SQLITE; name = SQLite; class = org.jetel.connection.jdbc.specific.impl.SQLiteSpecific; }

jdbcSpecific { database = VERTICA; name = Vertica; class = org.jetel.connection.jdbc.specific.impl.VerticaSpecific; }

jdbcDriver { database = MYSQL; urlHint = jdbc:mysql://hostname:3306/database; jdbc.zeroDateTimeBehavior = convertToNull; name = MySQL; driverLibrary = lib/mysql/mysql-connector-java-5.1.26-bin.jar; jdbcSpecific = MYSQL; dbDriver = org.gjt.mm.mysql.Driver; }

jdbcDriver { database = HSQLDB; urlHint = jdbc:hsqldb:hsql://hostname:9001/database; jdbc.zeroDateTimeBehavior = convertToNull; name = HSQLDB; driverLibrary = lib/hsqldb/hsqldb.jar; jdbcSpecific = HSQLDB; dbDriver = org.hsqldb.jdbc.JDBCDriver; }

jdbcDriver { database = ORACLE; urlHint = jdbc:***@cluster-alias:1521/service_name,jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name))),jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cluster_alias)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name))),jdbc:oracle:thin:@host:1521/service_name; name = Oracle; driverLibrary = lib/oracle/ojdbc6.jar; jdbcSpecific = ORACLE; dbDriver = oracle.jdbc.OracleDriver; }

jdbcDriver { database = POSTGRE; urlHint = jdbc:postgresql://hostname/database; name = PostgreSQL; driverLibrary = lib/postgre/postgresql-9.3-1102.jdbc41.jar; jdbcSpecific = POSTGRE; dbDriver = org.postgresql.Driver; }

jdbcDriver { database = REDSHIFT; urlHint = jdbc:redshift://cluster_id.redshift.amazonaws.com:5439/database; name = Amazon Redshift; driverLibrary = lib/redshift/RedshiftJDBC41-1.1.17.1017.jar; jdbcSpecific = REDSHIFT; dbDriver = com.amazon.redshift.jdbc41.Driver; }

jdbcDriver { database = MSSQL; urlHint = jdbc:jtds:sqlserver://hostname:1433/database;instance=instanceName,jdbc:jtds:sqlserver://hostname:1433/database; name = Microsoft SQL Server; driverLibrary = lib/jtds/jtds-1.2.8.jar; jdbcSpecific = MSSQL; dbDriver = net.sourceforge.jtds.jdbc.Driver; }

jdbcDriver { database = GENERICODBC; urlHint = jdbc:odbc:dsn_source;; name = Generic ODBC; driverLibrary = sun.jdbc.odbc.JdbcOdbcDriver; jdbcSpecific = GENERICODBC; dbDriver = sun.jdbc.odbc.JdbcOdbcDriver; }

jdbcDriver { database = MSACCESS; urlHint = jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=database_file,jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=database_file,jdbc:odbc:odbc_source_name; name = Microsoft Access ODBC; driverLibrary = sun.jdbc.odbc.JdbcOdbcDriver; jdbcSpecific = MSACCESS; dbDriver = sun.jdbc.odbc.JdbcOdbcDriver; }

jdbcDriver { database = MSACCESSJAVA; urlHint = jdbc:ucanaccess://database_file,jdbc:ucanaccess://database_file;newdatabaseversion=V2010; name = Microsoft Access; driverLibrary = lib/msaccess/ucanaccess-4.0.2.jar;lib/msaccess/jackcess-2.1.6.jar;lib/msaccess/hsqldb.jar; jdbcSpecific = MSACCESSJAVA; dbDriver = net.ucanaccess.jdbc.UcanaccessDriver; }

jdbcDriver { database = SYBASE; urlHint = jdbc:jtds:sybase://hostname:7100/database; name = Sybase; driverLibrary = lib/jtds/jtds-1.2.8.jar; jdbcSpecific = SYBASE; dbDriver = net.sourceforge.jtds.jdbc.Driver; }

jdbcDriver { database = SQLITE; urlHint = jdbc:sqlite:C:/database; name = SQLite; driverLibrary = lib/sqlite/sqlite-jdbc-3.6.20.1.jar; jdbcSpecific = SQLITE; dbDriver = org.sqlite.JDBC; }

jdbcDriver { database = DERBY; urlHint = jdbc:derby://hostname:1527/derby.db; name = Derby; driverLibrary = lib/derby/derbyclient-10.11.1.1.jar; jdbcSpecific = DERBY; dbDriver = org.apache.derby.jdbc.ClientDriver; }

jdbcDriver { database = FIREBIRD; urlHint = jdbc:firebirdsql:localhost/3050:/firebird/test.gdb; name = Firebird; driverLibrary = lib/firebird/jaybird-full-2.2.1.jar; jdbcSpecific = FIREBIRD; dbDriver = org.firebirdsql.jdbc.FBDriver; }

jdbcDriver { database = VERTICA70; urlHint = jdbc:vertica://hostname:5433/database; name = Vertica 7.0; driverLibrary = lib/vertica/vertica-jdbc-7.0.2-1.jar; jdbcSpecific = VERTICA; dbDriver = com.vertica.jdbc.Driver; }

jdbcDriver { database = VERTICA71; urlHint = jdbc:vertica://hostname:5433/database; name = Vertica 7.1; driverLibrary = lib/vertica/vertica-jdbc-7.1.1-0.jar; jdbcSpecific = VERTICA; dbDriver = com.vertica.jdbc.Driver; }

DEBUG [main] - Plugin org.jetel.lookup loaded.

id - org.jetel.lookup

version - 4.7.0

provider-name - Javlin a.s.

lookup { className = org.jetel.lookup.SimpleLookupTable; type = simpleLookup; }

lookup { className = org.jetel.lookup.DBLookupTable; type = dbLookup; }

lookup { className = org.jetel.lookup.RangeLookupTable; type = rangeLookup; }

DEBUG [main] - Plugin org.jetel.sequence loaded.

id - org.jetel.sequence

version - 4.7.0

provider-name - Javlin a.s.

sequence { className = org.jetel.sequence.SimpleSequence; type = SIMPLE_SEQUENCE; }

sequence { className = org.jetel.sequence.PrimitiveSequence; type = PRIMITIVE_SEQUENCE; }

DEBUG [main] - Plugin org.jetel.component loaded.

id - org.jetel.component

version - 4.7.0

provider-name - Javlin a.s.

component { className = org.jetel.component.DataReader; name = UniversalDataReader; type = DATA_READER; }

component { className = org.jetel.component.DataWriter; name = UniversalDataWriter; type = DATA_WRITER; }

component { className = org.jetel.component.DataReader; name = FlatFileReader; type = FLAT_FILE_READER; }

component { className = org.jetel.component.DataWriter; name = FlatFileWriter; type = FLAT_FILE_WRITER; }

component { className = org.jetel.component.DelimitedDataReader; name = DelimitedDataReader; type = DELIMITED_DATA_READER; }

component { className = org.jetel.component.DelimitedDataWriter; name = DelimitedDataWriter; type = DELIMITED_DATA_WRITER; }

component { className = org.jetel.component.SimpleCopy; name = SimpleCopy; type = SIMPLE_COPY; }

component { className = org.jetel.component.Concatenate; name = Concatenate; type = CONCATENATE; }

component { className = org.jetel.component.SimpleGather; name = SimpleGather; type = SIMPLE_GATHER; }

component { className = org.jetel.component.Reformat; name = Reformat; type = REFORMAT; }

component { className = org.jetel.component.DBInputTable; name = DBInputTable; type = DB_INPUT_TABLE; }

component { className = org.jetel.component.Sort; name = Sort; type = SORT; }

component { className = org.jetel.component.DBOutputTable; name = DBOutputTable; type = DB_OUTPUT_TABLE; }

component { className = org.jetel.component.FixLenDataWriter; name = FixLenDataWriter; type = FIXLEN_DATA_WRITER; }

component { className = org.jetel.component.Dedup; name = Dedup; type = DEDUP; }

component { className = org.jetel.component.FixLenDataReader; name = FixLenDataReader; type = FIXLEN_DATA_READER; }

component { className = org.jetel.component.Merge; name = Merge; type = MERGE; }

component { className = org.jetel.component.CrossJoin; name = CrossJoin; type = CROSS_JOIN; }

component { className = org.jetel.component.MergeJoin; name = MergeJoin; type = MERGE_JOIN; }

component { className = org.jetel.component.MergeJoin; name = ExtMergeJoin; type = EXT_MERGE_JOIN; }

component { className = org.jetel.component.MergeJoin; type = SORTED_JOIN; }

component { className = org.jetel.component.Trash; name = Trash; type = TRASH; }

component { className = org.jetel.component.Trashifier; type = TRASHIFIER; }

component { className = org.jetel.component.DBExecute; name = DBExecute; type = DB_EXECUTE; }

component { className = org.jetel.component.HashJoin; name = HashJoin; type = HASH_JOIN; }

component { className = org.jetel.component.HashJoin; name = ExtHashJoin; type = EXT_HASH_JOIN; }

component { className = org.jetel.component.CheckForeignKey; name = CheckForeignKey; type = CHECK_FOREIGN_KEY; }

component { className = org.jetel.component.DBFDataReader; name = DBFDataReader; type = DBF_DATA_READER; }

component { className = org.jetel.component.DBFDataWriter; name = DBFDataWriter; type = DBF_DATA_WRITER; }

component { className = org.jetel.component.ExtFilter; name = Filter; type = EXT_FILTER; }

component { className = org.jetel.component.ExtSort; name = ExtSort; type = EXT_SORT; }

component { className = org.jetel.component.SortWithinGroups; name = SortWithinGroups; type = SORT_WITHIN_GROUPS; }

component { className = org.jetel.component.Partition; name = Partition; type = PARTITION; }

component { className = org.jetel.component.DataIntersection; name = DataIntersection; type = DATA_INTERSECTION; }

component { className = org.jetel.component.Aggregate; name = Aggregate; type = AGGREGATE; }

component { className = org.jetel.component.SystemExecute; name = SystemExecute; type = SYS_EXECUTE; }

component { className = org.jetel.component.RunGraph; name = RunGraph; type = RUN_GRAPH; }

component { className = org.jetel.component.HttpConnector; name = HTTPConnector; type = HTTP_CONNECTOR; }

component { className = org.jetel.component.KeyGenerator; name = KeyGenerator; type = KEY_GEN; }

component { className = org.jetel.component.AproxMergeJoin; name = ApproximativeJoin; type = APROX_MERGE_JOIN; }

component { className = org.jetel.component.DBJoin; name = DBJoin; type = DBJOIN; }

component { className = org.jetel.component.XLSReader; name = XLSDataReader; type = XLS_READER; }

component { className = org.jetel.component.XLSWriter; name = XLSDataWriter; type = XLS_WRITER; }

component { className = org.jetel.component.CloverDataWriter; name = CloverDataWriter; type = CLOVER_WRITER; }

component { className = org.jetel.component.CloverDataReader; name = CloverDataReader; type = CLOVER_READER; }

component { className = org.jetel.component.StructureWriter; name = StructuredDataWriter; type = STRUCTURE_WRITER; }

component { className = org.jetel.component.Normalizer; name = Normalizer; type = NORMALIZER; }

component { className = org.jetel.component.Denormalizer; name = Denormalizer; type = DENORMALIZER; }

component { className = org.jetel.component.Rollup; name = Rollup; type = ROLLUP; }

component { className = org.jetel.component.JmsReader; name = JMSReader; type = JMS_READER; }

component { className = org.jetel.component.JmsWriter; name = JMSWriter; type = JMS_WRITER; }

component { className = org.jetel.component.LookupJoin; name = LookupJoin; type = LOOKUP_JOIN; }

component { className = org.jetel.component.LookupTableReaderWriter; name = LookupTableReaderWriter; type = LOOKUP_TABLE_READER_WRITER; }

component { className = org.jetel.component.DataGenerator; name = DataGenerator; type = DATA_GENERATOR; }

component { className = org.jetel.component.SequenceChecker; name = SequenceChecker; type = SEQUENCE_CHECKER; }

component { className = org.jetel.component.TextTableWriter; type = TEXT_TABLE_WRITER; }

component { className = org.jetel.component.XmlXPathReader; name = XMLXPathReader; type = XML_XPATH_READER; }

component { className = org.jetel.component.XMLExtract; name = XMLExtract; type = XML_EXTRACT; }

component { className = org.jetel.component.JsonExtract; name = JSONExtract; type = JSON_EXTRACT; }

component { className = org.jetel.component.XmlReader; name = XMLReader; 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; name = CustomJavaReader; type = GENERIC_READER; }

component { className = org.jetel.component.GenericComponent; name = CustomJavaWriter; type = GENERIC_WRITER; }

component { className = org.jetel.component.GenericComponent; name = CustomJavaTransformer; type = GENERIC_TRANSFORMER; }

component { className = org.jetel.component.GenericComponent; name = CustomJavaComponent; type = GENERIC_COMPONENT; }

component { className = org.jetel.component.XmlWriter; name = XMLWriter (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; name = 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; name = MSSQLDataWriter; type = MS_SQL_DATA_WRITER; }

component { className = org.jetel.component.MysqlDataWriter; name = 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.HadoopConnection; 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.HadoopPathResolver; 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.SMB2PathResolver; 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; name = 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 = Filter; 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.JdbcDriverImpl@269709]:jndi[null]:url[jdbc:mysql://localhost:3308/fakturama]:user[fakturama] ... OK

INFO [main] - Initializing connection:

INFO [main] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@ceadd4]:jndi[null]:url[jdbc:hsqldb:file:D:\Documents\Firma\Fakturama\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_1516149394050_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, validateRequiredParameters=false, password=null, skipCheckConfig=false, debugDirectory=C:\Users\otief\AppData\Local\Temp\, parentRunId=null, logLevel=null, compileClassPath=[], edgeDebugging=true, synchronizedRun=false, clusterNodeId=null, contextURL=null, runId=0, trackingInterval=5000, calculateNoMetadata=false, waitForJMXClient=false, additionProperties={}, jobUrl=file:migration.grf, classLoaderCaching=false, runtimeClassPath=[], batchMode=true, parentGraphInputPortsConnected=null, jobType=ETL_GRAPH, useJMX=true, verboseMode=false, dictionaryContent={ }, strictGraphFactorization=true, deamon=false, executionType=null, transactionMode=false, parentGraphOutputPortsConnected=null, executionLabel=null, executionGroup=null}

INFO [WatchDog_0] - Pre-execute initialization of connection:

INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@269709]:jndi[null]:url[jdbc:mysql://localhost:3308/fakturama]:user[fakturama] ... OK

INFO [WatchDog_0] - Pre-execute initialization of connection:

INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@ceadd4]:jndi[null]:url[jdbc:hsqldb:file:D:\Documents\Firma\Fakturama\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 C:\h2m\cleanup_targetdb.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: 21/04/24 09:11:06

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!

INFO [CATEGORY_0] - checkpointClose start

INFO [CATEGORY_0] - checkpointClose synched

INFO [CATEGORY_0] - checkpointClose script done

INFO [CATEGORY_0] - checkpointClose end

DEBUG [CATEGORY_0] - CATEGORY: Sending query "select * from FKT_CATEGORY"

DEBUG [CATEGORY_0] - CATEGORY: Query execution time: 00:00:00.000

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] - ----------------------** Final tracking Log for phase [1] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - Category CATEGORY FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 0 0 0 0

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 0 0 0 0

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [1] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [2]

DEBUG [WatchDog_0] - DBOUTPUT_TABLE2 ... starting

DEBUG [WatchDog_0] - VAT ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [VAT_0] - VAT: Sending query "select * from FKT_VAT"

DEBUG [VAT_0] - VAT: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 2 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - DBOUTPUT_TABLE2 ...OK

DEBUG [WatchDog_0] - VAT ...OK

DEBUG [WatchDog_0] - Phase 2 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [2] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - VAT VAT FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 2 0 125 15

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE2 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 2 0 125 15

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [2] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [3]

DEBUG [WatchDog_0] - DBOUTPUT_TABLE1 ... starting

DEBUG [WatchDog_0] - PRODUCT ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [PRODUCT_0] - PRODUCT: Sending query "select * from FKT_PRODUCT"

DEBUG [PRODUCT_0] - PRODUCT: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 3 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - DBOUTPUT_TABLE1 ...OK

DEBUG [WatchDog_0] - PRODUCT ...OK

DEBUG [WatchDog_0] - Phase 3 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [3] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - Product PRODUCT FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 149 35 2365 563

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE1 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 149 35 2365 563

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [3] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [4]

DEBUG [WatchDog_0] - DBOUTPUT_TABLE3 ... starting

DEBUG [WatchDog_0] - ITEMACCOUNTTYPE ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [ITEMACCOUNTTYPE_0] - ITEMACCOUNTTYPE: Sending query "select * from FKT_ITEMACCOUNTTYPE"

DEBUG [ITEMACCOUNTTYPE_0] - ITEMACCOUNTTYPE: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 4 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - DBOUTPUT_TABLE3 ...OK

DEBUG [WatchDog_0] - ITEMACCOUNTTYPE ...OK

DEBUG [WatchDog_0] - Phase 4 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [4] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - ITEMACCOUNTTYPE ITEMACCOUNTTYPE FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 0 0 0 0

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE3 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 0 0 0 0

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [4] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [5]

DEBUG [WatchDog_0] - DBOUTPUT_TABLE12 ... starting

DEBUG [WatchDog_0] - PRODUCTBLOCKPRICE ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [PRODUCTBLOCKPRICE_0] - PRODUCTBLOCKPRICE: Sending query "select * from FKT_PRODUCTBLOCKPRICE"

DEBUG [PRODUCTBLOCKPRICE_0] - PRODUCTBLOCKPRICE: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 5 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - DBOUTPUT_TABLE12 ...OK

DEBUG [WatchDog_0] - PRODUCTBLOCKPRICE ...OK

DEBUG [WatchDog_0] - Phase 5 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [5] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - productblockprice PRODUCTBLOCKPRICE FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 0 0 0 0

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE12 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 0 0 0 0

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [5] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [6]

DEBUG [WatchDog_0] - ADDRESS ... starting

DEBUG [WatchDog_0] - DBOUTPUT_TABLE11 ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [ADDRESS_0] - ADDRESS: Sending query "select * from FKT_ADDRESS"

DEBUG [ADDRESS_0] - ADDRESS: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 6 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - ADDRESS ...OK

DEBUG [WatchDog_0] - DBOUTPUT_TABLE11 ...OK

DEBUG [WatchDog_0] - Phase 6 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [6] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - Address ADDRESS FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 18 2 1200 192

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE11 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 18 2 1200 192

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [6] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [7]

DEBUG [WatchDog_0] - BANKACCOUNT ... starting

DEBUG [WatchDog_0] - DBOUTPUT_TABLE10 ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [BANKACCOUNT_0] - BANKACCOUNT: Sending query "select * from FKT_BANKACCOUNT"

DEBUG [BANKACCOUNT_0] - BANKACCOUNT: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 7 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - BANKACCOUNT ...OK

DEBUG [WatchDog_0] - DBOUTPUT_TABLE10 ...OK

DEBUG [WatchDog_0] - Phase 7 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [7] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - Bankaccount BANKACCOUNT FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 0 0 0 0

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE10 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 0 0 0 0

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [7] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [8]

DEBUG [WatchDog_0] - CEFACTCODE ... starting

DEBUG [WatchDog_0] - DBOUTPUT_TABLE4 ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [CEFACTCODE_0] - CEFACTCODE: Sending query "select * from FKT_CEFACTCODE"

DEBUG [CEFACTCODE_0] - CEFACTCODE: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 8 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - CEFACTCODE ...OK

DEBUG [WatchDog_0] - DBOUTPUT_TABLE4 ...OK

DEBUG [WatchDog_0] - Phase 8 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [8] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - CEFACTCODE CEFACTCODE FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 0 0 0 0

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE4 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 0 0 0 0

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [8] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Starting up all nodes in phase [9]

DEBUG [WatchDog_0] - DBOUTPUT_TABLE5 ... starting

DEBUG [WatchDog_0] - PAYMENT ... starting

DEBUG [WatchDog_0] - All components are ready to start.

INFO [WatchDog_0] - Successfully started all nodes in phase!

DEBUG [PAYMENT_0] - PAYMENT: Sending query "select * from FKT_PAYMENT"

DEBUG [PAYMENT_0] - PAYMENT: Query execution time: 00:00:00.000

DEBUG [WatchDog_0] - Phase 9 post-execution

DEBUG [WatchDog_0] - Edges post-execution

DEBUG [WatchDog_0] - Edges post-execution success.

DEBUG [WatchDog_0] - Components post-execution

DEBUG [WatchDog_0] - DBOUTPUT_TABLE5 ...OK

DEBUG [WatchDog_0] - PAYMENT ...OK

DEBUG [WatchDog_0] - Phase 9 post-execution succeeded.

INFO [WatchDog_0] - ----------------------** Final tracking Log for phase [9] **---------------------

INFO [WatchDog_0] - Time: 21/04/24 09:11:07

INFO [WatchDog_0] - Node ID Port #Records #KB aRec/s aKB/s

INFO [WatchDog_0] - ---------------------------------------------------------------------------------

INFO [WatchDog_0] - PAYMENT PAYMENT FINISHED_OK

INFO [WatchDog_0] - %cpu:0 Out:0 2 0 125 35

INFO [WatchDog_0] - DBOutputTable DBOUTPUT_TABLE5 FINISHED_OK

INFO [WatchDog_0] - %cpu:0 In:0 2 0 125 35

INFO [WatchDog_0] - ---------------------------------** End of Log **--------------------------------

INFO [WatchDog_0] - Execution of phase [9] successfully finished - elapsed time(sec): 0

INFO [WatchDog_0] - Post-execute finalization of connection:

INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@269709]:jndi[null]:url[jdbc:mysql://localhost:3308/fakturama]:user[fakturama] ... OK

INFO [WatchDog_0] - Post-execute finalization of connection:

INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@ceadd4]:jndi[null]:url[jdbc:hsqldb:file:D:\Documents\Firma\Fakturama\Database\Database]:user[sa] ... OK

INFO [WatchDog_0] - -----------------------** Summary of Phases execution **---------------------

INFO [WatchDog_0] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)

INFO [WatchDog_0] - 0 FINISHED_OK 0 16986

INFO [WatchDog_0] - 1 FINISHED_OK 0 18253

INFO [WatchDog_0] - 2 FINISHED_OK 0 18860

INFO [WatchDog_0] - 3 FINISHED_OK 0 20515

INFO [WatchDog_0] - 4 FINISHED_OK 0 20935

INFO [WatchDog_0] - 5 FINISHED_OK 0 21355

INFO [WatchDog_0] - 6 FINISHED_OK 0 21936

INFO [WatchDog_0] - 7 FINISHED_OK 0 22355

INFO [WatchDog_0] - 8 FINISHED_OK 0 22775

INFO [WatchDog_0] - 9 FINISHED_OK 0 23492

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=CLOVERJMX_1516149394050_0

INFO [main] - Freeing graph resources.

INFO [main] - Execution of graph successful !

C:\h2m>

Danke für eure Hilfe

Diese r Beitrag wurde geändert vor 1 Woche von Polli

AntwortZitat

Seite 2 / 2 Zurück

10 Foren
3,371 Themen
20.1 K Beiträge
2 Online
2,445 Mitglieder

Forum-Icons: Forum enthält keine ungelesenen Beiträge Forum enthält ungelesene Beiträge

Themen-Icons: Nicht beantwortet Beantwortet Aktiv Vieldiskutiert Angepinnt Nicht freigegeben Gelöst Privat Geschlossen