Make changes to MXADDRAS.TBL
Make changes to MXADDRAS.TBL
I copied the ruleset MXADDR, did the requisite changes as mentioned by Stuart in the thread titiled "How do you make changes to USFIRSTN.TBL ? ", provisioned the ruleset.
But the job is not running.
It gives an error:
StandardizeAddr,0: Invalid Tbl Code
tblc.c l1506
Is there any step i have missed or
is there any more change needs to be done for the table codes, which is not mentioned in the steps.
But the job is not running.
It gives an error:
StandardizeAddr,0: Invalid Tbl Code
tblc.c l1506
Is there any step i have missed or
is there any more change needs to be done for the table codes, which is not mentioned in the steps.
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Re: Make changes to MXADDRAS.TBL
Did you update the job with the new standardization Rule Set?
If yes ... try testing the rule set by itself using the Rule management GUI
If yes ... try testing the rule set by itself using the Rule management GUI
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
Re: Make changes to MXADDRAS.TBL
Ofcourse i did. Only then the error is coming.JRodriguez wrote:Did you update the job with the new standardization Rule Set?
If yes ... try testing the rule set by itself using the Rule management GUI
Re: Make changes to MXADDRAS.TBL
When we open the Rule Window for test, an error pops up:JRodriguez wrote:Did you update the job with the new standardization Rule Set?
If yes ... try testing the rule set by itself using the Rule management GUI
"standardization process failed. Invalid tabl code. The above error occured in the following line of file C:\IBM\Information Server1\Clients\Classic\TempRules\MXADDR1AS.TBL"
and ironically the new generated reference table name is MXADDR1AS.TBL only
The original rule set name was MXADDR and i replaced this name everywhere in the ruleset by MXADDR1
Also, when i installed QS v8.0, it was not accopmnied by the Mexican Rulesets. But i had a notepad file for same separately. And i checked just now:
the ReadOnly status was "0" when i had imported the original ruleset(Which means that the ruleset is editable). Even then i was not able to edit the table MXADDRAS.TBL
Hence the change in the property Readonly doesnt seem to work. Please guide.
the ReadOnly status was "0" when i had imported the original ruleset(Which means that the ruleset is editable). Even then i was not able to edit the table MXADDRAS.TBL
Hence the change in the property Readonly doesnt seem to work. Please guide.
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
I noticed the file name is 9 characters long.
Try renaming the files to 8.3 format.
Not sure if it will help this problem, but I've had issues with this in the past, on version 8.
Problems where it worked fine in the test window, but jobs that used it would fail with an error related to the ruleset.
Try renaming the files to 8.3 format.
Not sure if it will help this problem, but I've had issues with this in the past, on version 8.
Problems where it worked fine in the test window, but jobs that used it would fail with an error related to the ruleset.
Are you saying about the length of the Table name.stuartjvnorton wrote:I noticed the file name is 9 characters long.
Try renaming the files to 8.3 format.
Not sure if it will help this problem, but I've had issues with this in the past, on version 8.
Problems where it worked fine in the test window, but jobs that used it would fail with an error related to the ruleset.
So does it mean, that alnf with the original ruleset, all the table names and file names should also be < 8 characters?
Hi Stuartstuartjvnorton wrote:I noticed the file name is 9 characters long.
Try renaming the files to 8.3 format.
Not sure if it will help this problem, but I've had issues with this in the past, on version 8.
Problems where it worked fine in the test window, but jobs that used it would fail with an error related to the ruleset.
I tried with renaming again and making it MADDR and replacing MEX with M, which ensures the file names everywhere to be <8 characters. but even now the same error is coming:
StandardizeAddr,0: Invalid Tbl Code
tblc.c l1506
Divya
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Would you mind posting the entries that you added to this lookup table?
I remember having issues like this when the lookup table entries were not properly formatted. If you have a bad entry you could get an error specially when using CONVERT with the TKN argument. One way to know if that's your case will be commenting out one at a time the patterns actions that refers to this table in the pattern action file
I remember having issues like this when the lookup table entries were not properly formatted. If you have a bad entry you could get an error specially when using CONVERT with the TKN argument. One way to know if that's your case will be commenting out one at a time the patterns actions that refers to this table in the pattern action file
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
The reference files don't have to be 8 chars long IIRC, but the ruleset name (ie the name of all of the main ruleset files) needs to be 8 long.
As for the entries:
"CENTRO CEREMONIAL"
MXASENTA 850
"5 REALES"
MXASENTA 850
"ANDRES CUEXCONTITLAN"
"5 REALES" <-- Is this line a dupe? Doesn't look like it should be there.
MXASENTA 850
As for the entries:
"CENTRO CEREMONIAL"
MXASENTA 850
"5 REALES"
MXASENTA 850
"ANDRES CUEXCONTITLAN"
"5 REALES" <-- Is this line a dupe? Doesn't look like it should be there.
MXASENTA 850
No there are colony/street names like "5 reales" in Mexico.stuartjvnorton wrote:The reference files don't have to be 8 chars long IIRC, but the ruleset name (ie the name of all of the main ruleset files) needs to be 8 long.
As for the entries:
"CENTRO CEREMONIAL"
MXASENTA 850
"5 REALES"
MXASENTA 850
"ANDRES CUEXCONTITLAN"
"5 REALES" <-- Is this line a dupe? Doesn't look like it should be there.
MXASENTA 850
Even phrases like "5 de Mayo" can be a street name( it actually mean: 5th May)
Divya
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
divstands wrote:No there are colony/street names like "5 reales" in Mexico.stuartjvnorton wrote:The reference files don't have to be 8 chars long IIRC, but the ruleset name (ie the name of all of the main ruleset files) needs to be 8 long.
As for the entries:
"CENTRO CEREMONIAL"
MXASENTA 850
"5 REALES"
MXASENTA 850
"ANDRES CUEXCONTITLAN"
"5 REALES" <-- Is this line a dupe? Doesn't look like it should be there.
MXASENTA 850
Even phrases like "5 de Mayo" can be a street name( it actually mean: 5th May)
I'm not saying "5 REALES" isn't a valid place. I'm saying that piece of text shouldn't be there in that place.
It's supposed to look something like:
"CENTRO CEREMONIAL" MXASENTA 850
"5 REALES" MXASENTA 850
"ANDRES CUEXCONTITLAN" MXASENTA 850
ie:
"SOME PLACE IN MEXICO" MXASENTA 850
You have:
"CENTRO CEREMONIAL" MXASENTA 850
"5 REALES" MXASENTA 850
"ANDRES CUEXCONTITLAN" "5 REALES" MXASENTA 850
The last line is clearly not formatted correctly and would cause the error you are having.
So taking out the line I highlighted in the previous email should fix your problem.