Consultor Eletrônico



Kbase P12811: Schema change complete, restarting session. (1001)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   09/03/2009
Status: Verified

SYMPTOM(s):

Schema change complete, restarting session. (1001)

Changes have been made to the schema that require aborting execution and restarting.

Running 4GL code that:

1. Modifies the database schema in its first part and,
2. Compiles procedures that reference the same database.

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

CAUSE:

The error is caused because the schema changes cause the database schema to be different from the database schema cache file that was built at the client at the initial connection to the database.

FIX:

Use a batch file or a script file or 4GL to spawn two separate progress sessions where the 4GL code executed in the first session implements the schema changes, and the 4GL code executed in the second session compiles the procedures against the newly modified schema.