9 Replies Latest reply: Mar 5, 2012 4:36 PM by Srinivasa Rao Chapa RSS

Cannot Delete Client after a failed Client Copy

Currently Being Moderated

Hello all,

              I did a remote client copy from prd to dev with SAP_ALL profile. Client Copy failed - Out of storage error. I restarted and then unlocked the dev client and tried to login with my prd user id and password, login was successful but i got no authorization for any Tx Code. i tried logging with DDIC user too still no authorization for Tx Code. Pls help me as i am neither able to delete the client as i am not able to use SCC5 in the dev client nor able to repeat schedule the background clientcopy job from another dev client... Pls suggest any solution.

 

Regards

Shan

  • Re: Cannot Delete Client after a failed Client Copy
    John Feely
    Currently Being Moderated

    Hello,

     

    Please check

     

    552711  FAQ: Client copy

    541311  CC-INFO: Parallel processes FAQ

    489690  CC INFO: Copying large production clients

     

    regards,

    John nFeely

    • Re: Cannot Delete Client after a failed Client Copy
      Currently Being Moderated

      Hi John nFeely,

                               I went through the FAQ but i cannot find any useful solution for my case. My problem is inorder to reschedule the clientcopy job i am not able to use Tx Code SM37 in the client with even DDIC user. So i cannot get any action done on my dev client other than just login to the client...

       

      Help pls.. Very urgent...

       

      Thanx

      Shan

      • Re: Cannot Delete Client after a failed Client Copy
        Naveen Kumar Vasan
        Currently Being Moderated

        hi,

         

        Here goes: 

         

        1. log into the client to delete 

        2. go into SCC5 and delete client 

        3. log into another client and delete entry with SCC4 

        4. reorg database to recover database space. 

         

        Actually, if you check "on" the little "Delete Entry from T000" checkbox, you can skip step 3.

         

        One other way of deleting a client which could give significant performance gain and save time is at OS level using - R3trans 

         

        To delete a client 200, you have to create a command file "del200" with following entries 

         

        Clientremove 

        Client = 200 

        Select * 

         

        Place the command file in /usr/sap/trans/bin 

         

        $ cd /usr/sap/trans/bin 

         

        $ R3trans u2013w <log file name> -u 1 <command file name > 

         

        e.g $ R3trans -w del200.log -u 1 del200 

         

        To check the progress... 

         

        $ tail -f del200 

           

        Reorg the database post client delete

         

        Regards,

        Naveen.

        • Re: Cannot Delete Client after a failed Client Copy
          Currently Being Moderated

          Thanks Naveen for the reply. I will try it out let u know the outcome.

           

           

          Regards

          Shan

          • Re: Cannot Delete Client after a failed Client Copy
            Srinivasa Rao Chapa
            Currently Being Moderated

            Hi shiva,

             

            Did you try to re-launch the client copy ..it will continue from where it fails

             

            Also have tried to login with SAP* user ?

             

            If you want to start the client copy from scratch proceed as per the steps from Naveen.

             

             

            Regards,

            Srini Chapa.

            • Re: Cannot Delete Client after a failed Client Copy
              Currently Being Moderated

              Thanks Naveen and Srini...

               

              I got to rescedule the job using sap* but it is running for almost 21hrs now and is still active. What could be the reason? My database size is 190GB and got 16GB ram in my development system.

               

              Thanks

              Siva

              • Re: Cannot Delete Client after a failed Client Copy
                Srinivasa Rao Chapa
                Currently Being Moderated

                what does SCC3 log says?

                How many parallel sessions you have used ?

                 

                 

                 

                Regards,

                Srini Chapa.

                • Re: Cannot Delete Client after a failed Client Copy
                  Currently Being Moderated

                  Hi All,

                            Thanks for all u r suggestions. Atlast my remote client copy finished successfully. But had to check for TemSe data storage consistency and there where two conflicts and had to remove it and then the client copy got over in few minutes.

                   

                  Now i am doing remote client copy from PRD to QAS. I am having an issue wherein it is stuck

                  Following is the scc3 log

                   

                  Status                    Processing...

                  User                      SAP*

                  Start on                  04.03.2012 / 12:51:33

                  Last Entry on             04.03.2012 / 20:12:37

                   

                  Current Action:           Copy/Delete Tables

                  Process     Server        Table                  Time

                  00001       SAP-DERP      ZMSKA                  14:29:45

                   

                  Now the time is 05.03.2012 10:48 and the last entry is yesterday 8:12 pm....

                   

                  Last i cheked for TemSe data storage consistency but there is no inconsistency.

                   

                  Pls help...

                   

                  Points awarded for earlier query.. Thanks...

                   

                  Thanks...

                  Shan

Actions