- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Microsoft
- >
- ExStream: Duplicate reference values in reference ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2011 09:39 AM - last edited on 09-24-2013 07:25 PM by Maiko-I
03-26-2011 09:39 AM - last edited on 09-24-2013 07:25 PM by Maiko-I
ExStream: Duplicate reference values in reference file: error EX003654W
Hello,
I have a question regarding driver and reference files.
We have a set up that has a driver file defined with date and customer acct. Then we have a reference file that has multiple row of records for the particular date and account of a customer. So for date X and account Y, we get multiple rows of data which we display on a statement.
The problem is when we run the package. We get an error with the message in the title of this topic and the error. The error also lists an "example" of the problem is and it lists an account. When we check in the tables, we have multiple dates X for the account Y and each date/account combination has multiple rows of data. And that is just the way it should be. So why are we getting the error?
The result that is being produced is a statement that has a random row of data for the date/account combination and only one is being displayed, instead of multiples.
Our driver file looks like this:
Date(K), Account(K), CustomerName
Sample:
2011-03-21,4444,John
Our reference file looks like this:
Date(K), Account(K), SequenceNum(K), SomeOtherData
Sample:
2011-03-21, 4444, 1, Desc1, 22.50
2011-03-21, 4444, 2, Desc2, 23.50
2011-03-21, 4444, 3, Desc3, 24.50
2011-01-22, 4444, 1, Desc1, 11.50
2011-01-22, 4444, 2, Desc2, 12.50
(K) above means keys in the table.
We have defined a key in Exstream to be Account from the driver file. I believe, this is a correct setup for Driver/Reference file in Exstream, so why the error?
After some investigating, we found that with multiple keys in tables, we should use an Auxiliary file. We have added one too, and that does not change the output. So what is it that we are doing wrong? Does anyone have any insight on this? I would very much appreciate it.
Thank you.
P.S. This thread has been moevd from Microsoft > General to Printing and Digital Imaging > Software. - Hp Forum Moderator
- Tags:
- Exstream