Problem viewing project schedule details in PWA - Loading data error

[Noynoy]

Hi All,

I have one user who suddenly encountered error when trying to access
the project schedule details in PWA. The Gantt chart view for the
schedule details do not appear. Instead, the box will be empty except
for the "Loading Data" message and in the status bar of the web
browser will flag an "Error on Page" message. The user don't see this
problem when looking at the Project Center view.

I have asked the user to try using other workstations and still with
the same results. I also tried using the user's account on my
workstation and still encounter the same error. However, when I use my
own account, I can view the project schedule detail Gantt chart.

What could be the likely causes of this problem?

Our setup are as follows:

Project Server 2003 SP3
MS SQL Server 2000 SP2

Thanks in advance.

rgds.

Noynoy

 

[ProjmanZA]

Hi All,

I have one user who suddenly encountered error when trying to access
the project schedule details in PWA. The Gantt chart view for the
schedule details do not appear. Instead, the box will be empty except
for the "Loading Data" message and in the status bar of the web
browser will flag an "Error on Page" message. The user don't see this
problem when looking at the Project Center view.

I have asked the user to try using other workstations and still with
the same results. I also tried using the user's account on my
workstation and still encounter the same error. However, when I use my
own account, I can view the project schedule detail Gantt chart.

What could be the likely causes of this problem?

Our setup are as follows:

Project Server 2003 SP3
MS SQL Server 2000 SP2

Thanks in advance.

rgds.

Noynoy

Hi there,

I encountered this same problem a while ago. It works fine with the
users account on another machine but gives problems on his/her own
machine. This notmally points to an IE problem. Check if the user has
any addons like skype toolbar, other search bars loaded in IE as it
has caused issues. If that does not resolve the issue you will have to
look at the project controls in the addons. Try deleting them and
reload them.

If that not work im afraid it means a re install as with IE its never
really uninstalled properly.

Let me know what worked.

Andre

 

[Noynoy]

Hi Andre,

Thanks for the response.

I tried using the user's account on my own machine and experience the
same problem. However, when I use my own login, I don't see any
issues.

I also had the user try to login using a different account in her
machine and the problem never occurs. It is only with her account that
the problem happens. Even if she tries to use her account in a
different machine. I am suspecting there is some data corruption but I
am not sure how to find it.

rgds,

Noynoy

 

[ProjmanZA]

Hi Andre,

Thanks for the response.

I tried using the user's account on my own machine and experience the
same problem. However, when I use my own login, I don't see any
issues.

I also had the user try to login using a different account in her
machine and the problem never occurs. It is only with her account that
the problem happens. Even if she tries to use her account in a
different machine. I am suspecting there is some data corruption but I
am not sure how to find it.

rgds,

Noynoy









- Show quoted text -

Noynoy,

That then tells me that there is a corrupt assignment with her name.
Have a look at this article http://www.eggheadcafe.com/software/aspnet/31825668/my-task-page-error--help.aspx


It will assist you in finding the corrupted data.

Andre

 

[Noynoy]

Noynoy,

That then tells me that there is a corrupt assignment with her name.
Have a look at this articlehttp://www.eggheadcafe.com/software/aspnet/31825668/my-task-page-erro...

It will assist you in finding the corrupted data.

Andre- Hide quoted text -

- Show quoted text -

Hi Andre,

Thanks a lot!

I looked at the SQL script and there were some tables that I cannot
find in my ProjectServer database. I am running PS2003 SP3a.

MSP_TASKS_SAVED
MSP_ASSIGNMENTS_SAVED

I tried replacing these tables with what I have (without the _SAVED)
and I still have problems with the referred fields in the SQL that do
not exist in my tables.

Is the SQL created for other PS version?

rgds,

Noynoy

 

[ProjmanZA]

Hi Andre,

Thanks a lot!

I looked at the SQL script and there were some tables that I cannot
find in my ProjectServer database. I am running PS2003 SP3a.

MSP_TASKS_SAVED
MSP_ASSIGNMENTS_SAVED

I tried replacing these tables with what I have (without the _SAVED)
and I still have problems with the referred fields in the SQL that do
not exist in my tables.

Is the SQL created for other PS version?

rgds,

Noynoy- Hide quoted text -

- Show quoted text -

NoyNoy ,

Look at when the error started to occur. It must have been after a
publish of a project. Open the said project and just remove her name
from the assignee's. Save and republish the project. Then try to go in
again. Even though you have done it i advise you NOT to make changes
in SQL as there as a huge amount of interdependancies between the
tables in the DB. Lets hope you didnt break something

Lemme know how it goes

 

[Harald Guenter]

Hello Noynoy

you have to delete the file Pj11enuC Class or better all Pj*.class and then
go again on a Project web access page containing the Gantt Chart Diagramm
and reload the page. Then this missing element will be downloaded again and
you have to klick yes.
You have to close IE that this file is being released. So you must locate
before where the files are stored when you go under IE internetoptions /
General / Browser history / Options / Show objects. I assume they items are
called so in the English browser - I translated the my german ones.

I got this bug this week and spent a few days to work around it.
It appeared after I clicked on the project list and wanted to sort them
after project managers.
Then later I got the message that there is a problem with pjgrid12.ocx.
After many trials to find and replace this file I finally deleted all my add
ons that were installed in the Internet explorer.
So if it doesn't work in the first run you still have this option.
My Environment: I had Office 2000 and now upgraded to 2003 to use Project
Server 2003.

Good Luck
Harald



-- Posted on news://freenews.netfront.net - Complaints to (e-mail address removed) --

 

[Noynoy]

Hello Noynoy

you have to delete the file Pj11enuC Class or better all Pj*.class and then
go again on a Project web access page containing the Gantt Chart Diagramm
and reload the page. Then this missing element will be downloaded again and
you have to klick yes.
You have to close IE that this file is being released. So you must locate
before where the files are stored when you go under IE internetoptions /
General / Browser history / Options / Show objects. I assume they items are
called so in the English browser - I translated the my german ones.

I got this bug this week and spent a few days to work around it.
It appeared after I clicked on the project list and wanted to sort them
after project managers.
Then later I got the message that there is a problem with pjgrid12.ocx.
After many trials to find and replace this file I finally deleted all my add
ons that were installed in the Internet explorer.
So if it doesn't work in the first run you still have this option.
My Environment: I had Office 2000 and now upgraded to 2003 to use Project
Server 2003.

Good Luck
Harald

-- Posted on news://freenews.netfront.net - Complaints to (e-mail address removed) --

Hi Harald,

Thanks!

I tried your suggestion and I still get the same error.

rgds,

Noynoy