ocs 2.8 table software empty

Question

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,

Answer 1

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

Answer 2

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.