5 Replies Latest reply on May 22, 2012 7:13 AM by halliballi

    JBAS010785: Failed start store manager

    halliballi

      Hi everyone I have an application that uses ejb 2.1 when I deploy my Entity Beans I get the following error, can anyone tell me what that means?

      It seems as if JBoss wants to create tables, is this for some kind of cache? And why is it trying to create tables? Do I have some missconfiguration?

       

      On JBoss 4.01 it worked fine.

       

      10:38:02,158 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC00001: Failed to start service jboss.deployment.subunit."gan.ear".

      "gan_usermgr-server.jar".component.UserAssignedAssociatedRealmEntityEJB.jdbc.store-manager.START: org.jboss.msc.service.StartExc

      eption in service jboss.deployment.subunit."gan.ear"."gan_usermgr-server.jar".component.UserAssignedAssociatedRealmEntityEJB.jdbc.st

      ore-manager.START: JBAS010785: Failed start store manager

              at org.jboss.as.cmp.jdbc.JdbcStoreManagerStartService.start(JdbcStoreManagerStartService.java:46)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2

      .GA]

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [rt.jar:1.6.0_31]

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.6.0_31]

              at java.lang.Thread.run(Unknown Source) [rt.jar:1.6.0_31]

      Caused by: java.lang.RuntimeException: JBAS010765: Error while creating table: [user_assigned_associated_realms]

              at org.jboss.as.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:447)

              at org.jboss.as.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:175)

              at org.jboss.as.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:233)

              at org.jboss.as.cmp.jdbc.JdbcStoreManagerStartService.start(JdbcStoreManagerStartService.java:44)

              ... 5 more

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Falsche Syntax in der Nõhe von 'user_assigned_associated_realms'.

              at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)

              at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)

              at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(Unknown Source)

              at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:371)

              at org.jboss.as.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:439)

              ... 8 more

       

      Thanks in advance

        • 1. Re: JBAS010785: Failed start store manager
          halliballi

          Ok, I found the solution for the second problem.

          The tablename 'user_assigned_associated_realms' had was surrounded by [] in the jbosscmp-jdbc.xml

          I used the SQL profiler. JBoss was calling exec sp_tables to check if the table exists and if not wanted to create the table.

          The call of sp_tables did not succeed when the tablename [user_assigned_associated_realms] and therefore jboss wanted to create the table again, which caused the error.

          1 of 1 people found this helpful
          • 2. Re: JBAS010785: Failed start store manager
            jaikiran

            Was the use of [ ] allowed in previous versions of JBoss AS? What did those brackets signify?

            • 3. Re: JBAS010785: Failed start store manager
              halliballi

              At least with JBoss 4 we did not get any errors and the beans did work.

              This was for tableames that might have special characters (in MS SQL) or for tablenames that where e.g. reserved names like user

              • 4. Re: JBAS010785: Failed start store manager
                jaikiran

                Halli Balli wrote:

                 

                 

                This was for tableames that might have special characters (in MS SQL) or for tablenames that where e.g. reserved names like user

                So if I understand it right, those [ ] were used as escape characters. I'll check if that's what it was and if it was intentional to remove that support in AS7.

                • 5. Re: JBAS010785: Failed start store manager
                  halliballi

                  I think you solved my problem. I've set the default type-mapping to MS SQLserver2000 and set <create-table>false</create-table>

                  Now either the brackets are working or at least the call that caused the error is not called any more ;-)

                   

                  I think the brackets are standard escape characters in MS SQL but I am not a 100 percent sure.

                  Thank you very much