My Oracle Support Banner

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 1.12.0.3 to 2.3.0.2.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 2.3.0.2.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.

Symptoms

On : 2.3.0.2.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)
 VALUES (
  'omatest1', 'oma', 'oma_last', HEXTORAW(13532523FA21342342B234C), HEXTORAW(E82353C1A0), null, 'oma@nms-company.com', '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.


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.