Data Buffering Access

[Former Member]

Hi All ,

do anyone know how to access and check the data buffered in MII Data base by Data Buffering feature when a connection to external data base is failed.

Through a transaction , how can we check the status and delete the buffered data based on its status ?

[Former Member]

Hi Adarsh ,

we can check the error while inserting data for the first time. Suppose , if the connection is failed and it is stored in data buffer and while executing another transaction I wanna check whether the failed insertion is successfully inserted after some retries and if inserted then I wanna update its status to PI or other system , as a feedback , from which information related to that specific inserted data is received.

[Former Member]

Hi Adarsh and Jamie ,

I know that we can check the status and number of data buffer jobs and its details .

But my requirement is to send a feedback to other system like PI from which I received a message related to the data to be entered into a third party data base.

Hence , I need to check through a transaction and based on its status I have to reply automatically something like a feedback to PI.

I don't want manual checking , but Programmatically which is an automatic checking.

Do we have a way to achieve it.

[sidnooradarsh]

I would simply try something like this,

Add SQL action block in BLS transaction, then add Conditional action to check "Success" flag of SQL Action, if flag is false or zero then add Assignment action to read SQL attribute

[ActionName].LastErrorMessage

or

[ActionName].Results{/Rowsets/FatalError} 

which provides you the reason for failure of SQL action. Then perform whatever you want like send email, log error, call another transaction, display error etc..

Hope this helps!!

Regards,

Adarsh

[sidnooradarsh]

As Jamie said you can find all your buffered jobs On the SAP MII Administration Menu --> choose Data Services --> Data Buffer Jobs

Within the data server that you to create you will find an attribute called "DaysRetention" this will specify for how much duration you would like to buffer the data

Check this MII help link for more details on [Data Buffering|http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm]

Regards,

Adarsh

[jamie_cawley]

Did you look at the Data Buffer Entries page under data services? There's no need to use a transaction to delete the job, that's what the retention and retry count are for.

Jamie