Page 1 of 1
Quality Analysis error
Posted: Tue Sep 12, 2017 9:34 am
by qt_ky
In the IA thin client, after running Quality Analysis, many of the data sets' (tables) quality analysis succeeded but some failed. My data source in this case is SQL Server via the ODBC drivers on UNIX.
I found errors by hovering over the Error Information in the thin client, but also in the DataStage job logs, which does a better job of indicating which messages are info, warning, or fatal. The first one or more fatal error message generally look like this:
pxbridge(6),0: [Input link 0] Schema is non-negotiable. Attempted to modify field: field_name, attribute: IS_SIGNED. Design-time value: 0. External value: 1 (CC_DBSchemaRules::markModifiedAttribute, file CC_DBSchemaRules.cpp, line 1,314)
How can I resolve this type of error and get a quality score generated?
Posted: Tue Sep 12, 2017 12:21 pm
by qt_ky
Explanation
An unexpected internal error occurred.
User response
Gather the logs and contact IBM Software Support.
Workaround: rerun quality analysis (try, try again), not sure how to prevent this error in the first place...
Posted: Tue Sep 12, 2017 1:29 pm
by chulett
That's what happens with you try to negotiate with a machine.
Posted: Wed Sep 13, 2017 5:45 am
by rjdickson
Did the rerun work?
Posted: Wed Sep 13, 2017 6:00 am
by qt_ky
Yes, re-running each one worked fine.
Posted: Tue Sep 19, 2017 9:39 am
by qt_ky
Update: re-running quality analysis worked OK.
However, I now have a Data Rule that errors each time I run or re-run it with the same error. Re-running the Data Rule has not worked. We are going to apply Service Pack 2 and see if that helps.
Posted: Tue Sep 19, 2017 12:02 pm
by qt_ky
Looks like this second occurrence of the error falls under this condition listed in
http://www-01.ibm.com/support/docview.w ... wg21996131 :
Known issues in InfoSphere Information Analyzer, Version 11.5 Fix Pack 2 Service Pack 1:
1. Data rule jobs cannot be run if they include columns with INT8 and INT16 data types and the source repository is SQL Server that is being accessed by using the ODBC Connector and the Information Analyzer database (IADB) was setup with DB2 and is accessed by using DB2 Connector. To work around this issue, configure the Information Analyzer database (IADB) so it can be accessed by using the ODBC Connector.
Posted: Wed Sep 20, 2017 11:50 am
by qt_ky
We applied Service Pack 2 to the server (engine) and client tiers but it did not fix this particular error on running a data rule.
Posted: Mon Sep 25, 2017 5:14 am
by rjdickson
Lost track - which issue?
Posted: Mon Sep 25, 2017 7:20 am
by qt_ky
Sorry for any confusion.
The same error reported originally, which came at random when running Quality Analysis from the thin client, is now coming up again when running a particular Data Rule, whereas a couple dozen other Data Rules run just fine against other columns in the same data source. The error:
Code: Select all
pxbridge(6),0: [Input link 0] Schema is non-negotiable. Attempted to modify field: field_name , attribute: IS_SIGNED. Design-time value: 0. External value: 1 (CC_DBSchemaRules::markModifiedAttribute, file CC_DBSchemaRules.cpp, line 1,314)
The Data Rule that fails with the same error involves a SQL Server INT8 data type being accessed via ODBC as outlined under the bold Known Issues quote in my earlier post. Our IADB is setup using the DB2 Connector.