It's all about the answers!

Ask a question

What do I get a BatchUpdateException during accepting of changesets?


Simon Scherer (1111) | asked Jun 02 '12, 11:40 a.m.
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 operation
  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 #1
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
SQL Exception #2
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
  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 #1
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
SQL Exception #2
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
  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". 
  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 #1
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
SQL Exception #2
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
  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 #1
SQLState: XSDB0
Message: Unexpected exception on in-memory page Page(79,Container(0, 18753))
Vendor Code: 45000
SQL Exception #2
SQLState: XSDB0
Message: 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


permanent link
Sean G Wilbur (8722421) | answered Jun 02 '12, 4:25 p.m.
JAZZ DEVELOPER
  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
Seth Packham selected this answer as the correct answer

One other answer



permanent link
Simon Scherer (1111) | answered Jun 04 '12, 6:33 a.m.
We swiched to DB2 Express and now (for the moment) everything works fine (and it`s faster!).
Thanks for your tip!


Your answer


Register or to post your answer.