cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Power Designer 16.5 SP 5 Portal is not starting.

venkataramana_paidi
Contributor

on ‎11-17-2015 11:43 AM

0 Kudos

Hi ,

I have installed the Power Designer 16.5 sp 5 portal. But I am unable to open the portal.

Please find the below error for reference.

Repository database is up and running.

What went wrong.

Thanks & Regards,

Ramana.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

pascalmenoud
Explorer
‎11-17-2015 1:21 PM
0 Kudos

To verify if the Portal service is running, you could execute "netstat -a" in a Command Prompt.

The ":3030" port number should appear on the second column (local address).

It could be a problem with the Windows firewall, which prevents the access to the 3030 port.

Show replies
Show replies
venkataramana_paidi
Contributor
‎11-17-2015 1:45 PM
0 Kudos

Hi Pascal,

I have checked the netstat -a  and 3030 port is listening

I gave the license key while installing the power designer  and it is available in the C:\ProgramData\PowerDesigner 16 path.

ERROR localhost-startStop-1 2015/11/17 17:01:24 GST com.sybase.cmr.infra.server.license.LicenseUtils.getLicenseFilePath(LicenseUtils.java:134) License file powerdesigner.server.lic does not exist in the CMR_HOME : C:\Program Files\SAP\PowerDesigner Portal 16\license\powerdesigner.server.lic

ERROR localhost-startStop-1 2015/11/17 17:01:24 GST com.sybase.cmr.infra.server.license.LicenseManager.initLicenseService(LicenseManager.java:190) License validation service cannot be started. License library or configuration file cannot be found under CMR_HOME.

FATAL localhost-startStop-1 2015/11/17 17:01:25 GST com.sybase.cmr.infra.server.persistence.db.connection.DBCPConnectionProvider.init(DBCPConnectionProvider.java:241) Cannot create PoolableConnectionFactory (JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect)

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect)

    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

    at org.apache.commons.dbcp.BasicDataSource.getLogWriter(BasicDataSource.java:1098)

    at org.apache.commons.dbcp.BasicDataSourceFactory.createDataSource(BasicDataSourceFactory.java:350)

    at com.sybase.cmr.infra.server.persistence.db.connection.DBCPConnectionProvider.init(DBCPConnectionProvider.java:197)

    at com.sybase.cmr.infra.server.configuration.ServerBeanFactory.getBean(ServerBeanFactory.java:117)

    at com.sybase.cmr.infra.server.configuration.ServerConfigManagerImpl.getServerConfigBean(ServerConfigManagerImpl.java:316)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.loadConnectProvider(RepositoryImpl.java:301)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.getConnectionProvider(RepositoryImpl.java:290)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.initDataSource(RepositoryImpl.java:786)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.init(RepositoryImpl.java:741)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.<init>(RepositoryImpl.java:213)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.getInstance(RepositoryImpl.java:196)

    at com.sybase.cmr.infra.server.RepositoryFactory.createRepository(RepositoryFactory.java:27)

    at com.sap.powerdesigner.web.StartupListener.contextInitialized(StartupListener.java:68)

    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)

    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)

    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)

    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)

    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1877)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask.run(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

    at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2526)

    at com.sybase.jdbc4.jdbc.SybConnection.handleSQLE(SybConnection.java:2394)

    at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:474)

    at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:2760)

    at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:323)

    at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:238)

    at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:211)

    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

    ... 27 more

ERROR localhost-startStop-1 2015/11/17 17:01:25 GST com.sybase.cmr.infra.server.impl.RepositoryImpl.init(RepositoryImpl.java:774) "Repository initialization related with the database is failed.Please check with the database."

com.sybase.cmr.infra.RepositoryException: Failed to initialize database connection.

    at com.sybase.cmr.infra.util.RepoExceptionFactoryBase.internalCreateRepositoryException(RepoExceptionFactoryBase.java:784)

    at com.sybase.cmr.infra.util.RepoExceptionFactoryBase.createRepositoryException(RepoExceptionFactoryBase.java:63)

    at com.sybase.cmr.infra.server.persistence.db.connection.DBCPConnectionProvider.init(DBCPConnectionProvider.java:243)

    at com.sybase.cmr.infra.server.configuration.ServerBeanFactory.getBean(ServerBeanFactory.java:117)

    at com.sybase.cmr.infra.server.configuration.ServerConfigManagerImpl.getServerConfigBean(ServerConfigManagerImpl.java:316)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.loadConnectProvider(RepositoryImpl.java:301)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.getConnectionProvider(RepositoryImpl.java:290)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.initDataSource(RepositoryImpl.java:786)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.init(RepositoryImpl.java:741)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.<init>(RepositoryImpl.java:213)

    at com.sybase.cmr.infra.server.impl.RepositoryImpl.getInstance(RepositoryImpl.java:196)

    at com.sybase.cmr.infra.server.RepositoryFactory.createRepository(RepositoryFactory.java:27)

    at com.sap.powerdesigner.web.StartupListener.contextInitialized(StartupListener.java:68)

    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)

    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)

    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)

    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)

    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1877)

    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

    at java.util.concurrent.FutureTask.run(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

    at java.lang.Thread.run(Unknown Source)

My license file have below details:

# Sybase Software Asset Management License File. SS License for PowerDesigner

# EnterpriseArchitect

PACKAGE PD_EAR SYBASE COMPONENTS="PD_SHELL PD_CDM PD_PDM PD_OOM \

    PD_ILM PD_BPM PD_RQM PD_FRM PD_XSM PD_RMG PD_PRJ PD_IAM PD_EAM \

    PD_LDM PD_GLM PD_SAP PD_SHELLW PD_BPMW PD_SAPW" \

I have checked tomcat log files and I found the below information:

INFO: Stopping service Catalina

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [/powerdesigner-web] registered the JDBC driver [com.sybase.jdbc4.jdbc.SybDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/powerdesigner-web] appears to have started a thread named [CMRLightCacheCleaner] but has failed to stop it. This is very likely to create a memory leak.

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/powerdesigner-web] appears to have started a thread named [CMRDaemonThread-RepositoryCreation-1] but has failed to stop it. This is very likely to create a memory leak.

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [/cmr] registered the JDBC driver [com.sybase.jdbc4.jdbc.SybDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmr] appears to have started a thread named [CMRLightCacheCleaner] but has failed to stop it. This is very likely to create a memory leak.

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmr] appears to have started a thread named [CMRSessionTimeoutThread] but has failed to stop it. This is very likely to create a memory leak.

Nov 17, 2015 4:56:31 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/cmr] appears to have started a thread named [net.sf.ehcache.CacheManager@4a11e715] but has failed to stop it. This is very likely to create a memory leak.

Nov 17, 2015 4:56:31 PM org.apache.coyote.AbstractProtocol stop

INFO: Stopping ProtocolHandler ["http-apr-3030"]

Nov 17, 2015 4:56:31 PM org.apache.coyote.AbstractProtocol stop

INFO: Stopping ProtocolHandler ["http-bio-3443"]

Nov 17, 2015 4:56:31 PM org.apache.coyote.AbstractProtocol stop

INFO: Stopping ProtocolHandler ["ajp-apr-8009"]

Nov 17, 2015 4:58:23 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent

Please suggest me any way to resolve this issue?

Thanks & Regards,

Ramana.

c_baker
Employee
Employee
‎11-17-2015 2:02 PM
0 Kudos

As the error message states, you need to put a copy of your license file in the Portal directory under 'C:\Program Files\SAP\PowerDesigner Portal 16\license\powerdesigner.server.lic'

The path is not searched to find the license so it must be in this location under this explicit name.

Chris

venkataramana_paidi
Contributor
‎11-18-2015 6:14 AM
0 Kudos

Hi ,

Still I am getting the below error after keeping the Power designer license in portal directory.

ERROR localhost-startStop-1 2015/11/18 06:27:05 GST com.sybase.cmr.infra.server.license.LicenseUtils.getLicenseFilePath(LicenseUtils.java:134) License file powerdesigner.server.lic does not exist in the CMR_HOME : C:\Program Files\SAP\PowerDesigner Portal 16\license\powerdesigner.server.lic

ERROR localhost-startStop-1 2015/11/18 06:27:05 GST com.sybase.cmr.infra.server.license.LicenseManager.initLicenseService(LicenseManager.java:190) License validation service cannot be started. License library or configuration file cannot be found under CMR_HOME.

FATAL localhost-startStop-1 2015/11/18 06:27:07 GST com.sybase.cmr.infra.server.persistence.db.connection.DBCPConnectionProvider.init(DBCPConnectionProvider.java:241) Cannot create PoolableConnectionFactory (JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect)

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect)

Normal Power Designer enterprise architect license will work with portal .  Do we need any special license file for use the portal?

Thanks & Regards,

Ramana.

c_baker
Employee
Employee
‎11-18-2015 1:19 PM
0 Kudos

The previous error is still occurring.  The portal cannot find the license file. Have you followed the instructions in the error and my previous post?

The license file MUST be copied to the folder specified and renamed to 'powerdesigner.server.lic'.

chris

pascalmenoud
Explorer
‎11-18-2015 1:54 PM
0 Kudos

As far as I know (from the docs), the only supported option is to use a license server. Usually the license server name is entered during the setup.

So the powerdesigner.server.lic just contains the license server name, and port:

SERVER my.license.server.name ANY its.port.number
USE_SERVER

GeorgeMcGeachie
Active Contributor
‎11-17-2015 12:42 PM
0 Kudos

Looks like your web server (or the portal service) is not running, doesn't look like a database issue. Perhaps there's an issue with Java.

The scripts to start and stop the portal are in this folder:

C:\Program Files\SAP\PowerDesigner Portal 16\scripts

If you're using a local Tomcat server for the Portal, the log files are in:

C:\Program Files\SAP\PowerDesigner Portal 16\Tomcat\logs

Show replies
Show replies
Ask a Question