Comments (2)
shantstepanian
commented on May 24, 2024
Worth double-checking this particular exception stack trace. Also note that this was on obevo 5.x
com.ibm.db2.jcc.b.ni: [ibm][db2][jcc][102][10040] Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements.
at com.ibm.db2.jcc.b.p.a(p.java:414)
at com.ibm.db2.jcc.b.ih.a(ih.java:2876)
at com.ibm.db2.jcc.b.ih.b(ih.java:2710)
at com.ibm.db2.jcc.b.ih.executeBatch(ih.java:1554)
at com.gs.deployanywhere.db.impl.core.jdbc.JdbcHelper.batchUpdate(JdbcHelper.java:165)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer.executeInserts(CsvStaticDataDeployer.java:346)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer$2.run(CsvStaticDataDeployer.java:116)
at com.gs.deployanywhere.db.impl.platforms.AbstractSqlExecutor.executeWithinContext(AbstractSqlExecutor.java:46)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer.deployArtifact(CsvStaticDataDeployer.java:113)
at com.gs.deployanywhere.db.impl.core.changetypes.StaticDataChangeTypeBehavior.deploy(StaticDataChangeTypeBehavior.java:69)
at com.gs.deployanywhere.api.platform.ChangeTypeImpl.deploy(ChangeTypeImpl.java:93)
at com.gs.deployanywhere.api.appdata.Change.deploy(Change.java:557)
at com.gs.deployanywhere.impl.command.DeployChangeCommand.execute(DeployChangeCommand.java:17)
at com.gs.deployanywhere.impl.ExecuteDeployStrategy.deploy(ExecuteDeployStrategy.java:19)
at com.gs.deployanywhere.impl.MainDeployer.doExecute(MainDeployer.java:287)
at com.gs.deployanywhere.impl.MainDeployer.executeInternal(MainDeployer.java:168)
at com.gs.deployanywhere.impl.MainDeployer.execute(MainDeployer.java:92)
at com.gs.deployanywhere.db.impl.core.DbDeployerAppContextImpl.deploy(DbDeployerAppContextImpl.java:488)
at com.gs.deployanywhere.db.impl.core.DbDeployerAppContextImpl.deploy(DbDeployerAppContextImpl.java:73)
at com.gs.deployanywhere.db.cmdline.DbDeployerMain.start(DbDeployerMain.java:66)
at com.gs.deployanywhere.db.cmdline.DbDeployerMain.start(DbDeployerMain.java:21)
at com.gs.deployanywhere.cmdline.DeployAnywhereMain.start(DeployAnywhereMain.java:111)
at com.gs.deployanywhere.dist.Main.run(Main.java:105)
at com.gs.deployanywhere.dist.Main.main(Main.java:65)
With Root Cause: com.ibm.db2.jcc.b.SqlException: Error for batch element #1: DB2 SQL error: SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7;MYSCHEMA.MYTABLE
at com.ibm.db2.jcc.c.db.a(db.java:450)
at com.ibm.db2.jcc.c.db.a(db.java:68)
at com.ibm.db2.jcc.c.t.a(t.java:59)
at com.ibm.db2.jcc.c.tb.a(tb.java:207)
at com.ibm.db2.jcc.b.ih.a(ih.java:1904)
at com.ibm.db2.jcc.b.ih.b(ih.java:3033)
at com.ibm.db2.jcc.b.ih.a(ih.java:2818)
at com.ibm.db2.jcc.b.ih.b(ih.java:2710)
at com.ibm.db2.jcc.b.ih.executeBatch(ih.java:1554)
at com.gs.deployanywhere.db.impl.core.jdbc.JdbcHelper.batchUpdate(JdbcHelper.java:165)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer.executeInserts(CsvStaticDataDeployer.java:346)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer$2.run(CsvStaticDataDeployer.java:116)
at com.gs.deployanywhere.db.impl.platforms.AbstractSqlExecutor.executeWithinContext(AbstractSqlExecutor.java:46)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer.deployArtifact(CsvStaticDataDeployer.java:113)
at com.gs.deployanywhere.db.impl.core.changetypes.StaticDataChangeTypeBehavior.deploy(StaticDataChangeTypeBehavior.java:69)
at com.gs.deployanywhere.api.platform.ChangeTypeImpl.deploy(ChangeTypeImpl.java:93)
at com.gs.deployanywhere.api.appdata.Change.deploy(Change.java:557)
at com.gs.deployanywhere.impl.command.DeployChangeCommand.execute(DeployChangeCommand.java:17)
at com.gs.deployanywhere.impl.ExecuteDeployStrategy.deploy(ExecuteDeployStrategy.java:19)
at com.gs.deployanywhere.impl.MainDeployer.doExecute(MainDeployer.java:287)
at com.gs.deployanywhere.impl.MainDeployer.executeInternal(MainDeployer.java:168)
at com.gs.deployanywhere.impl.MainDeployer.execute(MainDeployer.java:92)
at com.gs.deployanywhere.db.impl.core.DbDeployerAppContextImpl.deploy(DbDeployerAppContextImpl.java:488)
at com.gs.deployanywhere.db.impl.core.DbDeployerAppContextImpl.deploy(DbDeployerAppContextImpl.java:73)
at com.gs.deployanywhere.db.cmdline.DbDeployerMain.start(DbDeployerMain.java:66)
at com.gs.deployanywhere.db.cmdline.DbDeployerMain.start(DbDeployerMain.java:21)
at com.gs.deployanywhere.cmdline.DeployAnywhereMain.start(DeployAnywhereMain.java:111)
at com.gs.deployanywhere.dist.Main.run(Main.java:105)
at com.gs.deployanywhere.dist.Main.main(Main.java:65)
at com.gs.deployanywhere.db.impl.core.jdbc.JdbcHelper.batchUpdate(JdbcHelper.java:169)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer.executeInserts(CsvStaticDataDeployer.java:346)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer$2.run(CsvStaticDataDeployer.java:116)
at com.gs.deployanywhere.db.impl.platforms.AbstractSqlExecutor.executeWithinContext(AbstractSqlExecutor.java:46)
at com.gs.deployanywhere.db.impl.core.changetypes.CsvStaticDataDeployer.deployArtifact(CsvStaticDataDeployer.java:113)
at com.gs.deployanywhere.db.impl.core.changetypes.StaticDataChangeTypeBehavior.deploy(StaticDataChangeTypeBehavior.java:69)
at com.gs.deployanywhere.api.platform.ChangeTypeImpl.deploy(ChangeTypeImpl.java:93)
at com.gs.deployanywhere.api.appdata.Change.deploy(Change.java:557)
at com.gs.deployanywhere.impl.command.DeployChangeCommand.execute(DeployChangeCommand.java:17)
at com.gs.deployanywhere.impl.ExecuteDeployStrategy.deploy(ExecuteDeployStrategy.java:19)
at com.gs.deployanywhere.impl.MainDeployer.doExecute(MainDeployer.java:287)
at com.gs.deployanywhere.impl.MainDeployer.executeInternal(MainDeployer.java:168)
at com.gs.deployanywhere.impl.MainDeployer.execute(MainDeployer.java:92)
at com.gs.deployanywhere.db.impl.core.DbDeployerAppContextImpl.deploy(DbDeployerAppContextImpl.java:488)
at com.gs.deployanywhere.db.impl.core.DbDeployerAppContextImpl.deploy(DbDeployerAppContextImpl.java:73)
at com.gs.deployanywhere.db.cmdline.DbDeployerMain.start(DbDeployerMain.java:66)
at com.gs.deployanywhere.db.cmdline.DbDeployerMain.start(DbDeployerMain.java:21)
at com.gs.deployanywhere.cmdline.DeployAnywhereMain.start(DeployAnywhereMain.java:111)
at com.gs.deployanywhere.dist.Main.run(Main.java:105)
at com.gs.deployanywhere.dist.Main.main(Main.java:65)
Caused by: com.ibm.db2.jcc.b.ni: [ibm][db2][jcc][102][10040] Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements.
at com.ibm.db2.jcc.b.p.a(p.java:414)
at com.ibm.db2.jcc.b.ih.a(ih.java:2876)
at com.ibm.db2.jcc.b.ih.b(ih.java:2710)
at com.ibm.db2.jcc.b.ih.executeBatch(ih.java:1554)
at com.gs.deployanywhere.db.impl.core.jdbc.JdbcHelper.batchUpdate(JdbcHelper.java:165)
... 19 more
from obevo.
shantstepanian
commented on May 24, 2024
Another string example:
DataAccessException containing SqlException:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;MYSCHEMA.MYTABLE, DRIVER=3.59.81
from obevo.
Related Issues (20)
- Obevo DB2 support HOT 2
- Changes in tokens, when used in an object, should trigger a change on the object
- Correct and clarify the graph cycle error message
- NPE caused when package-info.txt file w/ METADATA section exists in staticdata (data) folder
- Update documentation with CSV null value handling
- Rollback detection should work fine for multi-schema use case if one schema is a no-op and the other is rollback
- Update .travis.yml to only build releases if tag starts with "release-x.y.z"
- Add MemSQL Support
- Question on system-config.xml for SQL Server HOT 2
- Issue with reverse engineering SQL Server database HOT 4
- Oracle - XSD deployment capability HOT 1
- Building obevo using maven HOT 1
- commons-text NoSuchMethod due to version conflict HOT 2
- Issues with using -rollback flag
- Incorporate Credential Vault for Obevo deploy
- Issue with multiple sql queries in single change HOT 1
- Stored Procedure did not get installed with warning as "badFileFormat"
- Issue with DB2 Deploy DataType Converter from String to Clob
- Wrong table's schema introspecting query for Postgres DB HOT 2
- Getting Out of memory error for Oracle schema with code like packages functions and procedures
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from obevo.