Oracle Database Error Code ORA-30401 Description :
JOIN KEY columns must be non-null
Error Cause:
The dimension statement failed because the column(s) in the JOIN KEY clause permitted NULL values. The JOIN KEY columns are related to the columns of the dimensions skip levels in one or both of the following ways: 1. A skip level is defined over one or more of the JOIN KEY columns. 2. The attribute clauses of a skip level determine one or more of the JOIN KEY columns.
How to Solve :
Modify the JOIN KEY columns so that they do not allow NULL values.
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below