Package Level Validations and Errors
This section describes the PL/SQL package validations.
Other Package Level Validations
Package level parameter validations are executed by two APIs:
The export definition is saved and an export ID is returned in the error message.
Sample Error Message
{
"errorMessage" : "Error with export def id [10603]. No source DNA was specified for export. Export must have ALLDATAOPTION, GENOMICPOSITION or set of genes (GENE, PATHWAY, GENESET).",
"httpMessage" : "Bad Request",
"httpStatusCode" : 400,
"appErrorCode" : "400"
}
Oracle recommends deleting the errant export definition using Delete Export Definition
| User Defined Error Message | Parameters | Validation Logic |
|---|---|---|
| ORA-20010: No parameters exist for the specified export | ALL | Check to see if there is at least there one parameter present for the passed file export ID |
| ORA-20018: Only one context value (PATIENT or SUBJECT) can be specified for export OR ORA-20012: No SUBJECT or PATIENT context was defined for export. | CONTEXT | Parameter CONTEXT has to be present and cannot be specified more than once in a file export definition |
| ORA-20011: A context value of "' || [VALUE1] || '" was specified. Export expects context to be SUBJECT or PATIENT for export. | CONTEXT | Context must be set to one of the values:
|
| ORA-20013: There are ' || [COUNT] || ' possible sources of data patients or subjects for export. Export only supports one souce of patients or subjects. | QUERY | Check if there is only one query (CLOB) to get patients. If it is more than 1 then an exception is thrown. |
| ORA-20014: No source for patients or subjects specified for this export | QUERY SPECIMEN SPECIMENCDM |
Check that either a query (CLOB) or SPECIMEN parameter is provided, that is, SPECIMEN or SPECIMENCDM. |
| ORA-20013: There are ' || [COUNT] || ' possible sources of data patients or subjects for export. Export only supports one souce of patients or subjects. | QUERY SPECIMEN SPECIMENCDM |
Check that there is only one of the following is provided
|
| The export definition must have either a source of patients/subjects or specimens. Including both patient source and specimen source can produce errors. | QUERY SPECIMEN SPECIMENCDM |
Patient/subject sources and specimen sources can produce errors if specified simultaneously. Remove any one. |
| ORA-20015: No source DNA was specified for export. Export must have ALLDATAOPTION, GENOMICPOSITION or set of genes (GENE, PATHWAY, GENESET). | GENE GENESET PATHWAY ALLDATAOPTION GENOMICPOSITION |
Check if there is DNA information provided. The file export definition must have either:
|
| ORA-20016: There are ' || [COUNT] || ' combinations of ALLDATAOPTION and GENOMICPOSITION specified for export. Export only supports 1 combination. | ALLDATAOPTION GENOMICPOSITION |
Check if both ALLDATAOPTION and GENOMICPOSITION are provided. Only zero or one of these in a file export definition is supported. |
| ORA-20017: The export has specified a combination of ALLDATAOPTION and GENOMICPOSITION with a set of genes (GENE, PATHWAY, GENESET) | GENE GENESET PATHWAY ALLDATAOPTION GENOMICPOSITION |
Check if there is a combination of DNA information provided. File export definition must have either:
|
| ORA-20019: Only one FILETYPE for VCF is supported for export | FILETYPE | Check that there is only file type for VCF (or none) |
| ORA-20020: There are ' || [COUNT] || ' CLIENT_IDENTIFIER values specified for export. Export only supports 1 CLIENT_IDENTIFIER | CLIENT_IDENTIFIER | Check that there is not more than one client identifier present for the file export definition |
The following validations are performed only when the query (CLOB) is not set and parameters are not in one of these values: ,
ALLDATAOPTION
CONTEXT
CLIENT_IDENTIFIER
FILETYPE
USE_ASSAY
VERSIONID
| User Defined Error Message | Parameters | Validation Logic |
|---|---|---|
| ORA-20022: A parameter of "GENE" was specified without a proper value. | GENE | If the value specified is NULL |
| ORA-20022: A parameter of "GENOMICPOSITION" was specified without a proper value | GENOMICPOSITION | If the value specified is NULL |
| ORA-20022: A parameter of "GENOMICPOSITION" was specified with a non-numeric value of "' || [VALUE1] OR [VALUE2] || '".' | GENOMICPOSITION | If the value specified is non-numeric |
| ORA-20022: A parameter of "PATHWAY" was specified without a proper value. | PATHWAY | If the value specified is NULL |
| ORA-20022: A parameter of "GENESET" was specified without a proper value. | GENESET | If the value specified is NULL |
| ORA-20022: A parameter of "SPECIMEN" was specified without a proper value. | SPECIMEN | If the value specified is NULL |
| ORA-20022: A parameter of "SPECIMENCDM" was specified without a proper value. | SPECIMENCDM | If the value specified is NULL |
| ORA-20022: A parameter of "SPECIMENTYPE" was specified without a proper value. | SPECIMENTYPE | If the value specified is NULL |
| ORA-20022: A parameter of "ANATOMICALSITES" was specified without a proper value. | ANATOMICALSITES | If the value specified is NULL |
| ORA-20022: A parameter of "FILE_WID" was specified without a proper value. | FILE_WID | If the value specified is NULL |
| ORA-20022: A parameter of "STUDY" was specified without a proper value. | STUDY | If the value specified is NULL |
| ORA-20022: A parameter of "ALIGNMENTID" was specified without a proper value. | ALIGNMENTID | If the value specified is NULL |
| ORA-20022: A parameter of "ALIGNMENTID" was specified with a non-numeric value of "' || [VALUE1] || '".' | ALIGNMENTID | If the value specified is non-numeric |
| ORA-20022: A parameter of "VERSIONID" was specified without a proper value. | VERSIONID | If the value specified is NULL |
| \ORA-20022: A parameter of "VERSIONID" was specified with a non-numeric value of "' || [VALUE1] || '".' | VERSIONID | If the value specified is non-numeric |
| ORA-20023: A parameter was specified as "' || [INVALID_PARAMETER] || '" which is not supported for export. | INVALID PARAMETER | If any of the parameters provided are not in the above list are considered invalid |