Which User Avoids the "User does not have permission to use the import tool" Error when Using the numberDataImport Tool (Doc ID 1526135.1)

Last updated on APRIL 29, 2014

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.0 and later
Oracle Solaris on SPARC (64-bit)

Goal

With the release of NCC (Network Charging and Control) 5.0.0.1 comes a new tool, /IN/service_packages/ACS/bin/numberDataImport, which gives customers the ability to create CSV datasets, import them into a Oracle Database table and look up said data via the new Table Lookup Control Plan Feature Node.

More information can be found in the NCC 5.0.01 Release Notes.  The Release Notes can be found in the Patch 14637739 archive, which can be downloaded from My Oracle Support.

Usage:
   numberDataImport [-F|-D] -s -i
        -F to force Full import mode
        -D to force Delta import mode
        -u specifies the username/password
        -s specifies the dataset name
        -a specifies the ACS Customer name
        -i specifies the import file name

   Check $ESERV_CONFIG_FILE for location of configuration file

   Note that when no import mode is specified, mode is auto i.e.
        Full mode is applied when the Mapping table in the DB is empty.
        Delta mode is applied when the Mapping table in the DB is NOT empty.

When running the numberDataImport tool, it is unclear what user is required as an argument to the "-u" switch and results in the error:

$ ./numberDataImport -u smf/*** -i import.csv
Feb  5 03:37:35.071454 numberDataImport(7792) NOTICE: closedDirectory = /IN/service_packages/TELSTRA_CLEAR/geoData/closed
Feb  5 03:37:35.071980 numberDataImport(7792) NOTICE: errorDirectory = /IN/service_packages/TELSTRA_CLEAR/geoData/error
Feb  5 03:37:35.072190 numberDataImport(7792) NOTICE: progressDotInterval = 1000
Feb  5 03:37:35.072388 numberDataImport(7792) NOTICE: dbCommitBatchSize = 1000
Feb  5 03:37:35.072582 numberDataImport(7792) NOTICE: lockFile = /IN/service_packages/ACS/tmp/numberMappingImport.lock
User does not have permission to use the import tool.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms