I'm in ONE Automation - version 10.0.2. I have developed a SQL query (Stored in UC4 Variable object) and When I attempted using PREP_PROCESS_VAR function embedding the Variable contents- whlie executing the UC4 mail job it went to "FAULT OTHER MODE" prompting message - "more than 1023 characters".
Can someone please suggest, is there any other options to send mail from UC4 where I need the SQL output to be sent as mail body and not as an attachment.
Awaiting for your feedback.
The error message indicates that you are hitting the 1024 character limit that was only removed starting with v11.1.
Regarding the possibility to send the sql's output within the mail body, maybe you can get inspired by this : https://communities.ca.com/thread/241806360