14 Replies Latest reply: Dec 6, 2012 12:01 AM by sunilkcs RSS

    Activity Engine Schema issue

    Alfred Moreno

      On our local Jive development box, I'm getting the following warning from the activity engine:

       

      [INFO] 2012-01-05 19:09:33,404 [main] INFO [] com.jivesoftware.eae.service.Main - Starting EAE core server at localhost:7020
      [INFO] 2012-01-05 19:09:33,413 [main] INFO [] com.jivesoftware.eae.sendreceive.SendReceiveServerImpl - Starting Netty service endpoint... eae-service:7020 (minWorkerThreads=4, maxWorkerThreads=2048)
      [INFO] 2012-01-05 19:09:34,005 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:34,010 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 8 more seconds
      [INFO] 2012-01-05 19:09:35,013 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:35,014 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 7 more seconds
      [INFO] 2012-01-05 19:09:36,017 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:36,017 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 6 more seconds
      [INFO] 2012-01-05 19:09:37,020 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:37,021 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 5 more seconds
      [INFO] 2012-01-05 19:09:38,024 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:38,025 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 4 more seconds
      [INFO] 2012-01-05 19:09:39,027 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:39,030 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 3 more seconds
      [INFO] 2012-01-05 19:09:40,033 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:40,033 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 2 more seconds
      [INFO] 2012-01-05 19:09:41,036 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:41,037 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 1 more seconds
      [INFO] 2012-01-05 19:09:42,040 [pool-12-thread-1] INFO [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema does not appear to be installed.
      [INFO] 2012-01-05 19:09:42,040 [pool-12-thread-1] WARN [] com.jivesoftware.eae.service.dao.DataSourceManager - Schema for system with id 9112c19c-ce48-46e5-aaa2-b629ad279cca partially exists, waiting for 0 more seconds
      [INFO] 2012-01-05 19:09:43,045 [pool-12-thread-1] ERROR [] com.jivesoftware.eae.service.dao.DataSourceManager - Database schema version does not appear to match expected version for systemID: 9112c19c-ce48-46e5-aaa2-b629ad279cca. No work will be done on the connection.
      

       

      I've created the 'eae' database on our postgres server for the Activity Engine, but when I execute eae-start, it doesn't seem to create the schema.  This error has been persisting for some time now =/  Any ideas?  I've already tried deleting the database, re-creating it, and launching again.. same issue, over and over.  Even tried to run through setup again and re-launch the services.

        • Re: Activity Engine Schema issue
          Mandar Tuljapurkar

          Can you delete the system property "jive.master.eae.key.node" and restart the application, including eae.

          Does it work after that?

            • Re: Activity Engine Schema issue
              suresh548

              Hi Mandar,

               

              Could you please tell me,how to delete system property "jive.master.eae.key.node"?.

               

              Thanks a lot.

              Suresh P.

                • Re: Activity Engine Schema issue
                  Mandar Tuljapurkar

                  Hope you are on a Development Environment.

                  First Log In as admin.

                  Open the System Properties page, in the admin console: System > Management > System Properties

                  You can find the property in the list.

                    • Re: Activity Engine Schema issue
                      suresh548

                      Hi Mandar,

                      I am unable to login Dev Env,because when I  run ./eae-start,I am getting above error.

                      for cargo ,./cargo-start is working fine.

                      • Re: Activity Engine Schema issue
                        suresh548

                        Even I tried to create new project using below commands in linux terminal:

                        1.Create Base Project:

                        Desktop]#mvn archetype:create -e -DarchetypeGroupId=com.jivesoftware.maven -DarchetypeArtifactId=maven-jive-archetype -DarchetypeVersion=5.0.x-SNAPSHOT -DgroupId=com.jivesoftware.education -DartifactId=Test

                         

                        2.Build the base project(Navigate to the new base project):

                        Desktop/Test]#mvn clean install -Djive.setup=false -P internal

                        3.Then,I changed the execute permissions for both eae-start and cargo-start.

                        4.I Started the eae service:

                        Desktop/Test/web]#./eae-start

                         

                        Then,server log is showing like this

                         

                        :

                         

                        [INFO] 2012-05-16 23:48:01,001 [main] INFO [] com.jivesoftware.eae.sendreceive.SendReceiveServerImpl - Starting Netty service endpoint... eae-service:7020 (minWorkerThreads=4, maxWorkerThreads=2048)

                        [INFO] 2012-05-16 23:48:31,931 [CheckRecommenderForCommandThread] INFO [] com.jivesoftware.eae.service.dao.core.ConfigurationPropertiesDAO - Empty configuration properties file '/root/Desktop/Suresh/Test/web/src/test/eae/config/instance_properties.json' found in ConfigurationPropertiesDAO - return empty properties

                        [INFO] 2012-05-16 23:51:06,961 [Recency Sweeper] INFO [] com.jivesoftware.eae.service.dao.core.ConfigurationPropertiesDAO - Empty configuration properties file '/root/Desktop/Suresh/Test/web/src/test/eae/config/instance_properties.json' found in ConfigurationPropertiesDAO - return empty properties

                        [INFO] 2012-05-16 23:51:06,963 [Firehose Migrator] INFO [] com.jivesoftware.eae.service.dao.core.ConfigurationPropertiesDAO - Empty configuration properties file '/root/Desktop/Suresh/Test/web/src/test/eae/config/instance_properties.json' found in ConfigurationPropertiesDAO - return empty properties

                        [INFO] 2012-05-16 23:51:06,979 [CheckRecommenderForCommandThread] INFO [] com.jivesoftware.eae.service.dao.core.ConfigurationPropertiesDAO - Empty configuration properties file '/root/Desktop/Suresh/Test/web/src/test/eae/config/instance_properties.json' found in ConfigurationPropertiesDAO - return empty properties

                        [INFO] 2012-05-16 23:51:37,896 [CheckRecommenderForCommandThread] INFO [] com.jivesoftware.eae.service.dao.core.ConfigurationPropertiesDAO - Empty configuration properties file '/root/Desktop/Suresh/Test/web/src/test/eae/config/instance_properties.json' found in ConfigurationPropertiesDAO - return empty properties

                         

                        Cargo is fine.Please help,how to startup my eae-service.After this,I am unable to login to admin console(http://localhost:8080/admin/main.jsp).It is giving me 404 error.

                         

                        Thanks a lot.

                        Suresh P.

                         

                          • Re: Activity Engine Schema issue
                            Mandar Tuljapurkar

                            I think there is an issue with the sequence in which you are starting the applications.

                            You need to start the eae service first and then the application.

                             

                            Once you configure the database settings in admin console, you will get the mentioned file.

                            Example contents are as follows:

                             

                            {

                              "<some long text>" : {

                                "username" : "postgres",

                                "password" : "******",

                                "dialect" : "org.hibernate.dialect.PostgreSQLDialect",

                                "driver" : "org.postgresql.Driver",

                                "jdbcURL" : "<jdbc connection string>"

                              }

                            }

                              • Re: Activity Engine Schema issue
                                sunilkcs

                                I also have the same issue. which admin console you are talking about ? Is it pgadmin console ? as ./eae-start fails, i cannot see jive admin console.

                                  • Re: Activity Engine Schema issue
                                    Mandar Tuljapurkar

                                    You can try running the following query against the database and restart your application:

                                    delete from jiveproperty where name='jive.master.encryption.key.node';


                                    Thanks Tyler Whitesides

                                      • Re: Activity Engine Schema issue
                                        sunilkcs

                                        Hi Mandar

                                                   I had created two postgres databases named "dummyCustomerSite" and "eaecore-dummyCustomerSite (for EAE service)"  These two databases are empty and nothing is there inside. This is a fresh Jive5.0 setup in my linux box. My database details in jive_startup.xml is

                                         

                                        <database>

                                                <defaultProvider>

                                                    <username>postgres</username>

                                                    <serverURL>jdbc:postgresql://localhost:5432/dummyCustomerSite</serverURL>

                                                    <maxConnections>25</maxConnections>

                                                    <connectionTimeout>1.0</connectionTimeout>

                                                    <driver>org.postgresql.Driver</driver>

                                                    <password>postgres</password>

                                                    <minConnections>5</minConnections>

                                                </defaultProvider>

                                            </database>

                                         

                                        which is correct. When i execute "./eae-start" i am getting

                                         

                                        2012-11-30 12:50:49,474 [main] INFO [] com.jivesoftware.eae.sendreceive.SendReceiveServerImpl - Starting Netty service endpoint... eae-service:7020 (minWorkerThreads=4, maxWorkerThreads=2048)

                                        2012-11-30 12:51:19,279 [CheckRecommenderForCommandThread] INFO [] com.jivesoftware.eae.service.dao.core.ConfigurationPropertiesDAO - Empty configuration properties file '/usr/local/dummyCustomerSite/web/src/test/eae/config/instance_properties.json' found in ConfigurationPropertiesDAO - return empty properties

                                         

                                        Please help me.