11 Replies Latest reply: Oct 3, 2011 1:58 PM by Aman Hasan RSS

RSA7

Tanka Ravi Chandra
Currently Being Moderated

Hi all,

 

Can anybody tell me the what is the function of delete data in RSA7 TCODE ? what exactly happens and what care should we take before we perform that delete data operation?

 

Thanx & Regards,

RaviChandra

  • This reply has been hidden. This can happen if the message has been hidden by a moderator, or has been reported as abusive.
    • Re: RSA7
      Tanka Ravi Chandra
      Currently Being Moderated

      Hi arvind,

       

      thanx for ur reply,

       

      Can u explain briefly about this sentence "  It is comparable to deleting an InitDelta in the BW System and should preferably be executed there. Not only do you delete all data of this DataSource for the affected BW System, but you also lose all the information concerning the delta initialization. Then you can only request new deltas after another delta initialization"

       

      Plz explain in detail.

       

      Thanx & regards,

      Ravichandra

      • Re: RSA7
        Venkateswarlu Nandimandalam
        Currently Being Moderated

        Hi Ravi,

         

        When you run Init IP in BI system, after successful completion of init load you will get delta queue for the same data source in RSA7.

         

        when we want to delete init for any data source we will follow the below process.

         

        1)open the delta IP in RSA1

        2)in menu bar, click on scheduler --> select "initialization for source system".

        3)Now we will have init request in this screen.

        4)select the request and click on delete.

        5) this is where exactly we get the message which you mentioned.

         

        this means, if you delete init request here it will delete the delta queue in RSA7. System is telling us to check if we have any entries for the same data source in RSA7. If we delete this we will miss the records if any there in RSA7.

         

        The best procedure to delete the init is,

        1) first check if you have any LUWs in RSA7 for the same data source.

        2) If you have any run the delta IP to clear those LUW's

        3)Now delete the init request.

         

        Regards,

        Venkatesh

        • Re: RSA7
          Tanka Ravi Chandra
          Currently Being Moderated

          Hi venkatesh,

           

          Thanx for ur reply,

           

          I have deleted the bw delta queue , then if i want to recreate it once again. now should i run the initialization with delta transfer infopackage first and then initialization with out datatransfer then the delta queue will be created .

           

          plz i am confusing here . plz explain when the delta queue will be recreated .

           

          Thanx  & Regards,

          RaviChandra

          • Re: RSA7
            Venkateswarlu Nandimandalam
            Currently Being Moderated

            Hi,

             

            As already you have deleted delta queue, you have to run the delta ip to create delta queue.

             

            If you want historical data then fill the setup tables and run delta ip as

             

            "Init with data transfer".

             

            If you don't want historical data no need to fill setup tables.

            Run delta ip with "init with out data transfer".

             

            You will get delta queue in RSA7.

             

            Note: run init ip only once either init with data trasfer or init without data transfer based on your requirement.

             

            Regards,

            Venkatesh.

             

            Edited by: Venkateswarlu Nandimandalam on Oct 2, 2011 7:32 PM

  • Re: RSA7
    SVU 123
    Currently Being Moderated

    Hi Ravi,

     

    The two type of LOADS,Delta (Including Init Delta)and Full Load,Delta will come from RSA7 and full will come from the SET Up table and they are not related to each other in any way.

     

    For the First Question on deletion Scenerio you asked,Some of the scenerios i can recollect is

    1)whenever we want to  ReSet the delta in DEV then we delete the data in RSA7 and then RESET IT.However in Production it is never touched/Deleted.

    2)whenever we do the transports of LO datasources from DEV-QA-PRD we have to either extract the data from RSA7 ->PSA or delete the data from RSA7 .ie whenver the strucutre of the DS changes so usually we delete the data from RSA7 in QA and extract the data from RSA-> PSA in PRD.

    3)If any data that is being tested and is not required in BI ,then also we delete it from RSA7.

     

     

    Rgds

     

    SVU123

     

    Edited by: svu123 on Oct 2, 2011 10:43 PM

    • Re: RSA7
      Tanka Ravi Chandra
      Currently Being Moderated

      Hi svu ,

       

      What is the difference between qRFC monitor and RSA7 ?

       

      Thanx & regards,

      RaviChandra

      • Re: RSA7
        Laksh Arora
        Currently Being Moderated

        hi ravi,

         

        qRFC monitor displays almost the same data as that in RSA7, difference betwwen two is in the qRFC the data of LUW is in unstructured foramt and we cannot distinguish between the repeatable and new LUWs

         

         

        regards

        laksh

      • Re: RSA7
        Arvind Doomra
        Currently Being Moderated

        <<Copy pasted answers are not permitted>>

         

        Dear Rabi,

         

        The qRFC monitor basically displays the same data as RSA7. The internal queue name must be used for selection on the initial screen of the qRFC monitor. This is made up of the prefix 'BW, the client and the short name of the DataSource. For DataSources whose name is shorter than 20 characters, the short name corresponds to the name of the DataSource. For DataSources whose name is longer than 19 characters (for delta-capable DataSources only possible as of PlugIn 2001.1) the short name is assigned in Table ROOSSHORTN.

        In the qRFC monitor you cannot distinguish between repeatable and new LUWs. Moreover, the data of a LUW is displayed in an unstructured manner there

         

        You can also refer to the below link:

         

        http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8bde9690-0201-0010-ed8e-8787eae24388?quicklink=index&overridelayout=true

         

        Regards,

        Arvind

         

        Edited by: Matt on Oct 14, 2011 9:05 AM

      • Re: RSA7
        Aman Hasan
        Currently Being Moderated

        ravi,

         

        You should not delete entry from rsa7 its not a good practice rather do it from infopackage and check its result at rsa7.

         

        In rsa7 data comes after exctuion of V3 job....v3 job send data from inbound/outbond quesue to RSa7 using qrfc communication interface....hope this anwers ur question

  • Re: RSA7
    Mani Vannan P
    Currently Being Moderated

    Hi Ravi,

     

    Have a look at this blog too, hope it will be helpful.

     

    Delta Queue Diagnosis

     

    Regards,

    Mani

Actions