Hello All ,
I will start with a big disclaimer :
2012/09/05
I have did something bad
2012/08/15
How to Overwrite a project (properly)
Hello
This is a quick post for an Issue that i have faced today (not actually an Issue but something the user couldn't do)
2012/08/07
Project Server 2013 good news and bad news
Hi ,
I was going through project online and looking for any
changes and if any of the things that we usually struggle with have changed, I was
more than happy to notice allow multiple lines in timesheet administrative
tasks as you can notice below
2012/08/01
SSRS Error
Hi All
I know it should be about project server 2010 but for this im making a small change and i just want to mention a small error that consumed some of my time trying to figure it out in SQL reporting service .
so basically i was creating a custom report for one of our clients , did a small modification on my SQL statement and let the fun begin the error below appeared
and as you can notice the error message is not helpful not in any way but apparently it was an issue with my Query which is running perfectly on SQL and on the query designer retrieving the data with no issues
my SQL was something like this (just an example)
SELECT p.TaskDate , p.TaskName , x.TaskDate FROM
Table1 p JOIN Table2 x on p.TaskDate = x.TaskDate
the query will never have a problem on SQL or with the query designer ,
but the problem is SQL reporting service couldn't handle the same column name generated so you need to use aliases , just do that and you are good to go
Cheers hope this will help
Malek
I know it should be about project server 2010 but for this im making a small change and i just want to mention a small error that consumed some of my time trying to figure it out in SQL reporting service .
so basically i was creating a custom report for one of our clients , did a small modification on my SQL statement and let the fun begin the error below appeared
 |
| 2 hours wasted |
and as you can notice the error message is not helpful not in any way but apparently it was an issue with my Query which is running perfectly on SQL and on the query designer retrieving the data with no issues
my SQL was something like this (just an example)
SELECT p.TaskDate , p.TaskName , x.TaskDate FROM
Table1 p JOIN Table2 x on p.TaskDate = x.TaskDate
the query will never have a problem on SQL or with the query designer ,
but the problem is SQL reporting service couldn't handle the same column name generated so you need to use aliases , just do that and you are good to go
Cheers hope this will help
Malek
2011/01/09
Status Manager
Since this morning i have been straggling with the status manager problem .
the Project summary task status manager was the Server admin and not the owner .
this caused that some of the users trying to submit new assignments but its going to the project owner .
after trying for like 3 hours to change the status manager on the summery task and the simple solution is
the summery task status manager is the last user who published the project :D
hope this will help you
the Project summary task status manager was the Server admin and not the owner .
this caused that some of the users trying to submit new assignments but its going to the project owner .
after trying for like 3 hours to change the status manager on the summery task and the simple solution is
the summery task status manager is the last user who published the project :D
hope this will help you
2010/11/28
Timesheet Incorrect mode
Hello
recently i was facing a problem with some timesheets failing in the queue and no solution could be found in Google .
Basically the error reason is unknown and the error code is not clear , maybe it is generated after the latest update from Microsoft but anyway lets handle it
The error details are below
Queue type : Timesheet
Job Type : Timesheet Submit
In the error description you can see “Incorrect timesheet mode”
So after I looked over and over and couldn’t find a solution I made the biggest no in the Project server …. Yes I canceled the job from the queue and then I refreshed the timesheet and it turned into green and the status was approved and everything is perfect .
So far this is the solution I came up with and the data seams ok and no more problems is coming up
recently i was facing a problem with some timesheets failing in the queue and no solution could be found in Google .
Basically the error reason is unknown and the error code is not clear , maybe it is generated after the latest update from Microsoft but anyway lets handle it
The error details are below
Queue type : Timesheet
Job Type : Timesheet Submit
In the error description you can see “Incorrect timesheet mode”
So after I looked over and over and couldn’t find a solution I made the biggest no in the Project server …. Yes I canceled the job from the queue and then I refreshed the timesheet and it turned into green and the status was approved and everything is perfect .
So far this is the solution I came up with and the data seams ok and no more problems is coming up
2010/08/05
project server 2007 migrate to project server 2010
Ok, to make a long story short we are implementing project server 2010 for a client who we have already implemented project server 2007 so typically we need to migrate the current server .
so we started by studying our options the in place upgrade was eliminated project server 2007 was installed over 2003 server so i ended up asking my college to start a core upgrade following Microsoft steps
http://technet.microsoft.com/en-us/library/ee662499.aspx
and for some reason once we provision the PWA we end up with a provision failure and no luck for 2 days , the upgrade logs showed that the data base conversion went on with 0 errors and 0 warnings . but still the PWA couldn't provision correctly we went over Microsoft instructions over and over and step by step with no luck .
so to resolve this issue i done the following
1-i followed the steps again until i got the provision error
2-provision a new 2010 PWA
3-replace the new 2010 PWA databases with the converted data bases from the 2007
and we ended up with a working project web application still we didn't fully test it but at least we have something to start with
so we started by studying our options the in place upgrade was eliminated project server 2007 was installed over 2003 server so i ended up asking my college to start a core upgrade following Microsoft steps
http://technet.microsoft.com/en-us/library/ee662499.aspx
and for some reason once we provision the PWA we end up with a provision failure and no luck for 2 days , the upgrade logs showed that the data base conversion went on with 0 errors and 0 warnings . but still the PWA couldn't provision correctly we went over Microsoft instructions over and over and step by step with no luck .
so to resolve this issue i done the following
1-i followed the steps again until i got the provision error
2-provision a new 2010 PWA
3-replace the new 2010 PWA databases with the converted data bases from the 2007
and we ended up with a working project web application still we didn't fully test it but at least we have something to start with
Subscribe to:
Posts (Atom)