Oracle Stage - Phanthom Error

yuva010 · Post by **yuva010** » Thu Oct 02, 2008 4:41 am

Hi,

We are getting following error in Oracle Stage,

"Contents of Phantom Output File" -->
RT_SC661/OshExecute.sh()20:20944 MemoryFault (Coredump)."

Same query if we run on Direct database through toad, it works fine.
What could be the reason, Cache Memory?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 02, 2008 5:06 am

What are you DOING in the Oracle stage?

Without knowing that the reason for a core dump is impossible to guess.

Have you had your support provider analyze the core file?

chulett · Post by **chulett** » Thu Oct 02, 2008 7:21 am

Also let us know the exact version of the Oracle client installed on the DataStage server, the version of the database being connected to and your operating system's flavor of UNIX.

yuva010 · Post by **yuva010** » Fri Oct 03, 2008 1:12 am

Its 9i Oracle.
We have a normal query with few joins. It works fine even with Server Job but throws error in PX.
Core File, we haven't sent it to anybody. What can be seen in this file?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 1:53 am

yuva010 wrote:What can be seen in this file?

The state of your system (in particular the contents of memory) at the point of failure. You need documentation and probably some analysis tools, not to mention knowledge of the memory model used inside DataStage, to make any sense of a core file.

chulett · Post by **chulett** » Fri Oct 03, 2008 7:45 am

"9i" isn't the version, that would be more like "9.2.0.5" or something similar. And find out both the client and database versions.