SUA DB Error during Import Data

Usage and Config BFI
1

(imported topic written by kelevra_it)

Hi,

i have found an error in the “Import Data history and logs” about a space disk issue, but space disk is available and free:

2013-12-23 10:07:54 (+0:00:52.934) INFO: ETL from Origine dati - RawDatasourceFixlet (0x00000000003F562D - 0x000000000044AA6D): Failed

2013-12-23 10:07:54 (+0:00:00.000) ERROR: Sequel::DatabaseError: NativeException: com.microsoft.sqlserver.jdbc.SQLServerException: Unable to allocate space for object ‘dbo.raw_datasource_fixlets’.‘PK__raw_datasource_f__047AA831’ into database ‘tem_analytics’. Il filegroup ‘PRIMARY’ is full.

Anyone knows how to automatically increase the file size existing in the filegroup ?

Thanks & rgds

2

(imported comment written by jgstew)

I appear to be having this exact same issue.

My error:

ERROR: Sequel::DatabaseError: NativeException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object ‘sam.file_facts’.‘PK__file_fac__’ in database ‘tem_analytics’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

3

(imported comment written by kelevra_it)

Hi jgstew,

try to check the file size and other settings in SQL using “SQL Management Studio Express”. Probably the problem is the file size limit in SQL Express ( due to a license restriction )

In my scenario, the DB file size now is 4GB and, if i remember correctly, this is a SQL Express limitation.

Perhaps, using a SQL Enterprise Standard/Enterprise solve this issue. But, it’s only a hint :wink:

Rgds :slight_smile:

4

(imported comment written by jgstew)

The issue turned out to be that the DB was on the wrong volume and it ran out of space. It is now in the correct volume and appears to be working.