Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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 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!!

0 votes


Accepted answer

Permanent link
  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

1 vote


One other answer

Permanent link
We swiched to DB2 Express and now (for the moment) everything works fine (and it`s faster!).
Thanks for your tip!


1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jun 02 '12, 11:40 a.m.

Question was seen: 6,391 times

Last updated: Jun 04 '12, 6:33 a.m.

Confirmation Cancel Confirm