Problem Note 63573: An "ORA-00904: invalid identifier" error and a core dump might occur when there is mismatch in the cluster definition
 |  |  |  |
In SAS® Merchandise Planning, a core dump and the following error might occur in the pe.log:
</LogMsg> The error is [SAS Ins. Inc.][ODBC 20101 driver][Oracle]ORA-00904: LV1002CTREE_ID : invalid identifier
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f42ba728546, pid=56255, tid=139924582684416
#
# JRE version: OpenJDK Runtime Environment (7.0_181) (build 1.7.0_181-mockbuild_2018_04_20_01_16-b00)
# Java VM: OpenJDK 64-Bit Server VM (24.181-b00 mixed mode linux-amd64 compressed oops)
# Derivative: IcedTea 2.6.14
# Distribution: Red Hat Enterprise Linux Server release 6.9 (Santiago), package rhel-2.6.14.1.el6_9-x86_64 u181-b00
# Problematic frame:
# C [libCubeMgr.so+0x9d546]
CDAOHelper::GetDeletedFactCellsParent(SCubeMgrInternal*, I_Cube*, Dimension, int, SIDTuple, int&)+0x116
#
#
# SIGSEGV (0xb) at pc=0x00007f42ba728546, pid=56255, tid=139924582684416
#
# JRE version: OpenJDK Runtime Environment (7.0_181) (build 1.7.0_181-mockbuild_2018_04_20_01_16-b00)
# Java VM: OpenJDK 64-Bit Server VM (24.181-b00 mixed mode linux-amd64 compressed oops)
# Derivative: IcedTea 2.6.14
# Distribution: Red Hat Enterprise Linux Server release 6.9 (Santiago), package rhel-2.6.14.1.el6_9-x86_64 u181-b00
# Problematic frame:
# C [libCubeMgr.so+0x9d546]
CDAOHelper::GetDeletedFactCellsParent(SCubeMgrInternal*, I_Cube*, Dimension, int, SIDTuple, int&)+0x116
#
The issue occurs due to a mismatch between the cluster definition that is associated with the cluster history data and the plan data. The mismatch occurs because clusters that were originally in the cluster definition when the cluster was created and used in the worksheet are subsequently removed. So, the cluster set as it is currently definite now has fewer clusters in it than when it was used in the worksheet.
If you encounter this issue, then there are two options to correct the mismatch, so the worksheet can open.
- Remove the missing clusters from the plan data (not recommended since this results in a loss of plan data to the business).
- Restore the cluster definition to its original state to reflect the clusters that were originally defined when assigned to the worksheet.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Assortment Planning | Microsoft Windows Server 2012 R2 Std | 6.7 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 6.7 | 9.4 TS1M4 | ||||
| Linux for x64 | 6.7 | 9.4 TS1M4 | ||||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-03-11 14:54:40 |
| Date Created: | 2019-01-30 09:22:14 |