Not Able to Run the SQL File Generated from Mobile User Administration -Export Configuration.
(Doc ID 2468096.1)
Last updated on NOVEMBER 01, 2018
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11 to 18.104.22.168.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 22.214.171.124 to 126.96.36.199.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.
On : 188.8.131.52.0, CA - Configuration Assistant
Not Able to Run the SQL file generated from Mobile User Administration -Export Configuration.
We are trying to run the SQL file generated from Mobile User Administration-Export Configuration from Configuration Assistant
It is throwing errors for some of the entries like below.
INSERT INTO mobile_users(
USER_ID, FIRSTNAME, LASTNAME, PASSWORD, SALT, NEW_USER_KEY, EMAIL, PHONE, COMPANY, ACTIVE, CREATED, DEACTIVATED, CREW_KEY, PERMISSION_SET)
'omatest1', 'oma', 'oma_last', HEXTORAW(13532523FA21342342B234C), HEXTORAW(E82353C1A0), null, 'firstname.lastname@example.org', '9642', 'nmstest', 'Y', null, null, null, 'internal');
We have manually modified and tried to run, it is inserting records without error.
These errors are coming while running this SQL file from SQL developer and ces_setup.
ERROR at line 4:
ORA-00907: missing right parenthesis
The issue can be reproduced at will with the following steps:
Run Config Assistant.
In the Mobile User Admin tab, press the Export Configuration button for the
Mobile Users section.
Copy one of the "INSERT INTO mobile_users" entries, and attempt to run it in to sqlplus manually.
You will get an error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document