My Oracle Support Banner

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 FEBRUARY 25, 2019

Applies to:

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


With the release of NCC (Network Charging and Control) 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.

   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/CUSTOMER/geoData/closed
Feb  5 03:37:35.071980 numberDataImport(7792) NOTICE: errorDirectory = /IN/service_packages/CUSTOMER/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.


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

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