Skip to content

duplicate entry notimportedcomputers #373

@ready2play32

Description

@ready2play32

Hello,
i use glpi version 10.0.6 and ocsinventory plugin version 2.0.4
i have a issue when i launch the import script
/var/www/glpi/plugins/ocsinventoryng/scripts/ocsng_fullsync.sh

The computers are not imported or updated and i have sql errors below :
SQL: INSERT INTO glpi_plugin_ocsinventoryng_notimportedcomputers (name, domain, tag, ocs_deviceid, ipaddr, plugin_ocsinventoryng_ocsservers_id, ocsid, last_inventory, useragent, serial, reason, comment, entities_id, rules_id) VALUES ('totopc1', 'toto', 'MAB1613', 'totopc1-2024-01-28-16-31-02', '::1', '2', '2544509', '2024-01-29 07:00:44', 'OCS-NG_INJECTOR_PL_v3', '', '3', '', '0', '[]')
Error: Duplicate entry '2-2544509' for key 'ocs_id'
Backtrace :
src/DBmysql.php:1320
src/CommonDBTM.php:721 DBmysql->insert()
src/CommonDBTM.php:1326 CommonDBTM->addToDB()
...ventoryng/inc/notimportedcomputer.class.php:392 CommonDBTM->add()
...s/ocsinventoryng/scripts/ocsng_fullsync.php:468 PluginOcsinventoryngNotimportedcomputer->logNotImported()
...s/ocsinventoryng/scripts/ocsng_fullsync.php:299 plugin_ocsinventoryng_importFromOcsServer()
...s/ocsinventoryng/scripts/ocsng_fullsync.php:179 SecondPass()

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions