Migration nach MySQ...
 
Benachrichtigungen
Alles entfernen

Migration nach MySQL/MariaDB: java.lang.NullPointerException bei DBOutputTable

1 Beiträge
1 Benutzer
0 Reactions
505 Aufrufe
(@schmitti)
Trusted Member
Beigetreten: vor 5 Jahren
Beiträge: 54
Topic starter   [#4137]

Johoo, liebe Gemeinde, 😀

zwischenzeitig habe ich einfach mal eine Testinstallation mit einer MariaDB gewagt und will nun meine bisherige lokale Datenbank nach MySQL/MariaDB konvertieren.

Nachdem ich herausgefunden habe, dass dies ausschließlich bis JAVA 8 geht, habe ich das aktuelle JRE8 (OpenJDK) installiert und meine Standard-Java-Umgebung in Arch Linux entsprechend umgestellt. Dennoch schmeißt mir das Tool immer denselben Fehler raus. Vielleicht besteht ein Fehler in Hinblick auf die Verbindung zur Datenbank?

Jedenfalls habe ich vorher – wie beschrieben – entsprechende Anpassungen in den .grf-Dateien vorgenommen. Aber nichts geht. Folgende Debugging-Infos wirft die Konsole aus:

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 7.290.880 KB
INFO  [main] - Running on OpenJDK Runtime Environment, 1.8.0_392, Oracle Corporation (JDK)
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...
WARN  [main] - Graph configuration is invalid.
ERROR [main] - Error during graph initialization !
 Graph configuration is invalid.
  Issue in component [DBOutputTable:DBOUTPUT_TABLE]
   Cannot connect to the DB: java.lang.NullPointerException
    Unexpected null value.
ERROR [main] - Error details:
Element [1516149394050:migration]-Graph configuration is invalid.
	at org.jetel.graph.runtime.EngineInitializer.checkConfig(EngineInitializer.java:282)
	at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:266)
	at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:250)
	at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:240)
	at org.jetel.main.runGraph.runGraph(runGraph.java:445)
	at org.jetel.main.runGraph.main(runGraph.java:413)
Caused by: org.jetel.exception.ConfigurationException: Issue in component [DBOutputTable:DBOUTPUT_TABLE]
	at org.jetel.exception.ConfigurationProblem.toException(ConfigurationProblem.java:154)
	at org.jetel.exception.ConfigurationStatus.toException(ConfigurationStatus.java:183)
	... 6 more
Caused by: org.jetel.exception.JetelRuntimeException
	at org.jetel.exception.ConfigurationException.<init>(ConfigurationException.java:43)
	... 8 more
Caused by: org.jetel.exception.JetelRuntimeException: Cannot connect to the DB: java.lang.NullPointerException
	at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnectionImpl.java:903)
	at org.jetel.connection.jdbc.DBConnectionImpl.connect(DBConnectionImpl.java:926)
	at org.jetel.connection.jdbc.DBConnectionImpl.getConnection(DBConnectionImpl.java:362)
	at org.jetel.component.DBOutputTable.checkConfig(DBOutputTable.java:1255)
	at org.jetel.graph.Phase.checkConfig(Phase.java:339)
	at org.jetel.graph.TransformationGraph.checkConfig(TransformationGraph.java:1354)
	at org.jetel.graph.runtime.EngineInitializer.checkConfig(EngineInitializer.java:279)
	... 5 more
Caused by: java.sql.SQLException: java.lang.NullPointerException
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1074)
	at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3593)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2534)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	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.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
	at org.jetel.connection.jdbc.specific.impl.AbstractJdbcSpecific.connect(AbstractJdbcSpecific.java:111)
	at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnectionImpl.java:901)
	... 11 more
Caused by: java.lang.NullPointerException
	at java.util.TreeMap.put(TreeMap.java:563)
	at com.mysql.jdbc.Util.resultSetToMap(Util.java:508)
	at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1004)
	... 25 more

ERROR [main] - 
--------------------------------- Error details ----------------------------------
  Error during graph initialization !
   Graph configuration is invalid.
    Issue in component [DBOutputTable:DBOUTPUT_TABLE]
     Cannot connect to the DB: java.lang.NullPointerException
      Unexpected null value.
----------------------------------------------------------------------------------

Ist der Fehler vielleicht jemandem ein Begriff? Ich komme nicht weiter. 🙁

Danke und beste Grüße

Schmitti



   
Zitat
Teilen: