search cancel

Message templates that contain multiple lines are imported as one line

book

Article ID: 89611

calendar_today

Updated On:

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));