DSXchange

And those compile errors would be... ?

If there is a corruption in the project, i will not be able to open the project. No true. Not all forms of corruption would result in an inability to 'open' the project. Couldn't hurt to take a few minutes and check the integrity of the project. Search the forum for DS.REINDEX or for the use of the...

Then check the file that is giving you the error. There must be something different about it from the ones that run without error. Since you say they are fixed width, then it should be easy to tell. Each record should always be X bytes in length, the sum of the Display Sizes defined on your Columns ...

True... but more than likely something else is going on. Corruption in the project or a resource issue, I would think.

The other thing to keep in mind is the licensing based on concurrent users per server not project.

It's not a licensing error. Exceeding your licensed user count does not throw an error but pops up a rather obvious message box stating that you are licensed for X users and all X are in use.

You need to read up on how the Exception Handler stage is used. It only 'fires' when there is a problem within the sequence of jobs. So the error message is trying to tell you that you have no jobs to run. Disconnect the jobs from the Exception Handler. Only link things to the EH which should run if...

Then your metadata is wrong. The Display Size of your fields don't add up to the actual length of the records.

Yes, but did you fix your problem?

What's the Key field in your hashed file? Hopefully not just the Max Value. You'll need to 'hard code' a key value, like an 'X' and carry the max key in a data field in the hashed file. Then always look up the same row by hard-coding the key expression and check your row number to the looked up max ...

No. See previous answer.

No, it doesn't require sorted input, it just works better with it as long as you also tell it the input is sorted. And it matches the aggregation being done.

There is no 'inline sort option' available in the Aggregator.

Simply by using 'Reset if Required then Run' as the option... they're just jobs as well.

Kumar, that would be a PX answer and not at all applicable to a Server job.

No, you can't. Those options are for asserting that the incoming data is already sorted in a particular order. If that order supports the aggregation being done, then your aggregation will be much, much (much) more efficient.

Actually, there are no official downloads on ADN, only a pretty much all user supplied File Library. To get the patch you need to go to Ascential's EServices website: m As long as you are registered you can log on and go to the Downloads section there where several patches are available. You are loo...