Problem Note 67976: The error "ORA-00920: invalid relational operator" occurs in SAS® Merchandise Allocation during the Batch Allocate process
 |  |  |  |
In SAS Merchandise Allocation, the following ORA-00920 error might be generated in the logs during the Batch Allocate process. As a result, the process fails and puts records either in an error state or an unallocated state.
The following error is displayed in the Catalina logs:
SELECT lv10mast_id FROM maxdata.lv10mast WHERE maxdata.lv10mast.user_attrib1 IN
('177') AND maxdata.lv10mast.lv-10cmast_id IN ())]
ERROR <Error code="-1" userMessage="Native Error 920 [SAS Ins. Inc.][ODBC 20101
driver][Oracle]ORA-00920: invalid relational operator" systemMessage="Native
Error 920 [SAS Ins. Inc.][ODBC 20101 driver][Oracle]ORA-00920: invalid
relational operator"/>
('177') AND maxdata.lv10mast.lv-10cmast_id IN ())]
ERROR <Error code="-1" userMessage="Native Error 920 [SAS Ins. Inc.][ODBC 20101
driver][Oracle]ORA-00920: invalid relational operator" systemMessage="Native
Error 920 [SAS Ins. Inc.][ODBC 20101 driver][Oracle]ORA-00920: invalid
relational operator"/>
If you are experiencing this problem, contact SAS Technical Support.
A fix for this issue is planned for a future release.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Allocation | Microsoft Windows Server 2012 R2 Std | 4.2 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 4.2 | 9.4 TS1M6 | ||||
| Linux for x64 | 4.2 | 9.4 TS1M6 | ||||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-06-11 13:42:47 |
| Date Created: | 2021-05-28 10:34:40 |