DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
dj
Participant



Joined: 24 Aug 2006
Posts: 78
Location: india
Points: 1101

Post Posted: Thu Jul 21, 2016 8:31 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We are trying to design a notification system for the AVI and CASS Reference files updates. Can someone clarify the below please.

1) AVI even when the next Quarter files were available, we were able to use the previous quarter files. It did not stop the process.Wherease in CASS USPS when 105 days passed,CASS stage processing stopped.

So AVI the user has got the option to decide on the update of quarter files
But CASS is it mandatory to update the files?

2) Are there any configuration files which details for which quarter the files are for and when it is to be updated/expired?

thanks
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2813
Location: USA
Points: 21315

Post Posted: Thu Jul 21, 2016 12:15 pm Reply with quote    Back to top    

1) The 105 day expiration rule on USAC or CASS reference files is mandated by USPS for certification so that the most current and accurate address data is ensured to validate mailings sent through the post office.

USPS always publishes the next month's data on the 15th of each month. IBM then has to repackage it for QualityStage, preprocess everything, and encrypt it before they post the downloads on Passport Advantage.

I have noticed IBM generally posts these USAC/CASS updates somewhere in the day 20's of each month, but sometimes around holidays like Thanksgiving or Christmas, it may get delayed by a week or even skipped altogether.

The AVI data does not appear to expire. You can continue using it but if you don't apply the reference file updates then over time they will get stale and you of course won't get the benefit of new or improved records.

2) I'm not sure; haven't checked.

For both of these, we simply set ourselves monthly and quarterly calendar reminders using mail & calendar tools.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
dj
Participant



Joined: 24 Aug 2006
Posts: 78
Location: india
Points: 1101

Post Posted: Thu Aug 04, 2016 8:19 am Reply with quote    Back to top    

Thanks for the details.

We installed the latest USPS files and when trying to access from CASS Stage it throws the below error "CASS_195,0: Default Huffman handle was not set from Street Names
error opening files for reader"
Not sure what this error is all about.

We didn't overwrite the existing the files folder, we have placed it in a new folder path and it was just tar xvf command executed.

The folders have got the needed permission.

In the other server, it is working fine. But not sure why it is failing ?

Will there be any config files present in the older files and we have to set up the new ones in the same folder?

Thanks
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Thu Aug 04, 2016 10:53 pm Reply with quote    Back to top    

It's likely that not all files were unzipped. There are three files you should have downloaded, with four total files to unzip (one of the three downloads contains two zip files).

How many files in the old vs new directories?

_________________
Regards,
Robert
Rate this response:  
Not yet rated
dj
Participant



Joined: 24 Aug 2006
Posts: 78
Location: india
Points: 1101

Post Posted: Fri Aug 05, 2016 2:48 am Reply with quote    Back to top    

yes 3 zip files and 4 tar ones.It was due to directory name (not as per the standards too)

The new path where we placed has got some " -" in the directory name.

Corrected the directory names and it is working fine now.

Thanks
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours