*bump*
Ich wollte mal freundlich nachfragen, ob mir hier geholfen werden kann?
Gruß
generell schon. Ich hab's aber noch nicht geschafft, mir das Script anzuschauen.
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
*bump*
Gibts schon was neues?
Ja. Ich bin dran, habe aber festgestellt, daß das Script ganz schön veraltet ist...
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Danke. Wenn ich irgendwie unterstützen kann, dann lass es mich bitte wissen.
Moin,
probier bitte mal das hier aus. Ich hab das bißchen aktualisiert, bei mir läuft's auch durch. Bitte Anleitung beachten (vor allem die Zugangsdaten in allen drei Skripten ändern).
EDIT: Link aktualisiert.
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Hi.
Danke erstmal.
Allerdings bekomme ich den folgenden Fehler, wenn ich auf deinen Link klicke:
The requested document was not found on this server.
Was mache ich falsch?
sorry. Hab den Link aktualisiert.
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Hi,
es hat leider nicht geklappt Ich bekomme folgende Meldung ; ich hoffe, du kannst mir hier nochmal helfen:
$ ./bin/clover migration.grf
INFO [main] - CloverETL, (c) 2002-2017 Javlin a.s.
INFO [main] - Running with CloverETL version 4.7.0 build#010 compiled 10/10/2017 12:07:19
INFO [main] - Running on 8 CPU(s), OS Linux, architecture amd64, max available memory for JVM 1.806.336 KB
INFO [main] - Running on Java(TM) SE Runtime Environment, 1.8.0_181, Oracle Corporation (JDK)
INFO [main] - Loading default properties from: defaultProperties
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.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.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.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; }
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 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.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.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.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 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; }
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@7a8c8dcf]:jndi[null]:url[jdbc:mysql:///[dbname]:user[] ... OK
INFO [main] - Initializing connection:
INFO [main] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@24269709]:jndi[null]:url[jdbc:hsqldb:hsql:]: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:
CONN_DIR=${PROJECT}/conn
DATAIN_DIR=${PROJECT}/data-in
DATAOUT_DIR=${PROJECT}/data-out
DATATMP_DIR=${PROJECT}/data-tmp
DATA_SERVICE_DIR=${PROJECT}/data-service
GRAPH_DIR=${PROJECT}/graph
LIB_DIR=${PROJECT}/lib
LOOKUP_DIR=${PROJECT}/lookup
META_DIR=${PROJECT}/meta
PROFILE_DIR=${PROJECT}/profile
PROJECT=.
SEQ_DIR=${PROJECT}/seq
SUBGRAPH_DIR=${GRAPH_DIR}/subgraph
TRANS_DIR=${PROJECT}/trans
INFO [WatchDog_0] - Runtime classpath: []
DEBUG [WatchDog_0] - Graph runtime context: {fastPropagateExecution=false, validateRequiredParameters=false, password=null, skipCheckConfig=false, debugDirectory=/tmp, 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@7a8c8dcf]:jndi[null]:url[jdbc:mysql:///[dbname]:user[] ... OK
INFO [WatchDog_0] - Pre-execute initialization of connection:
INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@24269709]:jndi[null]:url[jdbc:hsqldb:hsql:]: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 /home/franz/Dokumente/HSQL2MYSQL4FAK/cleanup_targetdb.sql
ERROR [DB_EXECUTE0_0] - Error when executing statement: ALTER TABLE `fkt_category` DROP FOREIGN KEY FK_FKT_CATEGORY_ABSTRACTCATEGORY_PARENT
ERROR [WatchDog_0] - Component [DBExecute:DB_EXECUTE0] finished with status ERROR.
Can't DROP 'FK_FKT_CATEGORY_ABSTRACTCATEGORY_PARENT'; check that column/key exists
ERROR [WatchDog_0] - Error details:
org.jetel.exception.JetelRuntimeException: Component [DBExecute:DB_EXECUTE0] finished 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(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'FK_FKT_CATEGORY_ABSTRACTCATEGORY_PARENT'; check that column/key exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
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(sec): 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.JdbcDriverImpl@7a8c8dcf]:jndi[null]:url[jdbc:mysql:///[dbname]:user[] ... OK
INFO [WatchDog_0] - Post-execute finalization of connection:
INFO [WatchDog_0] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriverImpl@24269709]:jndi[null]:url[jdbc:hsqldb:hsql:]:user[sa] ... OK
INFO [WatchDog_0] - -----------------------** Summary of Phases execution **---------------------
INFO [WatchDog_0] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)
INFO [WatchDog_0] - 0 ERROR 0 18497
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=CLOVERJMX_1516149394050_0
INFO [main] - Freeing graph resources.
ERROR [main] -
---------------------------------- Error details ------------------------------------
Component [DBExecute:DB_EXECUTE0] finished with status ERROR.
Can't DROP 'FK_FKT_CATEGORY_ABSTRACTCATEGORY_PARENT'; check that column/key exists
-------------------------------------------------------------------------------------
ERROR [main] - Execution of graph failed !
Moin, irgendwie ist das immer noch derselbe Fehler wie oben. Welche Version des Migrationstools setzt Du denn ein? Irgendwie scheint das nicht zu der Datenbank zu passen. Setzt Du die Version 2.0.5 von Fakturama ein?
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Hi Ralf,
Ich verwende die Version 2.1.0a - das ist die aktuelle. Soll ich hier eine andere Version verwenden?
Bei dem Migrationstool meinst du das HSQL2MYSQL? Wie finde ich da die Versionsnummer raus?
Leider funktioniert der Download oben von dir nicht mehr.
Gruß
Kannst Du es bitte nochmal mit dieser Version des Migrationstools versuchen?
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Leider nein, hilft nix, ich bekomme immer noch Meldungen, dass irgendwelche Tabellen fehlen :
INFO [WatchDog_0] - -----------------------** Summary of Phases execution **---------------------
INFO [WatchDog_0] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)
INFO [WatchDog_0] - 0 ERROR 0 19314
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=CLOVERJMX_1516149394050_0
INFO [main] - Freeing graph resources.
ERROR [main] -
--------------------------------- Error details ----------------------------------
Component [DBExecute:DB_EXECUTE0] finished with status ERROR.
Can't DROP 'FK_FKT_ADDRESS_CONTACT_ADDRESSES'; check that column/key exists
----------------------------------------------------------------------------------
ERROR [main] - Execution of graph failed !
Dann lösch einfach mal diese Zeile in dem SQL-Script (cleanup_targetdb.sql, das ist eine normale Textdatei). Ich weiß nicht, warum das bei manchen Installationen da ist und bei anderen wieder nicht.
Viele Grüße,
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Hallo,
Ich würde auch gerne migrieren. Leider bricht bei mir das Script auch ab.
Bitte um Eure Hilfe.
Danke!
Ausgabe des Scripts angehängt.