Cannot login to Prime

[peiquan zhang]

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.

[Rasika Nayanajith]

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 ***

[peiquan zhang]

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

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

[Rasika Nayanajith]

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

[peiquan zhang]

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

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

[Rasika Nayanajith]

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

if no success reach TAC

HTH

[Rasika Nayanajith]

Did you able to get it working ? 

[mohanak]

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

[peiquan zhang · Accepted solution]

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

[davefalzone]

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.