FAQ

Q:	The AE databaseA database is an organized collection of data including relevant data structures. includes a lot of archived data. Can I just load the most recent data?
A:	You can open the Process Analytics Admin loader program by using a start parameter that loads only tasks that start at a particular point in time or afterwards. The argument form is "-d:YY/MM/DD hh:mm:ss" with the quotation marks being part of the parameter. For exampl, enter the argument string "-d:08/10/01 00:00:00" in order to load all data that is available since October 2008.
Q:	I use an SQL Server database. The ETL process fails when I try to load data from the AE database to the Process Analytics database because the transaction maximum log size is exceeded. What can I do to avoid this?
A:	You can set the recovery model to simple mode in the SQL Management Studio.
Q:	How do I know whether a process was successful if the ETL process starts automatically?
A:	You find this information in the application's Jave exit code. `0` - The ETL process was successful. `1` - Warnings have occurred during the loading process. `2` - The ETL process has failed.
Q:	An "Out Of Memory" error occurs when I execute the ETL process or load task data to Process Analytics. Why does this happen and how can I avoid this problem?
A:	Process Analytics Admin and Process Analytics are Java programs that require sufficient physical memory. This error occurs if there is not enough memory for the Java application. There may be two reasons for this problem. Either the system's memory is completely used or it is restricted to the Java application. Use the Java parameters -Xms and Xmx in order to provide more memory for the Java program. For further information about the Java command line parameters click: http://java.sun.com/j2se/1.5.0/docs/guide/vm/