DSXchange

Hi, We are experiencing this issue when running multiple instances of jobs from a remote server. A PMR has been opened with IBM and they had us install a patch which helped a bit but we are still experiencing the following. Just curious if anyone has experienced this before. The IBM consultant who h...

That did the trick.....I guess I need to have the developer look at this sinc I have no idea what it means. Starting at line 95: IF STAGECOM.NUM.ROWS(3) GE 1 THEN ABORT 'Aborting after ':STAGECOM.NUM.ROWS(3):' Rows written to ProduceSchC.xfmCognosCall.outCognosError' IF NOT(Pin%%V0S2P7.REJECTEDCODE)...

I figured as much but when I went into the RT_BP99 folder I only see the file .uvnlsmap

The job design is simple and ODBC1 stage to a transformer to two ODBC STAGES(2 and 3). The first ODBC stage calls the sql server proc and the 2 post transformer only have update statement in them.

I tried looking at the file (DT.1502744529.TRANS1 ) but it is mostly hex code(unreadable)

It is a job which has schedule in it's name beacuse it is creating Schedule C reports and makes it look like a sequence but it is a server job.

I did a reset of the job and do not see any "from previous" entries in the log.

Thanks everyone!! I ended up going with teh TYPE command and reading an indicator. Works fine!!

Hi, We have a sequence job that call a MS Sql Server Proc that creates Cognos reports for us. When the sequence runs and only one execution of the job is hit we are fine. When we have 2 or more reports queued up we get the following error for the 2nd execution of the job. Thanks - - John Project:FOR...

Hi, In the server world I would always store values in a hash file and look them up in the UserVariable stage. I now have parallel jobs where I am retrieving row counts (into a sequential file for now). How can I get those counts into the UserVariable activity stage in my sequence? Basically I am lo...

Hi,
I was curious if anyone new whether or not the XML stages are included in version 7.5 or is that feature purchased separately. I see the three stages on the palette but they all have an unplugged socket for an icon.
Thanks - - John

Hi pechonb,

I have the same problem and was wondering where you changed the Base distinguished name to all Caps? Was this for the group?

Thanks -- John

OK, Found the document for updating Windows 2003 permissions. I made the changes for the user/group. I am able to log into the "CRM" project but the developer gets: Failed to connect to DataStage server: NJROS1BVA0417,project: CRM The directory you are connecting to either is not a UV acco...

Hi, I just set up a user in the Information Server Console......we are using LDAP. I have an LDAP browser to verify his id and it comes up. When he tries to log in he receives a log in error and I see the following in the logs. Is there a piece I am forgetting? [6/23/09 16:22:26:543 EDT] 0000003d LT...

And they ask me to respond to.... AmI staisfied? Sure we spend all this money and there going to ask us to do the ETL in the database or withing shell scripts!!! Hello John, Since the job is working with the workaround and there is nothing additional I can assist with for this PMR, may I close it? A...

Hi, I opened a PMR with IBM and just recieved the following: Hello John, Engineering has provided the following: This is known issue with surrogate key in 8.0.1 We are working on a fix for 8.5. The usual workaround for this is to use the key generator in the database (Oracle, DB2 etc). Please try th...