You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have been trying to connect DT v4.6.x to MS-SQL server following documented instructions, but keep getting the same error. Does anyone have insights?
2022-12-13 15:59:11,649 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,651 INFO [Config] OS Name: Linux
2022-12-13 15:59:11,651 INFO [Config] OS Version: 4.18.0-305.65.1.el8_4.x86_64
2022-12-13 15:59:11,651 INFO [Config] OS Arch: amd64
2022-12-13 15:59:11,651 INFO [Config] CPU Cores: 2
2022-12-13 15:59:11,654 INFO [Config] Max Memory: 6.4 GB (6,873,415,680.0 bytes)
2022-12-13 15:59:11,654 INFO [Config] Java Vendor: Eclipse Adoptium
2022-12-13 15:59:11,655 INFO [Config] Java Version: 17.0.4.1+1
2022-12-13 15:59:11,655 INFO [Config] Java Home: /opt/java/openjdk
2022-12-13 15:59:11,655 INFO [Config] Java Temp: /tmp
2022-12-13 15:59:11,656 INFO [Config] User: dtrack
2022-12-13 15:59:11,656 INFO [Config] User Home: /data/
2022-12-13 15:59:11,656 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,656 INFO [Config] Initializing Configuration
2022-12-13 15:59:11,656 INFO [Config] System property alpine.application.properties not specified
2022-12-13 15:59:11,656 INFO [Config] Loading application.properties from classpath
2022-12-13 15:59:11,662 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,662 INFO [Config] Application: Dependency-Track
2022-12-13 15:59:11,662 INFO [Config] Version: 4.6.2
2022-12-13 15:59:11,662 INFO [Config] Built-on: 2022-10-24T10:49:26Z
2022-12-13 15:59:11,662 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,662 INFO [Config] Framework: Alpine
2022-12-13 15:59:11,662 INFO [Config] Version : 2.1.0
2022-12-13 15:59:11,662 INFO [Config] Built-on: 2022-10-09T07:15:51Z
2022-12-13 15:59:11,662 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,763 INFO [RequirementsVerifier] Initializing requirements verifier
2022-12-13 15:59:11,763 INFO [UpgradeInitializer] Initializing upgrade framework
2022-12-13 15:59:14,224 ERROR [Datastore] Error thrown executing ALTER TABLE COMPONENT ADD CONSTRAINT COMPONENT_PK PRIMARY KEY (ID) : The transaction ended in the trigger. The batch has been aborted.
com.microsoft.sqlserver.jdbc.SQLServerException: The transaction ended in the trigger. The batch has been aborted.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:775)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:799)
at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:749)
at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:497)
at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:544)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3497)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:3024)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:969)
at org.dependencytrack.upgrade.UpgradeInitializer.contextInitialized(UpgradeInitializer.java:66)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1048)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:624)
at org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:983)
at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:740)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:392)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:900)
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
at org.eclipse.jetty.server.Server.start(Server.java:470)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89)
at org.eclipse.jetty.server.Server.doStart(Server.java:415)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
at alpine.embedded.EmbeddedJettyServer.main(EmbeddedJettyServer.java:100)
2022-12-13 15:59:14,224 ERROR [Schema] An exception was thrown while adding/validating class(es) : The transaction ended in the trigger. The batch has been aborted.
com.microsoft.sqlserver.jdbc.SQLServerException: The transaction ended in the trigger. The batch has been aborted.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912)
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have been trying to connect DT v4.6.x to MS-SQL server following documented instructions, but keep getting the same error. Does anyone have insights?
"alpine_database_user" has dbo permisssion.
My config:
kubectl.kubernetes.io/last-applied-configuration: >
{"apiVersion":"v1","kind":"Pod","metadata":{"annotations":{"kompose.cmd":"kompose
convert","kompose.version":"1.26.1
(HEAD)"},"creationTimestamp":null,"labels":{"io.kompose.service":"dtrack-apiserver"},"name":"dtrack-apiserver","namespace":"zztp-vendor-dev-dependencytrack"},"spec":{"containers":[{"env":[{"name":"http_proxy","value":"http://inetgate.mycompany.com:9xxx"},{"name":"https_proxy","value":"http://inetgate.mycompany.com:9xxx"},{"name":"ALPINE_DATA_DIRECTORY","value":"/.dependency-track"},{"name":"ALPINE_CORS_ENABLED","value":"true"},{"name":"ALPINE_CORS_ALLOW_ORIGIN","value":"*"},{"name":"ALPINE_CORS_ALLOW_METHODS","value":"GET,
POST, PUT, DELETE,
OPTIONS"},{"name":"ALPINE_CORS_ALLOW_HEADERS","value":"Origin,
Content-Type, Authorization, X-Requested-With, Content-Length, Accept,
Origin, X-Api-Key, X-Total-Count,
*"},{"name":"ALPINE_CORS_EXPOSE_HEADERS","value":"Origin, Content-Type,
Authorization, X-Requested-With, Content-Length, Accept, Origin,
X-Api-Key,
X-Total-Count"},{"name":"ALPINE_DATABASE_MODE","value":"external"},{"name":"LOGGING_LEVEL","value":"TRACE"},{"name":"ALPINE_DATABASE_URL","value":"jdbc:sqlserver://HMBRSQLD24.company.com:1433;databaseName=dtrack;trustServerCertificate=true;sendStringParameterAsUnicode=false"},{"name":"ALPINE_DATABASE_DRIVER","value":"com.microsoft.sqlserver.jdbc.SQLServerDriver"},{"name":"ALPINE_DATABASE_USERNAME","value":"SQLDtrack"},{"name":"ALPINE_DATABASE_PASSWORD","value":"MXtty251"},{"name":"ALPINE_CORS_ALLOW_CREDENTIALS","value":"true"},{"name":"ALPINE_CORS_MAX_AGE","value":"3600"}],"image":"mycompany.jfrog.io/devops-vendor-docker/dependencytrack/dependency-track:1.0.0","name":"dtrack-apiserver","ports":[{"containerPort":8080}],"resources":{"limits":{"cpu":2,"memory":"8Gi"},"requests":{"cpu":"100m","memory":"128Mi"}},"volumeMounts":[{"mountPath":"~/.dependency-track","name":"dependency-track"}]}],"imagePullSecrets":[{"name":"zztp-pull-secret"}],"restartPolicy":"Always","volumes":[{"name":"dependency-track","persistentVolumeClaim":{"claimName":"dependency-track"}}]}}
openshift.io/scc: anyuid
Error
2022-12-13 15:59:11,649 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,651 INFO [Config] OS Name: Linux
2022-12-13 15:59:11,651 INFO [Config] OS Version: 4.18.0-305.65.1.el8_4.x86_64
2022-12-13 15:59:11,651 INFO [Config] OS Arch: amd64
2022-12-13 15:59:11,651 INFO [Config] CPU Cores: 2
2022-12-13 15:59:11,654 INFO [Config] Max Memory: 6.4 GB (6,873,415,680.0 bytes)
2022-12-13 15:59:11,654 INFO [Config] Java Vendor: Eclipse Adoptium
2022-12-13 15:59:11,655 INFO [Config] Java Version: 17.0.4.1+1
2022-12-13 15:59:11,655 INFO [Config] Java Home: /opt/java/openjdk
2022-12-13 15:59:11,655 INFO [Config] Java Temp: /tmp
2022-12-13 15:59:11,656 INFO [Config] User: dtrack
2022-12-13 15:59:11,656 INFO [Config] User Home: /data/
2022-12-13 15:59:11,656 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,656 INFO [Config] Initializing Configuration
2022-12-13 15:59:11,656 INFO [Config] System property alpine.application.properties not specified
2022-12-13 15:59:11,656 INFO [Config] Loading application.properties from classpath
2022-12-13 15:59:11,662 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,662 INFO [Config] Application: Dependency-Track
2022-12-13 15:59:11,662 INFO [Config] Version: 4.6.2
2022-12-13 15:59:11,662 INFO [Config] Built-on: 2022-10-24T10:49:26Z
2022-12-13 15:59:11,662 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,662 INFO [Config] Framework: Alpine
2022-12-13 15:59:11,662 INFO [Config] Version : 2.1.0
2022-12-13 15:59:11,662 INFO [Config] Built-on: 2022-10-09T07:15:51Z
2022-12-13 15:59:11,662 INFO [Config] --------------------------------------------------------------------------------
2022-12-13 15:59:11,763 INFO [RequirementsVerifier] Initializing requirements verifier
2022-12-13 15:59:11,763 INFO [UpgradeInitializer] Initializing upgrade framework
2022-12-13 15:59:14,224 ERROR [Datastore] Error thrown executing ALTER TABLE COMPONENT ADD CONSTRAINT COMPONENT_PK PRIMARY KEY (ID) : The transaction ended in the trigger. The batch has been aborted.
com.microsoft.sqlserver.jdbc.SQLServerException: The transaction ended in the trigger. The batch has been aborted.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:775)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:799)
at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:749)
at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:497)
at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:544)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3497)
at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:3024)
at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:969)
at org.dependencytrack.upgrade.UpgradeInitializer.contextInitialized(UpgradeInitializer.java:66)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1048)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:624)
at org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:983)
at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:740)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:392)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:900)
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
at org.eclipse.jetty.server.Server.start(Server.java:470)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89)
at org.eclipse.jetty.server.Server.doStart(Server.java:415)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
at alpine.embedded.EmbeddedJettyServer.main(EmbeddedJettyServer.java:100)
2022-12-13 15:59:14,224 ERROR [Schema] An exception was thrown while adding/validating class(es) : The transaction ended in the trigger. The batch has been aborted.
com.microsoft.sqlserver.jdbc.SQLServerException: The transaction ended in the trigger. The batch has been aborted.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912)
Beta Was this translation helpful? Give feedback.
All reactions