P
Prodigal Son
Hi,
We have been querying our project server 2003 database for a while (2
months) without issues. Last week we decided to create stored procedures
rather than use dynmic sql queries in order to improve performance.
Now when we run queries on the timephased data or execute the stored
procedures we are not getting any actuals from last week only actuals prior
to this. These actuals are visible from Project Web Access and Project
Professional but not when queried from the database. I guess that the
database holds these actuals as they are visible in PWA and PP.
Is there any reason why my queries or stored procedures can retrieve some
actuals and not all? All the actauls submitted last week have been accepted
by the project managers and nothing has significantly changed accept the
creation of the stored procedures.
Please help as we are not able to produce reports without this data.
Thanks in advance
Paul
We have been querying our project server 2003 database for a while (2
months) without issues. Last week we decided to create stored procedures
rather than use dynmic sql queries in order to improve performance.
Now when we run queries on the timephased data or execute the stored
procedures we are not getting any actuals from last week only actuals prior
to this. These actuals are visible from Project Web Access and Project
Professional but not when queried from the database. I guess that the
database holds these actuals as they are visible in PWA and PP.
Is there any reason why my queries or stored procedures can retrieve some
actuals and not all? All the actauls submitted last week have been accepted
by the project managers and nothing has significantly changed accept the
creation of the stored procedures.
Please help as we are not able to produce reports without this data.
Thanks in advance
Paul