Deleting Notifications in AX2012

(0) Share

Report

Posted on by Community Member

Hi,

Can anybody tell me how to delete the old notifications in my user account. one or two years back I have created some batch jobs from my user name and I have enabled the option of notification when it gets ended and getting any errors. The batch jobs were for pulling the data from my shops and I put the frequency every 30 minutes and I got so many shops. So what has happened is since then all these notifications are piled up and now it is taking too much time for me to login to my account. The message queue is showing millions of records. How can I delete these old notifications? Is it possible to delete it from Table level?

I tried the option in system administration but nothing is happening. It is just getting frozen and nothing is deleting.

Your help is very much appreciated.

Thanks,

Dhanoop R.Warrier

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (2)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

you may use Notification Cleanup form that provides the option to use it as batch job.

In addition have a look at a blog post, which is old for ax 2009, but still valid.

setting up batch job for this can make life easy, else you have to run it manually and wait for it get finished.

Was this reply helpful? Yes No
Suggested answer

Iulian Cordobin 8,201 on at

Like (1)

Report

Yes, you should be able to use this code: (just create an empty class in your AOT, with an empty method and then copy / paste over the following code):

public static void main(Args _args)
{
    EventInbox      eventInbox;
    EventInboxData eventInboxData;

    date        deleteUntil = systemDateGet() - 90;
    utcDateTime utcDeleteUntil = DateTimeUtil::newDateTime(deleteUntil, 0);

    eventInbox.skipDataMethods(true);
    eventInbox.skipDeleteActions(true);
    eventInbox.skipDeleteMethod(true);


    ttsbegin;

    delete_from eventInboxData
    exists join eventInbox
        where eventInboxData.InboxId == eventInbox.InboxId &&
              eventInbox.UserId == curUserId() &&
              eventInbox.AlertCreatedDateTime <= utcDeleteUntil;

    delete_from eventInbox
        where eventInbox.UserId == curUserId() &&
              eventInbox.AlertCreatedDateTime <= utcDeleteUntil;

ttscommit;


    info('Done');
}

This will delete the alerts up to a specific date (here you have current date - 90 days) for your user (the user running this code).

To run this just hit Run (or open) in the class. It's the same as a job, but we are doing this in a class, preparing for the next AX version.

On a live system, use this at your own risk (usual disclaimer).

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Sohaib,

I have already tried the option of notification cleanup but it is taking too much time and application is getting frozen and nothing is deleting after so many time.

If there any option in database level, it is more convenient for me.

Thanks,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Lulian,

Thanks for the suggestion. But let me ask you if there is any option to delete the same from database. I am not familiar with AOT classes.

Thanks,

Dhanoop R.Warrier

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

I was about to mention that Sohaib's option of using the standard periodic task is also a perfect way to go, without the hassle of writing code.

However, you can use the writing code approach if that gets the job done faster.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

if you want to delete by x++ code or sql server you can do it as below

basically we need to delete data from two tables.

a) EventInbox

b) EventInboxData

Make sure to delete EventInboxData, prior to deleting from EventInbox

following can be sequence of deletion

1) set status of EventInbox.SendEmail = 0/false

2) delete related records of EventInboxData (based on relationship of two tables)

3) delete records of EventInbox

Was this reply helpful? Yes No
Verified answer

Iulian Cordobin 8,201 on at

Like (1)

Report

Alright. Yes, you can do that from SSMS, just get a query like:

USE MicrosoftDynamicsAx

truncate table EventInboxData -- fastest option, drops all data in the alerts table

truncate table EventInbox -- fastest option, drops all data in the alerts table

-- delete from EventInboxData -- where add where conditions if you need to

-- delete from EventInbox -- where add where conditions if you need to

But be careful in using this when connected directly to your sql dbs.

Note: I have forgot that there is a EventInboxData table in my initial post, so depending on whether you want to still retain some alerts, you may needs to apply some logic to your T-SQL where clauses.

The question is: do you want to keep some data, or wipe them all?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Lulian,

I want to wipe the notification which I have created from my id only. Others can be remained.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sohaib & Lulian,

I have deleted only from the table "eventinbox" where I put the criteria my user name. Once it is finished I found that notifications have been deleted from my user name and other users notifications are there. Is that alright? May I need to delete from "eventinboxdata" as well?

Thanks,

Dhanoop Warrier

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

This table (EventInbox) does not have CreatedBy enabled, in standard AX. So, unless you have not enabled this field (CreatedBy), we cannot filter it with the way as you require(records created by you)

Edit:

if you will enable now(CreatedBy) there will not be any change on historical data or previously created records.

Was this reply helpful? Yes No