What does this mean? pxbridge: Unable to determine ...
Posted: Wed Jan 20, 2016 9:49 am
Performed a column analysis on a table that has been previously analyzed and received this error. To remedy it, I've re-imported the metadata after the previous analysis, but that didn't fix it.
What does this error message mean?
AnalysisSessionImpl.java:175 Event 1: pxbridge: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 2: pxbridge: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 3: pxbridge: Schema field value in input data set 0 not present in design time information. Extended field properties for this field will not be available.
Event 4: generator: When checking operator: Field DataClassification of type ustring[max=20]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 5: generator: When checking operator: Field DataClassificationStatusFlag of type string[1]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 6: generator: When checking operator: Field Culture of type ustring[max=20]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 7: generator: When checking operator: Field Gender of type ustring[max=20]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 8: pxbridge: An error occurred while creating the table. Statement = "create table "ec1481df.c862f974.q2v50or4o.c60dk61.280140.1uko8ipkte4h3tkfv06oo_FD" (
DomainValueFlag char(1),
DomainValueFlagDate date,
DomainValueFlaggedByUser integer,
SourceOfDistinctValue char(1),
FormatFlag char(1),
FormatFlagDate date,
FormatFlaggedByUser integer,
DomainPattern integer,
DefinitionOfDistinctValue vargraphic(512),
TransformValue vargraphic(512),
ChangeDate date,
ChangedByUser integer,
DistinctValue vargraphic(512),
InferredDataType vargraphic(20),
TypeCode smallint,
ODBCType vargraphic(20),
TypeOfDomainValue char(1),
PropertyLength integer,
PropertyPrecision integer,
PropertyScale integer,
GeneralFormat vargraphic(50),
FieldNumber integer,
FrequencyCount bigint,
DataClassification vargraphic(20),
DataClassificationStatusFlag char(1),
Culture vargraphic(20),
Gender vargraphic(20))
in IADB.IADBSPACE
"
Event 9: pxbridge,3: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 10: pxbridge,3: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 11: pxbridge,2: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 12: pxbridge,2: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 13: pxbridge,1: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 14: pxbridge,1: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 15: pxbridge,0: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 16: pxbridge,0: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 17: Parallel job reports failure (code 721035)
What does this error message mean?
AnalysisSessionImpl.java:175 Event 1: pxbridge: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 2: pxbridge: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 3: pxbridge: Schema field value in input data set 0 not present in design time information. Extended field properties for this field will not be available.
Event 4: generator: When checking operator: Field DataClassification of type ustring[max=20]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 5: generator: When checking operator: Field DataClassificationStatusFlag of type string[1]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 6: generator: When checking operator: Field Culture of type ustring[max=20]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 7: generator: When checking operator: Field Gender of type ustring[max=20]: `nulls=100' is specified for a non-nullable field;
the default value will be supplied in place of null.
Event 8: pxbridge: An error occurred while creating the table. Statement = "create table "ec1481df.c862f974.q2v50or4o.c60dk61.280140.1uko8ipkte4h3tkfv06oo_FD" (
DomainValueFlag char(1),
DomainValueFlagDate date,
DomainValueFlaggedByUser integer,
SourceOfDistinctValue char(1),
FormatFlag char(1),
FormatFlagDate date,
FormatFlaggedByUser integer,
DomainPattern integer,
DefinitionOfDistinctValue vargraphic(512),
TransformValue vargraphic(512),
ChangeDate date,
ChangedByUser integer,
DistinctValue vargraphic(512),
InferredDataType vargraphic(20),
TypeCode smallint,
ODBCType vargraphic(20),
TypeOfDomainValue char(1),
PropertyLength integer,
PropertyPrecision integer,
PropertyScale integer,
GeneralFormat vargraphic(50),
FieldNumber integer,
FrequencyCount bigint,
DataClassification vargraphic(20),
DataClassificationStatusFlag char(1),
Culture vargraphic(20),
Gender vargraphic(20))
in IADB.IADBSPACE
"
Event 9: pxbridge,3: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 10: pxbridge,3: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 11: pxbridge,2: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 12: pxbridge,2: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 13: pxbridge,1: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 14: pxbridge,1: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 15: pxbridge,0: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 16: pxbridge,0: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Event 17: Parallel job reports failure (code 721035)