21 Replies Latest reply: Nov 11, 2014 7:25 AM by 220987 RSS

    Activity Engine Schema issue

    alfred.moreno@zumba.com

      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
          mtuljapurkar

          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
                  mtuljapurkar

                  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
                            mtuljapurkar

                            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
                                    mtuljapurkar

                                    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.

                                          • Re: Activity Engine Schema issue
                                            mtuljapurkar

                                            Hi Sunil,

                                               I think once you access the admin console and set the eae database properties, this error should not appear.

                                            Let me know what happens.

                                            Regards,

                                            Mandar

                                              • Re: Activity Engine Schema issue
                                                sunilkcs

                                                Yes..I did that. It worked now. Thank You Mandar.

                                                  • Re: Activity Engine Schema issue
                                                    220987

                                                    Hi Sunil Kumar / Mandar Tuljapurkar

                                                     

                                                    I am facing the same issue , could you please let me know how can I acess jive admin console and set database properties as 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

                                                     

                                                    Chetan Mahendru

                                                      • Re: Activity Engine Schema issue
                                                        Vishwa

                                                        Once You Installed the rpm and started the Application, Open the browser and Login to your application Server link  with your Application  Admin Credentials.

                                                        That will allow , you access to admin console.  Once logged in there  , If you have done the database stetting , go to SYSTEM>> Management>> System Properties and add the required properties.

                                                         

                                                        If not, it will take you through the Database Settings  (EAE and APplication DB) . Once You set these properly and a connection is established. core.json and instanceproperties.json would be populated.  You can then proceed on the next Admin Console Settings as applicable.

                                                         

                                                        Regards

                                                        Vishwajeet

                                                          • Re: Activity Engine Schema issue
                                                            220987

                                                            Hi Vishwajeet ,

                                                             

                                                            First i execute "./eae-start"

                                                            I then execute "./cargo-start" in parallel terminal which says tomcat started on port[8080]

                                                             

                                                            I am using http://localhost:8080/ but i get 404 Error.

                                                            Any Idea what am I missing.

                                                            • Re: Re: Activity Engine Schema issue
                                                              220987

                                                              Hi Vishwajeet Joshi

                                                               

                                                              I see some Errors in form of Warnings when I execute cargo-start.

                                                              Can you check the attachment and let me know if you get some clue.

                                                               

                                                              Regards,

                                                              Amit Rajesth

                                                                • Re: Activity Engine Schema issue
                                                                  Vishwa

                                                                  Hi,

                                                                   

                                                                  I thought, You are deploying on  Server , but this seems to be like you are doing it on your local machine. Any case, You can ignore the  Warnings and access the Application on Port 8080. !!  Check, if it is available now ?

                                                                   

                                                                  All the Best.

                                                                   

                                                                  Regards

                                                                  Vishwajeet.

                                                                  • Re: Activity Engine Schema issue
                                                                    Vishwa

                                                                    Hi ,

                                                                     

                                                                    Please find the document i created trying to understand local setup, see if this works.

                                                                     

                                                                    Regards

                                                                    VIshwajeet

                                                                     

                                                                     

                                                                     

                                                                    Prerequisites


                                                                    Create a JiveDownloads Folder and Download  all the packages below .

                                                                    • PostgresSQL Database Server package must be downloaded.
                                                                    • Java JDK (C:\Program Files\Java\jdk1.8.0)   -- Setup Environment Variables like PATH, JAVA_HOME.
                                                                    • Apache Tomcat 7 as Application Server.(Download the zip , extract and Start and Stop Server)
                                                                    • Apache Maven – Build Tool (use 3.2.1 version) – Make relevant Changes to settings.xml                        
                                                                    • Jive6 Repository Access and License .
                                                                      Access will be set in  Settings.xml and License will be used during LocalSetup  .

                                                                     

                                                                    Installing Database Server and Creating Jive DB.

                                                                    • Extract the PgSQL zip to an <Install> like Directory. 
                                                                    • Open a Command Prompt and Change Directory to (<install>\pgsql) and Run commands as shown below to install PQSQL Server :-
                                                                    • <<Install>>pgsql>
                                                                    • <<Install>>\pgsql>bin\pg_ctl.exe start -D  <<Install>>\pgsql\data -l logfile.txt
                                                                    • server starting  (Find the logs regarding installation at  logfile.txt)
                                                                    • TO start the Server 
                                                                      <<Install>>
                                                                      \pgsql>bin\pg_ctl.exe start -D  data server starting
                                                                    • Browse  to   Pgsql folder>> bin>> Click on the Icon pgadmin3.exe to start
                                                                      PostGres Administrator
                                                                    • Create New Connection              
                                                                      Change username to postgres (Enter the password for the local instance (The package uses the password: passw0rd!))
                                                                    • Once Connection Successful close the Pgadmin tool
                                                                    • Restart the Pgadmin tool and Click on the Server Created.
                                                                    • Create two Databases on Postgres Server – JIVE_CORE and JIVE_EAE.

                                                                    Sample Screenshots

                                                                     

                                                                    Installing Maven and Building the Project

                                                                    Prerequisite: Ensure Java and JDK is available on machine.

                                                                    • Download the Appropriate version Maven zip from the maven site like http://maven.apache.org/download.cgi

                                                                      SET ENVIRONMENT VARIABLES

                                                                    • Change You Environment Variable to have the following values set
                                                                      JAVA_HOME = Point to the JDK Location.
                                                                      C:\Program Files\Java\jdk1.8.0\bin
                                                                      M2_HOME= (Path of the  Extract of Maven Zip);

                                                                    (D:\SOFTWARES_INSTALLED\apache-maven-3.2.2)

                                                                    Path =(Path of the  Extract of Maven Zip)/bin; 
                                                                    C:\Program Files\Java\jdk1.8.0\bin; D:\SOFTWARES_INSTALLED\apache-maven-3.2.2\bin)
                                                                    MAVEN_OPTS 
                                                                    should be Set Up with Appropriate value.

                                                                    Confirm, if Proper Version is installed and Set by using mvn --version.

                                                                    MAVEN  SETTINGS

                                                                    • Ensure Settings.xml have proper Username and password Set for accessing Maven Repository of Jive and Tomcat Home has been Configured.
                                                                      Also Ensure that , a dedicated directory is defined as a Local Repository  Path is configured and   Know that the dependency Jars will be downloaded here.

                                                                    • Open the Command Prompt and Change to Project Location Directory. Run the             Command.

                                                                                mvn –U jive:create-project
                                                                      Which Version of  Jive ? : 7.0.2.0

                                                                    What is your project's artifact id?: leapfrog

                                                                    Creates the directory for the Project

                                                                    What type of license will your instance use? (internal/external) internal:  external

                                                                    Build the Project

                                                                               cd leapfrog

                                                                               mvn clean install

                                                                    This would download all dependencies required to build the   application. Only runtime dependencies remain.

                                                                    Download the Source Jar Files by running the command

                                                                                mvn dependency:sources

                                                                     

                                                                     

                                                                    Import this Maven project to Eclipse and Add the Downloaded Source Jar to the Java Build Path.

                                                                     

                                                                    Add the details of application database created in jive_startup.xml
                                                                    present in the path(JIVE_CORE and JIVE_EAE )

                                                                    Enter the details of localhost:port, username , password, database name as created through postgres

                                                                    Configure Application Database Details  in JIVE_STARTUP.xml

                                                                    <database>

                                                                            <defaultProvider>

                                                                                <username>postgres</username>

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

                                                                                <maxConnections>25</maxConnections>

                                                                                <connectionTimeout>1.0</connectionTimeout>

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

                                                                                <password>passw0rd!</password>

                                                                                <minConnections>5</minConnections>

                                                                            </defaultProvider>

                                                                        </database>

                                                                    CONFIGURE EAE ACTIVITY  DATABASE in CORE.JSON

                                                                    Enter the details of activity database in the file core.json

                                                                    "template-jdbc-url" : "jdbc:postgresql://localhost:5432/eae-main",
                                                                    "jdbc-username" : "postgres",
                                                                    "jdbc-password" : "passw0rd!",

                                                                    Create devrunquick.bat in web  module

                                                                    mvn -DskipTests=true -Dcargo.wait=true -Djive.ws.disabled=true -P int cargo:start

                                                                    Create eae-start-nomaven.bat in web module

                                                                     

                                                                    java -Xmx768m -Xmx768m -Dhttp.proxyHost=gate.zrh.swissre.com -Dhttp.proxyPort=8080 -Dhttp.proxyUser= -Dhttp.proxyPassword= -jar %MAVEN_REPO%\eae\core\eae-service\1.3.2.0\eae-service-1.3.2.0.jar src/test/eae/config/

                                                                     

                                                                    Start the Engines (APPLICATION and ACTIVITY)  & FIRST RUN

                                                                     

                                                                    • Navigate  to the WEB folder created under the Project Directory(Leapfrog) .
                                                                    • Execute the command in eae-start file to bootstrap eae-instance.
                                                                    • Open a new Command Window and navigate to Web folder and execute cargo-start file to  Start the Application Server  

                                                                      Complete the Installation Setup.
                                                                    • Mark the <setup> as false in Jive_HOME Directory and Restart the App Server.
                                                                    • Browse to the link http://localhost:8080   and find the application live.   
                                                                    • Accept the default license.

                                                                     

                                                                    • Accept the default license settings.

                                                                     

                                                                    • Use the standard database connection.

                                                                     

                                                                    • Accept the default database settings and enter the DB password.

                                                                     

                                                                    • Test the connection and continue when successful.

                                                                     

                                                                    • Use the standard database connection of activity engine

                                                                     

                                                                    • Accept the default database settings and enter the DB password.

                                                                     

                                                                    • Test the connection and continue when successful.

                                                                     

                                                                    • Accept the default user settings.

                                                                     

                                                                    • Accept the default user profile name configuration.

                                                                     

                                                                    • Accept the default Username Case Sensitivity Configuration.

                                                                     

                                                                    • Accept the default Other settings.

                                                                     

                                                                    • Define an admin username and password

                                                                      Stop the server (ctrl-C on the console) and restart it