Hi, I have the message below starting the engines. Collabo

Hi,

I have the message below starting the engines.

Collaboration Statistics 1/1 FATAL! No gateway is active.
Inconsistent DBID on GW1
Server Database ID: 3673, Gateway Database ID: 0N

Process-Analytics0000 1/1 FATAL! No gateway is active.
Inconsistent DBID on GW1
Server Database ID: 378, Gateway Database ID: 0N

Process-Exec00 1/1 FATAL! No gateway is active.
Inconsistent DBID on GW1
Server Database ID: 3293, Gateway Database ID: 0N

What can I do?

Thanks.

OriginalPostID-215548

OriginalPostID-215548

  Discussion posts and replies are publicly visible

Parents
  • Thank you.

    I solved the problem by performing the steps below.
    1 - Stop the JBoss
    2 - Stop the Appian search service
    3 - Stop the Appian service windows
    4 - run the stop-suite.bat
    5 - copy the last good .kdb file and renamed to the latest file name+1 in folder (eg pe111.kdb to pe112.kdb). I made for all engines with problem.
    6 - start the Apppian service windows.
    7 - ran the checkengine.bat to confirm that all engines were ok and active.
    8 - start the Appian search service
    9 - start JBoss.
  • this didn't work for me can u please suggest the solution.

    whenever I transfer KDB files all the engines stop working .
  • 0
    Certified Lead Developer
    in reply to sonamg

    Old folder kdbs.

    If all the engines are showing the FATAL status, that due to some other reason i.e., Some went wrong.(Start doing from the beginning with fresh installation)

    If you are upgrading the your Appian, make sure you are following update guide and also you are using the same primary data source.

    Suppose for example if you want to repair the  process execution engine kdbs, Please fine the below steps(Assume my Appian is in C:/ drive.)

    1. Navigate to location where repair scripts available.
      • cd C:\appian\server\_scripts\tools
    2. Repair the kdb file which is corrupted.(not working) .
      • repair C:\appian\server\process\exec\02\gw1\pe44.kdb
    3. Navigate to the engine kdbs location.
      • cd C:\appian\server\process\exec\02\gw1\
    4. Create new kdb file with the repaired kdb file.The new kdb file should be the highest number kdb file.(So the engine will start pointing the new kdb file)
      • copy pe44.kdb.repaired pe55.kdb
  • I tried in one gateway out of 12 and its not working still all gateways are showing fatal error.
  • 0
    Certified Lead Developer
    in reply to sonamg
    Some went wrong with while updating....Can you please start the update process again?? or You can raise support ticket, probably they will help you on this.
  • It was working before transferring the old KDB files .
  • 0
    Certified Lead Developer
    in reply to sonamg
    Are you using the same primary data source?
  • yes

    description -

     


      1      N/A            Unable to communicate with the server

     

                             Gateway Details (Process-Design):

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5016   Unable to contact server:parse

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     


            ---     ---     ---     ---     ---     ---     ---     ---

     ## Process-Analytics0000 ##   (2017-06-06 05:12:38 GMT)   ## Process-Analytics0
    000 ##


                             Application Issues (Process-Analytics0000)
      No issues detected.


                             Gateway Issues (Process-Analytics0000)

     _GW_   _Severity_      _Details_

      1      N/A            No issues detected.

     

                             Gateway Details (Process-Analytics0000):

     Gateway Chain(s):


       GW 1 (STANDALONE)

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5018   0.007   0       1      18 mins         2 MB

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     


            ---     ---     ---     ---     ---     ---     ---     ---

     ## Process-Analytics0001 ##   (2017-06-06 05:12:38 GMT)   ## Process-Analytics0
    001 ##


                             Application Issues (Process-Analytics0001)
      No issues detected.


                             Gateway Issues (Process-Analytics0001)

     _GW_   _Severity_      _Details_

      1      N/A            No issues detected.

     

                             Gateway Details (Process-Analytics0001):

     Gateway Chain(s):


       GW 1 (STANDALONE)

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5020   0.003   0       1      18 mins         2 MB

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     


            ---     ---     ---     ---     ---     ---     ---     ---

     ## Process-Analytics0002 ##   (2017-06-06 05:12:38 GMT)   ## Process-Analytics0
    002 ##


                             Application Issues (Process-Analytics0002)
      No issues detected.


                             Gateway Issues (Process-Analytics0002)

     _GW_   _Severity_      _Details_

      1      N/A            No issues detected.

     

                             Gateway Details (Process-Analytics0002):

     Gateway Chain(s):


       GW 1 (STANDALONE)

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5022   0.003   0       1      18 mins         2 MB

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     


            ---     ---     ---     ---     ---     ---     ---     ---

     ## Process-Exec00 ##   (2017-06-06 05:12:38 GMT)   ## Process-Exec00 ##


                             Application Issues (Process-Exec00)

      _Severity_    _Details_

       FATAL!        No gateway is active.


                             Gateway Issues (Process-Exec00)

     _GW_   _Severity_      _Details_

      1      N/A            Unable to communicate with the server

     

                             Gateway Details (Process-Exec00):

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5024   Unable to contact server:parse

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     


            ---     ---     ---     ---     ---     ---     ---     ---

     ## Process-Exec01 ##   (2017-06-06 05:12:38 GMT)   ## Process-Exec01 ##


                             Application Issues (Process-Exec01)

      _Severity_    _Details_

       FATAL!        No gateway is active.


                             Gateway Issues (Process-Exec01)

     _GW_   _Severity_      _Details_

      1      N/A            Unable to communicate with the server

     

                             Gateway Details (Process-Exec01):

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5026   Unable to contact server:parse

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     


            ---     ---     ---     ---     ---     ---     ---     ---

     ## Process-Exec02 ##   (2017-06-06 05:12:38 GMT)   ## Process-Exec02 ##


                             Application Issues (Process-Exec02)

      _Severity_    _Details_

       FATAL!        No gateway is active.


                             Gateway Issues (Process-Exec02)

     _GW_   _Severity_      _Details_

      1      N/A            Unable to communicate with the server

     

                             Gateway Details (Process-Exec02):

     _GW_  _Host_            _Port_ _Resp_  _Trans_ _Conn_  _Online_        _Size_
      1   localhost           5028   Unable to contact server:parse

     Legend:
      Resp    - The response time of the gateway (seconds).
      Trans   - The number of transactions in the log.
      Conn    - The total number of read/write connections.
      Online  - The amount of time which the server has been online.
      Size    - The current size of the database.

     

            ---     ---     ---     ---     ---     ---     ---     ---

     

       S U M M A R Y    (2017-06-06 05:12:38.958 GMT)    S U M M A R Y

     _APP_                          _ACTIVE_GW_    _STATUS_  _ISSUES_
     Discussion Forums               0/1          * FATAL!  No gateway is active.

     Notifications Service           0/1          * FATAL!  No gateway is active.

     Notifications Email Processor   0/1          * FATAL!  No gateway is active.

     Channels                        0/1          * FATAL!  No gateway is active.

     Collaboration                   0/1          * FATAL!  No gateway is active.

     Collaboration Statistics        0/1          * FATAL!  No gateway is active.

     Personalization                 0/1          * FATAL!  No gateway is active.

     Portal                          0/1          * FATAL!  No gateway is active.

     Process-Design                  0/1          * FATAL!  No gateway is active.

     Process-Analytics0000           1/1            Okay

     Process-Analytics0001           1/1            Okay

     Process-Analytics0002           1/1            Okay

     Process-Exec00                  0/1          * FATAL!  No gateway is active.

     Process-Exec01                  0/1          * FATAL!  No gateway is active.

     Process-Exec02                  0/1          * FATAL!  No gateway is active.


        * : Not all instances defined in the gateway XML are currently active.

     

                      *  *  * ALERT *  *  *

      The following 12 applications require *IMMEDIATE* attention:

            Discussion Forums
            Notifications Service
            Notifications Email Processor
            Channels
            Collaboration
            Collaboration Statistics
            Personalization
            Portal
            Process-Design
            Process-Exec00
            Process-Exec01
            Process-Exec02

                      *  *  * ALERT *  *  *

  • 0
    Certified Lead Developer
    in reply to sonamg
    Seems... your kdbs are not corrupted...Please wait for some time and run the check engine script...
    And also please verify all the transferred kdbs are with highest numbered.
    With this we can't get the exact issue.
    Can you please tell the steps you followed.?we will try to get something.
  • I have transferred only last working KDB file in all engines with +1 name . Do I need to transfer all KDB files or only last good one ?
  • 0
    Certified Lead Developer
    in reply to sonamg

    if the old instance of Appian is working fine, last one is good...Please verify below steps once..

    1. Stop all engines for the currently running Appian suite.
    2. Navigate to old instance(which you were using before update)
    3. Start the engines and verify all engines are in OKAY status.

    If any problem here, there is an issue with your old kdbs . we need fix it by following the steps I mentioned in my previous comments.

Reply
  • 0
    Certified Lead Developer
    in reply to sonamg

    if the old instance of Appian is working fine, last one is good...Please verify below steps once..

    1. Stop all engines for the currently running Appian suite.
    2. Navigate to old instance(which you were using before update)
    3. Start the engines and verify all engines are in OKAY status.

    If any problem here, there is an issue with your old kdbs . we need fix it by following the steps I mentioned in my previous comments.

Children
  • The old instance of appian was not properly shutdown and we got log4j error that's y we have reinstalled the fresh appian server and after transferring the old KDBS files we are getting this error in new installation.
  • 0
    Certified Lead Developer
    in reply to sonamg

    sonamg

    What do you are planning to do now? Fresh installation or Updation.

    If fresh installation, Do it by following installation guide.

    If Updation, follow below steps.

    1. Switch back to old instance.
      • Stop Application server, search server and engines (Verify all processes are stopped by executing ps -ef , kill if any not stopped)
      • rename it to different name or delete the 'Appian' folder.
      • Rename your old instance to 'Appian'
    2. Start Appian engines (now you are running old instance)
      • Make sure all engines are started with 'Okay' status(If any FATAL error follow steps I have mentioned earlier)
      • Run check point script and followed by clean up script
    3. Start Search server
    4. Start Application server, make sure suite.ear is successfully deployed and you are able to login
    5. Stop the suite(Stop Application server, Search server and engines and Verify all processes are stopped)
    6. Now either do the fresh installation of your required version
    7. If you are updating follow the update guide.
  • ramanjaneyulut

    We did fresh installation by following the installation guide. The "suite.ear" also had deployed successfully. Everything's fine. It's only after transferring the KDB files, 12 out of 15 gateways are inactive.

    We tried to repair and rename the KDB files. There was no change.

    What can we do now ?
  • 0
    Certified Lead Developer
    in reply to sonamg

    We have to do either repair or rename only.

    The problem is with your old instance. First you need fix that issue, then only you can do the update.So before going for fresh installation first fix the issue with old kdb files either by following my instruction in earlier comment or by raising support ticket.

    I would suggest you contact Appian support, so you could get better help. Below are the contact details.

    Email: support@appian.com

    Call:

    United States: +1 703 442 1066          

    United Kingdom: +44 20 3695 0246

    France: +33 184 886 650    

    Australia: +61 285 203 042

  • ramanjaneyulut,

    I'd raised the ticket and mailed the support team.

    We have checked in the task manager for engines which are inactive. It is showing the below error(screenshot attached):

     

  • @sonamg - Can you please check the kdb files available in all the folders in new Appian installation. Ideally there should be only one kdb file after upgrade steps are finished. For e.g. If old Appian kdb number is 15 then there must not be a kdb in new installation with version number 1. We had faced this kind of issue previously. We reinstalled Appian and upgraded before starting Appian engines. Hope this helps.
  • we have 3 KDBs files in each folder after installing the server again and starting the checkengine but we want to transfer old kdb files from previous version for recovering the data. After transferring old KDB files Engines stop working.
  • 0
    A Score Level 2
    in reply to sonamg
    Have you performed following steps -
    1) Install fresh Appian and do not start Appian engines yet
    2) Copy the latest kdb from each folder as mentioned in Migration procedure.
    3) Now start Appian engines and see if it is working.

    Another diagnostic if above does not work.
    1) See the latest version number of kdbs in folder in old installation
    2) Perform checkpoint on old Appian version and now see if version number is increased. If not increased then there is issue with your old server.