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.8 available

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

ocs 2.8 table software empty

Hello,

We've recently upgraded our ocsinventory server from 2.4 to 2.8, running on a centos 7.9.

So before the migration we had a table "softwares" which is now gone.
From what I've read it looks like now it's splitted between different software tables, but this result in an empty software table.

| software                  |

| software_categories       |

| software_category_exp     |

| software_name             |

| software_publisher        |

| software_version          |

| softwares_name_cache

MariaDB [ocsweb]> select * from software;

Empty set (0.00 sec)

- ocs versions :

rpm -qa | grep ocs

ocsinventory-server-2.8.1-1.el7.ocs.noarch

ocsinventory-agent-2.6.0-2.1.el7.x86_64

ocsinventory-reports-2.8.1-1.el7.ocs.noarch

ocsinventory-2.8.1-1.el7.ocs.noarch

Ocsinventory is working well, but we don't have any infos loaded to software table anymore.
We deploy a lot of hosts daily, yet it is still empty.

Additional infos:



 

What would you advise to fix this ? We don't really want to upgrade to 2.9 yet.
Thanks in advance for your help,

in OCS Inventory NG server for Unix by (220 points)
edited by

2 Answers

0 votes
Propably it's the same problem, that software table doesn't refresh itself and show no software:

https://ask.ocsinventory-ng.org/13117/ocs-2-9-software-total-display-0-issue
by (2.8k points)
0 votes

Hello,

Update on this topic.

After changing the data_type of "ID" from "int" to "bigint", the software table has started to be populated again:

+--------------+-----------+

| column_name  | data_type |

+--------------+-----------+

| ID           | bigint    |

| HARDWARE_ID  | int       |

| NAME_ID      | int       |

| PUBLISHER_ID | int       |

| VERSION_ID   | int       |

| FOLDER       | text      |

| COMMENTS     | text      |

| FILENAME     | varchar   |

| FILESIZE     | int       |

| SOURCE       | int       |

| GUID         | varchar   |

| LANGUAGE     | varchar   |

| INSTALLDATE  | datetime  |

| BITSWIDTH    | int       |

+--------------+-----------+

We now have:

+---------------------------+------------+-----------------+

| Table Name                | Rows Count | Table Size (MB) |

+---------------------------+------------+-----------------+

| software                  |   25318590 |         7335.98 |

| software_categories       |          0 |            0.02 |

| software_category_exp     |          0 |            0.03 |

| software_name             |      55422 |            7.02 |

| software_publisher        |       1789 |            0.31 |

| software_version          |      52895 |            5.03 |

| softwares_name_cache      |      44845 |            6.03 |

The catch up took quite some time but we're up to date now.

by (220 points)
 
Powered by Question2Answer
...