S
Stephan Steiner
Hi
I'm writing task notes to the ProjectServer 2003 database as described
in Larry's blog (http://blogs.msdn.com/lduff/archive/
2006/08/24/719222.aspx). In addition, I always back up each task by
calling ProjectServer.dbo.MSP_BACKUP_TASK for each task where I'm
writing notes into (as outlined in PJDB.HTM)
There's just one little problem: The Project, seemingly at random,
chokes on those notes. Upon opening the project that contains my task
with notes, I can get a
An import error occurred
Check Row <RowNo> column TASK_RTF_NOTES
error message. The RowNo does not correspond to the row number
(=TASK_ID in the Database), nor to the TASK_UID of the affected task -
in fact I've run into a situation where RowNo was a line number that
doesn't even exist in my project.
If you click to continue importing, you'll then find that some notes
are not shown in the project client (even though in the database,
TASK_HAS_NOTES is set to 1 and the TASK_RTF_NOTES colum contains the
valid RTF text). If you then save the project, TASK_HAS_NOTES is reset
to 0 and TASK_RFT_NOTES is set back to NULL. If however, you do not
save, just close the project, and re-open, if you are lucky all notes
will be shown. It also happens that some notes that weren't shown when
previously opening the project are now being shown, and I've even seen
this error, but the notes would still show up.
The realization, that opening the same project (with no changes being
made anywhere in between), results in different behavior leads me to
the almost conclusion that the contents of the database is a priori
correct and that it's in fact the client that is having issues.
Now I'm wondering, has anybody encountered a similar issue and have
you found a solution for this problem?
Regards
Stephan
I'm writing task notes to the ProjectServer 2003 database as described
in Larry's blog (http://blogs.msdn.com/lduff/archive/
2006/08/24/719222.aspx). In addition, I always back up each task by
calling ProjectServer.dbo.MSP_BACKUP_TASK for each task where I'm
writing notes into (as outlined in PJDB.HTM)
There's just one little problem: The Project, seemingly at random,
chokes on those notes. Upon opening the project that contains my task
with notes, I can get a
An import error occurred
Check Row <RowNo> column TASK_RTF_NOTES
error message. The RowNo does not correspond to the row number
(=TASK_ID in the Database), nor to the TASK_UID of the affected task -
in fact I've run into a situation where RowNo was a line number that
doesn't even exist in my project.
If you click to continue importing, you'll then find that some notes
are not shown in the project client (even though in the database,
TASK_HAS_NOTES is set to 1 and the TASK_RTF_NOTES colum contains the
valid RTF text). If you then save the project, TASK_HAS_NOTES is reset
to 0 and TASK_RFT_NOTES is set back to NULL. If however, you do not
save, just close the project, and re-open, if you are lucky all notes
will be shown. It also happens that some notes that weren't shown when
previously opening the project are now being shown, and I've even seen
this error, but the notes would still show up.
The realization, that opening the same project (with no changes being
made anywhere in between), results in different behavior leads me to
the almost conclusion that the contents of the database is a priori
correct and that it's in fact the client that is having issues.
Now I'm wondering, has anybody encountered a similar issue and have
you found a solution for this problem?
Regards
Stephan