Issue 32004  —   MSS via TCP: Error 8035 is thrown when fixed part entity exceeds 8000 bytes

Status:   Planned for resolution in 10.4.01

Solution available in patch(es):      10.3.02.020    9.7.05.033

Description:

 Summary:
 Uniface:
 The limitation for the Microsoft SQL Server DBMS connector (MSS) for fixed part
 entity has changed from 8K to 20Mb since bug fix 30797:
 Topic in the Uniface library:
 DBMS Support > Database Connectors > DBMS Connector Overview > DBMS Connector
 Limits

 However when accessing SQL Server via the network connector still error 8035 is
 reported by the server:
 Server: Loaded 'umss52' from D:\uniface\installations\97\common\bin\umss52.dll,
 version: 9.7.05  028
 Fatal error: 8035 - Fixed part of table exceeds DBMS limit. Drv=TCP,
 Tbl=BIGTABLE, Siz=8200, Max=8000
 Retrieving direct using the Microsoft SQL Server DBMS connector (MSS) works fine

 Environment:
 + Uniface Version  : 9 / 10
 + Operating System : OS independent
 + Database         : Microsoft SQL Server via the network connector

 Reproduction scenario
 1. Setup Uniface client server for MSS:
    In client asn
    $TCP TCP:{server}+{port}|{serveruser}|{serveruserpwd}|{ust}
    $MSS $TCP
    In server asn used by ust {ust}
    $MSS MSS:{dsn}:{database}|{dbuser}|{dbuserpwd}
 2. Retrieve data for an entity with a fixed part exceeding 8K but below 20 Mb

 Expected Result
  Retrieve succeeds

 Actual Result
  Server: Loaded 'umss52' from
 D:\uniface\installations\97\common\bin\umss52.dll, version: 9.7.05  028
  Fatal error: 8035 - Fixed part of table exceeds DBMS limit. Drv=TCP,
 Tbl=BIGTABLE, Siz=8200, Max=8000

Workaround:

 There is no known workaround for this problem.

Notes: