Procedure is skipping some steps

A week or so ago our overnight procedure has started skipping some steps - so for example it performs data reads 2, 3, 4, 5, 7, 8 etc but misses #1 and #6. These data readers can be run manually and there does not appear to be anything wrong with them. They're not disabled in the procedure.

Does anyone have any ideas on what might be the cause of this? It's obviously extremely problematic!

Find more posts tagged with

Accepted answers

All comments

Ravichandra Aj

Victoria Walton if you debug the procedure. you will find your problem root cause.

Procedure Debugger

Regards,

Ravi

Joris van den Boogaard

Victoria Walton, In addition to Ravichandra Aj 's comment. You could test the different behaviors of your procedure when selecting other 'On Stop Behavior'.

It could be that overnight, procedure #1 and #6 experience run-time or timeout errors.

Pablo Luis Rodriguez Longhi

Some time ago I had the same issue.

The data reader work fine, everything looks fine... so I inactivate the line in the procedure and create a new one exactly as the old one. And the procedure started working fine all steps.

This happened not only in one procedure and in one database at the same time. I don't know what is the problem but this workaround solve it.

Regards,

Pablo

Previous Member

Thank you everyone for your comments. With some big help from Board support, the issue we eventually identified was that our database was corrupted because two different data readers tried to run at the same time. This had caused duplicate entity values to be created in our main product entity, and readers involving that entity no longer ran properly (and created more duplicates when they did run).

Solution is to extract all entities, trees and cubes and re-import them. At least I hope so!