Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a SP 2010 workflow that prompts information from the users, and a timer job which reads data from a constantly-updated DB. They both add data to another list item that stores the most recent business information.

Edit: To clarify, these list items are a sort of dashboard that aggregate information from several sources. Thus, both the workflows and the timer job will access the same list item (but the items will be different for different workflow instances). The workflow and the timer job will modify different fields.

Is there any chance of synchronization errors between the concurrent updates? Can user-entered information be lost? How do I go about synchronizing the workflow and timer job, and what other pitfalls should I look out for? Thanks.

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

There is a chance of a Save Conflict if the timer job saves an edit while the user has the edit screen open. It's really a warning message, but it looks like an error and generally you want to avoid it. Have you looked into external data columns? That is a good way to pull in data from a database without timer jobs.

share|improve this answer
    
Thanks. To be safe, I'll probably just have the workflow dump the data to another DB table, and then have the timer job populate the dashboard all in one go. –  Mihai Jul 18 '11 at 14:09
    
Glad I could help. As an alternative, I'm a big fan of Business Connectivity Services for connecting to databases from SharePoint. –  Tom Resing Jul 19 '11 at 1:21
add comment

I don't get your question completely:

  • is the data from the workflow stored in the same list as the data from the timer job?

if not, you can go with the BCS and show the database data in an external list.

if the data is stored in the same list: if both methods just both add data, i don't think it will bug out. New items will not overwrite other items that are being added, the SP object model handles it.

My question is: why would you put that two types of information in one list? need to edit it? or do you need to show the combination of data to a user?

share|improve this answer
    
Added clarification. –  Mihai Jul 15 '11 at 15:51
    
I don't see any problems on synchronization errors or something like that. –  Bas Lijten Jul 15 '11 at 18:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.