Page 1 of 1

Error with Mexico - PREP ruleset in QualityStage

Posted: Fri Jun 05, 2009 10:42 am
by divstands
I am getting the following error while running a job which includes the usgae of PRPE rulesets for mexico( MXPREP):



stanMXPREP,0: STANDARDIZE output column #D | $ [ {NombreDistrito} = "" ]
in rule set MXPREP is not defined in the dictionary
[stancmp4.c:2416]


Tha job looks like: Inout sequential file->Filer(Select MX as the country)
-> Standardize( Mexico CNTRY MXPREP.set)->Standardize( MXADDR.set, MXAREA.set)->Output Sequential file

Also, if the full address is like this:

Street : Domicilio Conocido
Ext No. : SN
Int. No. : 4
Colony : Santa Catarina Tabernillas
Municipality: Almoloya De Juarez
City : Almoloya De Juarez
State : Mexico
Postal Code : 50920
Reference Location: Cerca Del KM 7

then the final output files show:

DominioDirecccion_MXPREP ( Domain Address)

= SN Domicilio Conocido Almoloya De Juarez Cerca Del KM 7 <a symbol like a square> Almoloya De Juarez Mexico 1 50920

and

DominioArea_MXPREP (Domain Area)

=ZQAREA ZQAREA ZQAREA ZQAREA


In the Standardize( Mexico CNTRY MXPREP.set) stage i have put :
ZQADDRZQ Ext No ZQADDRZQ Int No ZQADDRZQ Street ZQADDRZQ Colony ZQADDRZQ Municipality ZQADDRZQ Reference Location ZQAREAZQ City ZQAREAZQ State ZQAREAZQ Postal Code

What can be the issue? Whyare all the fields being taken under address only inspite when everything has been seggregated at proper place?

Regards

DivT

Posted: Fri Jun 05, 2009 3:12 pm
by ray.wurlod
An output column used by one of the rules in your MXPREP rule set is not actually defined in the output file's file definition.