Problem Note 54418: SAS® Customer Experience Analytics CXA_ETL job returns "ORACLE execute error: ORA-01400: cannot insert NULL..."
If there is no internal search data to be loaded, then the CXA_ETL job for SAS Customer Experience Analytics fails to complete. When this problem occurs, the CXA_ETL job returns the following error:
ORACLE execute error: ORA-01400: cannot insert NULL into ("OLMCXA"."SEARCH_RESULTS"."SEARCH_RESULTS_SK")
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Customer Experience Analytics | 64-bit Enabled Solaris | 6.1 | 6.3 | | 9.4 TS1M0 |
| 64-bit Enabled AIX | 6.1 | 6.3 | | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 6.1 | 6.3 | | 9.4 TS1M0 |
| Linux for x64 | 6.1 | 6.3 | | 9.4 TS1M0 |
| Solaris for x64 | 6.1 | 6.3 | | 9.4 TS1M0 |
*
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.
The error "ORACLE execute error: ORA-01400: cannot insert NULL into ("OLMCXA"."SEARCH_RESULTS"."SEARCH_RESULTS_SK")" occurs when there is no internal search data to be loaded.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-10-24 10:19:58 |
| Date Created: | 2014-10-22 14:03:52 |
