Import Timesheet returns Unknown Error in Project Server 2007 Web Access (PWA)

[Neufusion]

Project Server 2007 Web Access (PWA) -

User clicks 'My Timesheets', enters time. User clicks 'My Tasks' >
'Import Timesheet'. Now it is at a screen that says 'Import Timesheet'
with '1. Select Timesheet' and '2. Preview'. When they try to select
the most recent timesheet, it fails with this error:

"Go back to site
Error
Unknown Error
Troubleshoot issues with Windows SharePoint Services. "

If they select the older timesheet, it works fine. If it is a user
that has only 1 timesheet, for the most recent week, it fails with the
above error before it gets to the select timesheet page.

This is a brand new installation of Project Server 2007 with new test
projects setup in Project Professional 2007.

I've tried deleting/recreating the Projects, and deleting/recreating
the timesheet.

What is the problem?

Some people were saying it is known issue and MS has a hotfix, but MS
said they will only provid free hotfixes if I have the article ID of
the hotfix. Otherwise, they want $245 to fix their product.

 

[Gary L. Chefetz [MVP]]

It is likely a corrupt assignment. These occur any time you assign an
additional resource to a task that has already started tracking. I tell you
that to help you track it down. Usually, saving the project to XML, deleting
the project from the server, and importing it back in fixes the problem.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Neufusion]

After speaking with some people that were able to solve the problem
with MS Tech Support, they said the solution was an alter proc
statement that prevented the proc from passing null values.

Microsoft still would not give me the hotfix without trying to charge
me $245. Nice marketing tactics there MS - try to charge someone $245
to fix an known issue while they are evaluating the software.

I was able to get the fix from another source.

USE THIS CODE AT YOUR OWN RISK
I highly recommend backing up your database and scripting out a copy
of the procedure before making any changes to your database.

USE [ProjectServer_Published]
GO
/****** Object: StoredProcedure [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData] Script Date:
09/20/2007 11:33:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData]
(
@resid UID,
@period UID
)
AS
SELECT L.TS_LINE_UID, L.ASSN_UID, L.PROJ_UID, A.TASK_NAME,
P.PROJ_NAME, L.TS_LINE_CLASS_UID, C.TS_LINE_CLASS_NAME,
L.TS_LINE_ACT_SUM_VALUE, ISNULL(A.ASSN_ACT_WORK,0) AS ASSN_ACT_WORK,
ISNULL(A.ASSN_WORK,0) AS ASSN_WORK, ISNULL(A.ASSN_PCT_WORK_COMPLETE,0)
AS ASSN_PCT_WORK_COMPLETE, L.TS_LINE_COMMENT
FROM MSP_TIMESHEET_LINES L
INNER JOIN MSP_TIMESHEETS T ON T.TS_UID=L.TS_UID
INNER JOIN MSP_TIMESHEET_CLASSES C ON
C.TS_LINE_CLASS_UID=L.TS_LINE_CLASS_UID
INNER JOIN MSP_ASSIGNMENTS_SAVED A ON L.ASSN_UID=A.ASSN_UID
INNER JOIN MSP_PROJECTS P ON L.PROJ_UID=P.PROJ_UID
WHERE T.WPRD_UID=@period
AND L.TS_LINE_VALIDATION_TYPE=1
AND T.RES_UID=@resid
AND L.TS_LINE_CLASS_UID='FCDB0E4E-B9C7-4A39-804F-FA44796F71A0'
ORDER BY P.PROJ_NAME, A.TASK_NAME

 

[Gary L. Chefetz [MVP]]

Thanks for sharing. Just so you know, hotifxes are no charge for licensed
versions of the software.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

After speaking with some people that were able to solve the problem
with MS Tech Support, they said the solution was an alter proc
statement that prevented the proc from passing null values.

Microsoft still would not give me the hotfix without trying to charge
me $245. Nice marketing tactics there MS - try to charge someone $245
to fix an known issue while they are evaluating the software.

I was able to get the fix from another source.

USE THIS CODE AT YOUR OWN RISK
I highly recommend backing up your database and scripting out a copy
of the procedure before making any changes to your database.

USE [ProjectServer_Published]
GO
/****** Object: StoredProcedure [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData] Script Date:
09/20/2007 11:33:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData]
(
@resid UID,
@period UID
)
AS
SELECT L.TS_LINE_UID, L.ASSN_UID, L.PROJ_UID, A.TASK_NAME,
P.PROJ_NAME, L.TS_LINE_CLASS_UID, C.TS_LINE_CLASS_NAME,
L.TS_LINE_ACT_SUM_VALUE, ISNULL(A.ASSN_ACT_WORK,0) AS ASSN_ACT_WORK,
ISNULL(A.ASSN_WORK,0) AS ASSN_WORK, ISNULL(A.ASSN_PCT_WORK_COMPLETE,0)
AS ASSN_PCT_WORK_COMPLETE, L.TS_LINE_COMMENT
FROM MSP_TIMESHEET_LINES L
INNER JOIN MSP_TIMESHEETS T ON T.TS_UID=L.TS_UID
INNER JOIN MSP_TIMESHEET_CLASSES C ON
C.TS_LINE_CLASS_UID=L.TS_LINE_CLASS_UID
INNER JOIN MSP_ASSIGNMENTS_SAVED A ON L.ASSN_UID=A.ASSN_UID
INNER JOIN MSP_PROJECTS P ON L.PROJ_UID=P.PROJ_UID
WHERE T.WPRD_UID=@period
AND L.TS_LINE_VALIDATION_TYPE=1
AND T.RES_UID=@resid
AND L.TS_LINE_CLASS_UID='FCDB0E4E-B9C7-4A39-804F-FA44796F71A0'
ORDER BY P.PROJ_NAME, A.TASK_NAME

It is likely a corrupt assignment. These occur any time you assign an
additional resource to a task that has already started tracking. I tell
you
that to help you track it down. Usually, saving the project to XML,
deleting
the project from the server, and importing it back in fixes the problem.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com













- Show quoted text -

 

[Neufusion]

Microsoft said they will only give a hotfix free of charge if you know
the article ID of the hotfix. I searched all of the hotfixes available
online for SharePoint and none of them had this fix. I explained this
to Microsoft and they said "Credit Card Number Please".

Thanks for sharing. Just so you know, hotifxes are no charge for licensed
versions of the software.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

After speaking with some people that were able to solve the problem
with MS Tech Support, they said the solution was an alter proc
statement that prevented the proc from passing null values.

Microsoft still would not give me the hotfix without trying to charge
me $245. Nice marketing tactics there MS - try to charge someone $245
to fix an known issue while they are evaluating the software.

I was able to get the fix from another source.

USE THIS CODE AT YOUR OWN RISK
I highly recommend backing up your database and scripting out a copy
of the procedure before making any changes to your database.

USE [ProjectServer_Published]
GO
/****** Object: StoredProcedure [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData] Script Date:
09/20/2007 11:33:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData]
(
@resid UID,
@period UID
)
AS
SELECT L.TS_LINE_UID, L.ASSN_UID, L.PROJ_UID, A.TASK_NAME,
P.PROJ_NAME, L.TS_LINE_CLASS_UID, C.TS_LINE_CLASS_NAME,
L.TS_LINE_ACT_SUM_VALUE, ISNULL(A.ASSN_ACT_WORK,0) AS ASSN_ACT_WORK,
ISNULL(A.ASSN_WORK,0) AS ASSN_WORK, ISNULL(A.ASSN_PCT_WORK_COMPLETE,0)
AS ASSN_PCT_WORK_COMPLETE, L.TS_LINE_COMMENT
FROM MSP_TIMESHEET_LINES L
INNER JOIN MSP_TIMESHEETS T ON T.TS_UID=L.TS_UID
INNER JOIN MSP_TIMESHEET_CLASSES C ON
C.TS_LINE_CLASS_UID=L.TS_LINE_CLASS_UID
INNER JOIN MSP_ASSIGNMENTS_SAVED A ON L.ASSN_UID=A.ASSN_UID
INNER JOIN MSP_PROJECTS P ON L.PROJ_UID=P.PROJ_UID
WHERE T.WPRD_UID=@period
AND L.TS_LINE_VALIDATION_TYPE=1
AND T.RES_UID=@resid
AND L.TS_LINE_CLASS_UID='FCDB0E4E-B9C7-4A39-804F-FA44796F71A0'
ORDER BY P.PROJ_NAME, A.TASK_NAME

- Show quoted text -

 

[Gary L. Chefetz [MVP]]

Yes it's true, that you do need to know the KB number. Unfortunately, the KB
articles are often well behind the hotfixes.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Microsoft said they will only give a hotfix free of charge if you know
the article ID of the hotfix. I searched all of the hotfixes available
online for SharePoint and none of them had this fix. I explained this
to Microsoft and they said "Credit Card Number Please".

Thanks for sharing. Just so you know, hotifxes are no charge for licensed
versions of the software.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

After speaking with some people that were able to solve the problem
with MS Tech Support, they said the solution was an alter proc
statement that prevented the proc from passing null values.

Microsoft still would not give me the hotfix without trying to charge
me $245. Nice marketing tactics there MS - try to charge someone $245
to fix an known issue while they are evaluating the software.

I was able to get the fix from another source.

USE THIS CODE AT YOUR OWN RISK
I highly recommend backing up your database and scripting out a copy
of the procedure before making any changes to your database.

USE [ProjectServer_Published]
GO
/****** Object: StoredProcedure [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData] Script Date:
09/20/2007 11:33:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].
[MSP_WEB_SP_QRY_Statusing_ReadImportTimesheetData]
(
@resid UID,
@period UID
)
AS
SELECT L.TS_LINE_UID, L.ASSN_UID, L.PROJ_UID, A.TASK_NAME,
P.PROJ_NAME, L.TS_LINE_CLASS_UID, C.TS_LINE_CLASS_NAME,
L.TS_LINE_ACT_SUM_VALUE, ISNULL(A.ASSN_ACT_WORK,0) AS ASSN_ACT_WORK,
ISNULL(A.ASSN_WORK,0) AS ASSN_WORK, ISNULL(A.ASSN_PCT_WORK_COMPLETE,0)
AS ASSN_PCT_WORK_COMPLETE, L.TS_LINE_COMMENT
FROM MSP_TIMESHEET_LINES L
INNER JOIN MSP_TIMESHEETS T ON T.TS_UID=L.TS_UID
INNER JOIN MSP_TIMESHEET_CLASSES C ON
C.TS_LINE_CLASS_UID=L.TS_LINE_CLASS_UID
INNER JOIN MSP_ASSIGNMENTS_SAVED A ON L.ASSN_UID=A.ASSN_UID
INNER JOIN MSP_PROJECTS P ON L.PROJ_UID=P.PROJ_UID
WHERE T.WPRD_UID=@period
AND L.TS_LINE_VALIDATION_TYPE=1
AND T.RES_UID=@resid
AND L.TS_LINE_CLASS_UID='FCDB0E4E-B9C7-4A39-804F-FA44796F71A0'
ORDER BY P.PROJ_NAME, A.TASK_NAME

It is likely a corrupt assignment. These occur any time you assign an
additional resource to a task that has already started tracking. I
tell
you
that to help you track it down. Usually, saving the project to XML,
deleting
the project from the server, and importing it back in fixes the
problem.

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

Project Server 2007 Web Access (PWA) -

User clicks 'My Timesheets', enters time. User clicks 'My Tasks' >
'Import Timesheet'. Now it is at a screen that says 'Import
Timesheet'
with '1. Select Timesheet' and '2. Preview'. When they try to select
the most recent timesheet, it fails with this error:

"Go back to site
Error
Unknown Error
Troubleshoot issues with Windows SharePoint Services. "

If they select the older timesheet, it works fine. If it is a user
that has only 1 timesheet, for the most recent week, it fails with
the
above error before it gets to the select timesheet page.

This is a brand new installation of Project Server 2007 with new
test
projects setup in Project Professional 2007.

I've tried deleting/recreating the Projects, and deleting/recreating
the timesheet.

What is the problem?

Some people were saying it is known issue and MS has a hotfix, but
MS
said they will only provid free hotfixes if I have the article ID of
the hotfix. Otherwise, they want $245 to fix their product.- Hide
quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -