Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2004
    Posts
    7

    Unanswered: Progress client disconnected

    Usually around the same time every afternoon, 1 or 2 of our users get disconnected from Progress/Symix without any error messages or warning. Progress/Symix just locks up and they have to reboot. Not always, but sometimes I have to stop then start Procontrol for them to be able to get back into Symix.
    This seems to only happen to Windows ME clients.

    Any suggestions would be appreciated.

  2. #2
    Join Date
    Nov 2003
    Location
    Lomza, POLAND
    Posts
    81
    Hi
    Perhaps it is not your issue but check out if your db startup parameters:
    -n
    -Mn
    -Ma
    -Mi

    match. They are meaningful for a remote client (visible in PROMON as REMC and using TCP layer), not for SELF-SERVICE type. The following rule must be fulfilled:

    -n > -Mn * -Ma

    -Ma means the max number of the connections served by a single _mprosrv process. -Mn limits the max number of _mprosrv processes which can be started by a dabatase broker. -n limits the max number of the concurrent connections with a database, including all processes, not only remote clients.

    By the way: Progress Explorer Tool seems to be more comfortable and up-to-date, than Procontrol. Have you tried it?

    Regards
    Bogdan Brzozowski

  3. #3
    Join Date
    Nov 2004
    Posts
    7

    Startup parameter setting

    My settings are as follows (per the symix.log file)
    -n 21
    -Mn 5
    -Ma 5
    -Mi 1

    We have approx 15 users, and these users can also connect via odbc to produce reports in Microsoft Access.

    I am not sure if these settings are correct. Also, where are these settings located?

    I haven't used the Progress Explorer Tool yet, but I may try it in the future.

    Any help/suggestions would be greatly appreciated.

    Thanks,
    Craig
    Last edited by cdoss; 11-18-04 at 08:52.

  4. #4
    Join Date
    Nov 2003
    Location
    Lomza, POLAND
    Posts
    81
    So it may cause your problem. Your current parameters do not fit each with other, because -n < -Mn * -Ma, so it is possible source of the problem (however the problem can be different).
    You are using ODBC driver which connents your application with Progress SQL-92 compliant db engine. If your exact Progress version is earlier than 9.1D06 (or 91.D05? - I don't remember accurate enough) rhe only possible set of db startup parameters is the following:
    -n 21
    -Mn 15
    -Ma 1
    -Mi 1
    as SQL-92 engine in this version does not support multi-threated server processes. Starting from version 9.1D06 (the latest service pack for Progress 9.1D is 9.1D09) you can configure your database server in the following way:
    -n 21
    -Mn 2
    -Ma 8
    -Mi 3
    if your db server machine has a fast processor and enough memory. In this way you can limit the max number of remote connestions to 2 * 8 = 16. When the less number of the server processes (in this case maximum 2) services remote clients they can connect to a database faster (there is no need to start then new process for each connection as in the first example). Less database processes, less competition for server resources.

    If your machine is weaker you can apply another set of parameters:
    -n 21
    -Mn 3
    -Ma 5
    -Mi 2

    Hope it helps
    Regards
    Bogdan Brzozowski

  5. #5
    Join Date
    Nov 2004
    Posts
    7
    We are using version 9.1B on a Dell server with dual 500Mhz processors and 512MB ram.
    Are the -n, -Mn, etc settings located in the symix.pf file?

    Thanks for your help.

  6. #6
    Join Date
    Nov 2003
    Location
    Lomza, POLAND
    Posts
    81
    Sorry, I haven't put parameter values for Progress version earlier than 9.1D06. Here they are:
    -n 21
    -Mn 15
    -Ma 1 # SQL-92 server process is single-threated
    -Mi 1
    They should be placed in your *.pf file which is the parameter for proserve command (this command starts up a database).
    Regards
    Bogdan Brzozowski

  7. #7
    Join Date
    Nov 2004
    Posts
    7
    I will try those settings and let you know.

    Thanks again for your help.
    Last edited by cdoss; 11-18-04 at 11:33.

  8. #8
    Join Date
    Nov 2004
    Posts
    7
    Just to make sure I have this correct. Let's say I have 15 users, and each of those users also connect to 2 odbc databases. Would the -n equal 45 (( 2 database instances and one progress instance each) * 15 users)?
    Then would -Mn equal 45 since -Ma equals 1?

  9. #9
    Join Date
    Nov 2003
    Location
    Lomza, POLAND
    Posts
    81
    Hi Craig,
    The parameters we discussed refer to a single Progress database. I think you should apply the same set of these parameters to each of your databases.
    You start your databases in the following way:

    proserve -pf symix1.pf
    proserve -pf symix2.pf

    where symix1.pf contains:
    -db <pathToDB1>
    ...
    -n 21
    -Mn 15
    -Ma 1
    -Mi 1

    The file symix2.pf has the same content except -db parameter which points on the second database (let's say <pathToDB2> for example). That's the first solution. Another possibility is to have a single symix.pf file (for both of your databases) with the following contents (without -db parameter):
    ...
    -n 21
    -Mn 15
    -Ma 1
    -Mi 1

    and start your 2 database in a different way:

    proserve -db <pathToDB1> -pf symix.pf
    proserve -db <pathToDB2> -pf symix.pf

    If you have any doubts, let me know (I know that my English is not excellent .

    Regards
    Bogdan Brzozowski

  10. #10
    Join Date
    Nov 2004
    Posts
    7
    I am only using one database, and the users can connect to this same database via odbc to run reports in Microsoft Access.
    If that makes sense.
    That's why I thought maybe -n would equal 45.
    Thanks a lot for your time on this.
    Craig

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •