Using free version 1.7. There are 55 actions in the RRD. After creation several weeks ago, the RRD is set to run once/week, and each action emails a report to a designated email address. Every week, the first action on the list successfully gets emailed. On week 1 actions 1,5 & 6 successfully emailed. Next week, only action 1. Following week, actions 1.5,6 again went. Is this a timing issue? Suggestions on how to troubleshoot? I am told that the email addresses are accurate. Willing to go to Pro version if that would be helpful - for support, logging capabilities.

Check the Action tab, see if the "Suppress If No Records" box is checked for each action. If it is, those reports may not be finding any data and therefore aren't shipping. Then you'd presumably have a report issue to troubleshoot.

Yes, the box is checked. Seems like you'd want that to happen - not send a blank report. If that's what's happening, would the execution of the RRD and therefore the rest of the actions within it stop?

If I uncheck it, what would be the effect - will it send blank reports to the addressee?

Additional info: when I tried to execute the RRd by double-clicking, the first action succeeded, then I got messages "the process cannot access the file . . . because it is being used by another process (emailCrystalReport).

Does that give you more clues?

It wouldn't stop the RRD, no. But since 1, 5, and 6 are running, that suggests the RRD is not stopping/failing on 2, 3, or 4. My next thought was that there could be a problem with the underlying report.

Are all the actions different reports or the same report to different addresses?

Here's what I'd do next. Make a copy of the RRD and open it in Notepad. Remove all but the first seven actions. Open it in Solution Builder and set each action to email to you, and uncheck the Suppress If No Records box. Now execute the copied RRD. See what happens with 2, 3, 4, and 7. It might give you some clue as to what's going wrong.

Okay, that update changes things. Are all the actions running different reports or the same report to different addresses?

It is the same report being sent to different addresses.

Huh. Well, that shoots every theory I had out of the water. It sounds like some kind of timing issue where it's trying to perform the next action before the previous action has released the file. I can't say I've seen that before. I wish I could be of more help, but it sounds like the Logicity folks will need to answer that one.

Weeks afterwards, but it seems good to cover off all the bases on this...

When Solution Builder emails out a file, it saves a temp version of it locally which it then picks up. The deletion of this can sometimes be a little delayed before the next action starts, so if you're using the same file name for all of the sent reports, it might be trying to save over a file which is currently being sent by the previous action.

Try selecting unique file names on the action tab and see if the same error still appears. If it does, I'm at a loss as to what to check next!

Cheers,

Andrew