Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.11.1 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Error Last Inventory and HTTP Status Code # 500

Hello

I have a problem with Ocsinventory Server 2.5. (Apache 2.4.25, Mariadb 10.1.26, PHP 7.0.30, Debian 9.1)

The last inventory field no longer updates, while the last contact field yes.
The error appeared between this morning and tonight without any change on the server. I tested my connection to the data bse that works perfectly.
I have the following error:
DBD :: mysql :: st execute failed: Out of range value for column 'ID' at row 1 at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Server/Inventory/Update.pm line 165.
On the clients I have the error:
ERROR *** AGENT => Failed to send Inventory <HTTP Status Code # 500>

Possible database problem?

Thanks for your help
in OCS Inventory NG server for Unix by (570 points)

6 Answers

+1 vote
 
Best answer
Hi,

To correct the problem you have to change id column of table "softwares" from int to bigint. I have one question : do you delete machines (and their softwares associated) that are not more inventoried? Actually this feature is not implemented yet but we are working on it.

Regards

Frank
by (88.5k points)
selected by
0 votes
Verify archive  z-ocsinventory-server.conf in the apache
by (300 points)
0 votes
This file is correct. Parameters are ok.
by (570 points)
+1 vote
please search for the number 2147483647 in the whole Database.
use adimer to do this

https://www.adminer.org/en/
2147483647 ist the biggest value a signed int field can store.
It can happen that a int field overflows. Change the type to bigint.

Now you should be able to use OCS Inventory without problems (hopefully)
by (22.6k points)
edited by
0 votes
Thank you very much it works.
Indeed we delete machines when we remove them from the inventory but we never delete linked software.
by (570 points)
0 votes
/Quote Frank

do you delete machines (and their softwares associated) that are not more inventoried? Actually this feature is not implemented yet but we are working on it.

/quote off

please do not implement a autodelete if we can't manually steer it.

For us even a very old computer which never inventoried for years are important for the following reasons.

1. We have offline PC's - which are used - but they should not contact the internet or even ocs-inventory for security reasons

2. computers which are thrown away should also beeing searchable. so even after years we can say - the old computer has the following software or bios ans so forth

kind regards sokatra
by (22.6k points)
 
Powered by Question2Answer
...