Timesheets setting issue

J

jpa

Hi,

MS PS 2007 , SP1 installed

When a team member tries to fill in a timesheet
1) he can fulfill "comment" and workload for the given day, then save
without any problem
2) but when he tries to fulfill timesheet using the widows popped up when
double clicking the "Task name/Description" then an error is displayed
telling user has not right access right (sorry I cannot write exact error
wording at the time being).

This user has "team member" template permission (and category_My_Tasks)
But maybe you have some ideas about what kind of check to do...
What is the permission he shoud have to allow above action?

thanks in advance
jpa
 
J

jpa

Hi Jonathan

thanks for your pointer.
I am not so familiar with SQL requests... And so I don't see how to perform
the STEP 1 ("Execute the following SQL Select Query to Project Server
Published database").
Could you please give me more detailed steps to execute STEP1 (kind of HOWTO)?
(eg: from which application I can run the SQL command? etc...)

thanks in advance for your help
jpa
 
J

Jonathan Sofer

In order to do the SQL query you will need to have access to run queries
directly on the SQL Server Database. If you have a database administrator
or IT person responsible for the installation of MSPS2007, you can have them
run the query for you.

Otherwise, if you have the access to the server via Remote Desktop, you can
do it yourself:
1) Go to Start>Run
2) Type mstcs and hit OK
3) On the Remote Desktop Connection page type in the name of the project
server
4) Type in the domain/username and password for an account that has access
to the server (try using the administrator account used during the
installation)
5) Go to Start>All Programs>Microsoft SQL Server 2005>SQL Server Management
Studio
6) Connect to the Database Engine, default settings will probably work
7) Navigate to the Published Database, should be something like
"ProjectServer2007_PWA_Published"
8) Right click on the DB and choose "New Query"
9) Paste the query in
"SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID FROM MSP_TASKS_SAVED WHERE (TASK_UID =
MSP_ASSIGNMENTS_SAVED.TASK_UID)))"

10) Select "Query>Execute"

Hope this helps,
Jonathan
 
J

jpa

Many thanks Jonathan

I performed STEP 1 as you indicated to me (your detailed explaination was
really helpful to me).
Unfortunately the SQL request did give NO result (ie record matching the
request).
Then I checked again whether my problem of access right (see here below) was
still present...
And good news, it has disappeared!!!

I have no real explanation about what exactly solves above problem.
Maybe this was also linked to another problem I solved in parallel with your
help:

Other problem: Tasks visible in My Timesheets but not in My Tasks PWA views
Solved by:
http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/TasksOnPMsMyTasksPage.aspx

Thanks again for your help and kindness
jpa
 
J

Jonathan Sofer

Thanks for the follow up and you are welcome. I have to admit that I too
was able to replicate this bug in one of my virtual machines but since then,
have not been able to reproduce the issue. It doesn't seem to be
consistently reproducable. In the future, if you do see this issue again, I
am confident you will have records returned from the query mentioned earlier
in this posting.

Regards,

Jonathan Sofer
 
Top