Peter Haik

I have a simple workflow I created in the Sharepoint Designer that pauses until a specified date on the document then sends an email.

I have seen the newsgroup postings saying that there are issues with the actual delay and rehydration, but I seem to be having another issue. As the workflow is running, in the paused state, I cannot go back and edit properties on the document (exception is thrown and I have yet to find the actual exception text).

Am I missing something basic here



Re: SharePoint - Workflow Cannot "Edit Properties" on a document when workflow running

Peter Haik

The exception I /believe/ to be the culprit is the following

01/17/2007 14:21:08.47 mssdmn.exe (0x1F20) 0x11B0 484 880j High
SqlError: 'Could not find stored procedure 'proc_ar_GetCacheInvalidationCountersWithCount'.' Source: '.Net SqlClient Data Provider' Number: 2812 State: 62 Class: 16 Procedure: '' LineNumber: 1 Server: 'xxx'








Re: SharePoint - Workflow Cannot "Edit Properties" on a document when workflow running

Peter Haik

I don't see any procedures in any of the sharepoint databases with the proc_ar_ prefix, and there isn't a single search result on google or yahoo! for the prefix or procedure name.

Does anyone have this procedure Could you post it here

Thanks.





Re: SharePoint - Workflow Cannot "Edit Properties" on a document when workflow running

Peter Haik

Bumping this to the top to see if anyone new has an idea...

Thanks in advance.





Re: SharePoint - Workflow Cannot "Edit Properties" on a document when workflow running

Michael Bunney

I have a MOSS 2007 portal that's logging the same error:

System.Data.SqlClient.SqlException: Could not find stored procedure 'proc_ar_GetCacheInvalidationCountersWithCount'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReade...





Re: SharePoint - Workflow Cannot "Edit Properties" on a document when workflow running

andepers

I have the exact same problem, same error message in my logs. I haven't either been able to find any answer to it anywhere. Anyone having any ideas Is the problem due to the Sharepoint/MOSS installation or is it because of the setup of the SSP
/Anders




Re: SharePoint - Workflow Cannot "Edit Properties" on a document when workflow running

Peter Haik

We left the problem since the original posting, and are now back at a point of dealing with it, have either of you found a solution

Thanks.