Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 01:42
    marcalwestf labeled #3858
  • 01:42
    marcalwestf labeled #3858
  • 01:42
    marcalwestf labeled #3859
  • 01:42
    marcalwestf labeled #3859
  • 01:42
    marcalwestf labeled #3860
  • 01:42
    marcalwestf labeled #3860
  • 01:28
    marcalwestf review_requested #3839
  • 01:28
    marcalwestf review_requested #3839
  • 01:28
    marcalwestf review_requested #3839
  • 01:05
    marcalwestf labeled #3839
  • 01:05
    marcalwestf unlabeled #3839
  • 01:04

    marcalwestf on develop

    Allows define discount based on… Add garden world example for di… Add classath and 2 more (compare)

  • 01:04
    marcalwestf closed #3852
  • 01:00
    marcalwestf review_requested #3852
  • 01:00
    marcalwestf unlabeled #3852
  • May 17 22:01

    e-Evolution on develop

    Add dependences to classpath Ju… Merge pull request #3871 from e… (compare)

  • May 17 22:01
    e-Evolution closed #3871
  • May 17 21:42
    yamelsenih assigned #3871
  • May 17 21:42
    yamelsenih review_requested #3871
  • May 17 21:42
    yamelsenih labeled #3871
DulipKumara
@DulipKumara
Hi My name is dulip
I have installed Adempiere_393LTS and done setup sucesecfully. As a next step i tryed to import data clicking utils\RUN_ImportAdempiere.bat.
But it doesn't work and exit without any error.
DulipKumara
@DulipKumara
Can someone help on this?
sajeev
@sajeevsahadev
Check the below
1st Check - Have you set the Environment variable - POSTGRES_HOME?
2nd Check - Add the privilege for PostgreSQL - shorturl.at/vHT01
This must solve your issue.
DulipKumara
@DulipKumara
Dear Sajeev , I did as you said , but still same issue
See what i did to install adempiere
  1. Installed Postgresql 12
  1. installed java jdk1.8.0_211
  1. Download Adempiere_393LTS and setup
in the environment variables i did as follows
DulipKumara
@DulipKumara
in the system variables
set ADEMPIERE_HOME
set CLASSPATH
Set JAVA_HOME as C:\Program Files\Java\jdk1.8.0_211
Set JRE_HOME as C:\Program Files\Java\jre1.8.0_211
Set POSTGRES_HOME as C:\Program Files\PostgreSQL\12
DulipKumara
@DulipKumara
After that run RUN_setup.bat in adempiere file and did setting in database server as follow
database local server - localhost
database name - adempiere
data base user - adempiere
Data base type - postgresql
Data base port - 5432
DB admin password - postgres
data base password - default password
and Run_setup.dat was done successfully.
DulipKumara
@DulipKumara
facing issue in import data - RUN_ImportAdempiere.bat is not working
please check and advice
fincencius hasti mahardhika
@FincenciusHastiMahardhika333
For Adempiere Creator, Thank you Sir , you are Amazing
Michael McKay
@mckayERP
@DulipKumara can you share the error you are getting from RUN_ImportAdempiere?
Sanoop K
@sksanoopz
image.png
@all Is it possible to map direct JSP pages in Adempiere Form Window ? Currently I am using Adempiere Ver 3.9.0
DulipKumara
@DulipKumara
Dear Mr.Michael , yes it was happening when clicking RUN_ImportAdempiere.bat in utils folder.when clicking that bat file do not open any command window or any error . i am trying to run adempiere on windows 10 . i have tried on adempiere 380 and 393.in the both version couldn't run RUN_ImportAdempiere.bat.
fincencius hasti mahardhika
@FincenciusHastiMahardhika333
Dear Mr.Michael , can we use jboss wildfly 10.1 for replaced jboss AS for adempiere?
DulipKumara
@DulipKumara
Much appreciated your support to sot out
DulipKumara
@DulipKumara
Dear Mr.Michael , it is sorted out.I copied RUN_ImportAdempiere.dat file of adempiere version 3.0 into adempirere version 393 . then its working
Michael McKay
@mckayERP
@DulipKumara glad to hear it. I always run the bat files in powershell or a cmd window.
@FincenciusHastiMahardhika333 replacing Jboss would be challenging. If you are using the web interface, consider using the tomcat server instead. Jboss only makes sense if you need to use the swing client.
fincencius hasti mahardhika
@FincenciusHastiMahardhika333
Thank You Mr. Michael McKay for your advice
DulipKumara
@DulipKumara
hi can some one say how to import/restore postgre data bakup.
1 reply
backup file with custom file type.
using command line in windows
Sanoop K
@sksanoopz

Hai @All
We were using ADempiere 3.9.0 with some customised columns in the production.

As part of upgrade to 3.9.3, We have followed the steps mentioned in the http://wiki.adempiere.io/Migrate. We have used Migration Tool.

From the reading what I understood is

  1. Keep the Reference database as ADempiere 3.9.3 Seed
  2. Keep our current production database as Target
  3. Run 'Start Migration'

The process took 4.5 hours to completed in my 8GB RAM PC and generated 9792 errors and 1851 warnings.

While trying logging to the migrated production database to see the complete errors, we identified that certain columns we created in AD_Role is removed from that table(But AD_Column of the same table still exists).
The 'Migration' window is not recorded any errors.

The below is my doubts:

  1. Using Migration Tool, Can I migrate the production database 3.9.0 to directly 3.9.3?
  2. Why the migration tool is removing the columns from the AD_Role table?
  3. In case more columns are removed, how do we track those columns?
  4. How do we get the the error list(9792)? (While clicking on the View Errors Button - we are getting only 500 errors - in our case that was related to the add/drop constraints)
  5. Is there any another way to improve the speed of migration process?
MicrosoftTeams-image (41).png
sajeev
@sajeevsahadev
@sksanoopz I had tried this before - but could not make it happen from 3.9.0 to 3.9.3. I think the custom columns that I created in 3.9.0 will make some issues while migrating database. I had got around 5000+ errors that time. Some one else may can help you here.
e-Evolution
@e-Evolution
@sksanoopz HI , I migrated in past and I had the problems with the errors, but this issue with postgresql configuration
is necessary to custom the parameters, the ADempiere Migration Tools use intensively the DDL to recreate all database
2 replies
e-Evolution
@e-Evolution

On the other hand, for custom fields, they must be identified with their own entity or the customization entity so that the migration tool does not delete them, if your new fields in the window have the Dictionary entity, they will be overwritten or not migrated.

In other words, the migration tool is based on any definition in the application dictionary and only migrates those that are correctly identified.

On the other hand, if you have modified any component of the application dictionary, this change generates a history which should be marked as customization, since the tool at the end of the migration takes all the historical changes and applies those that were marked as customization

Prapon-VDevSoft
@PraponVDevSoft
Yes, After trying many times I just understand,
Makes the migration from version 3.7x to version 3.9x have a lot easier.
@e-Evolution @sajeevsahadev
e-Evolution
@e-Evolution
@sksanoopz about the problem of gen_random_uuid ()
do you need check that have the right PostgreSQL versión.