Warning: The magic method Vc_Manager::__wakeup() must have public visibility in /home/starsolu/oracle-scn.com/wp-content/plugins/js_composer_salient/include/classes/core/class-vc-manager.php on line 205

Deprecated: Required parameter $width follows optional parameter $attach_id in /home/starsolu/oracle-scn.com/wp-content/plugins/js_composer_salient/include/helpers/helpers.php on line 395

Deprecated: Required parameter $height follows optional parameter $attach_id in /home/starsolu/oracle-scn.com/wp-content/plugins/js_composer_salient/include/helpers/helpers.php on line 395

Deprecated: Required parameter $slide follows optional parameter $blank in /home/starsolu/oracle-scn.com/wp-content/plugins/revslider/admin/includes/plugin-update.class.php on line 2976

Deprecated: Required parameter $slider follows optional parameter $blank in /home/starsolu/oracle-scn.com/wp-content/plugins/revslider/admin/includes/plugin-update.class.php on line 2976

Deprecated: Required parameter $access_token follows optional parameter $item_count in /home/starsolu/oracle-scn.com/wp-content/plugins/revslider/includes/external-sources.class.php on line 68

Deprecated: Required parameter $access_token follows optional parameter $item_count in /home/starsolu/oracle-scn.com/wp-content/plugins/revslider/includes/external-sources.class.php on line 85

Deprecated: Required parameter $current_photoset follows optional parameter $item_count in /home/starsolu/oracle-scn.com/wp-content/plugins/revslider/includes/external-sources.class.php on line 1367

Deprecated: Required parameter $args follows optional parameter $depth in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/helpers/nav-menus.php on line 137

Deprecated: Required parameter $output follows optional parameter $depth in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/helpers/nav-menus.php on line 137

Deprecated: Required parameter $args follows optional parameter $depth in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/helpers/nav-menus.php on line 399

Deprecated: Required parameter $output follows optional parameter $depth in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/helpers/nav-menus.php on line 399

Deprecated: Required parameter $is_script follows optional parameter $list in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 21

Deprecated: Required parameter $handle follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 45

Deprecated: Required parameter $src_cdn follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 45

Deprecated: Required parameter $deps follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 45

Deprecated: Required parameter $ver follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 45

Deprecated: Required parameter $footer_or_media follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 45

Deprecated: Required parameter $handle follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 100

Deprecated: Required parameter $src_cdn follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 100

Deprecated: Required parameter $deps follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 100

Deprecated: Required parameter $ver follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 100

Deprecated: Required parameter $footer_or_media follows optional parameter $register in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_cdn.php on line 100

Deprecated: Required parameter $path follows optional parameter $expire in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_functions.php on line 54

Deprecated: Required parameter $wp_customize follows optional parameter $args in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/extensions/customizer/extension_customizer.php on line 584

Deprecated: Required parameter $wp_customize follows optional parameter $args in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/extensions/customizer/extension_customizer.php on line 607

Deprecated: Required parameter $parent follows optional parameter $field in /home/starsolu/oracle-scn.com/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/fields/typography/field_typography.php on line 50
ORA-1400 Cannot Insert NULL in to a NOT NULL column - ORACLE-SCN Skip to main content
OGG Errors

ORA-1400 Cannot Insert NULL in to a NOT NULL column

By March 13, 2020One Comment

Installation of Oracle GoldenGate is very easy, but troubleshooting is a challenge. We come across many errors in OGG and some of the famous errors in them are,

ORA-1403 No data found
ORA-1400 Cannot Insert NULL into a NOT NULL column.

There are many reasons for hitting these errors. In this article, I am going to explain you in a diagrammatic way on

how ORA-1400 is been hit?

What exactly happens at the background?

I have a table called EMP with four columns namely, ID, NAME, ADDRESS and SALARY. ID column is the PK column and all are NOT NULL columns.
Minimal supplemental log / Trandata is enabled already. On the Replicat parameter, I am using the parameter INSERTMISSINGUPDATES. To know more about this parameter, check the below link,

https://www.oracle-scn.com/insertmissingupdates-noninsertmissingupdates/

Let me update a row in the source,

UPDATE EMP SET NAME='CHANDAN' WHERE ID=101;

Since only minimal supplemental log is enabled, only the changed columns along with the PK column will be captured by the Extract process.

And also, if you see the image, the row with ID=101 does not exist in the Target table. Since we are using the parameter INSERMISSINGUPDATES in the Replicat process, the current UPDATE will be converted into INSERT. The Replicat process will try to INSERT the missed row into the table.

As I mentioned earlier, only the changed columns along with the PK column will be captured by the Extract process. We have only values for 2 columns ID and NAME. We do not have values for the other two columns ADDRESS and SALARY.

So, the Replicat process will try to INSERT a NULL value to the other two columns ADDRESS and SALARY,

Since the columns are NOT NULL, it will not allow NULL to it and we hit the error, ORA-1400 Cannot insert NULL into a NOT NULL column

The solution for this is,

You need to enable supplemental log on all the columns. This is not only in the case of INSERTMISSINGUPDATES. The below parameters will also lead to this issue,

INSERTUPDATES
INSERTDELETES
HANDLECOLLISIONS
INSERTALLRECORDS

The above parameters are not advised or recommended to use in the replication. This will lead to data integrity issues.

Hope you got a clear idea about the error ORA-1400.

Cheers 🙂

One Comment

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!