A SAS^® Merchandise Data Integration loads fails at the end of the load when the following error is encountered:

This error is a known Oracle defect, which Oracle is still in the process of fixing. To get past this error, execute the following SQL command against your database, and then recycle the database:

Executing this code can reduce the frequency of the error, but the error might still reoccur. No other circumvention is available at this time.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Merchandise Data Integration	Microsoft Windows 2000 Advanced Server	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows NT Workstation	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	6.1.3M2		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	6.1.3M2		9.1 TS1M3 SP4
		Windows Vista	6.1.3M2		9.1 TS1M3 SP4
		64-bit Enabled AIX	6.1.3M2		9.1 TS1M3 SP4
		64-bit Enabled Solaris	6.1.3M2		9.1 TS1M3 SP4

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Load fails when experiencing "ERROR: ORACLE EXECUTE ERROR: ORA-04022: NOWAIT REQUESTED, BUT HAD TO WAIT TO LOCK DICTIONARY OBJECT"

Type:	Problem Note
Priority:	high

Date Modified:	2009-07-21 14:20:18
Date Created:	2009-05-14 16:23:38