Problem Note 50214: SAS® Merchandise Data Integration mdin_minventory_reagg might generate "ORA-12805: parallel query server died unexpectedly" running Oracle 10.2.0.4
 |  |  |  |
When running the mdin_minventory_reagg job in SAS® Merchandise Data Integration running with Oracle database release 10.2.0.4, the following error might be generated in the mdin_minventory_reagg.log:
ERROR: ORACLE execute error: ORA-20001: ORA-20001: ORA-20001: ORA-12805: parallel query server died unexpectedly (p_agg_location (...info specific to error...)
ORA-06512: at "MAXDATA.P_AGG_BATCH", line 202
The Oracle BDUMP log contains the following message:
ORA-00600: internal error code, arguments: [32695], [hash aggregation can't be done], [], [], [], [], [], []
This error is caused by Oracle bug number 6471770 and by bug number 5893340.
The workaround for this issue is contact Oracle support to determine the proper batches for your specific operating system and hardware.
After the usual back up and other precautions are taken for database changes, apply the patches provide by Oracle support, and re-attempt the job.
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® for 64-Bit Itanium-based Systems | 6.1.3 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 6.1.3 | |||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 6.1.3 | |||||
| Microsoft Windows XP 64-bit Edition | 6.1.3 | |||||
| Microsoft Windows 8 Ent | 6.1.3 | |||||
| Microsoft Windows 8 Pro | 6.1.3 | |||||
| Microsoft Windows 95/98 | 6.1.3 | |||||
| Microsoft Windows 2000 Advanced Server | 6.1.3 | |||||
| Microsoft Windows 2000 Datacenter Server | 6.1.3 | |||||
| Microsoft Windows 2000 Server | 6.1.3 | |||||
| Microsoft Windows 2000 Professional | 6.1.3 | |||||
| Microsoft Windows NT Workstation | 6.1.3 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 6.1.3 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 6.1.3 | |||||
| Microsoft Windows Server 2003 Standard Edition | 6.1.3 | |||||
| Microsoft Windows Server 2003 for x64 | 6.1.3 | |||||
| Microsoft Windows Server 2008 | 6.1.3 | |||||
| Microsoft Windows Server 2008 R2 for x64 | 6.1.3 | |||||
| Microsoft Windows Server 2008 for x64 | 6.1.3 | |||||
| Microsoft Windows Server 2012 Datacenter | 6.1.3 | |||||
| Microsoft Windows Server 2012 Std | 6.1.3 | |||||
| Microsoft Windows XP Professional | 6.1.3 | |||||
| Windows 7 Enterprise 32 bit | 6.1.3 | |||||
| Windows 7 Enterprise x64 | 6.1.3 | |||||
| Windows 7 Home Premium 32 bit | 6.1.3 | |||||
| Windows 7 Home Premium x64 | 6.1.3 | |||||
| Windows 7 Professional 32 bit | 6.1.3 | |||||
| Windows 7 Professional x64 | 6.1.3 | |||||
| Windows 7 Ultimate 32 bit | 6.1.3 | |||||
| Windows 7 Ultimate x64 | 6.1.3 | |||||
| Windows Millennium Edition (Me) | 6.1.3 | |||||
| Windows Vista | 6.1.3 | |||||
| Windows Vista for x64 | 6.1.3 | |||||
| 64-bit Enabled AIX | 6.1.3 | |||||
| 64-bit Enabled Solaris | 6.1.3 | |||||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-06-18 10:36:37 |
| Date Created: | 2013-06-18 09:19:24 |