report

Report Generation

Generates reports for regional NPAC databases and supplemental databases.

Keyword

report

Permission

The user must be defined as a member of the primary group lsms.

Syntax

$LSMS_DIR/report <OutputFile> <ReportType> [<SP>|<LRN>|<DPC>|<Region>|<SplitStatus>] [<StartTN>] [<EndTN>] [<StartNPB>] [<EndNPB>]

Options

None.

Parameters

OutputFile

The filename for the file in which to store the report. This is a mandatory parameter whose value is the filename. The filename is appended with the value specified for <ReportType> and the file is stored in the directory where the command is run.

ReportType

The type of report to create. This is a mandatory parameter; use one of the following values:

SPA - Service Provider Administrative Report

SPN - Service Provider Network Report

EMR - Element Management Report

6DT - Six Digit Translation Report

10DT - Ten Digit Translation Report

SPL - NPA Split Data by Status Report

SBL - Subscription Report by LRN

SBS - Subscription Report by Service Provider ID

SBT - Subscription Report by TN

NBL - Number Pool Block Report by LRN

NBS - Number Pool Block Report by Service Provider ID

NBN - Number Pool Block Report by NPA-NXX-X

SPD - Service Provider Data Report

SP

Four-character alphanumeric string to specify Service Provider ID. This is a mandatory parameter when <ReportType> is set to SBS or NBS; optional when <ReportType> is set to 6DT,10DT, EMR, or SPN; otherwise not allowed.

LRN

Ten-digit string (values 0000000000–9999999999) to specify Location Routing Number. This is a mandatory parameter when <ReportType> is set to SBL or NBL; otherwise not allowed.

DPC

Eleven-character string of format xxx-xxx-xxx (where each xxx can have a value 000 to 256) to specify Destination Point Code. This is an optional parameter when <ReportType> is set to 6DT or 10DT; otherwise not allowed.

Region

NPAC region. This is an optional parameter when <ReportType> is set to SPL; otherwise not allowed. Use one of the following values:

MidAtlantic

Midwest
Northeast

Southeast

Southwest

Western

Westcoast

Canada

SplitStatus

NPA-NXX split status. This is an optional parameter when <ReportType> is set to SPL; otherwise not allowed. Use one of the following values:

Active

Pending

Error

StartTN

Starting telephone number in a range of telephone numbers. This is a mandatory parameter when <ReportType> is set to SBT. Valid values are 10 digits from 0000000000 to 9999999999.

EndTN

Ending telephone number in a range of telephone numbers. This is a mandatory parameter when <ReportType> is set to SBT. Valid values are 10 digits from 0000000000 to 9999999999.

StartNPB

Starting value in a range of number pool blocks. This is a mandatory parameter when <ReportType> is set to NBN. Valid values are 7 digits from 0000000 to 9999999.

EndNPB

Ending value in a range of number pool blocks. This is a mandatory parameter when <ReportType> is set to NBN. Valid values are 7 digits from 0000000 to 9999999.

Sample Commands

 # Generate SPA report for MidAtlantic NPAC
 $ $LSMS_DIR/report MidAtlanticDB supDB report.output SPA
   # Generate SBL report for MidAtlantic NPAC for LRN 9194605500
 $ $LSMS_DIR/report MidAtlanticDB supDB report.output SBL 9194605500
 # Generate SPL report 
> $LSMS_DIR/report MidAtlanticDB supDB report.out SPL
# Generate SBS report for Midwest NPAC for all Subscriptions having a service provider of TKLC and a TN in the range of 9194600000 to 9195600000
$ $LSMS_DIR/report MidwestDB supDB report.out SBS TKLC 9194600000 9195600000
# Generate SBT report for Western NPAC for all Subscriptions having a TN in the range of 9194600000 to 9195600000
$ $LSMS_DIR/report WesternDB supDB report.out SBT 9194600000 9195600000

Files

Table A-25 shows the files for the report command.

Files: report
Filename	Type	Location
Output	Report Output File	Directory where command is run

Response Notes

The report command can process approximately 300-500 records per second, depending upon the type of report.

To view the report, change directory to the directory where the command was run and use any text editor to open the file named in the command. If you run the command from the $HOME/LSMSreports directory, you can also view the report through the graphical user interface; for information, refer to the Database Administrator's Guide.

Possible Errors

Error Messages: report
Exit Code	Message	Cause	Suggested Recovery
1	DATABASE <name> NOT FOUND	Specified database could not be found	Verify that the database exists and try the command again.
1	disk space check failed	Attempt to check available disk space failed	Remove unnecessary reports from disk.
1	End TN must be greater than Start TN value.	The start TN is greater than the end TN in the range of TNs to generate an LSMS subscription report	Try the command again using the correct syntax and supplying all required arguments.
1	Insufficient disk space available to generate report. N bytes of disk space required: n bytes of disk space available	Insufficient disk space to save report	Remove unnecessary reports from disk.
1	Invalid End TN value - <EndTN>	The last TN in the range of TNs to generate an LSMS subscription report is out of range. The valid range of values for a telephone number is 0000000000...9999999999.	Try the command again using the correct syntax and supplying all required arguments.
1	Invalid Report Type Specified <Report Type>	The value specified for the ReportType parameter is not valid.	Try the command again using the correct syntax and supplying all required arguments.
1	Invalid Start TN value - <StartTN>	The first TN in the range of TNs to generate an LSMS subscription report is out of range. The valid range of values for a telephone number is 0000000000...9999999999.	Try the command again using the correct syntax and supplying all required arguments.
1	LRN argument is required for SBL/NBL report	If <ReportType> parameter is specified as SBL or NBL, the <LRN> parameter must also be specified	Try the command again using the correct syntax and supplying all required arguments.
3	LRN argument must be exactly 10 numeric digits	An <LRN> parameter that had less than 10 digits, more than 10 digits, or non-numeric characters was specified	Try the command again using the correct syntax and supplying all required arguments.
1	Missing mandatory arguments	The command was specified with an insufficient number of arguments.	Try the command again using the correct syntax and supplying all required arguments.
1	NO ACCESS RIGHTS TO DATABASE	Requesting operator does not have access rights to the database	Change user to a username that has access rights to the database.
4	Service Provider argument must have from 1 to 4 characters	The <SP> parameter was specified with more than 4 characters	Try the command again using the correct syntax and supplying all required arguments.
1	Service Provider argument required for SBS/NBS report	If <ReportType> parameter is specified as SBS or NBS, the <SP> parameter must also be specified	Try the command again using the correct syntax and supplying all required arguments.
1	StartNPB argument is required for NBN report	If <ReportType> parameter is specified as NBN, the <StartNPB> parameter must also be specified	Try the command again using the correct syntax and supplying all required arguments.
1	StartTN argument is required for SBT report	If <ReportType> parameter is specified as SBT, the <StartTN> parameter must also be specified	Try the command again using the correct syntax and supplying all required arguments.
1	Unable to determine home directory of user - report could not be generated	Report could not be stored in home directory of user	Contact the My Oracle Support (MOS).
1	Unable to open <filename> - report could not be generated	Could not open the file in which to save the report	Contact the My Oracle Support (MOS).
1	Usage: report <regional_database_name sup_database_name> output file <report_type>[LRN\|SP]	Operator did not supply the correct number of arguments	Try the command again using the correct syntax and supplying all required arguments.
1	Wrong number of arguments for Split report	The <ReportType> parameter was specified as SPLA or SPLR, but the wrong number of parameters was specified	Try the command again using the correct syntax and supplying all required arguments.