6 Replies Latest reply on Jul 29, 2019 4:09 AM by Tamilselvan Parameswaran

    Smart Reporting Admin Password invalid Error

    Tamilselvan Parameswaran
      Share This:

      Hello,

      we have got invalid credentials error when upgrading Smart reporting to 1902 from 1805

       

      We have tried the same steps mentioned in the article https://communities.bmc.com/docs/DOC-72926

       

      but we got error message : Error occurred: com.hof.util.ActionErrorsException: DBAction constructor exception

       

       

      Anyone faced the same error and suggest a solution to reset the password.

        • 1. Re: Smart Reporting Admin Password invalid Error
          Ravi Reddi

          Hi Tamilselvan Parameswaran,

           

          Are you able to login the SmartReporting direct console with the new password?

           

          If yes, then it might be the problem with complex password. So suggest you to change it to simple password and post upgrade you can reset to complex password.

           

          If no, then might be with below parameter which needs to be changed. The parameter titled JDBCPasswordEncryption should be set to false

           

                <init-param>

                   <param-name>JDBCPassword</param-name>

                   <param-value>+aQ8Z35qmdFwNqEQe5M6uQ==</param-value>

                </init-param>

                <init-param>

                   <param-name>JDBCPasswordEncrypted</param-name>

                   <param-value>true</param-value>

                </init-param>

           

          Hope this helps!

           

          Regards,

          Ravi Reddi

          2 of 2 people found this helpful
          • 2. Re: Smart Reporting Admin Password invalid Error
            Tamilselvan Parameswaran

            Hello,

             

            Not able to login the SmartReporting direct console . and on-boarding console also got the same error (Incorrect username or password).

             

            It didnt work even after changing the Encryption option to false.

             

            How to find/ reset the user name and password to login to On boarding console

            • 3. Re: Smart Reporting Admin Password invalid Error
              Ravi Reddi

              I am presuming you have exactly followed the way it was demonstrated in the VIDEO. :-)

               

              Direct Console link you are using?  e.g. http://hosthame:8181/

               

              Do you have SSL enabled? Have you tried without SSL?

              Bundled or External Tomcat?

               

              Share the screenshot of the error and the jdbc.log from SmartReporting installation directory.

               

              Regards,

              Ravi Reddi

              • 4. Re: Smart Reporting Admin Password invalid Error
                Tamilselvan Parameswaran

                Hello,

                 

                Tried with direct console http://hosthame:8181/ and got the below error

                 

                 

                SSL disabled already and using bundled tomcat.

                 

                JDBC log we can find the account is locked error but we checked in DB and the account is still active.

                 

                Please find the jdbc.log :

                 

                2019-07-26 07:43:05 NOTICE: 2019-07-26 07:43:05

                2019-07-26 07:43:05 NOTICE: Starting DBConnectionPool

                2019-07-26 07:43:05 NOTICE: sourceId:            0

                2019-07-26 07:43:05 NOTICE: sourceName:          Application Configuration Database

                2019-07-26 07:43:05 NOTICE: connectionMethod:    JDBC

                2019-07-26 07:43:05 NOTICE: authAdapter:         Standard Authentication(GENERICUSER)

                2019-07-26 07:43:05 NOTICE: driver:              oracle.jdbc.driver.OracleDriver

                2019-07-26 07:43:05 NOTICE: url:                 jdbc:oracle:thin:@Korbsbvm33.APAC.bosch.com:1521:REMEDYV9

                2019-07-26 07:43:05 NOTICE: username:            ARAdmin

                2019-07-26 07:43:05 NOTICE: min connections:     2

                2019-07-26 07:43:05 NOTICE: max connections:     25

                2019-07-26 07:43:05 NOTICE: maxOpenTime:         4 h

                2019-07-26 07:43:05 NOTICE: maxCheckoutTime:     1 h

                2019-07-26 07:43:05 NOTICE: psCacheSize:         20

                2019-07-26 07:43:05 NOTICE: FetchSize:           0

                2019-07-26 07:43:05 NOTICE: Verify connections:  false

                2019-07-26 07:43:05 NOTICE: Application Version: 7.3

                2019-07-26 07:43:05 NOTICE: Build Version:       20180418

                2019-07-26 07:43:05 NOTICE: Pooling Enabled:     true

                2019-07-26 07:43:05 NOTICE: -----------------------------------------

                2019-07-26 07:43:06   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:43:21   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 2). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:43:36   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 3). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:43:51   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 4). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:44:06   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 5). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:44:21   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 6). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:44:36   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 7). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:44:51   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 8). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:45:06   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 9). Will try again in 15 seconds. java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:45:21   WARN: Failed to create initial connection at DBConnectionPool startup (attempt 10). java.sql.SQLException: ORA-28000: the account is locked

                 

                2019-07-26 07:45:21  ERROR: Failed to create initial connection at DBConnectionPool startup. Giving up.

                java.sql.SQLException: ORA-28000: the account is locked

                 

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

                    at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)

                    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)

                    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

                    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

                    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)

                    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)

                    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)

                    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

                    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

                    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

                    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

                    at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:179)

                    at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:127)

                    at com.hof.pool.DBConnectionPool.A(DBConnectionPool.java:1211)

                    at com.hof.pool.DBConnectionPool.createJDBCPool(DBConnectionPool.java:567)

                    at com.hof.pool.DBConnectionManager.initialiseAppPool(DBConnectionManager.java:396)

                    at com.hof.servlet.InitConnectionPool.init(InitConnectionPool.java:222)

                    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)

                    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)

                    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)

                    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4939)

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

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

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

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

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

                    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629)

                    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839)

                    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)

                • 5. Re: Smart Reporting Admin Password invalid Error
                  Tamilselvan Parameswaran

                  Hello,

                   

                  When we try to upgrade SmartReporting we got the error message.

                   

                   

                  • 6. Re: Smart Reporting Admin Password invalid Error
                    Tamilselvan Parameswaran

                    Hello All,

                     

                    I referred the link and tried with the steps mentioned int he below links and now it is working fine.

                     

                    ARAdmin password was changed earlier and forgot to setup the SmartReporting.

                     

                    Smart Reporting not working - Error information is missing

                     

                    Reseting Smart Reporting Repository database password

                     

                    Thank you

                    1 of 1 people found this helpful