14 Replies Latest reply: Sep 14, 2010 10:34 PM by Stuart Begg RSS

AppSet copy failed

Naga R
Currently Being Moderated

I am trying to add Appset and getting this error:

 

Error message:There is insufficient free space on disk volume 'C:\' to create the database. The database requires 4140564480 additional free bytes, while only 3137065984 bytes are available.

Problems were identified while planning for the RESTORE statement. Previous messages provide details.

RESTORE DATABASE is terminating abnormally.

 

Any suggetion why I am getting this error??

 

Thank you.

  • Re: AppSet copy failed
    Nilanjan Chatterjee
    Currently Being Moderated

    Hi Raju,

     

    As the message is indicating, there is not enough space on the drive where SQL is installed. You need to add some space to this drive.

    • Re: AppSet copy failed
      Naga R
      Currently Being Moderated

      I am also getting this error - this means the same solution (allocating a space) for the both errors?? Thanks in advance.

       

      Error message:A nonrecoverable I/O error occurred on file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempOutlookSoftDatabase.bak:" 112(There is not enough space on the disk.).

      BACKUP DATABASE is terminating abnormally.

      • Re: AppSet copy failed
        Mihaela Radulescu
        Currently Being Moderated

        Hi Raju,

         

           Yes, this error message is related to the same thing because first of all this file is copied there and after is restored.

         

        Best regards,

        Mihaela

        • Re: AppSet copy failed
          Naga R
          Currently Being Moderated

          Thanks for the response.

           

          The Appset supposed to be copy or add to the E: drive where all the appsets are located or configured. Why it is pointing to the C: Drive?? Why it is saying C:\ didnt have enough space??

           

          Please clarify me if I am wrong, So, when we say copy or add Appset, it is going to copy on C:\ and then, restore or move to the drive where it is configured?? thats the reason we allways need enough space in C:\ drive??

           

          Edited by: Raju on Apr 12, 2010 3:30 PM

          • Re: AppSet copy failed
            Mihaela Radulescu
            Currently Being Moderated

            Raju,

             

               It looks like the SQL settings (for sql data and log files is pointing to C drive), maybe on E drive you have the BPC file folder.

            In order to have SQL and data files on E drive as well, you ave to Open Management Studion, select Database Settings ad change the path for Data and Log file to E drive, then restart the SQl services and try to restore again.

             

            Best regards,

            Mihaela

            • Re: AppSet copy failed
              Naga R
              Currently Being Moderated

              HI Mihaela,

               

              Thanks for your quick response.

              As you suggested, I have looked the database settings (Right Click on Server->Properties->Database Settings) at SQL Server and they are pointing to E:\ Drive (NOT C:\ Drive). But It still giving me the errors mentioned above .... etc., doesnt have enough space on the C:\.

               

              Just found another new message when I am trying to create or add AppSet from BPC Admin:

              Detail Message Status:

              Check environment information

                   Validate calucalted members

              Copy File

                    Connecto to DB Server

                    Copy the application set's FileDB folder and files

                    Copy application set's Webfolders folder and files

              Copy database

              Error message:The tail of the log for the database "<APPSET_NAME>" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

              RESTORE DATABASE is terminating abnormally.

               

              Any suggession or solution - how to fix this??

               

              Kind Regards,

              Raju.

               

              Edited by: Raju on Apr 12, 2010 8:15 PM

              • Re: AppSet copy failed
                Mihaela Radulescu
                Currently Being Moderated

                Raju,

                 

                   You can try to restore manually the SQL backup from SQl folder to see exactly where is the proble,. It can be also a problem with the Log file, did you shrink the original database before to backup it?

                 

                Best regards,

                Mihaela

                • Re: AppSet copy failed
                  Sebastien Michel
                  Currently Being Moderated

                  Hi,

                   

                  Have a look at the following threads, we discussed about the appset restore with SQL Server 2005 : SAP BPC 7 APPSet Restore SQL 2005

                   

                  So far, personal testing show that BPC does not take care of the SQL Server default data and default log folder. It's linked to the SQL Server installation process.

                  • Re: AppSet copy failed
                    Naga R
                    Currently Being Moderated

                    Thank you all for the responses.

                     

                    My bad, this is all happening now - I used to create or take a copy of AppSets till last week and it is suddently behaving now and giving those errors. Does it mean if anybody changed or modified any settings at server??

                     

                    I also notified and looked at the C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data - all the .MDF and .LDF files are creating here. All these files supposed be at Server (E: Drive).

                     

                    This link says - some settings needs to be modified at REGEDIT (I already looked here and everything looks fine for me) or reinstall the BPC again

                     

                    SAP BPC 7 APPSet Restore SQL 2005

                     

                    Kind Regards,

                    Raju.

                    • Re: AppSet copy failed
                      Sebastien Michel
                      Currently Being Moderated

                      Best way is to move your *.mdf and *.LDF fmanually to your E: drive.

                       

                      This need to be done while the BPC application is stopped (IIS / COM+ and sendgovernor / Insight services). Also stop SSAS and SSRS. Then you could detach your DB and move data files then attach again. It's a DBA task.

                      • Re: AppSet copy failed
                        Naga R
                        Currently Being Moderated

                        Thanks again - I completly understand your way for the solution.

                         

                        But it is behaving like this?? because it is not configured or installed it proparly??

                        • Re: AppSet copy failed
                          Sebastien Michel
                          Currently Being Moderated

                          To my knowledge it's "by design" ! Even if it's not perfect.

                           

                          The only thing you can do is to reinstall SQL Server 2005 and change the default data path (click advanced after services choice). You may also change the registry key after the installation, but i would not recommend this because it may impact other SQL server functionnality.

                           

                          Sincerely,

  • Re: AppSet copy failed
    Naga R
    Currently Being Moderated

    The problem is - all the AppSets (Databases) targeted to C:\ Drive.

    Yes - finally got solved, ofcourse by taking your suggestions too. Moved all the AppSets to E:\ Drive including AppShell by using Detach/Attach options from SQL Server.

     

    Here are the Steps:

    ->Make the services off - OutlookSoft Services

    ->Detach the Appsets including Extra from SQL Server (Right Click on AppSet (Database) Alltasks->Detach)

    ->Move mdf and ldf files from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to destination (MDF Files: E:\BPC\Data and LDF Files: E:\BPC\Log)

    ->Attach the AppSets by right clicking on the Databases (Right Click on Databases->Attach)->Add->(MDF Files: E:\BPC\Data and LDF Files: E:\BPC\Log)

    ->Start the services on

     

    Regards,

    Raju.

  • Re: AppSet copy failed
    Stuart Begg
    Currently Being Moderated

    I can't locate the link right now, and I know this reply is 'late; but there is an Outlooksoft document out there that is entitled

    Outlooksoft 5 - How to manually port an AppSet, it documents the procedure to get the files where you need them.

Actions