Topic
  • 3 replies
  • Latest Post - ‏2014-01-09T14:51:18Z by jgstew
kelevra_it
kelevra_it
2 Posts

Pinned topic SUA DB Error during Import Data

‏2013-12-23T10:26:55Z |

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

 
  • jgstew
    jgstew
    12 Posts

    Re: SUA DB Error during Import Data

    ‏2014-01-06T20:26:11Z  

    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__<removed>' 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.
     
  • kelevra_it
    kelevra_it
    2 Posts

    Re: SUA DB Error during Import Data

    ‏2014-01-07T08:59:07Z  
    • jgstew
    • ‏2014-01-06T20:26:11Z

    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__<removed>' 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.
     

    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 ;)

    Rgds :)

  • jgstew
    jgstew
    12 Posts

    Re: SUA DB Error during Import Data

    ‏2014-01-09T14:51:18Z  

    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 ;)

    Rgds :)

    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.