Quality Analysis error

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Quality Analysis error

Post 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?
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post 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...
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's what happens with you try to negotiate with a machine. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Did the rerun work?
Regards,
Robert
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Yes, re-running each one worked fine.
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post 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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post 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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post 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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Lost track - which issue?
Regards,
Robert
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post 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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply