Problem with EventInBox, EventInBoxData tables on Workflows (Sandbox)

(0) Share

Report

Posted on by Pedro-Rodriguez

251

Hi,

I am testing Workflows on a Sandbox with demo data and from one day they do not work any more as they get to an duplicate create error on EventInBoxData.

I have access with SQL Management Studio to the database but I have no rights to delete the data in there.

There is a way to delete this data? The periodic job delete event data, do not clear this completely.

If not, then it is a case for support?

Thanks

All responses (5)

Answers (1)

Pedro-Rodriguez 251 on at

Like (0)

Report

RE: Problem with EventInBox, EventInBoxData tables on Workflows (Sandbox)

Yes. I will rise a support case as I still have some time until I need this solved. If the case were more urgent I would go for the script option.
Verified answer

nunomaia 11 Moderator on at

Like (0)

Report

RE: Problem with EventInBox, EventInBoxData tables on Workflows (Sandbox)

For inconsistent data, you can raise a ticket in MS to clean data if you don't want to create scripts. Microsoft cleans data without any problems. Once, we had an issue, and it was recommended to force cleaning data from MS side.
GirishS 27,825 Moderator on at

Like (0)

Report

RE: Problem with EventInBox, EventInBoxData tables on Workflows (Sandbox)

Hi Pedro-Rodriguez,

Then you need to write custom scripts to force delete the records in EventInbox and EventInboxData tables.

Thanks,

Girish S.
Pedro-Rodriguez 251 on at

Like (0)

Report

RE: Problem with EventInBox, EventInBoxData tables on Workflows (Sandbox)

Yes. I already did that. Most of the entries were deleted but not the ones that cause problems. Also it seems that there is a lot of inconsistent data in EventInBoxData.
nunomaia 11 Moderator on at

Like (0)

Report

RE: Problem with EventInBox, EventInBoxData tables on Workflows (Sandbox)

Did you tried to execute System administration / Periodic / Notification clean-up ?