Gateway ADC Problems - K4000037

A number of problems have recently come to light in AUXORACL and AUXWODBC.

• AUXORACL goes to 100% processor use and hangs

  In certain circumstances AUXORACL could hang and go into a tight loop. The problem was related to the maximum number of cursors being exceeded. This problem could also arise in AUXSYBAS.

• Spurious Oracle errors when attempting to update data from DP4 network client

  If a Gateway ADC is accessed via a DP4 network client (e.g. TCPW) then updating the database could cause system error 311 (with errors such as ORA-00426 reported from Oracle). The problem was caused by a mismatch between the bound and actual addresses of data submitted to the OEM database. Using -nofaster on TCPW would work around this problem.

• Depth reported incorrectly

  On non Intel platforms AUXORACL and AUXSYBAS reported the number of matching keys incorrectly for numeric keys. The same problem also arises on all platforms with AUXORACL for a single character key that is blank.

• Spurious Commit errors

  Spurious commit errors could be reported by the Gateway ADCs. The problem (introduced into 4.523 as a result of fixing earlier bugs in this area) would occur if the same record is updated more than once from different record areas in the same transaction. A typical cause of this would be updating the same record in two different QAB overlays in the cause of the same transaction without rereading the data in between.

DP4 Products/Versions Affected

_{Where the version affected is given as 4.5xx or 4.6xx, all versions of DP4 issued prior to the date of the fix are potentially affected. Where a specific version number is given the problem was introduced by that release and prior releases are unaffected. If a patch release number is also specified (in parentheses) , the fault was introduced at that specific patch level.}

Downloads

4.523 (3) AUXWODBC.W32
4.523 (3) AUXORACL.W32

The download for AUXORACL is encrypted as AUXORACL is not included with the standard DP4 product. Contact us to request the password.

_{Due to limitations on available web space downloadable fixes are only available for the most commonly used environments, and may not be separately available in both 4.5xx and 4.6xx flavours. If a file you require is not available you can ask us to e-mail it to you.}