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
Search found 18 matches
- Mon Aug 31, 2009 6:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Non-pipe (or non-virtual data set) with .v in its name error
- Replies: 3
- Views: 8729
- Fri Jul 31, 2009 2:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RAM not getting released on Datastage server
- Replies: 4
- Views: 2953
RAM not getting released on Datastage server
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
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
- Fri Jul 31, 2009 12:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage buffer issue
- Replies: 2
- Views: 5879
Datastage buffer issue
Thanks again for the input.
Any pointers to any references for setting of buffer sizes?
Thanks,
Santosh
Any pointers to any references for setting of buffer sizes?
Thanks,
Santosh
- Fri Jul 31, 2009 12:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RAM not getting released on Datastage server
- Replies: 4
- Views: 2953
RAM not getting released on Datastage server
Thanks for the reply.
We are checking it using nmon utility on AIX.
Regards,
Santosh
We are checking it using nmon utility on AIX.
Regards,
Santosh
- Wed May 20, 2009 8:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No connectivity to DS client. No o/p in dsproject -lprojects
- Replies: 5
- Views: 4030
No connectivity to DS client. No o/p in dsproject -lprojects
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....
- Wed Apr 15, 2009 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum length of SQL in Oracle query
- Replies: 11
- Views: 4676
Maximum length of SQL in Oracle query
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
But there are queries of almost 400 lines (and max is 700 lines). This doesnt seem to work for them.
Thanks,
Shrinivas
- Tue Apr 14, 2009 1:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum length of SQL in Oracle query
- Replies: 11
- Views: 4676
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...
- Mon Apr 13, 2009 5:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum Oracle connections in parallel job
- Replies: 4
- Views: 3343
Maximum Oracle connections in parallel job
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...
- Mon Apr 13, 2009 3:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum length of SQL in Oracle query
- Replies: 11
- Views: 4676
Maximum length of SQL in Oracle query
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 ...
- Mon Apr 13, 2009 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum Oracle connections in parallel job
- Replies: 4
- Views: 3343
Maximum Oracle connections in parallel job
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...
- Mon Apr 13, 2009 3:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Maximum Oracle connections in a parallel job
- Replies: 2
- Views: 2069
Maximum Oracle connections in a parallel job
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 -----> ...
- Tue Feb 03, 2009 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Java client stage error
- Replies: 4
- Views: 4532
- Tue Feb 03, 2009 2:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Java client stage error
- Replies: 4
- Views: 4532
Class not found exception
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...
- Mon Feb 02, 2009 11:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Java client stage error
- Replies: 4
- Views: 4532
Java client stage error
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...
- Mon Feb 02, 2009 10:56 pm
- Forum: General
- Topic: received signal SIGSEGV on Java Client
- Replies: 5
- Views: 3795
links are not opening
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...