ImporterStepValidationIssue Table

FlexNet Manager Suite (Cloud)

The ImporterStepValidationIssue table lists any validation issues that occurred during an import, that the user may need to review.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ImporterStepValidationIssue table

Database Column

Details

ImporterStepValidation IssueID

Type: integer. Key. Generated ID

A unique identifier for the import validation.

ImporterRunID

Type: integer. Key

Foreign key to the ImporterRun table.

ComplianceConnectionID

Type: integer. Key

Foreign key to the ComplianceConnection table.

ProcedureName

Type: text (max 256 characters). Nullable

The procedure that contains the issue.

StepName

Type: text (max 512 characters). Nullable

The step that contains the issue.

RowSkipped

Type: boolean

Source to object validatation issue specifing if row skipped.

ColErrorReason

Type: integer. Nullable

Source to object validatation issue specifing reason for error on particular row.

ColumnName

Type: text (max 128 characters). Nullable

Column name of the failed source to object validatation issue.

RowNumber

Type: big integer. Nullable

Row number of the failed source to object validatation issue.

AffectedItem

Type: text (max 512 characters). Nullable

An optional description for any further related item.

ImporterStepValidation IssueTypeID

Type: integer. Nullable

Foreign key to the ImporterStepValidationIssueType table.

OccurrenceDate

Type: datetime. Nullable

The time the issue was raised.

FlexNet Manager Suite (Cloud)

Current