Hash file problem

ady · Post by **ady** » Fri Dec 15, 2006 4:06 pm

I am trying to join columns from 2 transformers here. I am using a hashfile stage to make the join by manually giving a column and making it as the key in both tables.

The log says:

Timestamp:12/15/2006 5:03:33 PM
Event type:Fatal
User:balinea
Message:
TSTExtractRtlChnMerchNCDollars..x_trailer: |TSTExtractRtlChnMerchNCDollars..h_lookup.l_to_hf: DSD.UVOpen mkdbfile: invalid number of arguments
.|

narasimha · Post by **narasimha** » Fri Dec 15, 2006 4:15 pm

Search for "DSD.UVOpen mkdbfile", there are many posts discussed about this.
Do a "Search for all terms" you get more results for this.

In brief- The error is because you have trouble reading a hashed file

chulett · Post by **chulett** » Fri Dec 15, 2006 4:20 pm

No, it's because the name of the hashed file is invalid and is confusing the mkdbfile command. Typically this is because the Job Parameter used in the stage is not defined in the job, so the #PARAMETER_NAME# is still there untranslated.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 15, 2006 4:20 pm

No, the problem here is that the command for CREATING the hashed file is not being generated correctly. Try re-compiling the job, then validating it.

ady · Post by **ady** » Fri Dec 15, 2006 4:31 pm

Environment variable problem ....its working now

ray.wurlod · Post by **ray.wurlod** » Sat Dec 16, 2006 4:35 pm

Please advise which environment variable it was, so that others can more rapidly solve it if they get the same problem in future.

I am not aware of any environment variable that would affect the operation of mkdbfile, unless you were using that environment variable as a job parameter.