User:Fabiocanella

From ADempiere ERP Wiki
Jump to navigationJump to search
Name This user real name is : Fabio Canella


What am I doing?[edit]

  1. Implementing Adempiere ERP :)
  2. Developing various connectors for report, mail and document management, using jasper server and grails

My website is binario01

How increase the length of a varchar field (table m_product field value) in postgresql[edit]

I need to increase "value" fields in m_product table from 40 characters to 100

I tried with:\\

alter table adempiere.m_product alter column "value" TYPE character varying(100);


but I had to recreate many views So I find this trick

update pg_attribute set atttypmod = 100+4 where attrelid = 'm_product'::regclass and attname = 'value';

Then you need to change the value in application dictionary in "Table and Colums" table


How configure adempiere with libero[edit]

Meke a clone of the repository:

cd /opt/repos/sourceforge

hg clone -U http://adempiere.hg.sourceforge.net:8000/hgroot/adempiere/adempiere adempiere

hg clone -U http://adempiere.hg.sourceforge.net:8000/hgroot/adempiere/libero

cd /opt/repos/workspace


If you want adempiere 370:

hg clone /opt/repos/sourceforge/adempiere -r adempiere370lts

hg clone /opt/repos/sourceforge/libero

if you want to use adempiere 360lts

hg clone /opt/repos/sourceforge/adempiere -r adempiere360lts

hg clone /opt/repos/sourceforge/libero -r adempiere360libero


Error java.lang.OutOfMemoryError: PermGen space[edit]

Jboss need more memory ! Change the AdempiereEnv.properties located in ADEMPIERE_HOME increasing the memory ie: ADEMPIERE_JAVA_OPTIONS=-Xms128M -Xmx512M -XX:MaxPermSize=512m then save, run RUN_silentsetup.sh and then start adempiere