Followup - Gary's explanation of the dreaded 005 error - Dashes

I

Irish Sean

Gary - Thank you for your continued active involvement in these discussion
boards... you rock!

I was fascinated with your answer about dashes in project names causing
issues with the View Drop process.

Many of our project names have dashes/hyphens in them. The
timeout/non-publishing issue has come along more recently but does not appear
to have been much of an issue in the past. Are there other factors that may
be contrinuting to this issue - such as:
Volume of schedules
transactions/number of publish attempts?

I read the snippet on microsoft.com about the memory issue if the
VWNotify.exe process is listed but has no CPU time associated with it (while
there are xml files in the view drop folder). We have that symptom. Is this
also caused by hyphens in the name and the subsequent difficulties the
process has with Project Names with Hyphens?

Thanks again for your thoughts!
 
G

Gary L. Chefetz [MVP]

No, the two problems are not related. IMO, the issue with using dashes is
the way the system is localized for various languages. You simply don't know
what magical combination of characters may be combined through the
localization code that might cause SQL to interpret the dash as an operand
rather than charcter data. This seems logical to me as the symptom is not
predictable. So this becomes particulary troublesome with operand
characters - / + *, the list separator (typically comma) and single and
double quotes which can cause misfires as well.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
Top