ADempiere ERP Business Suite / Discussion / Help: Install on Windows XP + PostgreSQL

Mico Siahaan - 2007-05-01

Dear all,

I installed Adempiere on my Windows XP + PostgreSQL. I followed tutorial in: http://www.adempiere.com/wiki/index.php/Adempiere_Install_WinXp. After finish Step 8, I took a look at dump_errors.log then I found these (sorry, it would be quite long posting):

sql:adempiere_pg.dmp:52: ERROR: could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll": The specified module could not be found.
psql:adempiere_pg.dmp:55: ERROR: function sqlj.java_call_handler() does not exist
psql:adempiere_pg.dmp:63: ERROR: function java_call_handler() does not exist
psql:adempiere_pg.dmp:74: ERROR: could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll": The specified module could not be found.

...

psql:adempiere_pg.dmp:106: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:109: ERROR: function adempiere.acctbalance(numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:141: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:144: ERROR: function adempiere.adempiereproperties() does not exist
psql:adempiere_pg.dmp:154: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:157: ERROR: function adempiere.adempiereproperty(character varying) does not exist
psql:adempiere_pg.dmp:167: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:170: ERROR: function adempiere.adempiereversion() does not exist
psql:adempiere_pg.dmp:180: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:183: ERROR: function adempiere.bompricelimit(numeric, numeric) does not exist
psql:adempiere_pg.dmp:193: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:196: ERROR: function adempiere.bompricelist(numeric, numeric) does not exist
psql:adempiere_pg.dmp:206: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:209: ERROR: function adempiere.bompricestd(numeric, numeric) does not exist
psql:adempiere_pg.dmp:219: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:222: ERROR: function adempiere.bomqtyavailable(numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:232: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:235: ERROR: function adempiere.bomqtyavailable(numeric, numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:245: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:248: ERROR: function adempiere.bomqtyonhand(numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:258: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:261: ERROR: function adempiere.bomqtyonhand(numeric, numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:271: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:274: ERROR: function adempiere.bomqtyordered(numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:284: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:287: ERROR: function adempiere.bomqtyordered(numeric, numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:297: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:300: ERROR: function adempiere.bomqtyreserved(numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:310: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:313: ERROR: function adempiere.bomqtyreserved(numeric, numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:323: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:326: ERROR: function adempiere.bpartnerremitlocation(numeric) does not exist
psql:adempiere_pg.dmp:353: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:356: ERROR: function adempiere.currencybase(numeric, numeric, timestamp with time zone, numeric, numeric) does not exist
psql:adempiere_pg.dmp:366: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:369: ERROR: function adempiere.currencyconvert(numeric, numeric, numeric, timestamp with time zone, numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:379: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:382: ERROR: function adempiere.currencyrate(numeric, numeric, timestamp with time zone, numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:481: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:484: ERROR: function adempiere.invoicediscount(numeric, timestamp with time zone, numeric) does not exist
psql:adempiere_pg.dmp:494: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:497: ERROR: function adempiere.invoiceopen(numeric, numeric) does not exist
psql:adempiere_pg.dmp:507: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:510: ERROR: function adempiere.invoicepaid(numeric, numeric, numeric) does not exist
psql:adempiere_pg.dmp:520: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:523: ERROR: function adempiere.nextid(integer, character varying) does not exist
psql:adempiere_pg.dmp:533: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:536: ERROR: function adempiere.paymentallocated(numeric, numeric) does not exist
psql:adempiere_pg.dmp:546: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:549: ERROR: function adempiere.paymentavailable(numeric) does not exist
psql:adempiere_pg.dmp:559: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:562: ERROR: function adempiere.paymenttermdiscount(numeric, numeric, numeric, timestamp with time zone, timestamp with time zone) does not exist
psql:adempiere_pg.dmp:572: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:575: ERROR: function adempiere.paymenttermduedate(numeric, timestamp with time zone) does not exist
psql:adempiere_pg.dmp:585: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:588: ERROR: function adempiere.paymenttermduedays(numeric, timestamp with time zone, timestamp with time zone) does not exist
psql:adempiere_pg.dmp:598: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:601: ERROR: function adempiere.productattribute(numeric) does not exist
psql:adempiere_pg.dmp:693: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:696: ERROR: function sqlj.add_type_mapping(character varying, character varying) does not exist
psql:adempiere_pg.dmp:706: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:709: ERROR: function sqlj.drop_type_mapping(character varying) does not exist
psql:adempiere_pg.dmp:719: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:722: ERROR: function sqlj.get_classpath(character varying) does not exist
psql:adempiere_pg.dmp:732: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:735: ERROR: function sqlj.install_jar(character varying, character varying, boolean) does not exist
psql:adempiere_pg.dmp:745: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:748: ERROR: function sqlj.install_jar(bytea, character varying, boolean) does not exist
psql:adempiere_pg.dmp:758: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:761: ERROR: function sqlj.remove_jar(character varying, boolean) does not exist
psql:adempiere_pg.dmp:771: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:774: ERROR: function sqlj.replace_jar(character varying, character varying, boolean) does not exist
psql:adempiere_pg.dmp:784: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:787: ERROR: function sqlj.replace_jar(bytea, character varying, boolean) does not exist
psql:adempiere_pg.dmp:797: ERROR: language "java" does not exist
psql:adempiere_pg.dmp:800: ERROR: function sqlj.set_classpath(character varying, character varying) does not exist
psql:adempiere_pg.dmp:10041: ERROR: function productattribute(numeric) does not exist
LINE 2: ... uomsymbol, COALESCE(c.name, (((p.name)::text || (productatt...

I believe it mean my Adempiere installation would not successful. What confused me is: pljava.dll is under C:/Program Files/PostgreSQL/8.2/lib/. So it is there. Why PostgreSQL said: 'The specified module could not be found.'?

regards,

Mico

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Heng Sin - 2007-05-01
  
  Hi,
  
  Have you done 'Step 2' of the 'Setup Pre-Requisite' section ? The most common issue is problem with the path environment variable. Also, are you installing your postgresql using the MSI installer and have the pljava option selected/check during the installation process ?
  
  Regards,
  Low
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Mico Siahaan - 2007-05-02
  
  Dear Low,
  
  yes I did. My path:
  
  C:\Adempiere\data>echo %PATH%
  
  C:\Program Files\Java\jdk1.5.0_06\jre\bin\client;C:\Program Files\Java\jdk1.5.0_
  06\jre\bin;C:\jython2.2b1;C:\IronPython-1.0-RC2;C:\Python24\Scripts;C:\Python24\
  ;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
  
  C:\Adempiere\data>echo %JAVA_HOME%
  
  C:\Program Files\Java\jdk1.5.0_06
  
  I used PostgreSQL msi installer, and I choosed to install all. But when came to step choosing scripting only checkbox pgsql could be checked. Others were grey (could not be checked). I could not figure why.
  
  regards,
  
  Mico
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Heng Sin - 2007-05-02
    
    >I used PostgreSQL msi installer, and I choosed to install all. But when came to step >choosing scripting only checkbox pgsql could be checked. Others were grey (could not be >checked). I could not figure why.
    
    That surely wouldn't works, the pljava option must be enabled and checked. Try reinstall, if the problem persist, you can try to ask in the postgresql forum.
    
    Low
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Alejandro Falcone - 2007-05-03
  
  Hi Mico,
  
  A good tutorial you can look:
  
  http://okaw.wordpress.com/2006/09/22/postgresql-installation-in-windows-with-pljava-for-the-compiere/
  
  I hope that can help you with the pl/java installation.
  
  Best regards,
  
  Alejandro
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Mico Siahaan - 2007-05-03
  
  Hi Alejandro,
  
  thanks for the link. What I did:
  
  1. I changed the path following his suggestion
  2. Install pljava manually. Is it a bug in PostgreSQL for Windows installer? Don't know yet.
  
  Add these lines to postgresql.conf
  custom_variable_classes = 'pljava'
  pljava.classpath = 'C:\\Program Files\\PostgreSQL\\8.2\\share\\pljava\\pljava.jar'
  pljava.release_lingering_savepoints = true
  pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'
  pljava.debug = false
  Restart PostgreSQL
  
  Then go to PostgreSQL installation path, go to share/pljava directory and run:
  psql -U postgres -f install.sql
  
  This step will install pljava to PostgreSQL.
  
  3. Imported Adempiere dump files:
  psql -U adempiere -d adempiere -f adempiere_pg.dmp 2> dump_errors.log
  
  4. Run run_setup.bat
  
  Regards,
  
  Mico
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- PST - 2007-05-06
  
  I ever have that problem also. What I did to solve it is, to install JDK first of all others.
  
  in brief,
  
  1. install JDK. I use 1.6.0_01 and it is fine.
  
  2. check that path is OK.
  path should have "c:\program files\java\jdk1.6.0_01\bin;C:\Program Files\Java\jre1.6.0_01\bin;C:\Program Files\Java\jre1.6.0_01\bin\client;"
  
  3. also add path "C:\Program Files\PostgreSQL\8.2\bin". This will help you in other step.
  
  4. Install postgresql
  
  5. Install Adempiere. Do not delete c:\adempiere\jboss dir when use run_setup.bat. If deleted, it will not find some .xml file and adempiere will not success installed. I do not know why the install manual tell me to delete it.
  
  6. import database
  
  My first installation is 3 days trial. After I use above sequence, I could install it success within 1 hours.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Heng Sin - 2007-05-06
    
    >5. Install Adempiere. Do not delete c:\adempiere\jboss dir when use run_setup.bat. If >deleted, it will not find some .xml file and adempiere will not success installed. I do not >know why the install manual tell me to delete it.
    
    hmm ... , where is this install manual to that tell you to delete the c:\adempiere\jboss dir ?
    
    Regards,
    Low
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- PST - 2007-05-08
  
  To Low,
  
  Starting from c:\adempiere\install.htm, then under "Intallation" link No. 1 will be link to "http://www.adempiere.com/wiki/index.php/InstallServer". On this page, under "Start"
  
  Start
  
  * Delete existing jboss sub-directory
  * Download and extract the current distribution file ADempiere*.zip
  
  Because my first time install. I have the latest distribution file ADempiere*.zip already. I extract it, so I get latest jboss and have the c:\adempiere\install.htm. I have to follow the manual step by step. Then under start I do the first instruction (delete jboss dir), and skip the second instruction because I have the latest file already. That why I could not success run the run_setup.bat. If I follow the instruction strickly, there will be no problem. But why I have to download the file I already downloaded? And extract the file I already extracted? For the people that do first time installation, there is no need to delete the jboss dir.
  
  Is the deletion required for people who do the retry?
  
  Another problem, the run_setup.bat have been taken out the @pause command, the batch file disappeared without telling me what is wrong.
  
  I have to edit the run_setup.bat to put in @pause to find that it could not find the .xml in some subdir of jboss. This mean that jboss dir is neccessary for run_setup.bat.
  
  The @pause taken out from "RUN_silentsetup.bat" is OK. But I suggest the @pause should not taken out from run_setup.bat.
  
  Best regards,
  PST
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Heng Sin - 2007-05-08
    
    Hi,
    
    I've put back the @pause command and edited the wiki page to clarify the purpose of step1.
    
    Thanks for reporting this.
    
    Regards,
    Low
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- PST - 2007-05-08
  
  To Mico,
  
  ALso make sure that you select PL/Java in 2 screens,
  
  1. in "Installation Options"
  2. in "Enable Procedural Languages" : This page you cannot select it if Java SKD is not yet installed.
  
  Best Regards,
  PST
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Install on Windows XP + PostgreSQL

A full ERP system - moved to GitHub. See full description for details.

Forums

Help

Install on Windows XP + PostgreSQL

Install on Windows XP + PostgreSQL

A full ERP system - moved to GitHub. See full description for details.

Forums

Help

Install on Windows XP + PostgreSQL document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Install on Windows XP + PostgreSQL