DSXchange

Check the Query in the Lookup table.

I think defining SOURCE_DIR in your dsenv would allow you to refer this in your jobs.

Alternatively, you can also create a Project level Parameter to define SOURCE_DIR and use it in your project

Hi Kumar, If we call a process which doesnt have any parent process (ie., having Parent process as 1) as an orphaned process, then all the 110 odd phantoms are orphaned. nagesh 1076 1 0 Mar 01 ? 0:01 phantom DSD.StageRun SRQCGenerator.HTB SRQCGenerator.Transform 299 0/50/1 This process from March 1s...

Hi Ray ! $DSHOME/bin/dsdlockd -p This doesn't seem to get rid of phantom processes. I have 110 phantom processes, and I have run this command abt 1/2 hr back, still the processes remain. In the director, the entries for these phantom processes have the LastCommandProcessed as " DSD.OnAbort"...

Hi !

The problem is resolved now.

The issue was with the file from which we were trying to install the plugin.

It was corrupted during FTP process. we reimported the file and are now able to install the plugin successfully.


-Nagesh

I have contacted support for this issue, but the turn around time seems to be bit high.

Is there a way to analyze the core dump?

Hi ! We are trying to install MQ plugin into one of our projects and have encountered this error Reading package file mqseries.dsp Updating stage type records in project: testmq Segmentation Fault - core dumped PRINTER memory segment removed The log file, generated at the time of install does not re...

Hi !

The issue was resolved now

Ultimately it turned out to be a Unix issue.

There were issues with some group permissions. The unix admin modified those permissions and restarted the cron. It worked like charm.

:D


-Nagesh

Hi !

I tried restarting the datastage service, but the problem still prevails.

Thanks for the pointer Craig. I have checked the datastage job log and the last entry in the log is the one for the previous successful run. There is no indication that the job "tried" to run at the scheduled time. I have also checked up with the Unix guys and they are quite confident that...

Hi ! The datastage jobs are not running as scheduled, with any other user other than dsadm. The cron shows that the job is scheduled, but the job fails to kick start at the "scheduled moment". I have read in posts that it is worth checking the datastage logs for this. I couldnot find any l...

Hi DSGuru,

Can you send me the dsx file so that I can have a look at the same please.


Regards
Nagesh

I have set the reject property as "output". It will output the reject records into the reject link.

Yes, I have tried giving a default value and have tried removing the default value. I couldnot find any difference.

It wasnot going into the reject link

Hi ! I have a flat file with the following records "Empno","Ename","Salary","Deptno","JoiningDate" 1,"a",5000,100,2006-01-01 2,"b",,100,2006-01-01 3,"c",,, The Column definition of the sequential file stage is Empno numb...