.ds file is empty

deepa_shenoy · Post by **deepa_shenoy** » Mon Nov 30, 2009 10:30 pm

Hi,

I want to load a Dataset Target File, but it always throws the warning XYZ.ds file empty.

In the first load it will be empty right? I have created an empty file in UNIX and given Update='Overwrite' in the Dataset.

I have three dataset files as target. The error is coming only for two .ds files. I am not able to catch the problem. Any idea why this is happening?

Thanks in advance.

Regards,
Deepa

ray.wurlod · Post by **ray.wurlod** » Mon Nov 30, 2009 10:32 pm

The ".ds" file must not exist if you want to create a new Data Set.

Why did you create it? On whose advice? (It was incorrect advice.)

deepa_shenoy · Post by **deepa_shenoy** » Mon Nov 30, 2009 10:55 pm

But if I am running the same job more than once, it will throw an error saying that the .ds file already exists. How do I give the option of Overwrite as well? The job will always be run twice (minimum).

muraliipc · Post by **muraliipc** » Mon Nov 30, 2009 11:08 pm

Hi,
set update policy in dataset stage as overwrite

Thanks
vin..

ray.wurlod · Post by **ray.wurlod** » Mon Nov 30, 2009 11:29 pm

If a VALID ".ds" file exists then all will be well.

An empty ".ds" file is not valid.

deepa_shenoy · Post by **deepa_shenoy** » Mon Nov 30, 2009 11:33 pm

Hmmm. Only for the first load it will be empty. After that for every other load it will have valid data. Any workaround possible?

Or

Load 1: Create file
Load 2 onwards: Overwrite

But it throws the warning only for 2 out of 3 ".ds" files.

chulett · Post by **chulett** » Mon Nov 30, 2009 11:43 pm

No, for the first load it will not exist so it will create it and then with the right setting overwrite it after that. No "workaround" needed.

As noted, stop pre-creating empty files.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 01, 2009 3:46 am

Note also that the ".ds" file does not contain any data. Ever.

chulett · Post by **chulett** » Tue Dec 01, 2009 6:21 am

Other than the 'meta' kind.

deepa_shenoy · Post by **deepa_shenoy** » Tue Dec 01, 2009 10:44 pm

Thanks guys