Skip to content

[HDBDD] Table Type Double Processing Error #389

New issue
New issue
Open
Open
[HDBDD] Table Type Double Processing Error#389
Labels
bugSomething isn't workingcoredatabaseparsers
Milestone
2.0.0
@ThuF

Description

@ThuF
ThuF
opened on Jul 4, 2023

The following exception is being thrown, while processing for second time *.hdbdd file with table types:

c.c.k.h.d.f.HDBCoreSynchronizationFacade - SAP DBTech JDBC: [330]: cannot use duplicate synonym name: com.codbex.hdbdd::Test.myTableType: line 1 col 25 (at pos 24)
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [330]: cannot use duplicate synonym name: com.codbex.hdbdd::Test.myTableType: line 1 col 25 (at pos 24)
	at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:209) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:42) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.packet.HReplyPacket._buildExceptionChain(HReplyPacket.java:841) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.packet.HReplyPacket.getSQLExceptionChain(HReplyPacket.java:195) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.packet.HPartInfo.getSQLExceptionChain(HPartInfo.java:39) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.ConnectionSapDB._receive(ConnectionSapDB.java:5644) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.ConnectionSapDB.exchange(ConnectionSapDB.java:2566) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.PreparedStatementSapDB._prepare(PreparedStatementSapDB.java:3682) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.PreparedStatementSapDB._doParse(PreparedStatementSapDB.java:3569) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.PreparedStatementSapDB.<init>(PreparedStatementSapDB.java:170) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.PreparedStatementSapDB9.<init>(Unknown Source) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.HanaPreparedStatement.<init>(Unknown Source) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.HanaPreparedStatementClean.<init>(Unknown Source) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.HanaPreparedStatementClean.newInstance(Unknown Source) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.ConnectionSapDB9._prepareStatement(Unknown Source) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:419) ~[ngdbc-2.15.12.jar:2.15.12-287903cafd3f3116b5e4bef7d287c2f70db4113c]
	at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:327) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) ~[HikariCP-5.0.1.jar:na]
	at com.codbex.kronos.hdb.ds.processors.AbstractHDBProcessor.executeSql(AbstractHDBProcessor.java:63) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.synonym.SynonymCreateProcessor.execute(SynonymCreateProcessor.java:81) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.synonym.SynonymCreateProcessor.execute(SynonymCreateProcessor.java:38) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBSynonymManagerService.createDataStructure(HDBSynonymManagerService.java:101) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBSynonymManagerService.createDataStructure(HDBSynonymManagerService.java:35) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.utils.HDBUtils.createPublicSynonymForArtifact(HDBUtils.java:137) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.tabletype.TableTypeCreateProcessor.execute(TableTypeCreateProcessor.java:127) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.tabletype.TableTypeCreateProcessor.execute(TableTypeCreateProcessor.java:44) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBStructureManagerService.createDataStructure(HDBStructureManagerService.java:141) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBStructureManagerService.createDataStructure(HDBStructureManagerService.java:36) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.facade.TopologyDataStructureModelWrapper.complete(TopologyDataStructureModelWrapper.java:134) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at org.eclipse.dirigible.commons.api.topology.TopologicalDepleter.deplete(TopologicalDepleter.java:41) ~[dirigible-commons-api-6.3.16.2.jar:na]
	at com.codbex.kronos.hdb.ds.facade.HDBCoreSynchronizationFacade.createArtefactsOnPhaseTwo(HDBCoreSynchronizationFacade.java:481) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.facade.HDBCoreSynchronizationFacade.updateEntities(HDBCoreSynchronizationFacade.java:228) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.synchronizer.DataStructuresSynchronizer.synchronize(DataStructuresSynchronizer.java:301) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at org.eclipse.dirigible.core.scheduler.synchronizer.OrderedSynchronizer.synchronize(OrderedSynchronizer.java:81) ~[dirigible-core-scheduler-6.3.16.2.jar:na]
	at org.eclipse.dirigible.core.scheduler.api.AbstractSynchronizerJob$1.run(AbstractSynchronizerJob.java:53) ~[dirigible-core-scheduler-6.3.16.2.jar:na]
	at org.eclipse.dirigible.commons.timeout.TimeLimited$1.call(TimeLimited.java:52) ~[dirigible-commons-timeout-6.3.16.2.jar:na]
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]
	at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]
2023-07-04 19:09:51.609 [ERROR] [pool-56558-thread-1] c.c.k.h.d.f.HDBCoreSynchronizationFacade - java.lang.NullPointerException
org.eclipse.dirigible.database.persistence.PersistenceException: java.lang.NullPointerException
	at org.eclipse.dirigible.database.persistence.processors.entity.PersistenceQueryProcessor.query(PersistenceQueryProcessor.java:315) ~[dirigible-database-persistence-6.3.16.2.jar:na]
	at org.eclipse.dirigible.database.persistence.PersistenceManager.query(PersistenceManager.java:309) ~[dirigible-database-persistence-6.3.16.2.jar:na]
	at org.eclipse.dirigible.core.problems.service.ProblemsCoreService.getProblem(ProblemsCoreService.java:216) ~[dirigible-core-problems-6.3.16.2.jar:na]
	at org.eclipse.dirigible.core.problems.service.ProblemsCoreService.save(ProblemsCoreService.java:112) ~[dirigible-core-problems-6.3.16.2.jar:na]
	at org.eclipse.dirigible.api.v3.problems.ProblemsFacade.save(ProblemsFacade.java:43) ~[dirigible-api-facade-log-6.3.16.2.jar:na]
	at com.codbex.kronos.utils.CommonsUtils.logProcessorErrors(CommonsUtils.java:193) ~[kronos-modules-engines-commons-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.synonym.SynonymCreateProcessor.execute(SynonymCreateProcessor.java:86) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.synonym.SynonymCreateProcessor.execute(SynonymCreateProcessor.java:38) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBSynonymManagerService.createDataStructure(HDBSynonymManagerService.java:101) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBSynonymManagerService.createDataStructure(HDBSynonymManagerService.java:35) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.utils.HDBUtils.createPublicSynonymForArtifact(HDBUtils.java:137) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.tabletype.TableTypeCreateProcessor.execute(TableTypeCreateProcessor.java:127) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.processors.tabletype.TableTypeCreateProcessor.execute(TableTypeCreateProcessor.java:44) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBStructureManagerService.createDataStructure(HDBStructureManagerService.java:141) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.service.manager.HDBStructureManagerService.createDataStructure(HDBStructureManagerService.java:36) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.facade.TopologyDataStructureModelWrapper.complete(TopologyDataStructureModelWrapper.java:134) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at org.eclipse.dirigible.commons.api.topology.TopologicalDepleter.deplete(TopologicalDepleter.java:41) ~[dirigible-commons-api-6.3.16.2.jar:na]
	at com.codbex.kronos.hdb.ds.facade.HDBCoreSynchronizationFacade.createArtefactsOnPhaseTwo(HDBCoreSynchronizationFacade.java:481) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.facade.HDBCoreSynchronizationFacade.updateEntities(HDBCoreSynchronizationFacade.java:228) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at com.codbex.kronos.hdb.ds.synchronizer.DataStructuresSynchronizer.synchronize(DataStructuresSynchronizer.java:301) ~[kronos-modules-engines-hdb-0.2.0-SNAPSHOT.jar:na]
	at org.eclipse.dirigible.core.scheduler.synchronizer.OrderedSynchronizer.synchronize(OrderedSynchronizer.java:81) ~[dirigible-core-scheduler-6.3.16.2.jar:na]
	at org.eclipse.dirigible.core.scheduler.api.AbstractSynchronizerJob$1.run(AbstractSynchronizerJob.java:53) ~[dirigible-core-scheduler-6.3.16.2.jar:na]
	at org.eclipse.dirigible.commons.timeout.TimeLimited$1.call(TimeLimited.java:52) ~[dirigible-commons-timeout-6.3.16.2.jar:na]
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]
	at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]
Caused by: java.lang.NullPointerException: null
	at org.eclipse.dirigible.database.persistence.processors.AbstractPersistenceProcessor.setValue(AbstractPersistenceProcessor.java:244) ~[dirigible-database-persistence-6.3.16.2.jar:na]
	at org.eclipse.dirigible.database.persistence.processors.entity.PersistenceQueryProcessor.query(PersistenceQueryProcessor.java:296) ~[dirigible-database-persistence-6.3.16.2.jar:na]
	... 26 common frames omitted

Note: The exception is thrown for table types, that are already created.

Related to:

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingcoredatabaseparsers

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions