Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, September 9, 2008

SQORAS32 an unsupported operation was attempted

We were getting this error when we tried connecting Kewill Flagship installed on a Windows 2003 R2 box (with 10.2.0.3 Oracle client for windows installed) to an Apps 11i instance. This error comes up whenever you try to access the DSN in Control Panel > ODBC Data Sources. A google search returns the first hit in OTN forums: http://forums.oracle.com/forums/thread.jspa?messageID=2195086

The post refers this to metalink note 403021.1 and patch 5699495. Reproducing the contents of the note here:

Applies to:

Oracle ODBC Driver - Version: 10.2.0.3
Microsoft Windows 2000
Microsoft Windows XP
Microsoft Windows Server 2003
Microsoft Windows (32-bit)

Description

"An unsupported operation was attempted" error occurs when trying to do the following with the Oracle ODBC Driver version 10.2.0.3.0:

  1. Create a DSN
  2. Click on any tabs in the DSN configuration screen other than the "Workarounds" tab. It will not bring up the other tabs.
  3. Click on OK to save the DSN.

This problem began after applying the RDBMS 10.2.0.3.0 for Windows 32-bit, Patch 5337014, which installs the 10.2.0.3.0 Oracle ODBC Driver.

This issue was filed under two bugs: Bug 5699495 and Bug 5747525.

Likelihood of Occurrence

Your Applications use the Oracle ODBC driver 10.2.0.x.0 and you applied the RDBMS 10.2.0.3.0 patchset.

Possible Symptoms

"An unsupported operation was attempted" error occurs when trying to do the following with the Oracle ODBC Driver version 10.2.0.3.0:

  1. Create a DSN
  2. Click on any tabs in the DSN configuration screen other than the "Workarounds" tab. It will not bring up the other tabs.
  3. Click on OK to save the DSN.

This problem began after applying the RDBMS 10.2.0.3.0 for Windows 32-bit, Patch 5337014, which installs the 10.2.0.3.0 Oracle ODBC Driver.

Workaround or Resolution

  • If you have applied only the Oracle Database Server Version 10.2.0.3.0 Patch 5337014 please apply Patch 5699495 to apply the fix for the Oracle ODBC Driver.
  • If you have applied one of the Oracle Database Server Version 10.2.0.3 Patch 1 through 6. Please copy over the sqoras32.dll and sqresus.dll from Patch 5699495 to the \bin directory to apply the fix for the Oracle ODBC Driver.

The fix for Bug 5699495 / / Bug 5747525 has been released in the 10.2.0.3.0 RDBMS Patch 7 Patch 6038241 or higher. It is listed in the release notes as Bug 5747525.

If you are working on a Japanese Operating System please read Note 435737.1 "SQORAS32 An Unsupported Operation was Attempted."

Patches

There are two ways to get the fix for this issue:

1. If you have applied 10.2.0.3.0 Oracle Database patch 1 through 6 then you can apply:

Patch 5699495 for the Oracle ODBC Driver.

Or

2. 10.2.0.3.0 RDBMS Patch 7 Patch 6038241 or higher using opatch to install the fix along with the other Oracle Database bug fixes contained in patch 1 through 7.

After applying patch 5699495, the error went away.

1 comment:

Survivor izle said...

Thank you for information.