Support Forum

[kuzkot]

Hi,

I just downloaded your (apparently) great work, and set it up on WinXp/MYSqlInnoDB with the jdk you provided.
I ran the sql scripts (which btw contained unix CRLF at the wrong place which made the sql fail - corrected this and it was ok).
I can login as root/root, but whenever I want to click "new user", the login field is filled with a hash key(why ?).
If I replace the hash key by a humanly readable login, fill the other info then save the new user, I am unable to log in with this user.

LOG :
gran.exception.GranException: Hibernate lazy instantiation problem: No row with the given identifier exists: 8a8a8a90f461155100f46115ad1e0001, of class: gran.model.User
at gran.app.AppClass.logon(AppClass.java:171)
at gran.jsp.LoginAction_jsp._jspService(LoginAction_jsp.java:135)
[...]

Thanks for any help you might provide !

[admin]

I just downloaded your (apparently) great work, and set it up on WinXp/MYSqlInnoDB with the jdk you provided.
I ran the sql scripts (which btw contained unix CRLF at the wrong place which made the sql fail - corrected this and it was ok).

You can create database with sman - all should be fine with it.

I can login as root/root, but whenever I want to click "new user", the login field is filled with a hash key(why ?).

It's feature - we need unique user login at this stage, just enter right user login. Also, please try to log in with test/test.

If I replace the hash key by a humanly readable login, fill the other info then save the new user, I am unable to log in with this user.

LOG :
gran.exception.GranException: Hibernate lazy instantiation problem: No row with the given identifier exists: 8a8a8a90f461155100f46115ad1e0001, of class: gran.model.User
at gran.app.AppClass.logon(AppClass.java:171)
at gran.jsp.LoginAction_jsp._jspService(LoginAction_jsp.java:135)
[...]

Thanks for any help you might provide !

Its very like you use MySQL without InnoDB. Please try to log in as root, go user management, status and try to delete status 'administrator' or 'manager'. If you can - you use MySQL without InnoDB and you need recreate database.

[kuzkot]

You can create database with sman - all should be fine with it.

That is right, it worked very nicely.

I can login as root/root, but whenever I want to click "new user", the login field is filled with a hash key(why ?).

Its very like you use MySQL without InnoDB. Please try to log in as root, go user management, status and try to delete status 'administrator' or 'manager'. If you can - you use MySQL without InnoDB and you need recreate database.

I got it working, I am totally new to mysql and underestimated the customization effort to setup innodb.

Well I was able to create another user, so I am on my way to test the other features.
One question : is there a way to import defects from a ClearQuest database ?
I know that importing data is just a matter of insert statements, but do you provide a tool or do you have some tips and tricks to do so ?
I am testing this for my office, and would like to replace ClearQuest with your tool.
One of the things I have to do is keep as much ClearQuest history as I can, and I also have to get easy to use and clear reports.

I might post this as a feature request, but I just want to know what I can expect from current version in terms of import and reporting.

Spaciba (not sure about the spelling...)

[admin]

I got it working, I am totally new to mysql and underestimated the customization effort to setup innodb.

You can use it with HSQL - just start it (hsql.exe), create database and connect.

Well I was able to create another user, so I am on my way to test the other features.

MySQL without InnoDB has no FK support and you can delete something important (for example, used role status or workflow) and destroy your database.

One question : is there a way to import defects from a ClearQuest database ?
I know that importing data is just a matter of insert statements, but do you provide a tool or do you have some tips and tricks to do so ?

No tools available yet. You should fill GR_USERS with users, GR_TASK with tasks and GR_MESSAGE with bugnotes.

I might post this as a feature request, but I just want to know what I can expect from current version in terms of import and reporting.

Reporting still very basic, we implement new report generator now and they will be available in 2.7. Data import is also very basic - no special tools, just insert data in database with SQL.

Spaciba (not sure about the spelling...)

Da, pravilno, thanks

[mdurant]

Hello,
I had a clean install and evaluation of the system on WinXP/Oracle, but we're doing a setup in our Linux/MySQL (with InnoDB) development environment and are having some problems with it. I created a new project under the "Task Management-->Projects" root project, then went to user management, added a new user under "Admin" with the new project as the default, and when I try to log in as that user I get an error message identical to the one reported above:

Hibernate lazy instantiation problem: No row with the given identifier exists: 0040f212f5f342e500f5f4bdc2520012, of class: gran.model.User

I tried following the suggestion above to try deleting the "manager" or "administrator" roles, and the system won't let me do it ... so I believe our db is configured correctly.

Interestingly enough, when I add the users, they do appear in the list along with the "test" user (who I can log in as, by the way). When I log off and log back in as root, though, only the test user remains in the list ... BUT: If I click on the test user, then click the "go to parent" button, it takes me to a list that does have my new users in it.

Any suggestions? I'm anxious to get this set up as soon as I can so we can get our testers used to it.

Thanks!
Mark

[mdurant]

I should add that we had this problem once, wiped the database, recreated it (I can post the full output of that process, if you're interested), and still had the problem.

[admin]

I should add that we had this problem once, wiped the database, recreated it (I can post the full output of that process, if you're interested), and still had the problem.

Yes, please send me full output.

[admin]

I had a clean install and evaluation of the system on WinXP/Oracle, but we're doing a setup in our Linux/MySQL (with InnoDB) development environment and are having some problems with it.

It has only one bug - TrackStudio does not support export scheme to XML, we use Export functionality to generate en.xml and forget to remove it.

So, you can't now transfer data from ORACLE to MySQL, sorry. We plan to implement this functionality in 3.0

[mdurant]

Actually, I'm not trying to export/import anything ... I trashed the old WinXP data and we're starting with a completely clean build (running the database build script provided in the /sql/ directory). That's the point at which we're having problems.

Just ignore my WinXP/Oracle remark

[admin]

Actually, I'm not trying to export/import anything ... I trashed the old WinXP data and we're starting with a completely clean build (running the database build script provided in the /sql/ directory). That's the point at which we're having problems.

Just ignore my WinXP/Oracle remark

What version do you use - 2.5SP2 or 2.7Beta2 ?
Standalone or WAR ?