Manager for OAPP Request Set jobs aborting

Products

• CA Automic Dollar Universe

Issue/Introduction

Manager for OAPP v6.x (OEBS)

Request Set jobs were aborting with the following error:

####
Technical error. Command in error because an error occurred during the SQL statement execution. (exit code: 10)
An error occurred during the SQL statement execution (SQL exit code: 10).
The submission of the request set generated some errors.
Check the log and err files.
Exit code of /DUAS/NODE_node/bin/bin_oapp/uxstroapp is 10
####

Environment

Release : 6.x

Component : DOLLAR UNIVERSE APPLICATION SERVER - MANAGER FOR ORACLE APPLICATION

Cause

Request set fails if a computed flex value had a space character.

Issue was related to an unprotected SQL request, that only occurs if a flex value had a space character.

Resolution

Issue is fixed with Dollar.Universe 6.10.11

The SQL Packages delivered within the kit need to be imported again onto the OEBS application server:

Run the packages_activation.ksh script by entering in parameters the connection user to the database and its password.

Additional Information

Information to compile / update the PS SQL packages available in the documentation:

https://docs.automic.com/documentation/webhelp/english/ALL/components/DU_AS/latest/%20%20Dollar%20Universe%20Guides/help.htm#ORAHelp/Import%20UX%20Packages%20into%20the%20Database.htm%3FTocPath%3DManager%2520for%2520Oracle%2520Applications%7CConfiguring%2520the%2520Manager%2520for%2520Oracle%2520Applications%7CConfiguring%2520the%2520Oracle%2520Applications%2520Environment%2520of%2520the%2520Manager%7C_____1