DSXchange

I encountered the same error:

The problem was i have used some environmental variables in the job which i forgot to put in the job properties.
After adding them in job properties job ran fine

Hi,

We used the m part.. i.e teh memory utilization part to check RAM utilization.

And our jobs get aborted once RAM gets finished.

Regards,
Santosh

Thanks again for the input.

Any pointers to any references for setting of buffer sizes?

Thanks,
Santosh

Thanks for the reply.

We are checking it using nmon utility on AIX.

Regards,
Santosh

Hi All, We are facing an issue when we try to log in to Datastage client version 8.1 on AIX 5.3.0.0. The following is the error: ---------------------------------------------------- javax.security.auth.login.LoginException: Could not connect to server [SPEAIXP5LP11] on port [9080]. at com.ascential....

We have tried that.

But there are queries of almost 400 lines (and max is 700 lines). This doesnt seem to work for them.

Thanks,
Shrinivas

hi all, thanks for the replies. The stage in which the problem comes is teh Oracle Enterprise Stage. The query actually selects all columns from teh table and also appends a dummy record as shown below. Select e.ename,e.empno,e.deptno from emp e union Select 'a' as ename,1 as empno,'a' as deptno fro...

Hi Ray, Thanks for the solution (though it falls under premium category and we arent able to see it). A si see from the first visible statement of yours, teh setting is to be made on the oracle side and not on DS side. But on the contrary we could find teh following outcome as a hit and trial experi...

ERROR: Src_Scheme_Loans: The provided query statement did not prepare correctly; please verify that your statement is correct; [ eg., select emp.a,emp.b,emp.c from table emp union select emp1.a,emp1.b,emp1.c from table1 emp1 ] If the number of columns in the individual select statements exceeds 120 ...

We are facing the following error when we run the job containing more than 9 simultaneous oracle connections [ Oracle Enterprise stage ] ERROR: Oracle_Enterprise_9,2: ORA-12537: TNS:connection closed Oracle_Enterprise_9,2: The call to sqlldr failed; the return code = 256; eg., Oracle Source -----> O...

We are facing the following error when we run the job containing more than 10 simultaneous oracle connections [ Oracle Enterprise stage ] ERROR: Oracle_Enterprise_9,2: ORA-12537: TNS:connection closed Oracle_Enterprise_9,2: The call to sqlldr failed; the return code = 256; eg., Oracle Source -----> ...

chulett wrote:Sounds like a classpath issue to me. ...

Pl explain clearly.Is it a classpath issue at the system level or at datastage level.Becoz other java files outside datastage are executing properly.

Hi All, The above mentioned error is resolved.The DATASTAGE_JVM variable was not set up properly. Now i am getting a new error. APT_CombinedOperatorController,0: Fatal Error: Fatal: java.lang.ClassNotFoundException: TableSource.class I have placed the class file in every possible location like E:\IB...

Hi All, I am new to java client stage. Currently i wrote a sample program and trying to load into a dataset.The sample code is package com.ascentialsoftware.jds.test; import com.ascentialsoftware.jds.Row; import com.ascentialsoftware.jds.Stage; public class TableSource extends Stage { private int _r...

http://kepfeltoltes.hu/view/080819/762375539ds_java_01_www.kepfeltoltes.hu_.jpg Hi, The above mentioned links are not opening. Currently im trying to use java pack but facing problems. I am getting the following error. APT_CombinedOperatorController,0: Fatal Error: Fatal: TJClient::initialize: unabl...