column missing in QAbox

sureshchandra · Post by **sureshchandra** » Thu Feb 28, 2008 1:39 am

Hi,
In job deployment QA box,

i'm getting the fatal error column missing.How to resolve this pls help me.

Advance thanks

ray.wurlod · Post by **ray.wurlod** » Thu Feb 28, 2008 1:42 am

You're not on version 4. Please advise correct version. This will affect how the question is answered. Essentially your file structure and file definition do not match.

sureshchandra · Post by **sureshchandra** » Thu Feb 28, 2008 2:32 am

Thanks Ray,
If u won't mind can u help me how to resolve this.

sureshchandra · Post by **sureshchandra** » Thu Feb 28, 2008 2:36 am

This is the fatal error i'm getting

mq3_401k_step03..Focus_File.F_in: read_delimited() - row 1, column FC_NM, required column missing

ray.wurlod · Post by **ray.wurlod** » Thu Feb 28, 2008 4:15 am

The second person personal pronoun in English is spelled "you", not "u". I find it offensive to be addressed as "u" in any format.

Until you confirm your version, we can not help you further. If you're on version 7.x you will get a ProfileStage answer; if you're on version 8.x you will get an Information Analyzer answer.

As I said earlier, your problem is essentially that your file definition (metadata) does not correspond with what is in your file. You have defined at least one more column than is actually there. We can't help you with that - you have to examine the file and to compare what's there with the file definition that you're using in ProfileStage.

sureshchandra · Post by **sureshchandra** » Thu Feb 28, 2008 5:12 am

Hi Ray,
First of all i'm sorry.
i'm doing the deployment.Running the batch jobs(adminstrative work).
Once the devloper finished devloping the jobs puts in version control.That jobs i will promote it to QA server for testing.Run in dos prompt.While running the jobs i'm getting this fatal error in director(7.5).
I think now you can get me what i'm saying.
Thanks