5 Replies Latest reply on Jul 12, 2021 11:58 PM by Sakshi Thakur

    Not able to login to Hub Console

    Mohit Kumar Seasoned Veteran

      In a new installation, I am not able to login to http://localhost:8080/cmx/  by default credentials admin/admin.

       

      In logs, I see this warning when I was trying to login. I have already enabled Enable XA Transactions on sql server 2017. Can anyone help.

       

      ARJUNA016138: Failed to enlist XA resource XAResourceWrapperImpl@5e76632c[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@555af20a pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=15.00.2000 jndiName=java:jboss/datasources/jdbc/siperian-cmx_system-ds]: javax.transaction.SystemException: TransactionImple.enlistResource - XAResource.start ARJUNA016054: could not register transaction: < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffff0a0000aa:-c5f8f37:60ed1cac:ae, node_name=1, branch_uid=0:ffff0a0000aa:-c5f8f37:60ed1cac:f5, subordinatenodename=null, eis_name=java:jboss/datasources/jdbc/siperian-cmx_system-ds >

        • 1. Re: Not able to login to Hub Console
          SRINIVASA KALYAN KARAVADI Active Member

          Can you share us the error if you see anything in the console.log , you will find this in the below path.

           

          Example:  C:\Users\foldername\siperian

          • 2. Re: Not able to login to Hub Console
            Mohit Kumar Seasoned Veteran

            Thank you Srinivasa for your quick reply.

             

            I got the resolution. Actually some execute permissions were missing on master database.

             

            APPLYING THE SQL QUERY AS BELOW ON BOTH USERNAME [cmx_system] & [cmx_ors] fixed it.

             

            use [master]

            GO

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_commit] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_end] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_forget] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_forget_ex] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_init] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_init_ex] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_prepare] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_prepare_ex] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_recover] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_rollback] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_rollback_ex] TO [cmx_system]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_start] TO [cmx_system]

            GO

             

             

            use [cmx_ors]

            GO

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_commit] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_end] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_forget] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_forget_ex] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_init] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_init_ex] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_prepare] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_prepare_ex] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_recover] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_rollback] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_rollback_ex] TO [cmx_ors]

            GRANT EXECUTE ON [dbo].[xp_sqljdbc_xa_start] TO [cmx_ors]

            GO

             

             

            • 3. Re: Not able to login to Hub Console
              Sakshi Thakur Active Member

              Hi Mohit,

               

              Please check below kb.

              Support

               

              Regards!

              • 4. Re: Not able to login to Hub Console
                Mohit Kumar Seasoned Veteran

                Hi Sakshi,

                 

                Yes I have gone through this kb also but that was saying to execute permissions for SqlJDBCXAUser. I executed this grant permissions for other users also that I used to create & import ORS i.e cmx_system & cmx_ors.

                • 5. Re: Not able to login to Hub Console
                  Sakshi Thakur Active Member

                  Hi Mohit,

                   

                  Yes, exception occurs when permissions are missing for the object in the database for the users.

                  Thank you for the update.

                   

                  Regards!