Topic
2 replies Latest Post - ‏2012-10-21T21:47:43Z by andy__clifton
andy__clifton
andy__clifton
9 Posts
ACCEPTED ANSWER

Pinned topic Column analysis failing on all fields that are DATETIME

‏2012-10-19T00:30:02Z |
Hi All,
Wonder if anybody has had similar issues with column analysis in IA 8.7. on ORACLE 10GR2
Seems like the process is bombing out at the post processing phase of the analysis.
Any column that is of type of DATETIME fails. A summary level analysis is created ok but thats pretty much it.
From error log:

Failed to create FreqDist Summary for Error in post-process for DIM_PARTY

JobProcessor.java:180 ColumnAnalysisTask99207508: Error in processing job ->Failed to create FreqDist Summary for Error in post-process for DIM_PARTY

IA Job Status
Job Execution Status -> ColumnAnalysisTask99207508
JOB TYPE : com.ascential.investigate.ca.job.BaseProfileJob
JOB PROCESSOR : com.ascential.investigate.utils.jobs.osh.PXProcessor
------------------------------------------------------------------------
Data Stage> XXXXXXXXXXXXXXXXX:31538, credentialMapping=false
Scratch Data Source> XXXXXXX@itgsydr130n1:1521 (ORACLE)
[] pre-process completed (3 sec)
[] main-process completed (2531 sec)
[] post-process failed (1 sec)
 
Job run FAILURE in 42 minute(s) 20 seconds.


Updated on 2012-10-21T21:47:43Z at 2012-10-21T21:47:43Z by andy__clifton
  • RobertDickson
    RobertDickson
    50 Posts
    ACCEPTED ANSWER

    Re: Column analysis failing on all fields that are DATETIME

    ‏2012-10-19T11:44:01Z  in response to andy__clifton
    Hi,

    This sounds like JR43216 (https://www-304.ibm.com/support/entdocview.wss?uid=swg1JR43216), which was (according to the README) fixed in IA RollupPatch 3 (RU3). IA RU3 needs to be installed on top of FixPack 1 (FP1). Both FP1 and IA RU3 can be downloaded from FIxCentral.

    My understanding is that the workaround is to use ODBC connector instead of the Oracle connector.


    Regards,
    Robert

    p.s. These observations are my own opinion. Please feel free to open a PMR to obtain official IBM verification <grin>