Hi Team,
Our end users use CA IDENTITY MANAGEMENT and MSSQL Express.
When our end user attempts to operate the web console after logging in, the following message is displayed:
- CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed the licensed per database limit of 10240 MB.
- Failed to allocate space for object 'dbo.object12_5'.'PK_object12_5' in database 'imdb_14'.
The 'PRIMARY' file group is full.
Please create disk space by either deleting unnecessary files, deleting objects in the file group, adding new files to the file group, or setting automatic expansion for existing files in the file group.
They are using MSSQL Express(MSSQLSERVER2016), due to limitations in Express, the capacity has been exceeded at 10GB and the system is currently unable to operate.
They tried to resolve the issue by compressing the data, but as there was 10GB of data, this did not work.
They believe it is necessary to delete the following files:
- dbo.object12_5
- dbo.runtimeStatusDetail12
- dbo.lock12_5
- dbo.event12_5
- dbo.event_object12_5
- dbo.tasksession12_5
I would appreciate it if you could answer the following questions regarding how to delete the above tables.
Q1: How can they delete all of these tables, or just some of the data?
Q2: How can they specify a period and link it to each related table?
By the way, I found the following explanation in the manual( https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-suite/14-5/virtual-appliance.html ).
Virtual Appliance features a flexible and modular design that provides multiple environment types (Demo, Development, Staging, and Production) and supports High Availability (HA). The Virtual Appliance is based on Linux, using WildFly as the application server and Oracle (Express Edition) as an embedded database. The embedded database is applicable to the non-production environments only.
Just to be sure, if MSSQL Express(MSSQLSERVER2016) is used in a Demo, Development, Staging, and Production Environment, are there any issues in terms of contracts or support?
Best Regards,
Marubun Support