Error when I profile table attribute

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

Moderators: chulett, rschirm

Post Reply
cnjelita
Participant
Posts: 7
Joined: Wed Oct 11, 2006 10:30 am
Contact:

Error when I profile table attribute

Post by cnjelita »

I am getting column analysis error every time IA hits data attribut "createed_timestamp". It errors out all column analysis output on that table.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why did you post this in the server job forum?
:?

What is your actual question?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
cnjelita
Participant
Posts: 7
Joined: Wed Oct 11, 2006 10:30 am
Contact:

Post by cnjelita »

I am having difficulty profiling Date timestamp data attributes in the Information Analyzer.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

... and off we go to the IA forum.
-craig

"You can never have too many knives" -- Logan Nine Fingers
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

So you can perform column analysis on fields of other data types, but not timestamp fields?
Have you tried to run the column analysis on just that field? What do SystemErr.log and SystemOut.log say?
abhi.inventor
Participant
Posts: 10
Joined: Tue Oct 18, 2011 10:47 pm
Location: Chennai

Re:

Post by abhi.inventor »

Check the datasample ones before doing column analysis, it helps you to know whether right data is being recognised.

alt:

See you have imported the metadata properly. If you have changed the table structure after importing the metadata, and if you are trying to do column analysis you will get the error.
Insanely Human!
abhi.inventor
Participant
Posts: 10
Joined: Tue Oct 18, 2011 10:47 pm
Location: Chennai

Post by abhi.inventor »

Can help you better, if you tell the error message exactly.
Insanely Human!
Post Reply