What do I get a BatchUpdateException during accepting of changesets?
Hi,
we are using Jazz + RTC (on Windows Server, with Tomcat and Derby). Following problem:
I try to accept a incoming changeset from another team member. After pressing "Accept", I getting three problems:
There have been 3 problems running this operationCRJAZ0336I BatchUpdateException while processing statement "INSERT INTO SCM.CONFIGURATION_SELECTIONS (INTERNAL_ID, JZ_PARENT_ID, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR, STATE, PARENT, NAME, LOCKED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";SQL Exception #1SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000SQL Exception #2SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000CRJAZ0336I BatchUpdateException while processing statement "INSERT INTO SCM.CONFIGURATION_SELECTIONS (INTERNAL_ID, JZ_PARENT_ID, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR, STATE, PARENT, NAME, LOCKED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";SQL Exception #1SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000SQL Exception #2SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000CRJAZ0098I The "com.ibm.team.scm.common.IScmService{/ccm/service/com.ibm.team.scm.common.IScmService}" service failed. The server returned the HTTP error 500 with error text "Internal Server Error".CRJAZ0098I The "com.ibm.team.scm.common.IScmService{/ccm/service/com.ibm.team.scm.common.IScmService}" service failed. The server returned the HTTP error 500 with error text "Internal Server Error".CRJAZ0336I BatchUpdateException while processing statement "INSERT INTO SCM.CONFIGURATION_SELECTIONS (INTERNAL_ID, JZ_PARENT_ID, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR, STATE, PARENT, NAME, LOCKED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";SQL Exception #1SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000SQL Exception #2SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000CRJAZ0336I BatchUpdateException while processing statement "INSERT INTO SCM.CONFIGURATION_SELECTIONS (INTERNAL_ID, JZ_PARENT_ID, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR, STATE, PARENT, NAME, LOCKED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";SQL Exception #1SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000SQL Exception #2SQLState: XSDB0Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))Vendor Code: 45000
Has anyone an idea, what these exceptions mean and how we can fix them?
Is our derby database corrupt?
Thanks for your help!!
Accepted answer
Have you already tried restarting your Jazz Server and confirm that only one Java process is active on your server? The vendor code 45000 looks like an error starting the database, potentially because it is already connected elsewhere.
Also not a bad idea to look at another db vendor if you are outgrowing Derby, something like DB2 Express is a good free option that is supported.
-Sean