DSXchange

Thanks ray

Thanks Ray . But its puzzling that varchar / integer works when the range look up is done on the stream column .

So does it mean that I cannot have alphabet keys when the range is on the reference look up (key_range.txt).

Thanks,
Vinod

Hi , I used the look up stage with lookup type as Range in 8.x and have the following issue . Layouts Source File :Keys.txt Contents : Value 1 102 Reference File : Key_range.txt Contents : startvalue, endvalue, description 1 , 100 , A 101 ,200 ,B Expected Output : Contents : Value,Description 1,A 2,...

Hi, I did run with the two Environment variables set and the job ran fine as usual with no issues. I only have this issue at rare scenarios and I ahve a feeling that If my CPU is @ 100 % utilization at the time the player process starts this could be an issue. May be ray can throw some light on this...

Hi, Its aparallel with the following job design . Lk1 Lk2 Lk3 ..Lkn | | | | ORADB -------> Lookup -----------> Transformer ------->DataSet I have 3 streams in the same job with close to 9 reference data sets and one look up stage. This job runs fine but I get the following error at times : main_prog...

Can you please check the timeout setting in the administrator. This issue normally pops up when the time out is set for say 1 hour and the job runs for more than the the timeout set .

Thanks,
Vinod

This issue has been resolved. One of our shell clients F-Secure had remote forwrding set instead of local forwarding which started the second rogue listener process.

Has someone specifically started an instance of dsrpcd intended to listen only to localhost (127.0.0.1)? If so, why? Or it may have something to do with your specific tunnelling protocol - you'd have to ask your support provider about that. Thanks ray. I will check that but i am skeptical as the ds...

Hi , We connect to Data Stage through tunnel using port 31538 and F-secure client or directly by specifying the host name. This was the same way we used to connect with server.After upgrading to parallel we are facing issues where all of a sudden we see two listeners for the same port 31538 as shown...

Hi Ray,
Looks like the issue was fixed and it was due to a bad Configuration file.Is there a way to put the job design in the posts,if so can you please let me know how.

Yes these are seperate data sets and they are mutually exclusive.

Thanks,
Vinod

Hi Ray, Excuses for not posting the job design. It is as follows : DS1 DS2 DS3 | | | Row_Generator --> lookup stage-->Transformer-->Flat File Stage DS-- Data Set I have a key column in the source which I match with the reference . I have checked the row generator and the reference files but I do not...

Hi ,
I am getting the following error on PX.

main_program: Fatal Error: Bad numLogicalFiles: 0

Any idea as to what this error is.

Thanks,
Vinod

Hi Ray, The problem is that the connections are not getting terminated when the session get timed out . i.e. The unix machine times out the tunnel connection after 1 hour but the DS connection is not getting killed. If I manually close the tunnel then the DS connection gets killed. The main reason t...

Hi All, I connect to DataStage Server using a tunnel through the default port 31538 using F-secure shell client. We did an upgrade from Server to Data Stage Parallel 7.5.2 and now the projects are getting locked quite frequently as it exceeds the number of allowed open connections(80). We did not ha...

Hi, I am not able to use the below function to find teh difference between two date timestamp variables.I found the belwo function in the Designers help. The error I get is Expected %. %DateTimeDiff(datetime_from, datetime_to) Returns a time value representing the difference between two datetimes in...