Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




"Assigned To" and "Assigned Resource" empty

web-app

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
yohm31
Replies (16)
helpful
0
not helpful

Can you please check the project resources via the project administration screen?

Are there any resources assigned to the project?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

yes, this is what i have:

Project Administration

Project Administration General Components Versions Resourcing Custom Fields Security Scheme Project Attributes Version Attributes Reset Issues Votes  

Project 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


yohm31
· 1
yohm31
helpful
0
not helpful

Silly question, but are you sure that you are creating / editing the issue for the project in question?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

sorry, i've been out for a while...  see my answer below

the problem is still here


yohm31
· 1
yohm31
helpful
0
not helpful

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 :)


yohm31
· 1
yohm31
helpful
0
not helpful

Is it possible to get a copy of your database? If so, please send it to support@countersoft.com

 


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

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


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

i don't undestand beceause I've verified  and my database settings for collation are:
LATIN1GENERALCIAI

if i change to any other collation, i have the  "column   IssueId not found" problem, which we have discussed long time ago

so, the problem is not solved for me

for info, the sp gemini
getlut_1  returns this lines for project resources (active only)

0    !!2Nobody    0
1    Guillaume yohm    14043
2    jean pierre JP    14044
4    Mohamed Barik    14045


so it seems to work at the DB level....


yohm31
· 1
yohm31
helpful
0
not helpful

Check the collation order of the projectresources table (active field).


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

for "projectresource" table   it is  :  Latin1GeneralCI_AI
Ansi Nulls : true
QuotedIndentifier: true


yohm31
· 1
yohm31
helpful
0
not helpful

another thing to notice:  when I create an issue  the  listbox "AssignTo" is populated

it is when i edit the issue that the listbox is empty


yohm31
· 1
yohm31
helpful
0
not helpful

did you change to collation?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

my db collation is Latin1GeneralCIAI
collation on table  projectresource  is   Latin1
GeneralCIAI

what should I change?


yohm31
· 1
yohm31
helpful
0
not helpful

What is the collation for the isactive field? is it FrenchCSAS?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

yes it is FrenchCSAS

it's weird, beceause it is not the default collation neitheir of the SQL srv instance, nor the Gemini database

how can change the collation of a column?


yohm31
· 1
yohm31
helpful
0
not helpful

ok, i found the Sql statement:

 ALTER TABLE projectresource ALTER COLUMN isactive VARCHAR(1) COLLATE Latin1GeneralCI_AI;

now it works

thanks for all your help!  :)


yohm31
· 1
yohm31