Can't run sosreport on SA server on NW 12.3.1.0

[KovitThakral]

Hi Everyone,

We have NW Server 12.3.1.0 running. On the SA node-x we can't run sosreport.

It's error. "Could not obtain installed package list" 

[root@SA-NODE ~]# sosreport

sosreport (version 3.9)

Could not obtain installed package list

[JohnSnider]

Most likely your RPM database is corrupted, you can test this on the command line by running
rpm -qa | grep kernel
It will error out if the RPM db is corrupted.
To fix it you can follow these steps:

rm -f /var/lib/rpm/__db*

rpm -vv --rebuilddb

[OsamaFayed]

Hello Kovit,

Please perform the below and let me know if the issue is resolved:

mkdir root/bkp
mv /var/lib/rpm/__db.00* /root/bkp
rpm --quiet -qa
rpm --rebuilddb

Best Regards,

Osama Fayed