Kbase P32646: Error 1150 connecting to database with a Report Builder client where -Mm is defined
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/16/2009 |
|
Status: Verified
SYMPTOM(s):
Error connecting to database with a Report Builder Client
Server has -Mm parm <size> and client has <size>. They must match. (1150)
Server has -Mm parm 4096 and client has 1024. They must match. (1150)
EngineParameters= -Mm 4096 line is included in the [ReportBuilderDefaults] section of the (progress.ini) file.
FACT(s) (Environment):
Report Builder
Progress 9.x
Client Server connection using -H -S
non-default -Mm in use
All Supported Operating Systems
CAUSE:
Message Buffer Size (-Mm) is a session parameter. This means that whenever the CONNECT statement is run, the client session that is started must specify the same -Mm as was used for the database to connect to that database.
FOR EXAMPLE:
proserve sports -Mm 4096 -S 4444 -H localhost -N TCP
prowin32 -Mm 4096 # to start a client session
CONNECT -db sports -S 4444 -H localhost -N TCP
will connect to the database
or, any connections through the Connection Screen for (say) DBADMIN will connect.
BUT, another client session:
prowin32 # note without the -Mm specified
CONNECT -db sports -S 4444 -H localhost -N TCP
Will not connect to the database because the default -Mm for the client session 1024 has been used on initiation of this session.
Even if -Mm is specified in the CONNECT statement:
CONNECT -db sports -S 4444 -H localhost -N TCP -Mm 4096.
it will be ignored. This is a client session parameter, not a connection parameter.
Unfortunately, in the case of Report Builder, the (1150) error message will still return because it is not set on the prorb32.exe
For example:
prorb32.exe -Mm 4096
Database Connections -> sports2000 -> -S 4444 -H localhost -N TCP
will still return error 1150, even if -Mm is specified in the Other Startup Paramaters which is not where it should be specified anyway, because it is a Session parameter. As Report Builder is a retired product, this will not be addressed in future.
FIX:
Fully connect to the database through the cmd line utilities for report builder connections.
For example:
proserve sports -S 4444 -Mm 4096
prorb32.exe sports -S 4444 -H localhost -N TCP -Mm 4096