"Broker rejects connection" - Forum - OpenEdge General - Progress Community

"Broker rejects connection"

 Forum

"Broker rejects connection"

This question is answered

Dear all,
we have this scenário:
1) DB Progress 10.2B runing over AIX server started with script and configured with secondary broker to allow SAL92 ODBC connection. It is in the last service pack
2) one Windows 2008 64bits virtual server where we configured the system DSN to connect to the database
3) the application is an ASP webpage running over IIS in the above server
Some times there no problem, some time we get the error: "Broker rejects connection" and "Database is already connected"
How can I debug this error?

Verified Answer
  • There can be a number of reasons for that error, but I'd start with reviewing the database log file. First thing is to write down the parameters that determine the number of remote servers per broker and then look at the log file to see if that number has not been exceeded for the secondary login broker.

    There is a KBase which contains detailed information on how to configure secondary login broker, with all of the parameters explained: -n -Mn -Mpb -Ma _ServerType etc.

    000021731 - How to set up a secondary login broker for SQL-92 connections for Progress 9.1D and above

    For the error "Database is already connected" you would have to debug your ASP code.

    ______________________________________________________
    There is a time to laugh and a time not to laugh, and this is not one of them.

All Replies
  • Anyone following this forum could give magsoa some hints or suggestion?

  • There can be a number of reasons for that error, but I'd start with reviewing the database log file. First thing is to write down the parameters that determine the number of remote servers per broker and then look at the log file to see if that number has not been exceeded for the secondary login broker.

    There is a KBase which contains detailed information on how to configure secondary login broker, with all of the parameters explained: -n -Mn -Mpb -Ma _ServerType etc.

    000021731 - How to set up a secondary login broker for SQL-92 connections for Progress 9.1D and above

    For the error "Database is already connected" you would have to debug your ASP code.

    ______________________________________________________
    There is a time to laugh and a time not to laugh, and this is not one of them.