If unable to add device in OpenDCIM, need to find below method to get it resolved.
# mysql -u root -p
# select @@global.sql_mode;
# set sql_mode="";
# SET GLOBAL sql_mode = "";
# service httpd restart
# mysql -u root -p
# select @@global.sql_mode;
# set sql_mode="";
# SET GLOBAL sql_mode = "";
# service httpd restart