transaction handling in XI

[Former Member]

hi guys;

What I am trying to look is XI tries to insert data in database and some error happens while inserting data so how xi rolls back the trasaction and how can we write a logic to send a email about this error to any person.

[bhavesh_kantilal]

Mudit,

<i>how can we write a logic to send a email about this error to any person.</i>

You can create Alerts, which will trap all errors occuring in your process and send an email to the necessary person.

To create alerts , this blog can help you out,

/people/michal.krawczyk2/blog/2005/09/09/xi-alerts--step-by-step

From SP14 onwards, activation of end to end monitoring is not needed for Alerting. Refer to this note 870232 for this info.

If you are blow SP14, then also check this blog,

/people/michal.krawczyk2/blog/2005/09/09/xi-alerts--troubleshooting-guide

To send an EMAIL, assign an EMAIL ID to the corresponding user in the transaction SU01 and then set up SCOT and you can send emails when the ALERT is triggered.

<i>some error happens while inserting data so how xi rolls back the trasaction</i> Internally , you can set the TRANSCATON handling of XI. Mostly, this transcation handling for errors dyuring insertion is handled by the Database itself.

Regards,

Bhavesh

[Former Member]

Hi Mudit,

<i>some error happens while inserting data so how xi rolls back the trasaction</i>

whenever the JDBC adapter is trying to post the data if an error happens the data by default will not get uploaded and there will be error in the adapter.

For error handling, SAP XI has standard config to raise error in Adapter framework, Integration engine etc. If you want to send the error by mail you will have to use BPM for the same.

<i>and how can we write a logic to send a email about this error to any person.</i>

You can capture the error using BPM and use mail adapter to send the mail .

Regards

Vijaya

[Former Member]

thanx for you reply bhavesh;

<i>To send an EMAIL, assign an EMAIL ID to the corresponding user in the transaction SU01 and then set up SCOT and you can send emails when the ALERT is triggered.</i>

Can you please explain this in a little more detail abt the steps.

[bhavesh_kantilal]

Mudit,

Once you have configure Alerts, you will get the Alerts into ALERT INBOX in RWB of the user. To also get the email, the following needs to be done,

1. In <b>SU01</b> -- Assign the <b>Email ID</b> for the Recipient of the ALERT.

2. In , <b>RWB>ALERT INBOX> PERSONALIZATION--> Time Independent Delivery and Email</b> are selected.

3. Finally,<b> SCOT</b> needs to be set up to send Emails. Check this for the same. You can ask your BASIS team to do this step.

http://help.sap.com/saphelp_nw04/helpdata/en/23/1edf098ea211d2b47300609419ed29/frameset.htm

Also, to test your Alerts, execute the report<b> RSALERTTEST</b> in <b>SE38.</b>

Regards,

Bhavesh

[Former Member]

hi;

According to michals web log i did steps 1,2,3 but am not able to find a window for doing step 4(Adding ourself to receivers list).Can anyone help me in this matter.

[bhavesh_kantilal]

Mudit,

While defining your ALERT CATROGRY in ALRTCATDEF,

you will find a button Named FIXED RECIPIENTS at the Top.

Click on this button , to add the recipiebnt of the ALERT.

Regards,

Bhavesh

[Former Member]

hi bhavesh.

Thanx for your reply.I have tried all the things but still not getting any message in my inbox.

While creating an alert category i am getting 5 options .

Unclassified

CCMS Alerts

Security relevent alerts

Test BW alerts

Webflow alert

is there any restriction to create the categogy in any of these.

[bhavesh_kantilal]

Mudit,

Did you test your alerts using the report RSALERTTEST? If your configuration is fine, then you would have got the Alert in your ALERT INBOX.

You can create your Alert under UNCLASSIFIED ALERTS.

Which SP are you on. If on SP14 , check note 913858.

Regards,

Bhavesh

[Former Member]

hi bhavesh;

thanx.i executed the report and now am getting it in my inbox.thanx again

[bhavesh_kantilal]

Mudit,

the report is used to test your Alert Configuration. If you are getting the Alert, it implies your Configuration is done.

If you are on SP14 , check if the note 913858 and its sub notes have been implemented.

If you are below SP14, also do the tasks mentioned in this blog,

/people/michal.krawczyk2/blog/2005/09/09/xi-alerts--troubleshooting-guide

Regards,

Bhavesh

[Former Member]

hi;

i am getting the alerts in my alert inbox and now i want to receive it by Email.i went to ALRTCATDEF setting configuration and added my email address to SMTP forwarding as XML EMail add.

i have already added my email add in SU01 transaction

i have done the settings in Personalization

i have done settings in SCOT

After this when i am executing RSALERTTEST its giving "ID is unknows.Alert may not be created"

[bhavesh_kantilal]

Mudit,

If you select the option SMTPFORWARDING AS XML , <b>you will not get the Alert in your Aleert Inbox and you will get the Alert as an XML Message in your EMAIL if SCOT has been configured.</b>

To send Alerts in text fromat along with Email, just let the option be as INTERNAL PROCESSING , and give your email id to user under su01 and you should get the email.

If you do not get the email, then check the status of your MAIL in SCOT.

Regards,

Bhavesh

[Former Member]

hi bhavesh

you mean to say that in processing i just need to check Internal processing and dont have to specify anything in personalization and in logging keep checked the write log.

[bhavesh_kantilal]

Mudit,

Do the following,

1 CONFIGURATION -- INTERNAL PROCESSING

2 WRITE LOG ENABLED ~~ This will write the logger whenever Alerts are being triggered

3 ALERT INBOX-- PERSONALIZATION -- TIME INDEPENDENT DELIVERY --EMAIL selected

4 SU01 -- Assign EMAIL ID to the corresponding User / recipeint of the ALERT

5. SCOT has to be set up. Check if SCOT set up is completely done.

Regards,

Bhavesh