Kbase P182349: Error 1055 when connecting SQL client to database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/10/2011 |
|
Status: Unverified
SYMPTOM(s):
Cannot connect SQL client
Server's received count <n> does not equal client(<n>)'s send count <n>. (1055)
The number of servers setting is high enough fot the number of SQL users
Editing the conmgr.properties file manually for database configuration
Two server groups are entered in the conmgr.properties file
The second server group is SQL
Using dbman to start the database
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
Only one of the server groups (brokers) is actually starting due to a missing entry in the conmgr.properties file. The database log file will show only broker 0 starting and no broker 1.
Therefore, no clients can connect to the second server group (broker).
FIX:
In the [Progress installation directory]/properties/conmgr.properties file, make the following correction:
Incorrect file:
[configuration.mydb.defaultconfiguration]
afterimagebuffers=45
afterimageprocess=true
afterimagestall=true
asynchronouspagewriters=5
beforeimagebuffers=30
beforeimageprocess=true
blocksindatabasebuffers=3750
database=twl
directio=true
displayname=defaultConfiguration
hashtableentries=3751
locktableentries=100000
maxservers=10
maxusers=120
servergroups=mydb.defaultconfiguration.defaultservergroup <<<<<<<<<missing second server group here
spinlockretries=1
watchdogprocess=false
Correct file:
[configuration.mydb.defaultconfiguration]
afterimagebuffers=45
afterimageprocess=true
afterimagestall=true
asynchronouspagewriters=5
beforeimagebuffers=30
beforeimageprocess=true
blocksindatabasebuffers=3750
database=twl
directio=true
displayname=defaultConfiguration
hashtableentries=3751
locktableentries=100000
maxservers=10
maxusers=120
servergroups=mydb.defaultconfiguration.defaultservergroup, mydb.defaultconfiguration.secondaryservergroup
spinlockretries=1
watchdogprocess=false