Skip to Content
author's profile photo Former Member
Former Member

where to compare Current and previous messages.

i had requirment where i had to insert the text data from FTP to MSSQL Database

(R/3) File -> Xi -> JDBC.

but the condition is -> In case the SQL server is down for any time (1 Jan to 4 Jan), and when SQL Server is UP on 5 jan, All the data in R/3 form 1-4 Jan shall also be udpated on 5th Jan.

Check has to be made by XI whether Current Data DATE is 1 more then previous data DATE.

(i.e on 5 day XI has to check whether 4 Jan Data has passed Xi Sucessfuly or not)

My Views : Alert can be used to identify the days of downtime, and we again put the file from Archives to FTP.

But this process also has to be automated, no manual intervention on taking file from archives

I had to use BPM.?

any Inputs..?

Regards

Ajay Pant

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 26, 2007 at 05:49 AM

    Ajay,

    i hope adapter engine in case of Message Quality EO, guarantees message delivery if the system is up. in that case your previous messages will be delivered once your SQL server comes up.

    Regards

    Rajeev

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks a lot to all ...

      maintaining a table at MSSQL database side and using JDBC look will solve my problem.

      -> option of maintaining the table at XI or R/3 ( in abap stack)

      is not possible , for messages failed at target JDBC adapter level.

      why i am thinkin, because sxmb_moni, wo'nt take care of messages failed at (target side) Adapter Engine after passing Integration server.

      Regards,

      Ajay Pant

  • author's profile photo Former Member
    Former Member
    Posted on Dec 26, 2007 at 05:47 AM

    Hi,

    U can maintain a table at the R3 end with the information of date.

    Now when message comes to XI u pass that value to R3 and compare the value which is maintained in table of R3.

    U need to use the lookup for passing the value to R3.

    Thnx,

    Chirag

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.