CA Technologies

CA Workload Automation DE r11.3 Readme

2.0 Known Issues
2.1 Using an Oracle Database on a 32-bit Windows System
2.2 Server Shuts Down after Microsoft SQL Server Database Is Recycled
2.3 Update the Timezone Data for Your JRE Version
2.4 Error When Migrating Artifacts from r5.0.3 to r11.3
2.5 Installing CA WA Web Services on Windows 2008
2.6 Custom Report Fails to Execute after SQL Query is Updated
2.7 Using Monthly as a Scheduling Term
2.8 Contradictory Scheduling Terms Lead to Unpredictable Results
2.9 Updating Events with Absolute Past Dates
2.10 Cannot Update Array Values on Web Client

3.0 Access the Product Documentation

4.0 Contact CA Technologies

1.0 Welcome

Welcome to CA Workload Automation DE. This readme contains known issues and other information discovered after publication.

Note: For information about new and changed features, supported systems and requirements, and related documentation, see the CA Workload Automation DE Release Notes.

For the latest version of this Readme, visit http://ca.com/support.

2.0 Known Issues

2.1 Using an Oracle Database on a 32-bit Windows System

Valid on Windows with an Oracle database

If you use an Oracle database on a 32-bit Windows system, the server may crash with a database error (ORA-04030) during periods of heavy workload. By default, the Windows memory architecture limits the maximum amount of memory available to a single process to 2 GB. To overcome this limitation, extend the Windows 2-GB process address space by setting the /3GB and /PAE switches in the boot.ini file.

The following example shows the switches in bold:

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2003" /3GB /PAE

Note: For more information about increasing memory space for Oracle on Windows, see the Oracle documentation.

2.2 Server Shuts Down after Microsoft SQL Server Database Is Recycled

Valid on Windows with a Microsoft SQL Server database

When running heavy workload on a Microsoft SQL Server database, the CA Workload Automation DE server may shut down after the database server is recycled. When this issue occurs, server threads waiting to log in to the database fail to timeout and do not try to reconnect to the database.

To avoid this issue, you can modify the jdbc.URL database connection property by setting the following parameter:

loginTimeout
Specifies the number of seconds until the server threads timeout. After the server threads timeout, the server tries to reconnect to the database based on the relational.database.retry.attempts and relational.database.retry.interval database connection properties.

Default: 15 seconds

Note: For more information about modifying the database connection properties, see the Implementation Guide.

Example: Setting the loginTimeout Parameter

The following example sets the loginTimeout parameter to 5 seconds:

jdbc.URL=jdbc:sqlserver://;servername=<hostname>;port=<portnumber>;DatabaseName=<databasename>;loginTimeout=5

Note: You may have to adjust the timeout value depending on your environment and workload usage.

2.3 Update the Timezone Data for Your JRE Version

The JRE that runs the CA Workload Automation DE server contains timezone data that can become outdated over time. For example, if timezone boundaries or Daylight Saving Time (DST) rules change in a location, the JRE the server uses may no longer reflect the correct timezone data. As a result, the server might resolve the wrong time when scheduling using the updated timezone.

To update the timezone data for your JRE version, you can run the timezone updater tool (tzupdater) provided by your JRE vendor.

Note: For more information about the tzupdater tool, refer to the documentation provided by your JRE vendor website.

To update the timezone data for your JRE version

Download the latest tzupdater tool from the JRE vendor website for your operating system.

Extract the tzupdater tool.
- On UNIX, enter the following command to extract the files to a temporary directory:
```
tar -xvf tzupdate.tar
```
- On Windows, unzip tzupdate.zip into a temporary directory.
  tzupdate specifies the file name of the tzupdater tool that you downloaded.

Stop the server.

(Solaris systems only) Delete the following file:
- On UNIX:
```
install_dir/jre/lib/zi/EST
```
- On Windows:
```
install_dir\jre\lib\zi\EST
```
  install_dir specifies the server installation directory.

Enter the following command from a command prompt:
- On UNIX:
```
"install_dir/jre/bin/java" -jar "temp_dir/tzupdater.jar" -f -bc
```
- On Windows:
```
"install_dir\jre\bin\java" -jar "temp_dir\tzupdater.jar" -f -bc
```
  temp_dir specifies the temporary directory where you extracted the tzupdater tool.

Start the server.
Note: If you have CA WA High Availability configured, repeat Steps 3-6 on the Standby server.

2.4 Error When Migrating Artifacts from r5.0.3 to r11.3

Symptom:

When I try to migrate artifacts from r5.0.3 to r11.3, the migration utility aborts and the following error appears in the migration log:

ERROR com.cybermation.espresso.migration.Main - Migration failed due to error java.lang.NoClassDefFoundError: com/odi/IPersistent

Solution:

Copy the pro.jar file from the r5.0.3 source server to the r11.3 destination server.

To correct this problem

Locate the pro.jar file from the following location on the r5.0.3 source server:
- On Windows:
```
install_dir\JAR_Library\
```
- On UNIX:
```
install_dir/JAR_Library/
```
- install_dir
  Specifies the r5.0.3 server installation directory.

Copy the pro.jar file to the following location on the r11.3 destination server:
- On Windows:
```
install_dir\migration\5.0-lib\
```
- On UNIX:
```
install_dir/migration/5.0-lib/
```
- install_dir
  Specifies the r11.3 server installation directory.

Rerun the migration utility.

Delete the copied pro.jar file from the r11.3 server after the migration is complete.

Note: For more information about migration, see the Implementation Guide.

2.5 Installing CA WA Web Services on Windows 2008

Valid on Windows 2008

When you install CA WA Web Services on Windows 2008, we recommend that you use a 32-bit JDK. Although CA WA Web Services supports a 64-bit JDK on Windows 2008, the uninstall program cannot be run on a Windows 2008 64-bit server. If you use a 64-bit JDK on Windows 2008, you must delete the CA WA Web Services installation folder to uninstall the product.

2.6 Custom Report Fails to Execute after SQL Query is Updated

When you update a custom report, a problem can occur if you change the FROM criteria in the SQL query used by the report. For example, assume that you change the SQL query "SELECT * FROM ESP_APPLICATION" to the following:

SELECT * FROM ESP_AMS_DF

In the original report, the columns of the ESP_APPLICATION table are selected; in the updated report, the columns of the ESP_AMS_DF table are selected. Due to a known issue with Business Intelligence and Reporting Tools (BIRT), the column information from the ESP_APPLICATION table does not get deleted. As a result, the updated custom report fails to execute.

If this problem occurs, remove the column information for the deleted columns from the XML source.

To correct this problem

Open the XML Source tab of the report design.

Remove the column entries from the <list-property name="boundDataColumns"> tag. Due to the known issue, these entries do not get deleted. For example:

 <list-property name="boundDataColumns">
   <structure>
     <property name="name">APPL_ID</property>
     <text-property name="displayName">APPL_ID</text-property>
     <expression name="expression" type="javascript">dataSetRow["APPL_ID"]</expression>
     <property name="dataType">decimal</property>
    </structure>
    <structure>
      <property name="name">JOB_NAME</property>
      <text-property name="displayName">JOB_NAME</text-property>
      <expression name="expression" type="javascript">dataSetRow["JOB_NAME"]</expression>
      <property name="dataType">string</property>
     </structure>
     <structure>
       <property name="name">APPL_NAME</property>
       <text-property name="displayName">APPL_NAME</text-property>
       <expression name="expression" type="javascript">dataSetRow["APPL_NAME"]</expression>
       <property name="dataType">string</property>
     </structure>
   </list-property>

In this example, you would delete the structure tags for the APPL_ID, JOB_NAME, and APPL_NAME columns.

Save the updated XML.

Add new columns from the updated data set.

Upload the updated report to the server and run the report.
The report runs using the new columns.

2.7 Using Monthly as a Scheduling Term

Specifying MONTHLY as the run criteria for a job can produce unpredictable results. If you want to schedule a job to run at the same time each month, you must specify additional qualifiers. For example, to schedule a job on the third day of each month, specify 3RD MONTHLY.

Note: To schedule a job on the last day of the month, specify LAST DAY OF MONTH.

2.8 Contradictory Scheduling Terms Lead to Unpredictable Results

Using contradictory scheduling terms can lead to unpredictable results. For example, the following schedule criteria does not produce the expected results:

EVERY 30 MINUTES DAILY ENDING 1ST SEPTEMBER,2011

In this example, EVERY 30 MINUTES and DAILY are contradictory and should not be used together. To run a job every 30 minutes until July 15, 2011, use the following schedule criteria:

EVERY 30 MINUTES ENDING 1ST SEPTEMBER,2011

2.9 Updating Events with Absolute Past Dates

When scheduling Events, you can specify an absolute past date. For example, you can rerun an Application using a past date such as JAN 1ST 2011. If you specify an absolute past date, the Event triggers immediately, but jobs are selected and variables resolved based on the past date. However, every time you update an Event with an absolute past date, the server triggers the Event immediately.

To update an Event with an absolute past date without triggering the Event immediately, follow these steps:

Suspend the Event that you want to update.

Make the necessary changes to the Event definition.

Save the Event.

Resume the Event.

When the updated Event is resumed, the server does not trigger the Event immediately.

2.10 Cannot Update Array Values on Web Client

When inserting a job into an Application on Web Client, you cannot update the array values specified in the job definition. This issue applies to Application and Web Services jobs that support arrays as input parameters such as Entity Bean jobs. To avoid this issue, you can add an array parameter with the updated values and then delete the existing array parameter.

Note: This issue does not apply to CA WA Desktop Client.

3.0 Access the Product Documentation

You can access the CA Workload Automation DE documentation using the Bookshelf. The Bookshelf provides PDF and HTML links for all the guides and online help.

To open the Bookshelf

Open the Documentation directory.

Open the Bookshelf directory.

Double-click Bookshelf.html.
If you receive a browser security warning about active content, you are accessing the Bookshelf and documentation HTML files from a local drive in Microsoft Internet Explorer.

To avoid this message, you can do one of the following:
- View the Bookshelf in an Internet browser other than Internet Explorer
- View the Bookshelf from a network drive or through the HTTP protocol by going to http://support.ca.com and searching for your documentation set

4.0 Contact CA Technologies

Contact CA Support

For your convenience, CA Technologies provides one site where you can access the information that you need for your Home Office, Small Business, and Enterprise CA Technologies products. At http://ca.com/support, you can access the following resources:

Online and telephone contact information for technical assistance and customer services

Information about user communities and forums

Product and documentation downloads

CA Support policies and guidelines

Other helpful resources appropriate for your product

Providing Feedback About Product Documentation

If you have comments or questions about CA Technologies product documentation, you can send a message to techpubs@ca.com.

To provide feedback about CA Technologies product documentation, complete our short customer survey which is available on the CA Support website at http://ca.com/docs.