[OFBiz] Users - Unable to login in to this application

[Si Chen]

Basically, the log says that it could not insert data from 
file:/usr/local/ofbiz/applications/manufacturing/data/ManufacturingData.xml  
because of this:

(A truncation error was encountered trying to shrink VARCHAR 
'linearComponentFormula' to length 20.)

enumId is supposed to be only 20 chars long, but 
"linearComponentFormula" has 22 characters.

Let's see if someone can fix this soon...

Si

Gary Pinkham wrote:

> Well I think I might want to use the software for a home 
> installation..   So I wanted to see if I can install it here..
>
> Going on the "it's old" comment.. I downloaded the latest build from 
> SVN..  Built it.. Ran the run-install task in ant and get this...*
> [cut begining of log.. if you need to see let me know]
> ...
>     [java] 246957 (main) [    EntitySaxReader.java:183:INFO ] 
> Beginning import from URL: 
> file:/usr/local/ofbiz/applications/manufacturing/data/WorkEffortData.xml
>     [java] 246974 (main) [    EntitySaxReader.java:221:INFO ] 
> Transaction Timeout set to 2 hours (7200 seconds)
>     [java] 247984 (main) [    EntitySaxReader.java:239:INFO ] Finished 
> 39 values from 
> file:/usr/local/ofbiz/applications/manufacturing/data/WorkEffortData.xml
>     [java] 247993 (main) [    EntitySaxReader.java:183:INFO ] 
> Beginning import from URL: 
> file:/usr/local/ofbiz/applications/manufacturing/data/ManufacturingData.xml 
>
>     [java] 248010 (main) [    EntitySaxReader.java:221:INFO ] 
> Transaction Timeout set to 2 hours (7200 seconds)
>     [java] 251107 (main) [   GenericDelegator.java:599:ERROR]
>     [java] ---- exception report 
> ----------------------------------------------------------
>     [java] Failure in create operation for entity [Enumeration]: 
> org.ofbiz.entity.GenericEntityException: Exception while inserting the 
> following entity: [GenericEntity:Enumeration][createdStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][createdTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][description,Linear 
> product(java.lang.String)][enumCode,LINEAR_FORMULA(java.lang.String)][enumId,linearComponentFormula(java.lang.String)][enumTypeId,BOM_FORMULA(java.lang.String)][lastUpdatedStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][lastUpdatedTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][sequenceId,01(java.lang.String)] 
> (while inserting: [GenericEntity:Enumeration][createdStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][createdTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][description,Linear 
> product(java.lang.String)][enumCode,LINEAR_FORMULA(java.lang.String)][enumId,linearComponentFormula(java.lang.String)][enumTypeId,BOM_FORMULA(java.lang.String)][lastUpdatedStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][lastUpdatedTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][sequenceId,01(java.lang.String)] 
> (SQL Exception while executing the following:INSERT INTO 
> OFBIZ.ENUMERATION (ENUM_ID, ENUM_TYPE_ID, ENUM_CODE, SEQUENCE_ID, 
> DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, 
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation 
> error was encountered trying to shrink VARCHAR 
> 'linearComponentFormula' to length 20.))). Rolling back transaction.
>     [java] Exception: org.ofbiz.entity.GenericEntityException
>     [java] Message: Exception while inserting the following entity: 
> [GenericEntity:Enumeration][createdStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][createdTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][description,Linear 
> product(java.lang.String)][enumCode,LINEAR_FORMULA(java.lang.String)][enumId,linearComponentFormula(java.lang.String)][enumTypeId,BOM_FORMULA(java.lang.String)][lastUpdatedStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][lastUpdatedTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][sequenceId,01(java.lang.String)] 
> (while inserting: [GenericEntity:Enumeration][createdStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][createdTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][description,Linear 
> product(java.lang.String)][enumCode,LINEAR_FORMULA(java.lang.String)][enumId,linearComponentFormula(java.lang.String)][enumTypeId,BOM_FORMULA(java.lang.String)][lastUpdatedStamp,2000-04-17 
> 19:17:28.514(java.sql.Timestamp)][lastUpdatedTxStamp,2000-04-17 
> 19:17:26.019(java.sql.Timestamp)][sequenceId,01(java.lang.String)] 
> (SQL Exception while executing the following:INSERT INTO 
> OFBIZ.ENUMERATION (ENUM_ID, ENUM_TYPE_ID, ENUM_CODE, SEQUENCE_ID, 
> DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, 
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation 
> error was encountered trying to shrink VARCHAR 
> 'linearComponentFormula' to length 20.)))
>
> *
> Si Chen wrote:
>
>> Have you tried the demos listed on the ofbiz.org site first?  What is 
>> it exactly that you want to do?  Look at the code, or try out some of 
>> the functionality?
>>
>> Gary Pinkham wrote:
>>
>>> Ok I  will take another look.. pretty sure I saw some stuff that 
>>> looked like it was loading..   I noticed it was rather old..  That's 
>>> all I saw on sourceforge.. Is there a prefered stable version??    
>>> Should I check out latest SVN code??    I was hoping to start with a 
>>> stable base..
>>>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>