Consultor Eletrônico



Kbase P126159: Error 4043 using Query Results
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/6/2009
Status: Unverified

SYMPTOM(s):

Error 4043 in several operations.

DITEM is not large enough to hold string. (4043)

Very large schemas with one or multiple databases

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x
Windows

CAUSE:

Due to the large schema, some operations may fail because a char variable used to store schema information could not hold the desired value.

FIX:

The schema information, table relations, and other information are stored in a file with the logical name of the first connected database and extension .qc7. This file is a text file, and can be edited to take out relationships and tables, allowing a custom view of the database with fewer tables, and even easier to the final user. This technique could be used also to split the qc7 in several files having each of them with a subset more appropriated to a business need. However, in order to that, logical database name of the first database must be changed previous to run Results, to allow a custom version to be loaded. More information on customization can be found in the solution P117913 , "What are the QUERY/RESULTS generated files?"