ADempiere ERP

 In a production environment such a simple installation may not be sufficient, especially when there are more than a handful of concurrent users. Performance demands will require more attention to the architecture of the installation. In a production environment, it is highly recommended to separate the servers, with the  Application Server  and  Database Server  on different machines. http://wiki.adempiere.net/System_Requirements COMPUTER HARDWARE - Recommended configuration for above 100 users Server : Server class hardware with Dual Socket 2.xG and 4 Core dedicated                             300GB 15K RAID Protected                             16 GB RAM, Page file on SSD Recommended.                             1Gbps Network, Microsoft Windows 2008R2+                             Any Backup Application to protect structured data Client (End users) :   iCore / Core2Duo / Pentium IV             Processor 2.8 MHz or above          

     Some times, there will be few port conflicts with the ADempiere server with any other applications running on the same. We had a same kind conflict few days  back. Our internal server web port was 8080, as normal. and it was forward to 8888 for publishing the web application to the internet. During a server machine restart, the ADempiere server was reluctant to execute saying port 8080 is already in use.      The culprit was the Ammy Admin this time. For the remote access we were using the ammy admin in the server machine. So it was engaging the 8080 port.  There are TWO solutions for this.  1. Kill the application which engaging the web server port. 2. Change the web server port from 8080 to any other. The following are the simple steps to find out the engaged ports in the machine and killing those services. 1. netstat -b It will list down all the established communications and corresponding port. We will get to know the application details from this

1. Application theft, Database theft KeyStore Password is  the answer for the application theft. If email has set, you will get an email alert if server runs. 2. User Privileges Several user and Role privileges for window, process, workflow etc. Personal Lock 3. Busy Connection issue Try to use the default DB.java methods to execute your query. If you want to use the PreparedStatement, be sure you have closed the ResultSet and Connection String using ' DB.close(rs,pstmt) ;' in the finally block of your try 4.  Default Reports in a window is not active? Then, check any Report is mapped in the field Process of corresponding Tab of that window. The connected report is invoked with that button with different print formats(if defined!). 5. Slow down issue    1. http://www.chuckboecking.com/adempiere-idempiere-performance-tuning-scale-ability/    2. http://www.chuckboecking.com/adempiere-idempiere-high-volume-warehouse-locators-update/ "Table Direc

PostgreSQL is a highly customizable relational database management system (RDBMS) with a dazzling array of configuration options.   The postgresql.conf file is located in the \PostgreSQL\9.x\Data folder. You can tune the following sections of the postgresql.conf file to get the best performance.     CONNECTIONS AND AUTHENTICATION In this section change the following entries to the following: max_connections = 350 authentication_timeout = 7min RESOURCE USAGE (except WAL) In this section change the following entries to the following: shared_buffers = 256MB : PG Backends that need to access tables first look for needed blocks in this cache. If they are already there, they can continue processing right away. The change can be made with a   postmaster  command-line flag or by changing the value of   shared_buffers temp_buffers = 32MB max_prepared_transactions = 20 work_mem = 1024MB maintenance_work_mem = 1024MB QUERY TUNING effective_cache_size = 2048MB R

Send Email Through Adempiere E-Mail Configuration in Adempiere Mail Server This will specify the mail server to use Default: mailserver.(domain portion of %{serverFQDN}) Example: smtp.gmail.com Admin Email Use the default administrative mail address and it can be overwritten on client level Default: adempiere@(domain portion of %{ serverFQDN}) Example: teksalahadempiere@gmail.com Mail User Here we specify user of the default mail account Default: adempiere Example: teksalahadempiere Mail Password The password of the default mail account Default: adempiere Example: ********** 1    2.     Configuring Email in the client window The Client Definition Tab defines a unique client Step 1 .Login as admin Step  2 . Go to Menu -> System Admin -> Client Rules -> Client. In tab client fill fields’ mail host, request email request user and request user password. Finally press Test Email Button

ClickatellSMS .java /**  * For executing the code you may need the following requirements 1. Clickatell  * account : You may have a user name, password and an API id. 2. Need to import  * two external jar files i. smsj-20051126.jar (Source :  * https://sourceforge.net/projects/smsj/files/) ii. slf4j-simple-1.0-beta4.jar  * (Source :  * http://www.findjar.com/jar/org/slf4j/slf4j-simple/1.0-beta4/slf4j-simple  * -1.0-beta4.jar.html;jsessionid=74226B10CDFB28C183745181681836C7)  */ import java.io.IOException; import java.util.Properties; import org.marre.sms.SmsAddress; import org.marre.sms.SmsException; import org.marre.sms.SmsTextMessage; import org.marre.sms.transport.SmsTransport; import org.marre.sms.transport.SmsTransportManager; public class ClickatellSMS { /** * @param args */ public static void main(String[] args) { // The username, password and apiid is sent to the clickatell transport // in a Properties Properties props = new

In trunk/zkwebui/theme/default there are a couple of files: login-left.zul, vendor-logo.zul, version-info.zul etc. File version-info.zul contains the server info data. You can change these files so the login page appears as you please. In file vendor-logo.zul there is the possibility of customization to own logo, links etc. Configuring the files in trunk/zkwebui/theme/default enables you to change the appearance of the webui login page to your needs. A build is needed.

ADempiere have its own standard in its pop up messages. Normally we can use JOptionPane provided by  java. But you need to compromise its look and feel in your application. The following are the commonly used pop up box menthods in ADempiere in different instances. 1. mTab.fireDataStatusEEvent("Already open access","message",true); Used in callouts. 2. log.saveError("Invalid Date", message); Used in model classes. 3. ADialog.error(m_WindowNo, this, "FillMandatory", sb.toString());             return false; Used in client classes. If it is used in the higher build priority classes, you may have build error. 4. throw new IllegalStateException("Could not create accrual entry"); Used to throw exceptions in your code.

ADempiere 370LTS contains the following Ant build scripts which are required to build the entire system: tools/build.xml base/build.xml extend/build.xml client/build.xml JasperReports/build.xml serverRoot/build.xml serverApps/build.xml webStore/build.xml webCM/build.xml sqlj/build.xml posterita/posterita/build.xml zkwebui/build.xml install/build.xml More details in the following link http://www.adempiere.com/FR3409987_Cleanup_of_Ant_build_scripts

1. Get the jar file 2. Edit the Adempiere370\tools\Build.xml 3. Copy the jar file to Adempiere370\tools\ 4. Add the code fragment in the xml file     both in CSTools and CCTools eg:     <!-- Joda                -->     <zipfileset src="lib/joda-time-2.3.jar">         <patternset refid="manifest.exclude" />     </zipfileset> 5. If we are using the jar objects in base, client or zkwebui, edit respective build.xml files

Installing ADempiere 3.7.0 on Ubuntu 11.04 This is a simple how to install ADempiere 3.7.0 on Ubuntu 11.04. There are alot of installation How-To's, the reason I believe this might be useful is that the new 3.7.0 has some little twist in the installation and lots of the installation manuals here in the wiki are outdated. I will keep it as simple as possible to allow anyone new to ADempiere and even to Ubuntu to be able to get ADempiere running. Contents   [ hide ] 1   OS Installation 2   ADempiere Pre-Installation Routine 3   PostgreSQL Installation 4   ADempiere Installation 5   ADempiere Start OS Installation Install Ubuntu 11.04 directly on a PC or as a VM. During the installation, set "adempiere" as the username, that will make things a bit easier later on ADempiere Pre-Installation Routine After the installation finishes, lets get going with downloading the needed files. Open a Terminal Screen and type the following: wget http:

              This installation instruction is intended for initial installations where the database, application server and client all run on the same machine. For more complex installations, see   Installation Steps . An installation can take as little as 15 or 20 minutes if you start with the required downloads and do everything correctly. Other alternatives you might want to investigate are the   Windows Installer   or VMWare/VirtualBox AVA packages. However, the following method will give you much more control over the installation including upgrades with the latest patches and scripts. Before you begin, download each of the following packages: §   Java SE Development Kit   - Get the latest from   http://java.sun.com/javase/downloads/index.jsp . You only need the   JDK   without JavaFX, EE or NetBeans bundles. §   Postgre SQL   - Get the latest Windows install from   http://www.postgresql.org/download/windows . §   ADempiere Latest Release   - Download the latest Ad