topic http://mrncciew.com/2015/11 in Wireless

Cannot login to Prime

peiquan zhang — Mon, 05 Jul 2021 11:20:50 GMT

Hi,

We cannot login to our Prime these days, due to the following error message:

{"message":"Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection"}

We haven't changed the JAVA version. Tried from another PC, still getting the same error. Tried both Firefox and IE, all the same.

Any suggestion? Will it help if I login in from SSH and reboot the server? Thanks a lot.

I would log onto CLI and

Rasika Nayanajith — Mon, 07 Dec 2015 03:47:05 GMT

I would log onto CLI and check its status

prime/admin#show application status NCS

if there is no obvious issues could seen on the above,then would restart the service

http://www.cisco.com/c/en/us/td/docs/net_mgmt/prime/infrastructure/3-0/administrator/guide/PIAdminBook/maint_sys_health.html#pgfId-1088333

HTH

Rasika

*** Pls rate all useful responses ***

Refer the link : https:/

mohanak — Mon, 07 Dec 2015 11:03:34 GMT

Refer the link : https://supportforums.cisco.com/discussion/11716151/prime-infrastructure-12-login-problem-httpsservernamewebacsjspringsecuritycheck

Hi Rasika,

peiquan zhang — Mon, 07 Dec 2015 22:59:16 GMT

Hi Rasika,

Thank you for your kindly help, it seems that the Database Server is not running, any suggestion for the next step?

**********************************************************************

prime01/admin# show application status NCS

Health Monitor Server is running.
Ftp Server is running
Database server is stopped <-------------------Here
Tftp Server is running
Matlab Server is running
NMS Server is running.
Plug and Play Gateway is running.
SAM Daemon is running ...
DA Daemon is running ...
Syslog Daemon is running ...

**********************************************************

http://mrncciew.com/2015/11

Rasika Nayanajith — Tue, 08 Dec 2015 00:24:07 GMT

http://mrncciew.com/2015/11/26/cpi-3-0-disk-running-out-of-space/

Check your disk space for DB, may be run out of space.

HTH

Rasika

Not really...... I am jsut

peiquan zhang — Tue, 08 Dec 2015 00:32:49 GMT

Not really...... I am jsut thinking about a simple stop/start, is that harmless or risky? Thank you Rasika.

****************************************************

ade # df -h
Filesystem            Size Used Avail Use% Mounted on
/dev/mapper/smosvg-rootvol
                      3.8G 285M 3.4G   8% /
/dev/mapper/smosvg-storeddatavol
                      9.5G 151M 8.9G   2% /storeddata
/dev/mapper/smosvg-localdiskvol
                       43G 4.1G   37G 10% /localdisk
/dev/sda2              97M 5.6M   87M   7% /storedconfig
/dev/mapper/smosvg-home
                       93M 5.6M   83M   7% /home
/dev/mapper/smosvg-optvol
                      200G   81G 109G 43% /opt
/dev/mapper/smosvg-varvol
                      3.8G 600M 3.1G 17% /var
/dev/mapper/smosvg-usrvol
                      6.6G 1.2G 5.1G 19% /usr
/dev/mapper/smosvg-tmpvol
                      1.9G   36M 1.8G   2% /tmp
/dev/mapper/smosvg-recvol
                       93M 5.6M   83M   7% /recovery
/dev/mapper/smosvg-altrootvol
                       93M 5.6M   83M   7% /altroot
/dev/sda1             485M   18M 442M   4% /boot
tmpfs                 7.8G 4.0G 3.9G 51% /dev/shm

********************************************************************

Yes, do a restart & see. It

Rasika Nayanajith — Tue, 08 Dec 2015 01:12:59 GMT

Yes, do a restart & see. It won't harm

if no success reach TAC

HTH

Did you able to get it

Rasika Nayanajith — Thu, 10 Dec 2015 05:55:45 GMT

Did you able to get it working ?

Hi Guys,

peiquan zhang — Thu, 10 Dec 2015 06:23:02 GMT

Hi Guys,

Eventually it turns out to be a CISCO bug, please find the article below:

http://transmitfailure.blogspot.fr/2013/04/cisco-prime-infrastructure-bug-id.html

I am lucky that my oracle colleague fixed this with me, but I am very frustrated that we faced the same issue on Prime v2.0. But CISCO announced that this issue is only for v1.2.....

Re: Hi Guys,

davefalzone — Wed, 14 Feb 2018 14:13:00 GMT

Ran into this issue today, three years later. Prime 2.1 (2.1.0.0.87). Your procedure fixed issue. Did have to do . oracleenv instead of .. /opt/oracle/oracleenv. Thanks for your post, saved me a lot of time.