DSXchange

Hi,
The issue is resolved.There stage variable which was used to set the status of the job had a null value and hence the issue.
Regards,
Vinod

Hi, I have a job which ran well and now it throws a error Job status = 99 (Not running). I tried all the ways in this thread like i) Delete and Reimport the job. ii) Ray's suggestion of renaming the job and re-import the dsx. iii) Clear the status file. iv) This is a multi instance job,ran it with a...

Ray ,

I tried to re-import the job and it threw an error saying job being accessed by another user. After 4 - 5 hrs I tried to re-import it and it imported without any issues and I was able to compile the job,not sure though what the reason could be.

Thanks,
Vinod

I am unable to kill by PID as there are no process running and we have a lot of slave connections open.

Hi , I am getting the following error when I try to open teh job from designer Record J\376\V0 in file DS_JOBOBJECTS does not exist When i tried to delete the job and/or reimport it it says job accessed by another user but I checked for locks and tried to clear the status of the file but nothing hel...

Hi Arnd, Where does /dev/null point to. Do you want me to point the directory path to /dev/null. My Job is like this [img] HF1 HF2(2.8 Million) | | SeqFile ------ TF1 ------------------TF2 ---------------------SEQFILE TF(1&2) : Transformer HF 1 : Hashed file 1 looked up at TF 1 HF2 : Hashed File...

Hi Arnd, I thought it would be better if i replied in this topic rather than the one for computed blink. I ran the ANALYZE.FILE and got the following stats : FILETYPE : DYNAMIC HASHING ALGORITHM : GENERAL MODULUS : 114057 (114057 minimum) LARGE RECORD SIZE : 1628 GROUP SIZE : 2048 LOAD FACTORS : SPL...

Hi ,

I am closing this topic and am continuing the same with already existing topic viewtopic.php?t=112399&postdays=0&postorder=asc&start=0

Thanks,
Vinod

Hi Arnd, We did go through the same issue last time and it is still not resolved,but I managed to tune the parameters so that the job writes to the Hashed file in 1 hr but it stilll takes close to 4 hrs to read from it.I tried using a Static file too but the result was not as expected.Let me analyze...

As Craig has stated, the file is corrupted and needs to be repaired or, failing that, cleared out. The blink errors denote internal corruption. Sometimes files with blink errors in some groups allow adding data into other groups, so the error won't always manifest itself on writes. Quickest fix is ...

Hi,

If that is the Case should it not fail while data is written to the Hash File.I computed the size by taking the data.30 size in bytes which is 2136631296 bytes. Should I include the overflow size too

Regards,
Vinod

Hi, I got the following error when there was an attempt to read the Hash File.there was no change done to the jobs.Please advise. I am not sure what this error means though.Any clues.I did check the Phantom and the line number points to a stage variable where the Keys are built. Thanks for your help...

Hi, This is in Correlation to my earlier post but thought it would be helpful to have it seperately. i) My Hashed file would approximately have 2.5 million records and 67 columns and it was taking ever to write.So I split it into 6 Hashed Files. One thing I have noticed is that my key size (key colu...

...But teh last 6 digits of ID are always 0 out of (22) If you strip this dummy data out of your key you would save 18Mb of key space alone. So what I need to do is to ignore this 6 bytes write out the Id and change the modulus and alogrithm to sequential and see for the same data set.I would do th...

Now i got what you are saying.My combination of ID and Covg type would be teh Key.But teh last 6 digits of ID are always 0 out of (22) and covg type should be between 01 to 06. so it would be like .....000001 here 01 is the covg type.I would try to decrease the modulus and see i fi can get any gain,...