DSXchange

Hi Ernie, Sorry I think I didn't explain my issue clearly. We have an third party application fand for that we don't have direct control over the tables they gave RESTful URL's to delete and load the data and we need to pass XML data. Our java guys are doing that truncate and refresh using java but ...

Hi, I am trying to create a job which extracts data from oracle table and need to pass it to a URL (RESTful service) as XML data. I designed job using XML output stage to create XML format and then I logged in Information services director and created Project, Application, Service and after that I g...

Thanks Craig.

Thanks Ray,

I used four routine activity stages and I am calling same routine in all four with passing different parameters and in under trigger return value = "1" and then calling fifth sequencer using job activity stage. Correct me if I am wrong.

Thank you,

Hi Craig, I designed a server routine with type: Transform_function and in the code section I wrote below code $INCLUDE DSINCLUDE JOBCONTROL.H handle=DSAttachJob (Arg1,DSJ.ERRFATAL) if handle <> 0 Then jobName=DSGetJobInfo(handle,DSJ.JOBNAME) jobStatus=DSGetJobInfo(handle,DSJ.JOBSTATUS) Ans=jobStatu...

Craig,
It looks like a silly question. But I didn't get the starting point to look in to routine and code writable area. Just to make sure is it Routine Activity stage or something else? Routine activity stage is under sequence Palette.

Thank you,

Thank you Craig,
Could you please throw some light on me regarding custom routine? I haven't had a chance to work with routines. Do I need to define each routine in 4 different sequencers and one in final one or just only in final sequencer.

Hi, I need to run 5 sequencers and I schedule all these under run director daily. But there is no control of one sequencer over another. I want to kickoff last sequencer if only first 4 sequencers run successfully. I scheduled sequencers like below. Sequencer 1 - 02:00 am Sequencer 2 - 03:30 am Sequ...

Hi, I am facing an issue with decimal round off. I used an aggregator stage to calculate the sum of a decimal field. I tried changing it to float and again in transformer used Dfloat to Decimal function still it is rounding off decimal places. Can someone please guide me how can I restore decimals w...

I am no more getting "The record is too big to fit in a block" since I increased the value of APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I am getting below error after loading 3500-3900 rows out of 8000 rows. Please suggest me a way to handle this error. Oracle_Connector_0,0: Caught exception from ...

Hi all, I am loading data into target using oracle connector and I am using funnel to merge the data from three 3 different sources (Oracle sources). I observed there are some duplicates on target. So, First I want to take records from two sources and later I want to add all the records from the thi...

ArndW wrote:Are you certain that you don't have this entry? Or is this perhaps not a parallel job? ...

The issue is resolved. There was a problem with select query / columns.

chulett wrote: Bhanu - please use the Reply to topic button, there's no need to constantly 'Reply with quote' when we can all see the text of the message you are replying to. Thanks.

Sorry Chulett,
Generally I use Reply to Topic, but I didn't noticed on this one.

Thanks,

I don't have any entries with OSH under run director log.

Sorry ArndW, I got that value in log from Run Director only. I am pasting the entire thing below. Environment variable settings: ALLUSERSPROFILE=C:\ProgramData APPDATA=C:\Windows\system32\config\systemprofile\AppData\Roaming APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- APT_...