DSXchange

The issue was resolved once we restarted the server. we do not know what the problem is and were forced to restart before we could understand the issue as the testing phase was getting delayed

Data is about 100 rows from reference, we have about 800K records from the source. the sort is carried out in the query, so we don't have any sorts applied in data stage. disk space on scratch is about 20% and on the server it is 27%. swap memory utilization is 50% at any time, when the job was in w...

the queries are fine, remove lookup stage, dump both the main query, and lookup data to peek stages, the job is done in 30 seconds.

as soon as the process kicks off, it gets into a dormant state, it waits forever, till we logout the PIDs from director, attempting to release resources was unsuccessful

Hi, i have few jobs, well any job with a lookup or a join stage getting hung in my testing environment All these jobs have a common flow We read from Oracle Database, use a lookup stage to lookup data from Oracle DB, and write data to a Dataset What we did to verify? we checked with the DBAs , there...

If your table is on oracle DB try using Listagg function!!

ok.. so IBM couldn't help much as they concur with us that the problem is with the system and not the server. as per them the server identifies the project by ShortName/ProjectName when i try "ping shortname", i dont get response from this single machine. Till we get a response for the sho...

Hi Ray All the services on all the tiers are working. Everyone else from the team is able to connect to this server without any issues The login issue from the client machine is not specific to a particular datastage server. This machine cannot connect to dev, sit, uat or prod using any login creden...

Ray

Yes, the users PC should be able to resolve the IP address

Below is the host entry i have on the users PC
111.666.777.88 hltixxx.abcc.ccc.com hltixxx

I tried ping on both the IP and server name, and had a successful reply.

Thanks
Srividya

Hi All I am having trouble in setting up access for one of my team members. We keep running into the error message pasted below Also, below are the checks i have made 1. Uninstalled and re-installed the client after cleaning the registry entries 2. listed the IP address in Hosts file 3. ping and tel...

I tried this and it worked!!! Thanks Kumar

kumar_s wrote:You can use OUTROWNUM with PARTNUM if you have many streams out from Transformer. ...

uhho .. i am on the same boat, I have installed the Information server, as we still haven't got the licences for the C++ compiler (we were over excited to install the tool :oops: ) when we had a similar problem on 7.5 we changed the default path for parameter - APT_COMPILER to the local point where ...

the output i get is 0 now, which is the initial value for the stage variable. I have taken care to flow only 01 records to this stage variable

Anbu, the if then else is a "bit" long :lol: it also has strings with four characters which have values like COSH,COSL :? but yes i did try to restrict the code to read the first 3 characters only, the COS that read correctly was from COSH and COSL, the one with COS only failed :shock: :cry:

Sai Sample of the input data set i get 01,COS 02,chasidh,dasdasd,asdasdasd,wdfddwasd, 03,dsfds,dsasd,asdasd,asdasdas, 04,dfoprewo,qwqe,reteererqwe 01,MOS 02,chasidh,dasdasd,asdasdasd,wdfddwasd, 03,dsfds,dsasd,asdasd,asdasdas, 04,dfoprewo,qwqe,reteererqwe 01,FOS 02,chasidh,dasdasd,asdasdasd,wdfddwasd...

Hi alll I have an issue while reading data from a comma delimited file. There is a simple if then else statement in a stage variable which does basic string comparison if Field(trim(Lnk_Src_Socn.Field002),",",1) ='COS' Then 'Type1' else if Field(trim(Lnk_Src_Socn.Field002),",",1)...