Getting 'cannot log in' errors and SQL erros from repo.
I'll try to provide as much context here as possible. Let me know if you need any more information.
We have a Jazz server set up for our software engineering class. The students are developing a Java project in Rational Team Concert. They are divided into groups of two, and each group has a workspace. Both students are 'team-members' of their workspaces. They're keeping the projects on their workspaces so that they can load them from anywhere, work on them, and submit their changes.
Everything was working fine until a few days ago. Now the Jazz server seems to have blown up. We're getting a lot of different errors. Some students are not having any problems, some are having problems with working with large check-in's, and some cannot use their repositories at all.
Here's one of the more extreme cases.
In Team Artifacts, create a new connection, provide the URI of the Jazz server, and log in. Create a new repository workspace and select the team's workspace. Select 'Load Eclipse Projects' and select the project to be loaded.
While the project attempts to download, an error along the lines of "cannot connect to x.x" keeps flashing next to the project folder, where x.x is the address of the Jazz server. Eventually we get the following errors:
http://img227.imageshack.us/my.php?image=ss1hk6.jpg
http://img227.imageshack.us/my.php?image=ss2cb6.jpg
It looks like there is something wrong with the SQL database on the server. Any suggestions?
Thanks for you help!
We have a Jazz server set up for our software engineering class. The students are developing a Java project in Rational Team Concert. They are divided into groups of two, and each group has a workspace. Both students are 'team-members' of their workspaces. They're keeping the projects on their workspaces so that they can load them from anywhere, work on them, and submit their changes.
Everything was working fine until a few days ago. Now the Jazz server seems to have blown up. We're getting a lot of different errors. Some students are not having any problems, some are having problems with working with large check-in's, and some cannot use their repositories at all.
Here's one of the more extreme cases.
In Team Artifacts, create a new connection, provide the URI of the Jazz server, and log in. Create a new repository workspace and select the team's workspace. Select 'Load Eclipse Projects' and select the project to be loaded.
While the project attempts to download, an error along the lines of "cannot connect to x.x" keeps flashing next to the project folder, where x.x is the address of the Jazz server. Eventually we get the following errors:
http://img227.imageshack.us/my.php?image=ss1hk6.jpg
http://img227.imageshack.us/my.php?image=ss2cb6.jpg
It looks like there is something wrong with the SQL database on the server. Any suggestions?
Thanks for you help!
2 answers
The error seems to have occurred when our server restarted over the weekend.
Another student has reported the issue with the full stacktrace below:
CRJAZ0265I The virtual storage or database resource is not available.
SQL: select t1.ITEM_ID, t1.STATE_ID from SCM.WORKSPACE t1 where (t1.OWNER_ITEM_ID = '_qpwegH-xEd2_pI9tNhIUhQ')
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096
SQL State: 57011
Error Code: -1218
CRJAZ0265I The virtual storage or database resource is not available.
SQL: select t1.ITEM_ID, t1.STATE_ID from SCM.WORKSPACE t1 where (t1.OWNER_ITEM_ID = '_qpwegH-xEd2_pI9tNhIUhQ')
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096
SQL State: 57011
Error Code: -1218
There were errors during download. It is recommended that components be reloaded. The reload will be incremental, loading only the missing items. You can further reduce the reload time by reloading just the projects out of sync.
Failed to download /iTrust/.classpath
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/iTrust HTTP Tests.launch
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/itrust-build.xml
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/.djunitplugin
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/iTrust Unit Tests.launch
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/loginPage.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/logout.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/resetPassword.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/privacyPolicy.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/displayWikiDatabase.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/resources/menuIE.css
CRJAZ0098I Return code 500 from http request: Internal Server
...etc....
Any help would be very much appreciated!
Another student has reported the issue with the full stacktrace below:
CRJAZ0265I The virtual storage or database resource is not available.
SQL: select t1.ITEM_ID, t1.STATE_ID from SCM.WORKSPACE t1 where (t1.OWNER_ITEM_ID = '_qpwegH-xEd2_pI9tNhIUhQ')
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096
SQL State: 57011
Error Code: -1218
CRJAZ0265I The virtual storage or database resource is not available.
SQL: select t1.ITEM_ID, t1.STATE_ID from SCM.WORKSPACE t1 where (t1.OWNER_ITEM_ID = '_qpwegH-xEd2_pI9tNhIUhQ')
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -1218, SQLSTATE: 57011, SQLERRMC: 4096
SQL State: 57011
Error Code: -1218
There were errors during download. It is recommended that components be reloaded. The reload will be incremental, loading only the missing items. You can further reduce the reload time by reloading just the projects out of sync.
Failed to download /iTrust/.classpath
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/iTrust HTTP Tests.launch
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/itrust-build.xml
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/.djunitplugin
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/iTrust Unit Tests.launch
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/loginPage.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/logout.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/resetPassword.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/privacyPolicy.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/displayWikiDatabase.jsp
CRJAZ0098I Return code 500 from http request: Internal Server Error
Failed to download /iTrust/WebRoot/resources/menuIE.css
CRJAZ0098I Return code 500 from http request: Internal Server
...etc....
Any help would be very much appreciated!