Not Able to Run the SQL File Generated from Mobile User Administration -Export Configuration.
(Doc ID 2468096.1)
Last updated on MARCH 10, 2019
Applies to:Oracle Utilities Network Management System - Version 188.8.131.52 to 184.108.40.206.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 220.127.116.11 to 18.104.22.168.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.
**Disclaimer:** This KM article may include the following abbreviations:
NMS - Oracle Network Management System
SQL - Standard Query Language
On : 22.214.171.124.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)
'<USER>', '<FIRST NAME>', '<LAST NAME>', HEXTORAW(<PASWWORD>), HEXTORAW(<VALUE>), null, '<EMAIL>', '<PHONE>', '<COMPANY>', '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