DSXchange

Not sure if this will help but I needed to use the following command in the transformer when loading a binary value through DS:

Iconv(MappedColumn,"MX0C")

Apparently, DS converts binary to the numerical equivalent without this command.

Double that on the Windows version. We've been experiencing random terminations for the last 8 months. Last night 3 jobs failed with this error or similar: jb000PlyrSessionGroupALL6.9.Copy_of_Link_Partitioner_62.ww: ds_ipcopen() - call to OpenFileMapping() failed - The system cannot find the file sp...

Another option might be to use the datediff function in your custom SQL.

Ascential support informed me that I needed to use the "start" command prior to the "rcmd" command. Worked flawlessly. :D

So I figured out the security issue but I'm still getting an error:

Epiphany_Launch_Test..JobControl (@Execute_Epiphany_Job): Executed: \\bgedwapp02\e$\executeepiphany.bat
Reply=1
Output from command ====>
Executing on \\bgepiphany: epiphanyruncmd

Error:8 - Internal error = 6

Thoughts?

It's actually tring to connect to \\bgepiphany. \\bgedwapp02 is the server that DS is running on. I've logged into that server and fired off the batch file using our service account and it runs fine. There's always a possibility that I'm missing something and a different account is being used. I wil...

I'm trying to use DataStage to fire off a separate vendor's ETL process. I've generated a batch file that successfully fires off the job successfully. However, when I use the "execute command" stage in DS to fire off the batch file I get the following message: Epiphany_Launch_Test..JobCont...

I've read the recent posts on this topic but have not seen a clear answer either way. Is there any way to pass a SQL generated GUID to DataStage? When I attempt this I just get a "0." Any advice would be greatly appreciated.

Bill

The target table uses nchar so I think if nothing else I would get a metadata mismatch ( ) for every row.

It seems that we need to turn on NLS. We've been running without for about a year and I was wondering if there was anything I needed to be aware of before turning it on (i.e. recompiling jobs, new options, server reboot etc.)? There is no specific language need, it's just that to use nchar or nvarch...

Have not logged a support call yet. On vacation and will handle when I get back. Sorry Dale, sorry Keith.

I've seen others post the same concern but I have never seen anyone with any resolution. I have a stage using a link collector with multiple (under 64) streams coming in. I'm getting the following error on several jobs: b000PlyrSessionGroupALL4..Link_Partitioner_62.DSLink13b: ds_ipcopen() - call to ...

Allow users to choose a "top level" sequence to compile and have DS compile all jobs and sequences below it.

We seem t obe expreiencing intemittent data loss using the SQL bulk loader. One factor the might be contributing is that we have multiple streams of data feeding into the bulk loader stage directly. Has anyone seen this problem before. I am open to changing jobs to load multiple strams into a link c...

Network traffic should not be a problem. We've looked at our network usage through the NIC on both ends and we don't go much past 25% usage. We've also been monitoring overall bandwidth and have not been exceeding any major thresholds there. My next step is to move the job over to the other appserve...