Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Operating System - Microsoft
Showing results for 
Search instead for 
Did you mean: 

ExStream: Duplicate reference values in reference file: error EX003654W

Occasional Contributor

ExStream: Duplicate reference values in reference file: error EX003654W


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


Our reference file looks like this:
Date(K), Account(K), SequenceNum(K), SomeOtherData

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