You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Pierre Smits <pi...@gmail.com> on 2008/11/19 23:43:25 UTC
Error while addint to ENUMERATION table
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
Re: Error while addint to ENUMERATION table
Posted by Pierre Smits <pi...@gmail.com>.
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 <le...@gmail.com> 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 <pi...@gmail.com>
>
> > 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
> >
>
Re: Error while addint to ENUMERATION table
Posted by Scott Gray <le...@gmail.com>.
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 <pi...@gmail.com>
> 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
>