What does this mean? pxbridge: Unable to determine ...

dquan97 · Post by **dquan97** » 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)

rjdickson · Post by **rjdickson** » Sun Jan 24, 2016 11:25 am

Hi,

Some of these messages are normal (http://www-01.ibm.com/support/docview.w ... wg21584766).
However, the 'create' issue....is the IADB or the IADBSPACE full?
Can you please 'retain scripts' and show the entire log instead of just a piece?

dquan97 · Post by **dquan97** » Mon Jan 25, 2016 10:59 am

Reran the column analysis job with "Retain Scripts" enabled. I'm posting the full log:

AnalysisSessionImpl.java:175 Job 47: BaseProfileLoad1_ColumnAnalysisTask99902770: aborted
AnalysisSessionImpl.java:175 Job failure log
============
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: 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 3: 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 4: 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 5: 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 6: 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 7: pxbridge: ODBC Info: SQLSTATE = 42S02: Native Error Code = -204: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]IAUSER.ec1481df.c862f974.q2v51agnv.fhee
Event 8: Parallel job reports failure (code 721035)
AnalysisSessionImpl.java:175
Job failed:
PXProcessor.java:92 ColumnAnalysisTask99902770: Job status -> 1:Job failed, please verify that the job is submitted correctly. DS job Numer is RT_SC463.
Detailed Log: 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: 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 3: 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 4: 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 5: 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 6: 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 7: pxbridge: ODBC Info: SQLSTATE = 42S02: Native Error Code = -204: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]IAUSER.ec1481df.c862f974.q2v51agnv.fhee
Event 8: Parallel job reports failure (code 721035)
IA Job Status
--------------------------------------------------------------------------
| Job Execution Status -> ColumnAnalysisTask99902770 |
| JOB TYPE : com.ascential.investigate.ca.job.BaseProfileJob |
| JOB PROCESSOR : com.ascential.investigate.utils.jobs.osh.PXProcessor |
|------------------------------------------------------------------------|
| Data Stage> ANALYZERPROJECT@EDRPPD891:31538, credentialMapping=false |
| Scratch Data Source> IADB@edrppd891:54220 (DB2) |
| [] pre-process completed (0 sec) |
| [] main-process failed (18 sec) |
| [] post-process failed (0 sec) |
| |
| Job run *FAILURE* in 25 seconds. |
--------------------------------------------------------------------------

rjdickson · Post by **rjdickson** » Mon Jan 25, 2016 11:28 am

Please look at the the log from the DataStage/QualityStage Director (or Operations Console, if you use that).

Open the project you run you Information Analyzer jobs in (the default is ANALYZERPROJCT).

dquan97 · Post by **dquan97** » Mon Jan 25, 2016 3:01 pm

Unfortunately, I don't have the permissions needed to open the project in Director. Is there another way to see the log?

dquan97 · Post by **dquan97** » Mon Jan 25, 2016 3:10 pm

Unfortunately, I don't have the permissions needed to open the project in Director. Is there another way to see the log?

rjdickson · Post by **rjdickson** » Mon Jan 25, 2016 3:15 pm

Sadly, no, not without the right permissions.
You will likely need your administrator to obtain the log OR open a PMR (their choice

)

dquan97 · Post by **dquan97** » Mon Jan 25, 2016 3:32 pm

Thanks for the info! I'll get them to do one (or both) of those!