Message templates that contain multiple lines are imported as one line

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Message templates that contain multiple lines are imported as one line

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

When importing message templates inApplications Manager that have multiple lines, the entire message is wrappedinto one line but each of the lines are separated by a '\n' character insteadof a carriage return.

---

Cause

The SQL procedure used to import themessage templates was using the '\n' character as the line separator instead ofCHR(10), which was not being evaluated correctly during the import process.

---

Resolution

This issue was resolved with therelease of Applications Manger v8.0 SP5, (Fix 26359).

---

Workaround

Run the following SQL statement as theApplications Manager's Oracle userid to replace all '\n' characters in theaw_msg_template table with CHR(10).

updateaw_msg_template setaw_template_body=replace(aw_template_body,'\n',CHR(10));