Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. snorkel9

    "Getting empty buffer block for reading" message

    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...
  2. snorkel9

    "Getting empty buffer block for reading" message

    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...
  3. snorkel9

    TIMEOUT Settings

    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...
  4. snorkel9

    TIMEOUT Settings

    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...
  5. snorkel9

    WRT_8158 and PETL_24020 error messages

    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????
  6. snorkel9

    FATAL ERROR Message recieved - HELP

    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 ***********...
  7. snorkel9

    Installation of Informatica 6

    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...

Part and Inventory Search

Back
Top