Error while addint to ENUMERATION table

[Pierre Smits]

When I added some records to the ENUMERATION table I got following error:

The Following Errors Occurred:

Creation of Enumeration failed for entity:
[GenericEntity:Enumeration][createdStamp,null()][createdTxStamp,null()][description,Consumenten
electronica(java.lang.String)][enumCode,ConsumerElectronics(java.lang.String)][enumId,IND_ConsElec(java.lang.String)][enumTypeId,PARTY_INDUSTRY(java.lang.String)][lastUpdatedStamp,null()][lastUpdatedTxStamp,null()][sequenceId,null()]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:Enumeration][createdStamp,2008-11-19
23:39:19.366(java.sql.Timestamp)][createdTxStamp,2008-11-19
23:39:19.365(java.sql.Timestamp)][description,Consumenten
electronica(java.lang.String)][enumCode,ConsumerElectronics(java.lang.String)][enumId,IND_ConsElec(java.lang.String)][enumTypeId,PARTY_INDUSTRY(java.lang.String)][lastUpdatedStamp,2008-11-19
23:39:19.366(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-19
23:39:19.365(java.sql.Timestamp)][sequenceId,null()] (SQL Exception while
executing the following:INSERT INTO ENUMERATION (ENUM_ID, ENUM_TYPE_ID,
ENUM_CODE, SEQUENCE_ID, DESCRIPTION, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?) (The table 'ENUMERATION' is full))


Stating that the table is full.

Is there a limit to this table?

Regards,

Pierre

[Scott Gray]

It's unlikely to be anything to do with OFBiz but more likely something to
do the your database.  Try googling the error message with your db in there
to find possible causes, could be your disk is full or something like that.
Regards
Scott

2008/11/20 Pierre Smits <[hidden email]>

> When I added some records to the ENUMERATION table I got following error:
>
> The Following Errors Occurred:
>
> Creation of Enumeration failed for entity:
>
> [GenericEntity:Enumeration][createdStamp,null()][createdTxStamp,null()][description,Consumenten
>
> electronica(java.lang.String)][enumCode,ConsumerElectronics(java.lang.String)][enumId,IND_ConsElec(java.lang.String)][enumTypeId,PARTY_INDUSTRY(java.lang.String)][lastUpdatedStamp,null()][lastUpdatedTxStamp,null()][sequenceId,null()]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:Enumeration][createdStamp,2008-11-19
> 23:39:19.366(java.sql.Timestamp)][createdTxStamp,2008-11-19
> 23:39:19.365(java.sql.Timestamp)][description,Consumenten
>
> electronica(java.lang.String)][enumCode,ConsumerElectronics(java.lang.String)][enumId,IND_ConsElec(java.lang.String)][enumTypeId,PARTY_INDUSTRY(java.lang.String)][lastUpdatedStamp,2008-11-19
> 23:39:19.366(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-19
> 23:39:19.365(java.sql.Timestamp)][sequenceId,null()] (SQL Exception while
> executing the following:INSERT INTO ENUMERATION (ENUM_ID, ENUM_TYPE_ID,
> ENUM_CODE, SEQUENCE_ID, DESCRIPTION, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?) (The table 'ENUMERATION' is full))
>
>
> Stating that the table is full.
>
> Is there a limit to this table?
>
> Regards,
>
> Pierre
>

[Pierre Smits]

Scott,

Thanks for your comment. I will google.

But in the mean while I herewith state my architecture;

   - The application server is on a virtual machine with 1.0GB internal
   memory
   - Connecting to a fysical server having 2GB internal memory, running
   MySQL (version 5.0.54), with 26% of disk space in use.
   - MySQL driver 5.0.15 is used.

Has anyone else had this experience with MySQL?

Regards,

Pierre


On Wed, Nov 19, 2008 at 11:51 PM, Scott Gray <[hidden email]> wrote:

> It's unlikely to be anything to do with OFBiz but more likely something to
> do the your database.  Try googling the error message with your db in there
> to find possible causes, could be your disk is full or something like that.
> Regards
> Scott
>
> 2008/11/20 Pierre Smits <[hidden email]>
>
> > When I added some records to the ENUMERATION table I got following error:
> >
> > The Following Errors Occurred:
> >
> > Creation of Enumeration failed for entity:
> >
> >
> [GenericEntity:Enumeration][createdStamp,null()][createdTxStamp,null()][description,Consumenten
> >
> >
> electronica(java.lang.String)][enumCode,ConsumerElectronics(java.lang.String)][enumId,IND_ConsElec(java.lang.String)][enumTypeId,PARTY_INDUSTRY(java.lang.String)][lastUpdatedStamp,null()][lastUpdatedTxStamp,null()][sequenceId,null()]:
> > org.ofbiz.entity.GenericEntityException: Error while inserting:
> > [GenericEntity:Enumeration][createdStamp,2008-11-19
> > 23:39:19.366(java.sql.Timestamp)][createdTxStamp,2008-11-19
> > 23:39:19.365(java.sql.Timestamp)][description,Consumenten
> >
> >
> electronica(java.lang.String)][enumCode,ConsumerElectronics(java.lang.String)][enumId,IND_ConsElec(java.lang.String)][enumTypeId,PARTY_INDUSTRY(java.lang.String)][lastUpdatedStamp,2008-11-19
> > 23:39:19.366(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-19
> > 23:39:19.365(java.sql.Timestamp)][sequenceId,null()] (SQL Exception while
> > executing the following:INSERT INTO ENUMERATION (ENUM_ID, ENUM_TYPE_ID,
> > ENUM_CODE, SEQUENCE_ID, DESCRIPTION, LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?,
> ?,
> > ?, ?, ?, ?, ?) (The table 'ENUMERATION' is full))
> >
> >
> > Stating that the table is full.
> >
> > Is there a limit to this table?
> >
> > Regards,
> >
> > Pierre
> >
>