when I run the parrallel job, im getting the following error.
Contents of phantom output file =>
RT_SC2122/OshExecuter.sh[20]: 18765 Memory fault(coredump)
Parallel job reports failure (code 139).
Environment.
HP unix box - DS 7.5.1A Server
Windows XP - DS 7.5.1A Client
DB - Oracle 9i
Please help us in resolving the issue
18765 Memory fault(coredump),code 139
Moderators: chulett, rschirm, roy
Re: 18765 Memory fault(coredump),code 139
Try to analyse your SQL statement carefully. We encountered this problem several times, yet. In our case, it always was related to the statement itself:
1st time: SELECT NULL, something, something_else FROM (...)
--> You cannot select NULL in the select-clause of a sql-statement within DataStage, although it is allowed in sql itself.
2nd time: SELECT something, something_else, something FROM (...)
--> You must not state the same column twice! This leads to the problem described above.
I do not remember the other examples, but it always had to do with the sql statement.
1st time: SELECT NULL, something, something_else FROM (...)
--> You cannot select NULL in the select-clause of a sql-statement within DataStage, although it is allowed in sql itself.
2nd time: SELECT something, something_else, something FROM (...)
--> You must not state the same column twice! This leads to the problem described above.
I do not remember the other examples, but it always had to do with the sql statement.