It's all about the answers!

Ask a question

Performance issue in loading repository workspace to our sandbox


Jojie Valiente (3021417) | asked Sep 30 '12, 11:56 p.m.

Hi, we're getting the error below when loading a repository workspace to our sandbox.

2012-10-01 12:43:02,526 [ ccm: AsynchronousTaskRunner-4] ERROR com.ibm.team.process                                - CRJAZ6016E:Exception occurred attempting to load project area change listeners.

java.lang.IllegalStateException: CRJAZ1100I Extension service has not been started.

        at com.ibm.team.repository.common.transport.registry.ExtensionServiceElementDescriptor.getImplementation(ExtensionServiceElementDescriptor.java:349)

        at com.ibm.team.process.internal.service.ProjectAreaChangeListenerRegistry$ProjectAreaChangeListenerExtensionServiceElementDescriptor.getImplementation(ProjectAreaChangeListenerRegistry.java:233)

        at com.ibm.team.process.internal.service.ProjectAreaChangeListenerRegistry.getCalledOnAllNodesListeners(ProjectAreaChangeListenerRegistry.java:200)

        at com.ibm.team.process.internal.service.ProjectAreaChangeListenerRunningOnAllNodesTask.runTask(ProjectAreaChangeListenerRunningOnAllNodesTask.java:47)

        at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:87)

 

        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

        at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)

        at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)

        at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)

        at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)

        at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)

        at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)

        at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)

        at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)

        at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)

        at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)

        at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)

        at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)

        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)

        ... 58 more

2012-09-18 11:09:59,361 [      AsynchronousTaskRunner-1] ERROR sqlTxLogger                                         - Exception preparing SQL: SELECT c.HASH_CODE, c.DELTA_PREDECESSOR FR

OM SCM.CONTENT c LEFT OUTER JOIN SCM.CONTENT_CLAIMER cl on c.HASH_CODE = cl.CLAIMED_CONTENT_HASH WHERE c.SEQUENCE = 0 AND cl.CLAIMED_CONTENT_HASH IS NULL

2012-09-18 11:09:59,364 [      AsynchronousTaskRunner-1] ERROR com.ibm.team.scm                                    - CRRTC5001E SQL Exception encountered

java.sql.SQLSyntaxErrorException: Schema 'SCM' does not exist

        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)

        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)

        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)


Comments
Jojie Valiente commented Oct 01 '12, 7:22 p.m.

Hi Ralph,

Thanks for replying on this post.

We're using Oracle 11g R2 DB. And the weird thing about this issue is that only one in my team is not facing this performance issue. Our sys admin yesterday had monitored the logs and couldn't find any other error except for this one.

What do you mean by use diagnostics based on RTC version we are running? Is there a tool for this?


Ralph Schoon commented Oct 02 '12, 2:27 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

If you use Oracle, the error above is most likely due to the data warehouse. See answers below on performance monitoring.

Is there something special about the one not facing the performance issue? Different hardware, network connection/adapter (more than one) etc? 

2 answers



permanent link
Ralph Schoon (59.4k23642) | answered Oct 01 '12, 5:29 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Jojie,

that looks bad, as if the database has an issue, not as if you have a performance issue. I would check the logs of the server if there are more errors, also use diagnostics (based on the RTC version you run) and check if there are service errors. Can you access SCM using the Web UI? If the database has an issue you might want to consider restoring a backup. You could even do this on an isolated test system to check if it fixes your issue.

Please be aware, Derby is really only supposed to be used for standalone test and demo systems. Any production system, even for very few users should use an enterprise DB. You can get DB2 on the Optional Programs tab on the download page of your version.

permanent link
Ralph Schoon (59.4k23642) | answered Oct 02 '12, 2:35 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
With respect to performance, there are several ways to diagnose.

See http://dtoczala.wordpress.com/ for some hints, especially JazzMon https://jazz.net/library/article/822.

Also see https://jazz.net/blog/index.php/2012/05/15/performance-health-check/ for the Performance Health Check Widget and how to use it.

For the Eclipse client you can use the Metronome https://jazz.net/library/article/503 to look into performance issues.

Last but not least there is the server diagnostics: on https://<Server>:<Port>/jts/admin#action=jazz.viewPage&id=com.ibm.team.repository.server you can see various items in the top left menu. In 4.0 the Diagnostics should give you a health check and you can also downoad the stats mentioned in the JazzMon article. The diagnostics is also available for each application (replace jts by ccm or another context root.).

Are you running your client machines stand alone or in VMWare?

Comments
Jojie Valiente commented Oct 11 '12, 6:00 a.m.

Thanks for your help Ralph. We came to know recently that the root cause of the performance issue is related to our VPN.

Your answer


Register or to post your answer.