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 Reply Children
  • 0
    Certified Lead Developer
    in reply to sonamg

    Hi sonamg

    1. We should stop the respective engine(s), when transferring the kdbs.
    2. The possible cause for the above problem is , the kdbs might have corrupted.(Earlier the engines were didn't shutdown properly)
    3. When we got the issue like this, we can resolve by either of the following.
      • Rename the latest working kdb to next number appended in the series.(So the engine(s) will start pointing new one)
      • repair the kdb by running the repair script.(If you are in production environment it not recommend to do. Please raise a support case) Please go through this link for instructions . https://docs.appian.com/suite/help/17.2/Appian_Engine_Repair.html 
  • how do we repair the KDB files can u please help and I followed the first step is it renaming the last working KDB according to new folder KDBS or old folder KDBS.
  • 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.