RE: Status Report Notification

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi Jay,
\par
\par Please do not delete these records from the database, we just needed to have a peek at what's there. ANY direct manipulation (adding, deleting, modifying) of the data for ProjectServer is ALWAYS a last ditch effort.
\par
\par Please also tell me exactly HOW you deleted the status report originally. What were the exact steps that you followed?
\par
\par I understand that when you run the query:
\par
\par Use ProjectServer
\par Go
\par select * from MSP_WEB_STATUS_REPORTS
\par
\par You see two records.
\par
\par Locate the status report in question in the WREPORT_NAME field then check the WREPORT_IS_ENABLED field and confirm whether it's 0 or 1.
\par
\par IF the WREPORT_IS_ENABLED field is 0, it's been deleted, if 1 it's still active. If the 'deleted' report is showing as 1, we can first check to make the setting in PWA.
\par
\par 1) PWA > Status Reports
\par 2) Delete a status report so your team members no longer have to respond to it
\par 3) Select the correct WREPORT_NAME from the dropdown
\par 4) Click OK twice.
\par
\par This will update the WREPORT_IS_ENABLED field to 0, and you should no longer receive notifications.
\par
\par If for some reason you are not able to perform the above steps in PWA, then you may consider manually updating the record in the database. Again, this is a last resort, and a bigger concern is how did the problem happen like this.
\par
\par update msp_web_status_reports set wreport_is_enabled=1 where wreport_name = '<your report name here>'
\par
\par Please note that when you delete 'status reports' in the PWA Clean up Project Server database page, you are only deleting submitted reports, not the actual request.
\par
\par Please let me know if this helps.
\par
\par Best,
\par Dana
\par
\par Dana Brash [MSFT]
\par
\par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
\par =====================================================
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par
\par \pard\li720 --------------------
\par Thread-Topic: Status Report Notification
\par thread-index: AcXmMwQvg5XY/82eQSq0KX4QZClOhw==
\par X-WBNR-Posting-Host: 204.4.13.72
\par From: =?Utf-8?B?SmF5?= <fjm@xxxxxxxxxxxxxx>
\par References: <F2952271-793A-4E44-98C8-9A98F7BD3E7F@xxxxxxxxxxxxx> <zUuCfE23FHA.1172@xxxxxxxxxxxxxxxxxxxxx> <6A85A105-8483-4120-9D5A-D02635737904@xxxxxxxxxxxxx> <uUGYxU04FHA.1172@xxxxxxxxxxxxxxxxxxxxx>
\par Subject: RE: Status Report Notification
\par Date: Thu, 10 Nov 2005 12:12:03 -0800
\par Lines: 281
\par Message-ID: <CA670D32-1662-4DDF-AF9E-6008FB78C24E@xxxxxxxxxxxxx>
\par MIME-Version: 1.0
\par Content-Type: text/plain;
\par \tab charset="Utf-8"
\par Content-Transfer-Encoding: 7bit
\par X-Newsreader: Microsoft CDO for Windows 2000
\par Content-Class: urn:content-classes:message
\par Importance: normal
\par Priority: normal
\par X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
\par Newsgroups: microsoft.public.sharepoint.teamservices
\par NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
\par Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
\par Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sharepoint.teamservices:22763
\par X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par
\par I've run the query and the report has two entries in the table. Can I simply
\par delete the two entries to resolve the problem?
\par --
\par Jay, MCP
\par
\par
\par ""Dana Brash"" wrote:
\par
\par > Hello Jay,
\par >
\par > Please let me know what you find with running the query and looking into
\par > the other potential environmental issues I mentioned previously.
\par >
\par > As this is really a Project question, I'm unsure as to why you would be
\par > directed to post in the SharePoint newsgroup, particularly as you have a
\par > way to the correct newsgroup (starting from non-managed). I would like to
\par > follow up with the specific case where you were told to post to this group.
\par > If possible, could you tell me the NG, initial post date, and subject line
\par > of the thread where you were given this information?
\par >
\par > Also, if you use Outlook Express, or another direct newsgroup reader, you
\par > should be able to go directly to the public newgroups at
\par > microsoft.public.... Using IE, you can also directly access all Office
\par > newsgroups at
\par > http://www.microsoft.com/office/community/en-us/default.mspx?d=1, including
\par > the groups for Project and Project Server.
\par >
\par > microsoft.public.project.server can be accessed directly here:
\par > http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.pu
\par > blic.project.server&lang=en&cr=US
\par >
\par > Please let me know as you get more information. I look forward to hearing
\par > back from you.
\par >
\par > Best,
\par > Dana
\par >
\par > Dana Brash [MSFT]
\par >
\par > When responding to posts, please "Reply to Group" via your newsreader so
\par > that others may learn and benefit from your issue.
\par > =====================================================
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par >
\par > --------------------
\par > Thread-Topic: Status Report Notification
\par > thread-index: AcXhfdkcHm4JM/E0SvOOWDyQQhFo4w==
\par > X-WBNR-Posting-Host: 204.4.13.72
\par > From: =?Utf-8?B?SmF5?= <fjm@xxxxxxxxxxxxxx>
\par > References: <F2952271-793A-4E44-98C8-9A98F7BD3E7F@xxxxxxxxxxxxx>
\par > <zUuCfE23FHA.1172@xxxxxxxxxxxxxxxxxxxxx>
\par > Subject: RE: Status Report Notification
\par > Date: Fri, 4 Nov 2005 12:25:07 -0800
\par > Lines: 190
\par > Message-ID: <6A85A105-8483-4120-9D5A-D02635737904@xxxxxxxxxxxxx>
\par > MIME-Version: 1.0
\par > Content-Type: text/plain;
\par > \tab charset="Utf-8"
\par > Content-Transfer-Encoding: 7bit
\par > X-Newsreader: Microsoft CDO for Windows 2000
\par > Content-Class: urn:content-classes:message
\par > Importance: normal
\par > Priority: normal
\par > X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
\par > Newsgroups: microsoft.public.sharepoint.teamservices
\par > NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
\par > Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
\par > Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sharepoint.teamservices:3535
\par > X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par >
\par > I run the query you suggested to see that it was deleted from the table.
\par > SP1
\par > has been installed since it was released in 2004 and the client SP1 was
\par > slipstreamed into our Project Pro image so all users are running that as
\par > well. I have a feeling I'll find that the report wasn't actually removed
\par > from the table.
\par >
\par > I'll let you know what I find.... thank you for following up.
\par >
\par > As far as the NG is concerned I'm accessing them from
\par > http://www.microsoft.com/technet/community/newsgroups/managed/dgbrowser/en-u
\par > s/default.mspx?dg=microsoft.public.sharepoint.teamservices&mid=c50653dc-3097
\par > -4026-9ae1-df42271cf7aa
\par > which has an expanding menu on the left, none of the project news groups
\par > show
\par > there. If you start from the Non-managed newsgroups link then you are able
\par > to see the Project groups. It's very strange. I reported this to the NG
\par > managers some time ago and it's still not resolved. They stated I should
\par > post on the Sharepoint groups even though this issue is not Sharepoint
\par > related.
\par > --
\par > Jay, MCP
\par >
\par >
\par > ""Dana Brash"" wrote:
\par >
\par > > Hi Jay,
\par > >
\par > > Thanks for looking for the Project newsgroups. It's interesting that
\par > > you're not able to see the microsoft.public.project or
\par > > microsoft.public.project.server newsgroups, though I'm sure your support
\par > > case will manage to get that sorted out. Regardless, I'm happy to work
\par > > with you here on this problem.
\par > >
\par > > From your post, my understanding of this issue is: a user is receiving
\par > > reminders to submit status reports that have been deleted. If this is
\par > not
\par > > correct, please feel free to let me know.
\par > >
\par > > I'd like to confirm that you've got the latest updates installed for the
\par > > system. There are some known issues with SP2 for Project Server at this
\par > > point related to RBS, so I am recommending that users continue with SP1
\par > > until these issues are resolved.Please apply both server and client
\par > service
\par > > packs and retest the problem. You can find more information here:
\par > >
\par > > Description of Project Server 2003 Service Pack 1
\par > > http://support.microsoft.com/?id=837241
\par > >
\par > > Please see the "Determine whether the service pack is installed " link in
\par > > the above article for information about determining the version and the
\par > > build number of Project Server 2003 that is installed on the server.
\par > > For the SQL installation of Project Server SP1, confirm that the correct
\par > > .sql files are installed on the system.
\par > >
\par > > SP1 should display something along the lines of 11.1.2004.0.1707.15.
\par > >
\par > > Project Server 2003 SP1:
\par > >
\par > http://www.microsoft.com/downloads/details.aspx?familyid=5dea5862-d534-4f17-
\par > > ab08-7c9b790c5b15&displaylang=en
\par > >
\par > > Project 2003 SP1:
\par > >
\par > http://www.microsoft.com/downloads/details.aspx?familyid=1b04c073-e58f-4f42-
\par > > b76d-6b565a45cdc3&displaylang=en
\par > >
\par > > If you would like to check the database to see whether the status report
\par > is
\par > > still in the dataset, you can try the below query in Query Analyzer:
\par > >
\par > > Please run the below query to confirm that the status report has truly
\par > been
\par > > deleted:
\par > >
\par > > Use ProjectServer
\par > > Go
\par > > select * from MSP_WEB_STATUS_REPORTS
\par > >
\par > > You can review the WREPORT_NAME field for the name of the deleted status
\par > > report.
\par > >
\par > > ** NOTE: This programming example is provided for illustration only,
\par > > without warranty either expressed or implied, including, but not limited
\par > > to, the implied warranties of merchantability and/or fitness for a
\par > > particular purpose. This assumes that you are familiar with the
\par > programming
\par > > language being demonstrated and the tools used to create and debug
\par > > procedures. Microsoft support professionals can help explain the
\par > > functionality of a particular procedure, but they will not modify these
\par > > examples to provide added functionality or construct procedures to meet
\par > > your specific needs. If you have limited programming experience, you may
\par > > want to contact a Microsoft Certified Partner or the Microsoft fee-based
\par > > consulting line at (800) 936-5200. For more information about Microsoft
\par > > Certified Partners, please visit the following Microsoft Web site: \tab
\par > > http://www.microsoft.com/partner/referral/
\par > >
\par > > For more information about the support options that are available and
\par > > about how to contact Microsoft, visit the following Microsoft Web site:
\par > > http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
\par > >
\par > > I would like to check a couple of obvious thing with you. I noticed a
\par > > similar case, where both the Support Engineer and the contact on the
\par > > customer side were very experienced and savvy. After about a month of
\par > > working on the problem and trying numerous things, it turned out to be an
\par > > old copy of the database running on a testing server that was sending the
\par > > reminders. So, I'd like to make sure we're not running into something
\par > > obvious like that. =)
\par > >
\par > > Another case had the users reporting that the reminders were from a
\par > deleted
\par > > status report, but the report showed up in the PWA > Status reports >
\par > > Status reports archive list. Please have the user confirm in PWA that
\par > the
\par > > status report in question is not in this list.
\par > >
\par > > I believe that this problem should be resolved by either applying Service
\par > > Pack 1, or that we will find a different problem in the environment.
\par > > However, it is entirely possible that there is something else going on,
\par > > which will require extensive, in-depth analysis of both your environment
\par > > and your data.
\par > >
\par > > Based on my experience, a problem as complex as this may take extensive
\par > > time to narrow down. If the issue is urgent, you may want to work with
\par > > Microsoft Customer Service and Support (CSS) for a faster resolution.
\par > Once
\par > > you open a Support incident with Microsoft CSS, a dedicated Support
\par > > Professional can work with you in a more efficient manner.
\par > >
\par > > NOTE: Our private partner newsgroup is focused on break fix issues that
\par > are
\par > > neither urgent, nor complex. If the issue is urgent to your business, it
\par > is
\par > > recommended that you contact Microsoft Customer Support Services (CSS)
\par > via
\par > > telephone so that a dedicated Support Professional can help you resolve
\par > > your issue in a more efficient manner. Please be advised that contacting
\par > > phone support will be a charged call.
\par > >
\par > > To obtain the phone numbers for a specific technology request please take
\par > a
\par > > look at the web site listed below.
\par > > <http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS>
\par > >
\par > > If you are outside the US please see http://support.microsoft.com for
\par > > regional support phone numbers.
\par > >
\par > > Please let me know your progress with the above information so that I can
\par > > provide further assistance on this problem. I look forward to your reply.
\par > >
\par > > Hope this helps!
\par > >
\par > > Sincerely,
\par > >
\par > > Dana Brash
\par > > Microsoft Online Partner Support
\par > >
\par > > When responding to posts, please "Reply to Group" via your newsreader so
\par > > that others may learn and benefit from your issue.
\par > > =====================================================
\par > > This posting is provided "AS IS" with no warranties, and confers no
\par > rights.
\par > >
\par > >
\par > > --------------------
\par > > Thread-Topic: Status Report Notification
\par > > thread-index: AcXe9IcsrBZnHNjgQiuXM9+7Y9gpDA==
\par > > X-WBNR-Posting-Host: 204.4.13.72
\par > > From: =?Utf-8?B?SmF5?= <fjm@xxxxxxxxxxxxxx>
\par > > Subject: Status Report Notification
\par > > Date: Tue, 1 Nov 2005 06:57:07 -0800
\par > > Lines: 19
\par > > Message-ID: <F2952271-793A-4E44-98C8-9A98F7BD3E7F@xxxxxxxxxxxxx>
\par > > MIME-Version: 1.0
\par > > Content-Type: text/plain;
\par > > \tab charset="Utf-8"
\par > > Content-Transfer-Encoding: 7bit
\par > > X-Newsreader: Microsoft CDO for Windows 2000
\par > > Content-Class: urn:content-classes:message
\par > > Importance: normal
\par > > Priority: normal
\par > > X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
\par > > Newsgroups: microsoft.public.sharepoint.teamservices
\par > > NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
\par > > Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
\par > > Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sharepoint.teamservices:3517
\par > > X-Tomcat-NG: microsoft.public.sharepoint.teamservices
\par > >
\par > > This is the Third Time I've posted this!
\par > >
\par > > I am posting this here because there is no Project Server newgroup in the
\par > > Managed lists. I've already talked to support about this and they are
\par > > looking to see why that group is not here. They told me to post it under
\par > > sharepoint.
\par > >
\par > >
\par > > We have a Project user who continually gets notifications from project
\par > > server for a Status Report which has been cancelled and deleted from the
\par > > system for 6 months or more. I have delete the report request from the
\par > > system and even disabled the report requstors accont (he no longer works
\par > > for
\par > > us) yet she still recieves daily emails that the report is due.
\par > >
\par > > BTW all servers (Project Server, SQL and WSS) reside on the same physical
\par > > server.
\par > >
\par > > --
\par > > Jay, MCP
\par > >
\par >
\par \pard
\par
\par }