DSXchange

I have the EXACT same issue! We have several jobs where, in the log, there are either warnings or fatal errors and yet the job status is "Finished" (i.e. OK, i.e JobStatus=1). This is NOT acceptable to us. Looking at the status screen in director, everything looks great. We have to individ...

I appreciate the tips on the database checks. Our DBA doesn't see anything in error or deadlocking. What I am MORE concerned about is the second part of my question. "When we recieve the fatal deadlock error, the job completes with a status = 1. This is NOT ok. Since the job status is fine, we ...

Hi, I'm hoping that someone can help here, I'm completely stumped. I have a two part problem. 1) We are updating a database in our parallel job. When the update ODBC stage is set to parallel mode, I get fatal deadlock errors. When the update ODBC stage is set to sequential mode, no error. Why would ...

Thanks for the help. After investigating the sendmail command for linux. I determined that I needed to escape the $ with a \ And I needed to escape the \ with another \ So: \\\servername\\\$cldirectory\subdirectory\Stats.xls, results in: \\servername\$cldirectory\subdirectory\Stats.xls Which is what...

7.5x2

We're moving from a Windows 2003 server to a Linux server (not sure about a version on the Linux)

You explanation makes sense though. So...it would a difference between the two O/S sendmail functions.

I have a after job subroutine which sends out emails. It sends out a link to a file for our customers to view. We are moving from DataStage 7.1 Server Edition to DataStage 7.5 Parallel Edition. The routine has always worked correctly on the server edition. Here is the code: code = DSSendMail("f...

I always use OCONV and ICONV to do conversions in date formats.

The job normally runs in about 2 hours total. When it gets stuck, it just sits there like it's about to begin the clear then insert. The table is actually already empty when it gets to that step (it's emptied in another job earlier in the sequence). It just sits there until I kill it. When I got in ...

I have a couple of jobs that keep hanging suddenly. They are very simple jobs, but they are processing a lot of data. This is what the jobs look like: ODBC select data -> Transformer -> File -> ODBC Insert Data The ODBC Insert Data step, does a "clear the table, insert the rows". The job h...

v7.1 and no browse button and I tried the #Default# one...so, I guess that 7.1 does not support it.

Thanks! I guess I'll wait to add that in after we upgrade to 7.5.1.

I agree with a previous poster. Use the Pivot stage. That's what it is designed to do (take one row and split it into mutiple rows). Much cleaner than the transformer split and sequential file merge option.

I'm annoyed. I've tried to figure this out before, but never with any success. Hopefully someone here can help me. I have a notification activity in my sequence. The "To" email address is currently filled in with the actual email address (abc@myserver.com). I want to change it to use a job...

Yeah...I don't see anything in FileInfo about row count. That's okay, I just realized that I might as well count the rows myself as I am reading through the file (building up my email message). So, I guess I don't need a function to do this. Although it is a little annoying. You think there would be...

Okay, I just want to verify. According to what I've read, now, in the BASIC manual.

The Status Statement on OPENSEQ can not be used to determine row count.

Is there anyway to determine row count on a file in a subroutine?

I have the following code in a before/after subroutine: OPENSEQ reportFile TO H.REPORT THEN status FileInfo from H.REPORT ELSE STOP fileRowCount = FileInfo<6>; * get the row count CALL DSLogInfo("Row Count: " : fileRowCount, "EmailReportRoutine") : : I need to find the row count....