Oracle transparent gateway

  • Hi all! i´m having an issue whit this interfase. In certainly situations the user associated hangs up the db, locking some tables, and generating a Dr.Watson in NT (!!). When i close that error, this tables are automatically freed. This process executes a RPC, which send the result to an Oracle 8.1 server (which is working at full resources!). Could be a timeout trouble, or i should look at the code in de RPC? Any suggestions?

    TIA

  • COuld be a number of things. However, Watson should generate a dump you can look over to see if anything jumps out at you. Also, make sure you look in the SQL Server logs and event viewer logs to see if anything specific shows up or around the time of the issue. Most likely though you are using some syntax that is blowing the driver to h#!! and back. Try using profiler to perform a trace on all the queires up to the point it happens again. Also, try setting up on another server for testing to see if you can reporduce. If not then may be the install is an issue, Oracle or SQL.

  • Thanks for the help, Antares. When i look at the Event Viewer, i see this error:

    'The library file "infoctrs.DLL" specified for the "InetInfo" service could not be opened. Performance data for this service will not be available.

    Status code is data DWORD 0. '

    I looked into Technet for a work around, and all the references point to a trouble with performance monitor, which is actually running in that server (see kbprb KB275494).

    I gonna stop the monitoring, and try to see if the error continues.

    Also, i have a lot (7) of instances of tg4msql.exe running in the server, is that normal?

    Thanks again!

  • Not sure, not running so I have no way to compare. Stop server and reboot then see if they come back quick.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply