Solved: LMS 3.2 Portal inaccessible (produces Java error after login)

alfred.brunner · ‎04-23-2010

Hi

After logon in CW Portal the screen in the browser is blank, means that I see no portlets, and any click on a link in the menu section produces following error:

An unexpected system error occurred.

javax.servlet.jsp.JspException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update

All CW processes are up and running and it seems that the functionality of the modules is OK (we receive alarm emails form DFM)

Our installation:

Windows 2003 Enterprise edition

LMS 3.2

I didn't find any hints about this issue so any help would be very appreciated. Thanks in advance

A. Brunner

Joel Monge · ‎04-26-2010

Try this:

1. Stop daemon manager from DOS:

net stop crmdmgtd

2.    Delete the files: NMSROOT/MDC/tomcat/webapps/cwportal/db/portal*.
3.    Copy files under NMSROOT/MDC/tomcat/webapps/cwportal/db/orig/* to NMSROOT/MDC/tomcat/webapps/cwportal/db.
4.    Start daemon manager:

 net start crmdmgtd

NOTE: NMSROOT stands for the installation path, by default C:\Program Files\CSCOpx.

View solution in original post

Joel Monge · ‎04-23-2010

If you reboot the server, does the problem remain?

alfred.brunner · ‎04-24-2010

Yes, the problem persists after reboot of the machine.

Joel Monge · ‎04-26-2010

Try this:

1. Stop daemon manager from DOS:

net stop crmdmgtd

2.    Delete the files: NMSROOT/MDC/tomcat/webapps/cwportal/db/portal*.
3.    Copy files under NMSROOT/MDC/tomcat/webapps/cwportal/db/orig/* to NMSROOT/MDC/tomcat/webapps/cwportal/db.
4.    Start daemon manager:

 net start crmdmgtd

NOTE: NMSROOT stands for the installation path, by default C:\Program Files\CSCOpx.

alfred.brunner · ‎04-26-2010

Hi,

it works!!!!!

Thanks a lot

fred