Salesforce

conv1011 fails 11158

« Go Back

Information

 
Titleconv1011 fails 11158
URL Nameconv1011-fails-11158-000060797
Article Number000172600
EnvironmentProduct: OpenEdge
Version: 11.0x, 11.1x, 11.2x, 11.3x, 11.4x, 11.5x, 11.6x,
OS: All supported platforms
Other: conv1011
Question/Problem Description
PROUTIL -C conv1011 fails with error 11158 prior to OpenEdge 11.6
In OpenEdge 116 and later PROUTIL -C conv1011 does not show error 1158 and appears to succeed, but IDXCHECK it will report errors with the index on _user
 
Steps to Reproduce
Clarifying Information
UPDATEVST run prior to conversion.
The correct codepage is used for conv1011.
The database uses non-ascii characters.
 
Error MessageVST Table Deletion has completed successfully. (6885)
Internal error in drSchemaV10KeyDelete, errno 5. (11158)
Internal error in drTblAndIdxUpd, errno 6. (11158)
Defect NumberDefect PSC00333480
Enhancement Number
Cause
CONV1011 failed during the conversion of the _User table where conversion is building and deleting the _Userid key for a user id containing a non-ascii character. The delete of the OpenEdge 10 key fails as the internal keysort produces an incorrect key. This incorrect key build resulted from the incorrect setup of the codepage.

The problem affects sorting keys for non-ascii chars when the specified -cpinternal does not match the database charset.
keySortCallback uses the collation table for the specified -cpinternal instead of the database collation.
 
Resolution
Upgrade to OpenEdge 11.7.3 or later before running conv1011. Where the sort function always uses that of the database collation.
Workaround
OPTION 1:  Delete the User table content prior to conv1011

Dump and Delete the User table content in the OpenEdge 10 environment prior to running CONV1011. After the database has been successfully converted to OpenEdge 11, load the _user.d content back through the Database Administration utility:

1. Dump the _user table through the Data Administration (_user.d)

2. Delete the _user table:
FOR EACH _user:
DELETE _user.
END.
Truncate the bi:
$   proutil dbname -C truncate bi -pf startup.pf

In the OpenEdge 11 environment run the conversion:
$   proutil dbname -C conv1011 -pf startup.pf

OPTION 2:  Dump and Load.

Instead of running conv1011, dump the database content in OpenEdge 10 and Load it in OpenEdge 11.
Notes
Keyword Phrase
Last Modified Date4/3/2019 8:46 AM

Powered by