"Assigned To" and "Assigned Resource" empty
hello
i've affected ressource to a projet... OK
when i have started populating my components and issues, everything was normal but today, the list of assigned ressources are empty... even when i'm creating or editing an issue..
ay idea?
my Sql Srv DB is case insensitive now... and the installation ran OK.
yohm31
· 1 |
|
Thursday, February 7, 2008, 4:56:40 PM |
0
|
Can you please check the project resources via the project administration screen? Are there any resources assigned to the project? |
||||
|
0
|
yes, this is what i have:
Project AdministrationProject Administration General Components Versions Resourcing Custom Fields Security Scheme Project Attributes Version Attributes Reset Issues VotesProject Resourcing Add, remove resources to this project Assigned Resources Available Resources Full Name User Name Guillaume yohm admin X Active Edit Remove jean pierre JP jpsimon X Active Edit Remove they are Active of course. i have also checked that these ressources have the correct access (ie Issue Worker) in the main administration |
||||
|
0
|
Silly question, but are you sure that you are creating / editing the issue for the project in question? |
||||
|
0
|
sorry, i've been out for a while... see my answer below the problem is still here |
||||
|
0
|
yes of course the workaround i found is to click on "Assigned issue to me" but still after that operation the behaviour remains weird: the name of the ressource in the column "assigned to" appears in the list of issues (per project) but when i edit the task , the ListBox "Assigned To" is empty (and if I save anything in the editing page, then the AffectedTo field is reset to nothing)
any help is welcome :) |
||||
|
0
|
Is it possible to get a copy of your database? If so, please send it to support@countersoft.com
|
||||
|
0
|
Ok, we have found the issue. Your database is setup to use case sensative collation order. That is causing the issue. Suggest you change that to case insensative. Otherwise change all stored procedures to use uppercase 'Y' such as geminigetlut1 |
||||
|
0
|
i don't undestand beceause I've verified and my database settings for collation are: |
||||
|
0
|
Check the collation order of the projectresources table (active field). |
||||
|
0
|
for "projectresource" table it is : Latin1GeneralCI_AI |
||||
|
0
|
another thing to notice: when I create an issue the listbox "AssignTo" is populated |
||||
|
0
|
did you change to collation? |
||||
|
0
|
my db collation is Latin1GeneralCIAI |
||||
|
0
|
What is the collation for the isactive field? is it FrenchCSAS? |
||||
|
0
|
yes it is FrenchCSAS |
||||
|
0
|
ok, i found the Sql statement: |
||||
|