Discussion
TCS
TCS
IN
TCS
Posted: Apr 11, 2016
Last activity: Oct 4, 2018
Last activity: 4 Oct 2018 13:54 EDT
Closed
rules upgrade is failed for an application updating from 7.1.4 to 7.2
Hi,
We used windows authentication for SQL Server as explained in the below link.
Migrate was succesfull but during rules upgrade(internal server startup) we are facing the below error.
[java] Apr 11, 2016 2:57:44 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] java.lang.NullPointerException
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getSchemaName(SQLGeneratorMssql.java:563)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.lookupDBInfo(DatabaseInformationMapImpl.java:405)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.get(DatabaseInformationMapImpl.java:269)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnectionFromDatabaseName(ConnectionManagerImpl.java:884)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1214)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1156)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.rebuildDBNameDefinitions(ConnectionManagerImpl.java:2911)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:662)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:1460)
[java] at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1130)
[java] at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.setStageDirectory(ParUtilsImpl.java:213)
[java] at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.copyFileToVfsRoot(ParUtilsImpl.java:309)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:63)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Apr 11, 2016 2:57:44 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega
[java] SEVERE: Problem during method invocation (main)
[java] java.lang.NullPointerException
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getSchemaName(SQLGeneratorMssql.java:563)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.lookupDBInfo(DatabaseInformationMapImpl.java:405)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.get(DatabaseInformationMapImpl.java:269)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnectionFromDatabaseName(ConnectionManagerImpl.java:884)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1214)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1156)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.rebuildDBNameDefinitions(ConnectionManagerImpl.java:2911)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:662)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:1460)
[java] at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1130)
[java] at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.setStageDirectory(ParUtilsImpl.java:213)
[java] at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.copyFileToVfsRoot(ParUtilsImpl.java:309)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:63)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:279)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: java.lang.NullPointerException
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getSchemaName(SQLGeneratorMssql.java:563)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.lookupDBInfo(DatabaseInformationMapImpl.java:405)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.get(DatabaseInformationMapImpl.java:269)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnectionFromDatabaseName(ConnectionManagerImpl.java:884)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1214)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1156)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.rebuildDBNameDefinitions(ConnectionManagerImpl.java:2911)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:662)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:1460)
[java] at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1130)
[java] at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.setStageDirectory(ParUtilsImpl.java:213)
[java] at com.pega.pegarules.deploy.internal.archive.ParUtilsImpl.copyFileToVfsRoot(ParUtilsImpl.java:309)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:63)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] ... 1 more
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Posted: 8 years ago
QBE
QBE
AU
Hi,
We can confirm that the system is not taking into consideration of Windows Authentication for SQL Server. When we create a DB User with required priveleges, we are able to proceed with upgrade.
Just to confirm that the issue is with windows authentication, we have tested with above temporary DB User.
However as per client we are still looking for a solution which will take Windows Credentials into consideration while running Upgrade/Update.
Based on our knowledge, migrate will not start the server and hence there was no issue with migrate step. However Upgrade/Update tries to start the server with connection properties given in setupdatabase and failing during startup as it is not able to recognize the authentication details given.
Regards,
Sudheer
Posted: 7 years ago
Infosys Ltd
Infosys Ltd
AU
Hi Sudheer,
Have you guys found a solution for this? Is the solution, if any, present for the upgrade to 7.3.1? I am also facing a same issue. The client uses windows authentication for database, MSSQL. Please let me know how to resolve this. Thanks.
Regards.
Shikhar Dongre
Proprietary information hidden