7 Replies Latest reply on Jun 24, 2016 6:52 AM by Bill Robinson

    file server is full, solution please?

    Harsha A

      Hi BSA SMEs,

       

      We are using BSA 8.6 and file storage (File server) is also in the same server. But now the storage is getting filled, only left is 3 GB space.

       

      Could you please suggest best approach/solution to resolve the bottleneck at later stage?

       

      Do we need to increase the drive size? or can we move half of the folder to other drive and keep remaining half in the same server, if yes how to do this? -  is it possible to have multiple file storage in the same file server?

       

      NOTE: both file server and application server are on the same server and OS is windows 2012 R2., DB is MS SQL.

       

      Please let me know if you need any further information

       

      Thanks,

       

      Harsha

        • 2. Re: file server is full, solution please?
          Santhosh Kurimilla

          - Try to do a cleanup of File Server contents either using a FileServer cleanup script or

          - Identify the folders which are not standard ones like blpackages, installables, scripts, etc.

          - Identify the folder which might be the most space used and check for the possibilities to mount with another drive/folder with high space. Be cautious in doing this.

           

          If possible, copy the File system contents and space usage here. It may be more meaningful in suggesting other options.

          • 4. Re: file server is full, solution please?
            Bill Robinson

            so first i would see what directory on your server is consuming the space.  is it the file server location specified in bsa?  or the datafile location for your database ? or maybe some other application on this server is having an issue.  right now it's unclear which is the case.

             

            if you determine it's the file server, then you should start w/ the cleanup mentioned above - however you will need 'cleanupDatabase' and 'hardDeleteAllSharedObjects' to complete before cleanupFileServer will have anything to delete.  additionally, that assumes there are things to actually delete.  if you have users creating objects in bsa and not deleting them, then there will be nothing to clean.

             

            if you determine it's the database then we need to see what tables are large, maybe there is a job or some jobs putting a lot of data into the database and it shouldn't be.

             

            and it could be both the file server and database.  and maybe this is just normal growth for your environment based on usage and you will need to add more space.

             

            so first figure out what is eating up space and we can start to investigate from there.

             

            there are some sql queries we can run to get some of this info, i'll try to post those in a bit.

            1 of 1 people found this helpful
            • 5. Re: file server is full, solution please?
              Bill Robinson

              so let's start w/ a couple queries.

               

              there are two attached.  and the ones below.  run them all as the bladelogic db user against the bladelogic database.  if you want to move this to a ticket that's fine, just open one and post the #.

               

              # breakdown of jre table

              select COUNT(*),CONVERT(datetime,convert(varchar(7),event_date,120) + '-01') from job_run_event group by CONVERT(datetime,convert(varchar(7),event_date,120) + '-01') order by CONVERT(datetime,convert(varchar(7),event_date,120) + '-01')

               

              # soft-deleted objects still on the file server

              select '//' + fs.host + fs.root_path + '/' + fl.relative_path as fsPath from file_location fl

              join file_server fs on fl.file_server_id = fs.file_server_id

              join depot_object_location dol on fl.file_location_id = dol.file_location_id and not exists (select 1 from depot_object do2, depot_object_location dol2 where do2.is_deleted = 0 and do2.depot_object_id = dol.depot_object_id and dol2.file_location_id = dol.file_location_id)

              join depot_object do on dol.depot_object_id = do.depot_object_id and dol.depot_object_version_id = do.depot_object_version_id;

               

              # soft-deleted job run objects

              select '//' + fs.host + fs.root_path + '/' + fl.relative_path as fsPath from file_location fl

              join file_server fs on fl.file_server_id = fs.file_server_id join depot_object_location dol on fl.file_location_id = dol.file_location_id

              join depot_object do on dol.depot_object_id = do.depot_object_id and dol.depot_object_version_id  = do.depot_object_version_id

              join job_result_depot_object jrdo on do.depot_object_id = jrdo.depot_object_id and do.depot_object_version_id  = jrdo.depot_object_version_id

              join job_result jrr on jrdo.result_id = jrr.result_id

              join job_run jr on jrr.job_run_id = jr.job_run_id where jr.is_deleted = 1 and do.is_saved_explicitly = 0 and do.depot_object_id not in ( select distinct depot_object_id from job_depot_object jdo join job j on jdo.job_id = j.job_id and jdo.job_version_id = j.job_version_id where j.is_deleted = 0 and j.is_latest_version = 1 and j.object_type_id = 30);

               

              for the last two you can just provide the count of results returned.

              • 6. Re: file server is full, solution please?
                Harsha A

                Bill Robinson

                 

                I do not want to delete any previously created blapackages, could you please suggest what is best approach we can resolve this? is it the only option is to add mode space to the File storage space or any other alternative?

                 

                Thanks,

                 

                Harsha Angadi

                • 7. Re: file server is full, solution please?
                  Bill Robinson

                  did you read my post ?  first - what space is being used?  we need to investigate before blindly deleting things.

                   

                  then - how do you think you can reclaim space unless something is deleted ?