Difference between revisions of "Version 10.9 Installable (Oct 2017)"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(9 intermediate revisions by the same user not shown)
Line 9: Line 9:


==About the Installable Version==
==About the Installable Version==
The installable version of the {{EnterpriseBrand}} allows you to create and manage a private cloud behind your firewall. {{EnterpriseBrand}} also helps you to set up a public cloud with a shared application and global data.  
The installable version of the {{EnterpriseBrand}} allows you to create and manage a private cloud behind your firewall. {{EnterpriseBrand}} also helps you to set up a public cloud with a shared application and global data.


===10.9 platform features and fixes===
===Version 10.9.7 Release===
For more information on new features and fixes, see [[Release Notes]].
Following fixes are available as part of this release:


===Software support===
:* LJP-7432
:* MySQL 5.7
:* SI# Number - 5343831
:* JDK 8
:::While creating a view, if it includes a formula column with one or more special characters, it results in an error.
For more information, see [[Software Requirements]] and [[Hardware Requirements]]
:::This issue is resolved. Now the user cannot create a formula column in a view that has one or more special characters (with the exception of white space).
 
:* LJP-6893
:* SI# Number - 5338309
:::While editing the Form Layout for some fields beyond 126 fields, at save, the order of the fields beyond the number 126, the fields are shuffled in an arbitrary order, but not the one chosen by user.
:::This issue is resolved and now any number of fields should be ordered as per the preference of the user and saved as expected.
 
===Version 10.9 Features and Fixes===
For information on fixes, see [[Version 10.9 Platform]]. The following new features are introduced for this release:
==== Certificates in your trustStore ====
:You must have these certificates in your trustStore if you are interacting with the AgileApps Cloud platform through any third party REST services.  
:''For more information, see'' [[Certificates in your trustStore]].
 
==== Enable HTML Sanitization ====
:When this option is selected, it prevents XSS attacks by allowing you to use only the HTML tags and attributes listed in the table. When this option is not selected, all the HTML tags and attributes are allowed and XSS attacks are not prevented.
:''For more information, see'' [[Widget Types]].


==New Installation==
==== Installing AgileApps Live for Windows ====
For new installation, see [[Quick Install Guide]] and [[Platform Installation Guide]].
: AgileApps Live is now available for Windows. To install AgileApps Live on Windows operating system, see [[Installing AgileApps Live for Windows]]


{{Note|The installation and operation of the {{EnterpriseBrand}} requires Java 8. But, the custom code in Java Class continues to be validated against Java 6 syntax as the instrumentation engine responsible for monitoring resource utilization works only on Java 6 byte codes.}}
==== Create record with specific ID ====
:You can define your own record ID while creating a record through REST. For more information, see [http://agileappscloud.info/aadev/REST_API:record_Resource#Create_record_with_specific_ID Create record with specific ID].


==Upgrading an existing installation==
==== Update a record using filter ====
Upgrade options available:
:You can update a record using filter criteria. For more information, see [http://agileappscloud.info/aadev/REST_API:record_Resource#Update_a_record_using_filter Update a record using filter].
:* Version 10.5 to Version 10.9
:* Version 10.6 to Version 10.9
:* Version 10.7 to Version 10.9
:* Version 10.8 to Version 10.9


===Upgrade program===
==== SQL Parameterized query ====  
AgileApps Cloud uses an upgrade program to update from an existing application server to the target application server. The upgrade program migrates the custom JARs from the existing application server to the target application server.  
:To execute the SQL query, you have to provide the parameters in the prepared statement. This parameterized query avoids SQL injection issues. AgileApps Cloud supports parameterized SQL query as well as the plain SQL query. For more information, see [[SQL Parameterized query]]
{{Note| 10.9 is the target application server.}}


====Prerequisites:====
==== Capability to trigger business rules when user changes teams ====
:* Set the value for '''max_allowed_packet''' property in '''my.cnf''' or '''my.cfg''' (MySQL configuration files) under '''[client]''', '''[mysqld]''' & '''[mysqldump]''' sections. If you are installing any package through [[Packages]] using AgileApps Cloud application, you must have at least 512 MB of RAM or ten times the size of package.
:webMethods AgileApps Cloud now supports business rule events whenever a user changes memberships to various teams that he or she could be part of. For more information, see [[Event Rules]].
:* Verify the privileges to access the database with the username, password, host-name and port as mentioned in the '''com.softwareag.catalina.resource.pid-agileappsRN.properties''' file under the target application server. Use the following command to ensure that you have the database access:
::;mysqldump -u<DB_USER_NAME> -p<DB_PASSWORD> -h<DB_SERVER_HOST_NAME> -P<DB_PORT> db<DB_NUMBER> > db<DB_NUMBER>.sql
::For example: mysqldump -uthomas -pthomas-hvmaalind05 -P3306 db1108948326 > db1108948326.sql


====Upgrading to 10.9====
==== Support on Windows 2016 and Suse Linux 12 ====
#Stop the 10.5 or 10.6 or 10.7 or 10.8 application server.
:webMethods AgileApps installation is now supported on Windows Server 2016 and SLES12 operating systems, thus improving both the developer and production environments. For more information, see [[Software Requirements]].
#Install the 10.9 application server using SoftwareAG installer. For more information, see '''webMethods 10.0''' Installation documents available on Empower.
{{Important|
*Do not run the 10.9 application server after installation.
*After the installation, the 10.9 application server exists in parallel with the 10.5 or 10.6 or 10.7 or 10.8 application server.
*Do not initiate the upgrade program.}}
:3. Create a new folder '''aal-upgrade''' in the installed 10.9 root directory.
:4. Extract '''upgrade.tar.gz'''. The extracted folder '''upgrade''' is available at '''{install_dir}/AgileApps/upgrade'''. The extracted folder consists of three files '''upgrade.sh, upgrade.jar, upgrade_supported_configurations.txt,''' and one folder '''db-upgrade-patches'''.
::The '''upgrade_supported_configurations.txt,''' is a new file added in this upgrade program. This file contains properties and configurations that are not available in the source or target installation. This file helps you in copying the custom libraries like the third-party JARs available at '''{install_dir}/AgileApps/lib''' or '''{install_dir}/AgileApps/platformlib or {install_dir}/AgileApps/userlib''' and custom configurations present in '''wrapper.conf''' and '''custom_wrapper.conf''' files under '''{install_dir}/profiles/LJP/configuration'''
:5. Move the extracted '''Upgrade''' folder to '''aal-upgrade''' folder.
:6. Provide executable permission to '''upgrade.sh''' file.
:7. Run '''upgrade.sh''' file with mandatory parameters.


=====Mandatory parameters=====
==== Refresh of applications in Marketplace ====
:# '''--aal-path''' - provide the folder path of the existing application server.  
:webMethods AgileApps Cloud has now refreshed all the existing application templates in the Marketplace and introduced new applications for customers to install in their tenants and customize it as per their requirements. All these applications now come with some sample data, a template external site, and customizable object models. These applications are contributed by the user community and hence not supported by Software AG. There is a new application sample called ComplaintDesk which has speech recognition capability added to the external site. For more information, see [[Community Marketplace]].
:#:Example: '''--aal-path=/{install_dir}/aal-lab/AgileApps10.6'''
:# '''--aal-version''' - provide the version number of the target application server.
:#:Example: '''--aal-version=10.9'''


=====Non-mandatory parameters=====
==== Improvements in Job scheduling ====
:# '''--aal-db-backup-folder {-BDF}''' - provide a path for database backup of all relationals and tenants.
:webMethods AgileApps Cloud now improves the way jobs are scheduled and prioritized for execution on the platform. These architectural changes result in reducing the number of job failures and also consume lesser memory and CPU resources. For more information, see [[Job Scheduler]].
:#:Example: '''--aal-db-backup-folder=/{install_dir}/aal-lab/AgileApps10.6_DB_Backup'''
:# '''--remote-source {-RS}''' - provide this option if the source is installed on a remote machine. If you provide the RS parameter, then the upgrade program ignores the --aal-path from the mandatory parameter and a new source path is set.
:#:Example: --remote-source=no|yes OR --remote-source (~ yes)
{{Note|
#If the upgrade program finds RS parameter in the command then the upgrade program copies the required and related configurations from the remote machine to the local machine and upgrades the server.  
#The upgrade program uses Linux SCP command for connecting and transferring the source configurations. This requires you to provide the user credentials to access the remote machine.}}
::3. '''--enable-quartz {-Q}''' - This parameter enables quartz configuration in the target application server. This parameter includes the Import, Export and Reports configurations also. Disable this parameter if you are using a different server or node for running the Quartz configuration either by not providing this parameter or by providing the value as ‘no’ for this parameter.
::::Example: --enable-quartz=no|yes OR --enable-quartz (~ yes)
::4. '''--ignore-db-upgrade {-IDU}''' - This parameter is for the environment with multiple nodes or servers connected to a centralized database server. Disable the database upgrade for target application server.
::::Example: --ignore-db-upgrade=no|yes OR --ignore-db-upgrade (~ yes)


=====Note=====
==== Improvements in UI performance ====
::*Provide the mandatory parameter’s value separated by equal (=) character. For example, '''--aal-version=10.8'''
:webMethods AgileApps Cloud has considerably improved the performance of the end-user user interface thus improving the experience for the user.  
*Provide the non-mandatory parameters with values ‘yes’ or ‘no’ separated by equal (=) character. For example, '''--move-reportdb-cfg=yes''' and '''--move-reportdb-cfg=no'''
   
*You can also provide the non-mandatory parameters without the value ‘yes’. For example, '''--move-reportdb-cfg'''
*If you do not mention the non-mandatory parameter, the upgrade utility program does not consider the parameter.
*The values ‘yes’ and ‘no’ are not case sensitive.  
*Syntax: {install_dir}/aal-upgrade/upgrade.sh mandatory-param1=val1 mandatory-param2=val2 mandatory-param3=val3 non-mandatory-param4 non-mandatory-param5 non-mandatory-param6. For example:  '''upgrade.sh --aal-path=/home/aal-lab/AgileApps10.6  --aal-version=10.8  --aal-db-backup-folder=/home/aal-lab/AgileApps10.6_DB_Backup --move-reportdb-cfg  --move-tomcat-ports  --move-quartz'''
*In case of errors, look at the log messages available at '''upgrade.log''' file under '''aal-upgrade/upgrade/logs.'''.
*After runnning the upgrade.sh file, SummaryReport.txt is generated at '''aal-upgrade/upgrade/SummaryReport.txt'''.


:8. Move the documents and temporary files or folders from the existing application server to the target application server.  
===Software support===
::(a) '''<SOURCE_INSTALLATION_HOME_PATH>/docs''' to '''<TARGET_INSTALLATION_HOME_ PATH>/docs''' 
:* MySQL 5.7
::(b) '''<SOURCE_INSTALLATION_HOME_ PATH>/temp''' to '''<TARGET _INSTALLATION_HOME_ PATH>/temp'''
:* JDK 8
For more information, see [[Software Requirements]] and [[Hardware Requirements]]


:9. Start the 10.8 application server available at '''{install_dir}/profiles/LJP/bin/startup.sh'''
==New Installation==
:10. In case of errors, check:
For new installation, see [[Quick Install Guide]] and [[Platform Installation Guide]].  
::'''{install_dir}/profiles/LJP/logs/wrapper.log'''
::'''{install_dir}/profiles/LJP/logs/relationals.log'''
:11. Change the ‘Document Directory’ and ‘Temp Directory’ folder path in 'Configure Service settings' in the target application server.
:12. For custom configuration, proceed to [[Configuring the Application Server]].
::Custom configuration considerations:
::*This upgrade program does not copy custom libraries like the third-party JARs available at '''{install_dir}/AgileApps/lib''' or '''{install_dir}/AgileApps/platformlib or {install_dir}/AgileApps/userlib'''. You must move such libraries manually from the existing application server to the target application server.
::*This upgrade program does not copy the custom configurations present in '''wrapper.conf''' and '''custom_wrapper.conf''' files under '''{install_dir}/profiles/LJP/configuration'''. You must move such configurations manually from the existing application server to the target application server.
::*


==Upgrading an existing installation==
For information on upgrading to version 10.9, see [[Upgrading to Version 10.9]].
<noinclude>
<noinclude>


[[Category:ISV Release Notes]]
[[Category:ISV Release Notes]]
</noinclude>
</noinclude>

Latest revision as of 07:25, 10 May 2021

Release Notes for the installable version of the AgileApps Cloud platform.

See also:

About the Installable Version

The installable version of the AgileApps Cloud platform allows you to create and manage a private cloud behind your firewall. AgileApps Cloud platform also helps you to set up a public cloud with a shared application and global data.

Version 10.9.7 Release

Following fixes are available as part of this release:

  • LJP-7432
  • SI# Number - 5343831
While creating a view, if it includes a formula column with one or more special characters, it results in an error.
This issue is resolved. Now the user cannot create a formula column in a view that has one or more special characters (with the exception of white space).
  • LJP-6893
  • SI# Number - 5338309
While editing the Form Layout for some fields beyond 126 fields, at save, the order of the fields beyond the number 126, the fields are shuffled in an arbitrary order, but not the one chosen by user.
This issue is resolved and now any number of fields should be ordered as per the preference of the user and saved as expected.


Version 10.9 Features and Fixes

For information on fixes, see Version 10.9 Platform. The following new features are introduced for this release:

Certificates in your trustStore

You must have these certificates in your trustStore if you are interacting with the AgileApps Cloud platform through any third party REST services.
For more information, see Certificates in your trustStore.

Enable HTML Sanitization

When this option is selected, it prevents XSS attacks by allowing you to use only the HTML tags and attributes listed in the table. When this option is not selected, all the HTML tags and attributes are allowed and XSS attacks are not prevented.
For more information, see Widget Types.

Installing AgileApps Live for Windows

AgileApps Live is now available for Windows. To install AgileApps Live on Windows operating system, see Installing AgileApps Live for Windows

Create record with specific ID

You can define your own record ID while creating a record through REST. For more information, see Create record with specific ID.

Update a record using filter

You can update a record using filter criteria. For more information, see Update a record using filter.

SQL Parameterized query

To execute the SQL query, you have to provide the parameters in the prepared statement. This parameterized query avoids SQL injection issues. AgileApps Cloud supports parameterized SQL query as well as the plain SQL query. For more information, see SQL Parameterized query

Capability to trigger business rules when user changes teams

webMethods AgileApps Cloud now supports business rule events whenever a user changes memberships to various teams that he or she could be part of. For more information, see Event Rules.

Support on Windows 2016 and Suse Linux 12

webMethods AgileApps installation is now supported on Windows Server 2016 and SLES12 operating systems, thus improving both the developer and production environments. For more information, see Software Requirements.

Refresh of applications in Marketplace

webMethods AgileApps Cloud has now refreshed all the existing application templates in the Marketplace and introduced new applications for customers to install in their tenants and customize it as per their requirements. All these applications now come with some sample data, a template external site, and customizable object models. These applications are contributed by the user community and hence not supported by Software AG. There is a new application sample called ComplaintDesk which has speech recognition capability added to the external site. For more information, see Community Marketplace.

Improvements in Job scheduling

webMethods AgileApps Cloud now improves the way jobs are scheduled and prioritized for execution on the platform. These architectural changes result in reducing the number of job failures and also consume lesser memory and CPU resources. For more information, see Job Scheduler.

Improvements in UI performance

webMethods AgileApps Cloud has considerably improved the performance of the end-user user interface thus improving the experience for the user.


Software support

  • MySQL 5.7
  • JDK 8

For more information, see Software Requirements and Hardware Requirements

New Installation

For new installation, see Quick Install Guide and Platform Installation Guide.

Upgrading an existing installation

For information on upgrading to version 10.9, see Upgrading to Version 10.9.