This problem is still persisting. I would like to supply some more information in the hope that it might help you with my problem.
There is a complicated SQL Override consisting of UNIONS and pseudo tables which when executed in SQLPLUS returns around 40,000 records after 30 minutes. In the...
Below is part of the session log file. The main error that is occuring is:
Getting empty buffer block for reading
This occurs immediatley after the Source Qualifier [SQ_CP_ACC_PROPERTY_TRN_ARCH_DTL]. The SQL override returns records in SQL but for some reason not within Informatica and it...
The platform is client/server pc/Sun Solaris Unix, Oracle9i/Informatica 6.1. The Source is oracle 9i.
The workflow properties gives the following failed status messages
- PETL_24013 Session run completed with failure.
below is an extract of the session log file immediately after the SQL in...
I have this situation where the SQL in the SQL override of the Source qualifier takes a long time to run. It attempts to retieve the records (throughput always remains 0) but after some time the session fails. When I replace the slow SQL with a much faster piece of SQL that returns records...
I am recieving the following error messages in my session log and their is no reference in the on line help for the errors:
WRT_8158 and PETL_24020 error messages
Has anyone ever come across them????
Can anyone help or come across the following error messages. They appear at the end of the session log after records have been written away to the target tables.
Informatica6/Oracle 9 environment. Server on Solaris box.
***********
FATAL ERROR : Caught a fatal signal/exception
***********...
Has anyone come across the following error message while installing the Client tools:
At the end of the install an alert pops up with the header
RegSvr32
LoadLibrary("D:\Program Files\Informatica6\Powermart Client\mmcsnap.dll)failed. Get last error returns 0x0000007e
and then while...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.