DSXchange

Thanks ! I am going to give it a shot and will mark it as resolved (will put some notes how I achvd it)...

Hey Guys ,

Trying to archive logs of a Project (preferably in a readable mode) before I purge them on a regular basis for the project.

If I do not find an easier way , then we can't purge the log files in the project which may not be a best practice.

Thanks

.. and ofcourse is there an easier way to reset this? Project Created with AutoPurge Option (last 5 Runs). Imported Jobs Need to reset that last 5 runs to some other values , is there any quickier way other than going to each and every job and changing it? (we have like more than 1000 jobs)... Thanks

Alrite Guys just an FYI , I think the file was already hit the 2 GB limit and hence was not able to resize.
So Cleared the File , Resized it and now it work. Running the job now , crossed fingers ;).

Will mark it resolved if its complete !!

Thanks
Dk

Here is the error -

Error message -

Computed blink of 0x908 does not match expected blink of 0x0!
Detected within group starting at address 0x80000000!
RESIZE: Error on HASHEDFILE. File not resized.

So I ran the resize command - RESIZE HASHEDFILE DYNAMIC 64BIT The command rund for some time and then returns with the some blink error. Does it mean I have to empty the file and then do it? Error message - Computed blink of 0x908 does not match expected blink of 0x0! Detected within group starting ...

So I ran the resize command -

RESIZE HASHEDFILE DYNAMIC 64BIT

The command rund for some time and then returns with the some blink error. Does it mean I have to empty the file and then do it?

All failing "at the same time" sounds like a disk space issue to me. Any kind of "bigger than 2GB" situation would corrupt the hashed file and get you "blink" errors, do you see anything like that? If so, the solution to that is to switch to 64bit hashed files and that...

I was trying to run 3 ETLs in the same environment (each of them processes around 7 million rows) , all of them failed at the same time giving the following error (record id is different on all three) while writing their respective Hashed files. I think it may be due to resource issue and trying to ...

Yes, do that as soon as you are done with the handle, so typically just before the exit point. :idea: And you need to not enable the 'Disable BBCode in this post' option if you want tags (like the quote tags you used) to work properly. I fixed your post, so just FYI at this point. LOL Thanks !! $IN...

chulett wrote:Where's your detach of the handle?

oh I did not think of that one.. Ideally where will I do that.. in the routine right? after getting all the information??

Thank You !!

Hey Guys , I want to compare the incoming data to a specified value , something like this - input like '%XYZ%' or input like '%ABC%' in the stage variable and assign it a value if it matches , if not then assign it another value. I am not sure which function I can use to accomplish this , please hel...

Here is the code that I have in my routine , I filter out few enteries before passing the job name to this routine. This routine may not be a very good one as this is one of my initial tries. Can you guys take a look what i am doing wrong? $INCLUDE DSINCLUDE JOBCONTROL.H Equate RoutineName To 'GetJo...

Hey ,

I checked , I am filtering out few jobs including the one which is calling it. So that may not be the case.

Thanks !!