Prefix "<>\" destroys my database

[Hans Wurst]

Hi folks,

that's a nice X-MAS gift!

Projectmanagers startet complaining that they can't open their projects.
Next thing was that while appoving the actuals there was an error message
saying the actuals of the Project "<>\projectname" can't be approved because
the project manager has no rights for that project.

The thing is that all projects are renamed in the database and have this <>\
- prefix. Therefore the security is not working any more. Because Mr.
Projektmanager has just the rights for project "projectname" and not for
"<>\projectname".

As a adnministrator I can open the project, but even republishing does not
remove the <>\-prefix.

Has anyone an idea?

Would also be a nice X-MAS gift. :-S

Michael

 

[Hans Wurst]

problem solved - was another problem and had nothing to do with the prefix <>\

 

[Dale Howard [MVP]]

Hans --

Why don't you tell us what other problem caused this problem?

 

[mark.everett]

Hans -

It looks as if the database has somehow become corrupted with those
special characters. Those characters are "forbidden" in SQL, so you
should probably investigate how they got there in the first place.

I would ask a DBA to edit the project name field to remove the special
characters from one project and see if that fixes it. If it does, then
edit the rest of them.

Also review the Event Logs for the servers.

Mark Everett | PMP

 

[Hans Wurst]

Hi Dale -

someone dechecked the checkbox allowing the projectmanager to open their own
projects. Of course noone did it :-D

But it tokk me a while to find that out. The errormessage is a bit
confusing, because MSP says you're not allowed to open the project named
"<>\projectname". I thought: OK, that project has another name so project
can't remember the name and therefore the rights belonging to it.

On a backup I saw then that's it's regurlar fpr the MSP_projects table to
habe these "<>\" in the columns - so I found the real mistake... :-D (happy
it was that easy and not a real DB-error)

 

[Hans Wurst]

Mark, thanks a lot for your suggestion.

It's stored in the column Proj_Project in the msp_projects - table.

Renaming is not a good idea, because project does not find the project
anymore then.

I guess I leave it like that.... but thank's!

 

[Gary L. Chefetz [MVP]]

Mark:

The prefix is standard. This is not corruption.

 

[Dale Howard [MVP]]

Hans --

Thanks for sharing the cause of and solution to the problem. This helps
everyone to learn from your experience!