8.12 - Could not allocate space for object 'F98761DV812FS' in database because the 'PRIMARY' filegroup is full

8.12 - Could not allocate space for object \'F98761DV812FS\' in database because the \'PRIMARY\' filegroup is full

Hello All,

I am not able to save TC on a FAT client and in jde.log I am getting some space related errors.

JDE.LOG -

3452 MAIN_THREAD Thu Mar 06 08:46:36.735000 Jdbodbc.c8330
ODB0000163 - wSQLExecute failure. rc=-1
2972/3452 MAIN_THREAD Thu Mar 06 08:46:36.735001 Jdbodbc.c8330
ODB0000164 - STMT:00 [42000][1105] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'F98761DV812FS' in database 'SPEC_DV812FS' because the 'PRIMARY' filegroup is full.
2972/3452 MAIN_THREAD Thu Mar 06 08:46:36.751000 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
2972/3452 MAIN_THREAD Thu Mar 06 08:46:36.751001 Jdb_exet.c5906
JDB3400009 - Failed to perform Insert for F98761DV812FS
2972/3452 MAIN_THREAD Thu Mar 06 08:46:36.766000 SpecWrite.c177
jdeSpecInsert failed with a JDB error but unable to determine more detail about failure. jdeSpecGetLastErrorInfo() returned error or returned no data.
2972/3452 MAIN_THREAD Thu Mar 06 08:46:36.766001 tcsav.c120
TCE009168 - DR_REPORT rdaspec record write failed for Report R5542S03A, Version +.
2972/3452 MAIN_THREAD Thu Mar 06 08:47:08.299000 Jdbodbc.c8330
ODB0000163 - wSQLExecute failure. rc=-1
2972/3452 MAIN_THREAD Thu Mar 06 08:47:08.315000 Jdbodbc.c8330
ODB0000164 - STMT:00 [42000][1105] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'F98761DV812FS' in database 'SPEC_DV812FS' because the 'PRIMARY' filegroup is full.
2972/3452 MAIN_THREAD Thu Mar 06 08:47:08.315001 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
2972/3452 MAIN_THREAD Thu Mar 06 08:47:08.330000 Jdb_exet.c5906
JDB3400009 - Failed to perform Insert for F98761DV812FS
2972/3452 MAIN_THREAD Thu Mar 06 08:47:08.330001 SpecWrite.c177
jdeSpecInsert failed with a JDB error but unable to determine more detail about failure. jdeSpecGetLastErrorInfo() returned error or returned no data.
2972/3452 MAIN_THREAD Thu Mar 06 08:47:08.362000 tcsav.c778
The Table Conversion <R5542S03A, +> failed to be saved. jdeSpecInsert returned error: JDESPECRESULT_JDBFAILED

We are on 8.12 with 8.96 Tool release, JAS server is on Windows 2003 R2 Enterprise Edition SP2 with Oracle App Server 10.1.2.0.2, ES is OS400, V5R4M0.

Thanks.

Re: 8.12 - Could not allocate space for object \'F98761DV812FS\' in database because the \'PRIMARY\' filegroup is full

Hi,

Get your DBA to increase the size of the database or set it to autogrow

Re: 8.12 - Could not allocate space for object \'F98761DV812FS\' in database because the \'PRIMARY\' filegroup is full

This message is coming from the MSDE database running on your Fat Client and not your enterprise SQL Server DB. When you save an object in one of the development tools it must save the specs into your local package database. In this case the package database is "SPEC_DV812FS", "DV812FS" being the name of the full package installed on your machine.

I checked a couple of 8.96/8.12 fat clients and all had unlimited growth set for the package database. This is what I would expect.

I suggest you check the local drive that your E1 fat client is installed to (x:\E812) and see how much free space you have available.

If you have plenty of disk space available take a look at the growth parameter on the DB files. To do this try the following from a command prompt:

osql -E -S the_name_of_your_fatclient\JDELOCAL

(Note that the -E and -S must be uppercase)

When you see the "1>" prompt type the following pressing enter on each line:

1> USE SPEC_DV812FS
2> SELECT NAME, SIZE, MAXSIZE, GROWTH FROM SYSFILES
3> go

You should get results like this (note the results are wrapped):

NAME
XSIZE
-------------------
---------
Data
-1
Log
268435456

(2 rows affected)

You should see that file "Data" has a MAXSIZE of -1. This means unlimited growth. If it is something other than that your growth is limited to the value displayed.

Let us know how you get on.

Re: 8.12 - Could not allocate space for object \'F98761DV812FS\' in database because the \'PRIMARY\' filegroup is full

Also consider that MSDE has a size limit of 2GB for data files.