Kbase 16695: AS/400: Errors 2468, PRO9023 and PRO9024 with 8.1A+ Client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
IBM AS/400
SYMPTOM(s):
Errors when trying to connect to an AS/400 database.
Error: Unable to open the database file. (2468)
Error: PRO9023 There is a client/server file mismatch for <file>.
Error: PRO9024 There is a server schema/object mismatch for <file>.
CAUSE:
It means that the schema holder doesn't match the server schema, or the server schema doesn't match the object files on the AS/400.
If you have moved your library from one machine to another and you are using Progress version 8.1A client or greater there is a new parameter to verify logical files by using a CRC instead of the timestamp. The CRC is an integer that has been built by mathematically combining the logical file name, record format ID, and each key's name, type, size, and position. Previous versions of Progress used the time of file modification to know if the file has been changed. This time changes when you restore your library from a tape, because the logical file is rebuilt.
The parameter is -Dsrv LFLVLCHK=CRC. Used when connecting to the AS/400 database from the client, it will inform the DataServer to use the CRC rather than the timestamp.
Starting with Progress 400 DataServer, 8.0C, the CRC is calculated every time a file definition is processed, even when the new parameter -Dsrv LFLVLCHK=CRC is not specified and timestamp is used.
FIX:
Specify -Dsrv LFLVLCHK=CRC in the AS/400 connection parameters.