11.6.3 / Windows 10/x64
I suddenly get this Message when trying to Connect my local Developer database from eclipse. It is enoying me, because I have not done any changes to the configuration (as far as I know). I have tried to delete the config for the database, and added it like a default db, but still same problem.
-Ma 5
-Mi 1
-Mn 4
-n 21
anyone seen this before?
Part of the LOGFILE:
2017/04/06@15:56:21.897+0200] P-14432 T-3360 I BROKER 0: (17562) Number of Alternate Database Buffers (-B2): 0
[2017/04/06@15:56:21.897+0200] P-14432 T-3360 I BROKER 0: (9422) Maximum private buffers per user (-Bpmax): 64
[2017/04/06@15:56:21.897+0200] P-14432 T-3360 I BROKER 0: (14016) Database block consistency check (-DbCheck): Not Enabled
[2017/04/06@15:56:21.898+0200] P-14432 T-3360 I BROKER 0: (13869) Database Service Manager - Service(s) to start (-DBService): Not Enabled
[2017/04/06@15:56:21.898+0200] P-14432 T-3360 I BROKER 0: (10535) Enhanced Read-Only mode (-ERO): Not Enabled
[2017/04/06@15:56:21.899+0200] P-14432 T-3360 I BROKER 0: (4237) Force Access (-F): Not Enabled
[2017/04/06@15:56:21.899+0200] P-14432 T-3360 I BROKER 0: (4249) Before-Image Truncate Interval (-G): 0
[2017/04/06@15:56:21.899+0200] P-14432 T-3360 I BROKER 0: (4261) Host Name (-H): THIncMobil04
[2017/04/06@15:56:21.900+0200] P-14432 T-3360 I BROKER 0: (14018) Index block consistency check (-IndexCheck): Not Enabled
[2017/04/06@15:56:21.900+0200] P-14432 T-3360 I BROKER 0: (4241) Current Size of Lock Table (-L): 8192
[2017/04/06@15:56:21.901+0200] P-14432 T-3360 I BROKER 0: (16688) Lock Governor (-LGovernor): 0%
[2017/04/06@15:56:21.901+0200] P-14432 T-3360 I BROKER 0: (4257) Maximum Number of Clients Per Server (-Ma): 5
[2017/04/06@15:56:21.902+0200] P-14432 T-3360 I BROKER 0: (14016) Memory overwrite check (-MemCheck): Not Enabled
[2017/04/06@15:56:21.902+0200] P-14432 T-3360 I BROKER 0: (4245) Delay of Before-Image Flush (-Mf): 3
[2017/04/06@15:56:21.902+0200] P-14432 T-3360 I BROKER 0: (4259) Minimum Clients Per Server (-Mi): 1
[2017/04/06@15:56:21.903+0200] P-14432 T-3360 I BROKER 0: (12818) Message Buffer Size (-Mm): 1024
[2017/04/06@15:56:21.903+0200] P-14432 T-3360 I BROKER 0: (4258) Maximum Number of Servers (-Mn): 5
[2017/04/06@15:56:21.904+0200] P-14432 T-3360 I BROKER 0: (12819) Servers per Protocol (-Mp): 0
[2017/04/06@15:56:21.904+0200] P-14432 T-3360 I BROKER 0: (5647) Maximum Servers Per Broker (-Mpb): 4
[2017/04/06@15:56:21.904+0200] P-14432 T-3360 I BROKER 0: (4240) Excess Shared Memory Size (-Mxs): 23
[2017/04/06@15:56:21.905+0200] P-14432 T-3360 I BROKER 0: (4263) Network Type (-N): TCP
[2017/04/06@15:56:21.905+0200] P-14432 T-3360 I BROKER 0: (16954) Server network message wait time (-Nmsgwait): 2
[2017/04/06@15:56:21.906+0200] P-14432 T-3360 I BROKER 0: (10357) Pending client connection timeout (-PendConnTimeout): 0
[2017/04/06@15:56:21.906+0200] P-14432 T-3360 I BROKER 0: (4262) Service Name (-S): 4001
[2017/04/06@15:56:21.907+0200] P-14432 T-3360 I BROKER 0: (17804) Broker server group support (-ServerType): BOTH
[2017/04/06@15:56:21.907+0200] P-14432 T-3360 I BROKER 0: (10028) SQL Server Max Open Cursors (-SQLCursors): 0
[2017/04/06@15:56:21.908+0200] P-14432 T-3360 I BROKER 0: (10026) SQL Server Stack Size (-SQLStack): 0
[2017/04/06@15:56:21.908+0200] P-14432 T-3360 I BROKER 0: (10027) SQL Server Statement Cache Size (-SQLStmtCache): 0
[2017/04/06@15:56:21.909+0200] P-14432 T-3360 I BROKER 0: (10029) Size [1K byte units] of SQL Server temp table buffer (-SQLTempStoreBuff): 0
[2017/04/06@15:56:21.909+0200] P-14432 T-3360 I BROKER 0: (10030) Size [1K byte units] of SQL Server temp table disk storage (-SQLTempStoreDisk): 0
[2017/04/06@15:56:21.909+0200] P-14432 T-3360 I BROKER 0: (10031) Size [1K byte units] of SQL Server temp table data page (-SQLTempStorePageSize): 0
[2017/04/06@15:56:21.910+0200] P-14432 T-3360 I BROKER 0: (17955) Authorized data truncation (-SQLTruncateTooLarge): OFF
[2017/04/06@15:56:21.910+0200] P-14432 T-3360 I BROKER 0: (18156) SQL Autonomous Schema Update (-SQLWidthUpdate): OFF
[2017/04/06@15:56:21.911+0200] P-14432 T-3360 I BROKER 0: (14019) Record block consistency check (-TableCheck): Not Enabled
[2017/04/06@15:56:21.911+0200] P-14432 T-3360 I BROKER 0: (17717) TXE Lock retry limit (-TXERetryLimit): 0
[2017/04/06@15:56:21.912+0200] P-14432 T-3360 I BROKER 0: (10836) Database connections are not allowed at this time.
[2017/04/06@15:56:21.912+0200] P-14432 T-3360 I BROKER 0: (10471) Database connections have been enabled.
[2017/04/06@15:56:24.416+0200] P-6572 T-5896 I BIW 5: (-----) Login by SYSTEM.
:
[2017/04/06@16:59:25.897+0200] P-6344 T-13032 I SRV 1: (7129) Usr 24 set name to goo.
[2017/04/06@16:59:52.540+0200] P-14432 T-3360 I BROKER 0: (8839) No SQL servers are available. Try again later.
Your log states:
Broker server group support (-ServerType): BOTH
this means that any server spawned can be either 4GL or SQL. If you configure one servergroup to be 4GL only (with say a maximum of 4 servers) and another servergroup for SQL only (with f.e. 2 servers) than you always have 4GL AND SQL servers available. If you don't split these you run the risk that all servers are 4GL and there are no servers that can handle SQL. Now, you can do two things:
- define two server groups under one broker
- define two brokers with each 1 server group. One broker for 4GL connections and 1 for SQL.
In the latter case you can fine tune better (since a lot of settings are set at the broker level).
Which OE version are we talking about and do you use adminserver w/ the OE Explorer webinterface?
If I stop the server from Management console, and restart it in commandline (proserve norcalc -H localhost -S 4001
It seems to work from eclipse....
//Geir Otto
Hi goo,
[2017/04/06@16:59:52.540+0200] P-14432 T-3360 I BROKER 0: (8839) No SQL servers are available. Try again later.
Are you start db from OE explorer/Management?
Whats value set for minport/maxport parametrs ?
Is the firewall used?
Check in promon the Status: Servers screen:
R&D -> 1. Status Displays -> 3. Servers
What will this screen shown?
Do you have separate servergroups defined for 4GL and SQL? If not, all available servers may be 4GL ones (a server can either be 4GL or SQL, not both). With the max server all 4GL there's no server for SQL.
+1
Yes
default (3000 and 5000)
no firewall
PROMON:
# Type Port
0 Login 4001
1 Inactive 0
:
4 Inactive 0
With server started from commandline:
0 Login 4001
1 Auto 4002
:
4 Auto 4004
Bronco, I have not added servergroups, but could you explain what I should look for, if I have done a mistake With setup. I have just used the default setup, and it has been working, but suddenly it stopped... so there has to be a change somewhere.
Your log states:
Broker server group support (-ServerType): BOTH
this means that any server spawned can be either 4GL or SQL. If you configure one servergroup to be 4GL only (with say a maximum of 4 servers) and another servergroup for SQL only (with f.e. 2 servers) than you always have 4GL AND SQL servers available. If you don't split these you run the risk that all servers are 4GL and there are no servers that can handle SQL. Now, you can do two things:
- define two server groups under one broker
- define two brokers with each 1 server group. One broker for 4GL connections and 1 for SQL.
In the latter case you can fine tune better (since a lot of settings are set at the broker level).
Which OE version are we talking about and do you use adminserver w/ the OE Explorer webinterface?
aaah, suddenly I learned something new :-) of course that was why it was possible to add servergroups. I did not know, but now I know :-) it worked, and I agree, it is much better to have another broker serving SQL. Thanks
One is never too old to learn :-)
Maybe you can set the question to answered.