Password Reset

[Former Member]

Hi All,

we have implemented password reset policy in our Portal System with AIX and Database is DB2.

After reset the password for <SID>ADM and SAP<SID>DB in OS Level and restarted but my portal URL is not working..

Do we need do any thing on DB2 Databases?

Regards,

Panu.

[Former Member · Accepted solution]

Please find the logs as below

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:338)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:267)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

... 11 more

Caused by: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID

revoked.

at com.ibm.db2.jcc.a.b.m(b.java:2014)

at com.ibm.db2.jcc.a.b.c(b.java:1659)

at com.ibm.db2.jcc.a.bb.r(bb.java:792)

at com.ibm.db2.jcc.a.bb.k(bb.java:349)

at com.ibm.db2.jcc.a.bb.c(bb.java:133)

at com.ibm.db2.jcc.a.b.yc(b.java:1283)

at com.ibm.db2.jcc.a.b.b(b.java:1204)

at com.ibm.db2.jcc.a.b.y(b.java:4593)

at com.ibm.db2.jcc.a.b.b(b.java:758)

at com.ibm.db2.jcc.a.b.a(b.java:701)

at com.ibm.db2.jcc.a.b.a(b.java:378)

at com.ibm.db2.jcc.a.b.<init>(b.java:316)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:166)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:125

)

... 14 more

#

#1.#00215E51D5B000BA002A706F0007802400049A07209276A0#1295255308760#com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource#sap.com/i

rj#com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49,5,SAPEngin

e_Application_Thread[impl:3]_Group]##0#0#Error##Java###There was a problem getting the timestamp of the node: network_paths with interna

l id: 4294969123

[EXCEPTION]

#1#com.sap.netweaver.config.store.ConfigStoreException: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceExceptio

n in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown

by the physical connection: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred.

Reason: User ID revoked.

at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.makeException(CommonJDBCConfigPersistence.java:1388)

at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.getProperty(CommonJDBCConfigPersistence.java:1136)

at com.sap.netweaver.config.store.ConfigNode.getProperty(ConfigNode.java:61)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getInternalTimestamp(CMStoreSource.java:1111)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.shouldRefresh(CMStoreSource.java:997)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.refreshObjects(CMStoreSource.java:1187)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getTimeStamp(CMStoreSource.java:1331)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.synchronizeListeners(ConfigurableSourceSynchronizer.java:124)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.run(ConfigurableSourceSynchronizer.java:167)

at java.util.TimerThread.mainLoop(Timer.java:461)

at java.util.TimerThread.run(Timer.java:408)

===============================================================================

node name : jcmon

pid : 381178

system name : GQP

system nr. : 00

started at : Mon Jan 17 09:49:35 2011

arguments :

arg[00] : jcmon

arg[01] : pf=GQP_JC00_GMU-EPQB

[Thr 1] Mon Jan 17 09:49:35 2011

[Thr 1] *** WARNING => INFO: Unknown property [instance.box.number=GQPJC00gmu-epqb] [jstartxx_mt. 841]

[Thr 1] *** WARNING => INFO: Unknown property [instance.en.host=GMU-EPQB] [jstartxx_mt. 841]

[Thr 1] *** WARNING => INFO: Unknown property [instance.en.port=3201] [jstartxx_mt. 841]

[Thr 1] *** WARNING => INFO: Unknown property [instance.system.id=0] [jstartxx_mt. 841]

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

JStartupReadInstanceProperties: read instance properties [/usr/sap/GQP/JC00/j2ee/cluster/instance.properties:/usr/sap/GQP/JC00/SDM/progr

am/config/sdm_jstartup.properties]

-> ms host : GMU-EPQB

-> ms port : 3901

-> OS libs : /usr/sap/GQP/JC00/j2ee/os_libs

-> Admin URL :

-> run mode : normal

-> run action : NONE

-> enabled : yes

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

[Thr 1] Mon Jan 17 09:49:39 2011

[Thr 1] *** ERROR => Can't attach to administration shared memory (rc = 3) [jcmonxx_mt.c 228]

[Thr 258] Mon Jan 17 09:50:07 2011

[Thr 258] JCMON_ReceiveThread: Thread 258 started as ms receiver.

=======================================================

One more i have reset password sap<sid>db at os level when system is up and runing...

Regards,

Panu

[Former Member]

I think you has to maintain the password of <sid>adm in secure store by config tool. admin/password

[nirmal_konchada]

Hi,

SIDadm password need not be updated in the secure store.

I think SAP<SID>DB is a schema user and you need to update this password in secure store.

Regards,

Nirmal.K

[Former Member]

I am unable to login to configtool because it gives error "Error occurred while working with Configuration (Scanning). Msg: Error while connecting to DB.

After OK

Then i able to see only Secure store option

in Secure Store Data...

i have changed values of jdbc/pool/<SID>/Password and admin/password/<SID>

after saving it gives that changes will effect after cluster restart...

i unable to find the where i can find the cluster?

[former_member191418]

It says just to restart your portal system (java stack) using stopsap j2ee and startsap j2ee (since yours is AIX box)

[nirmal_konchada]

I think the password that you have changed is for admin user and cluster restart is nothing but restart of JAVA Engine. Just restart your SAP server.

Nirmal.

[Former Member]

i have restarted my portal even though i am unable to open the portal url..

checked sidadm and db2sid services are running in OS.

[nirmal_konchada]

How did u change the SAP<SID>DB user password and why???

Nirmal.k

[Former Member]

startsap j2ee

Checking db6 db Database

-

---

Error: java.io.FileNotFoundException: JdbcCon.log (The file access permissions do not allow the specified action.)

J2EE Database is not available via test

See logfile JdbcCon.log

Starting SAP-Collector Daemon

-

---

open logfile '/usr/sap/tmp/dev_coll.tmp' failed... use stderri

11:03:34 17.01.2011 ERROR: cannot open log file /usr/sap/tmp/dev_coll.tmp

11:03:34 17.01.2011 ERROR: Make sure directory /usr/sap/tmp exists or specify DIR_PERF

11:03:34 17.01.2011 ERROR: in profile and run saposcol pf=<profile>

saposcol already running

Starting SAP Instance SCS01

-

---

Startup-Log is written to /home/gqpadm/startsap_SCS01.log

Instance Service on host GMU-EPQB started

Instance already running

Starting SAP Instance JC00

-

---

Startup-Log is written to /home/gqpadm/startsap_JC00.log

Instance Service on host GMU-EPQB started

Instance already running

[Former Member]

Did you maintain new password in secure store for SAP<SID>DB. In my last post i wrongly mentioned <sid>adm.. Please maintain the new password & stop the sap system & start

[Former Member]

SAP <SID>DB Password has been changed by setting password reset policy by Network administrator....

when i login with SID<ADM> User it request for new password has password expired.

[Former Member]

i have change for jdbc/pool and admin/password in configtool even though i am unable to open

[nirmal_konchada]

>

> SAP <SID>DB Password has been changed by setting password reset policy by Network administrator....
How can a database user be under the control of password policy???????
> 
> when i login with SID<ADM> User it request for new password has password expired.

SIDadm is fine. You can cange the password.

In your earlier post it shows that you have not restarted the server but simply started the already running SAP system. Please stop ad then start te system.

Regards,

Nirmal.K

[Former Member]

Previously... i have changed the password for users SID<ADM> and SAP<SID> in ABAP Systems by using script "dscdb6up".

abap stack systems are working fine..

only problem with JAVA Stacks....

stopsap gives error..

Checking db6 db Database

-

---

Error: java.io.FileNotFoundException: JdbcCon.log (The file access permissions do not allow the specified action.)

J2EE Database is not available via test

See logfile JdbcCon.log

Stopping the SAP instance JC00

-

---

Shutdown-Log is written to /home/gqpadm/stopsap_JC00.log

Instance on host GMU-EPQB stopped

Waiting for cleanup of resources...............

Stopping the SAP instance SCS01

-

---

Shutdown-Log is written to /home/gqpadm/stopsap_SCS01.log

Instance on host GMU-EPQB stopped

Waiting for cleanup of resources.........

ABAP Database not running

[former_member191418]

Also change sap<SID>db password using dscdb6up under sidadm user at os level

[Former Member]

we can't reset password because these script doesn't exist in JAVA Stacks....

[sunny_pahuja2]

Could you please paste latest default trace logs ?

Thanks

Sunny

[Former Member]

ccured while creating ManagedConnection: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failu

re occurred. Reason: User ID revoked.#

#1.#00215E51D5B000BA002A70660007802400049A07209253CE#1295255308751#com.sap.engine.services.dbpool#sap.com/irj#com.sap.engine.services.d

bpool#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error#1#/System

com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.synchronizeListeners(ConfigurableSourceSynchronizer.java:124)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.run(ConfigurableSourceSynchronizer.java:167)

at java.util.TimerThread.mainLoop(Timer.java:461)

at java.util.TimerThread.run(Timer.java:408)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.ibm.db2.

jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked.

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:193

)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:338)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:267)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

... 11 more

Caused by: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID

revoked.

at com.ibm.db2.jcc.a.b.m(b.java:2014)

at com.ibm.db2.jcc.a.b.c(b.java:1659)

at com.ibm.db2.jcc.a.bb.r(bb.java:792)

at com.ibm.db2.jcc.a.bb.k(bb.java:349)

at com.ibm.db2.jcc.a.bb.c(bb.java:133)

at

)

... 14 more

#

#1#com.sap.netweaver.config.store.ConfigStoreException: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceExceptio n in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked. at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.makeException(CommonJDBCConfigPersistence.java:1388) at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.getProperty(CommonJDBCConfigPersistence.java:1136) at com.sap.netweaver.config.store.ConfigNode.getProperty(ConfigNode.java:61) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getInternalTimestamp(CMStoreSource.java:1111) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.shouldRefresh(CMStoreSource.java:997) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.refreshObjects(CMStoreSource.java:1187) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getTimeStamp(CMStoreSource.java:1331) at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.synchronizeListeners(ConfigurableSourceSynchronizer.java:124) at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.run(ConfigurableSourceSynchronizer.java:167) at java.util.TimerThread.mainLoop(Timer.java:461) at java.util.TimerThread.run(Timer.java:408) # #1.#00215E51D5B000BA002A706A0007802400049A0720927125#1295255308759#com.sap.sql.jdbc.NativeConnectionFactory#sap.com/irj#com.sap.sql.jdb c.NativeConnectionFactory#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49,5,SAPEngine_Application_Thread[impl:3]_Group]# #0#0#Error#1#/System/Database/sql/jdbc#Java#com.sap.sql_0002##SQL error occurred on connection jdbc:db2://GMU-EPQB:5912/GQP:deferPrepare s=0;: code=-4,214, state="null", message="[ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID r evoked.". [EXCEPTION] #6#-4214#<null>#[ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked.#jdbc:db2://GMU -EPQB:5912/GQP:deferPrepares=0;#<null>#com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked. at com.ibm.db2.jcc.a.b.m(b.java:2014) at com.ibm.db2.jcc.a.b.c(b.java:1659) at com.ibm.db2.jcc.a.bb.r(bb.java:792) at com.ibm.db2.jcc.a.bb.k(bb.java:349) at com.ibm.db2.jcc.a.bb.c(bb.java:133) at com.ibm.db2.jcc.a.b.yc(b.java:1283) at com.ibm.db2.jcc.a.b.b(b.java:1204) at com.ibm.db2.jcc.a.b.y(b.java:4593) at com.ibm.db2.jcc.a.b.b(b.java:758) at com.ibm.db2.jcc.a.b.a(b.java:701) at com.ibm.db2.jcc.a.b.a(b.java:378) at com.ibm.db2.jcc.a.b.<init>(b.java:316) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:166) at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215) at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608) at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285) at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:125 ) at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:338) at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:267) at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51) at com.sap.netweaver.config.store.CommonJDBCConnectionHandler.getReadOnlyConnection(CommonJDBCConnectionHandler.java:37) at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.getProperty(CommonJDBCConfigPersistence.java:1098) at com.sap.netweaver.config.store.ConfigNode.getProperty(ConfigNode.java:61) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getInternalTimestamp(CMStoreSource.java:1111) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.shouldRefresh(CMStoreSource.java:997) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.refreshObjects(CMStoreSource.java:1187) at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getTimeStamp(CMStoreSource.java:1331) at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.synchronizeListeners(ConfigurableSourceSynchronizer.java:124) at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.run(ConfigurableSourceSynchronizer.java:167) at java.util.TimerThread.mainLoop(Timer.java:461) at java.util.TimerThread.run(Timer.java:408) # #1.#00215E51D5B000BA002A706B0007802400049A0720927256#1295255308759#com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl#sap. com/irj#com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49, 5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error##Plain###ManagedConnectionFactoryImpl.createManagedConnection(): SQLException o ccured while creating ManagedConnection: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failu re occurred. Reason: User ID revoked.# #1.#00215E51D5B000BA002A706D0007802400049A07209273C6#1295255308760#com.sap.engine.services.dbpool#sap.com/irj#com.sap.engine.services.d bpool#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error#1#/System /Server#Java#dbpool_0300##ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.B aseResourceException: SQLException thrown by the physical connection: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] C onnection authorization failure occurred. Reason: User ID revoked.#3#ResourceException#ConnectionFactoryImpl.getConnection()#com.sap.en gine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.ibm.db2.jcc.b.SqlException: [ ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked.# #1.#00215E51D5B000BA002A706E0007802400049A07209274DF#1295255308760#com.sap.engine.services.dbpool#sap.com/irj#com.sap.engine.services.d bpool#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error#1#/System /Audit#Java###Exception #1#com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryI

mpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: co

m.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked.

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)

at com.sap.netweaver.config.store.CommonJDBCConnectionHandler.getReadOnlyConnection(CommonJDBCConnectionHandler.java:37)

at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.getProperty(CommonJDBCConfigPersistence.java:1098)

at com.sap.netweaver.config.store.ConfigNode.getProperty(ConfigNode.java:61)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getInternalTimestamp(CMStoreSource.java:1111)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.shouldRefresh(CMStoreSource.java:997)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.refreshObjects(CMStoreSource.java:1187)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getTimeStamp(CMStoreSource.java:1331)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.synchronizeListeners(ConfigurableSourceSynchronizer.java:124)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.run(ConfigurableSourceSynchronizer.java:167)

at java.util.TimerThread.mainLoop(Timer.java:461)

at java.util.TimerThread.run(Timer.java:408)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.ibm.db2.

jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID revoked.

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:193

)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:338)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:267)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

... 11 more

Caused by: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred. Reason: User ID

revoked.

at com.ibm.db2.jcc.a.b.m(b.java:2014)

at com.ibm.db2.jcc.a.b.c(b.java:1659)

at com.ibm.db2.jcc.a.bb.r(bb.java:792)

at com.ibm.db2.jcc.a.bb.k(bb.java:349)

at com.ibm.db2.jcc.a.bb.c(bb.java:133)

at com.ibm.db2.jcc.a.b.yc(b.java:1283)

at com.ibm.db2.jcc.a.b.b(b.java:1204)

at com.ibm.db2.jcc.a.b.y(b.java:4593)

at com.ibm.db2.jcc.a.b.b(b.java:758)

at com.ibm.db2.jcc.a.b.a(b.java:701)

at com.ibm.db2.jcc.a.b.a(b.java:378)

at com.ibm.db2.jcc.a.b.<init>(b.java:316)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:166)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:125

)

... 14 more

#

#1.#00215E51D5B000BA002A706F0007802400049A07209276A0#1295255308760#com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource#sap.com/i

rj#com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource#Guest#0##n/a##1d40c0701f5c11e09a9e00215e51d5b0#Thread[Thread-49,5,SAPEngin

e_Application_Thread[impl:3]_Group]##0#0#Error##Java###There was a problem getting the timestamp of the node: network_paths with interna

l id: 4294969123

[EXCEPTION]

#1#com.sap.netweaver.config.store.ConfigStoreException: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceExceptio

n in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown

by the physical connection: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][t4][2017][11253] Connection authorization failure occurred.

Reason: User ID revoked.

at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.makeException(CommonJDBCConfigPersistence.java:1388)

at com.sap.netweaver.config.store.CommonJDBCConfigPersistence.getProperty(CommonJDBCConfigPersistence.java:1136)

at com.sap.netweaver.config.store.ConfigNode.getProperty(ConfigNode.java:61)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getInternalTimestamp(CMStoreSource.java:1111)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.shouldRefresh(CMStoreSource.java:997)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.refreshObjects(CMStoreSource.java:1187)

at com.sap.netweaver.portal.prt.config.cmsource.CMStoreSource.getTimeStamp(CMStoreSource.java:1331)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.synchronizeListeners(ConfigurableSourceSynchronizer.java:124)

at com.sapportals.config.fwk.meta.ConfigurableSourceSynchronizer.run(ConfigurableSourceSynchronizer.java:167)

at java.util.TimerThread.mainLoop(Timer.java:461)

at java.util.TimerThread.run(Timer.java:408)

[sunny_pahuja2]

Hi,

Have you updated the correct password of administrator user of portal system and SAP<SID>DB in the config tool ? Also, have you restarted the system after that ?

As per the logs, it looks like that passwords are still not correct in the secure store.

Thanks

Sunny

[Former Member]

Hi,

If you already update the SAP<SID>DB password in configtool please check user SAP<SID>DB locked or not

[nirmal_konchada]

Hi,

IS SAP<SID>DB a OS user???

Can you please check the dev_disp, dev_ms logs.

Regards,

Nirmal.K