Kbase P122885: Loading incremental.df via prodict\load_df.p to foreign database fails
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/7/2011 |
|
Status: Verified
SYMPTOM(s):
Loading incremental.df via prodict\load_df.p to foreign database fails
if ALIAS DICTDB FOR DATABASE is the Schema Holder database it fails error 916
But connection to type PROGRESS was requested. (916)
if ALIAS DICTDB FOR DATABASE is the foreign database it fails error 869
Table-type mismatch. Current database-type is PROGRESS
prodict/load_df.p Database <dbname> has type MSS (869)
FACT(s) (Environment):
do not want to connect to the foreign database with -dt
Data Admin tool applies incremental.df to foreign database without problems
All Supported Operating Systems
Progress/OpenEdge Product Family
DataServers
CAUSE:
The reason there is no issue through the Admin Tool is the ability to select the foreign database as the current database before applying the incremental.df. There is no means to alter this in the custom 4GL calling the prodict/load_df.p, as the ALIAS DICTDB can only be created for a Progress database.
FIX:
1.) Ensure that the custom 4GL code to load the .df is calling the Progress Schema Database with the alias (not the foreign database).
Example:
CREATE ALIAS DICTDB FOR DATABASE sports NO-ERROR.
DISPLAY LDBNAME("DICTDB").
RUN prodict/load_df.p ("incrmental.df").
DELETE ALIAS DICTDB.
2.) Edit the incremental.df file by adding an UPDATE DATABASE "foreign_name" TYPE <-dt type> before the schema update ADD, DROP etc detail.
Example:
UPDATE DATABASE "my_sql" TYPE MSS
DBNAME "MY_SQL"
DB-MISC11 1
DRIVER-NAME "SQLSRV32.DLL"
DRIVER-VERS "03.86.1830"
ESCAPE-CHAR " """
DRIVER-CHARS "3,13,14,17,20,23,33,35,36,"
DBMS-VERSION "Microsoft SQL Server 08.00.0760"
DSRVR-VERSION "03.52.0000"
PROGRESS-VERSION "Dictionary Ver#: 1.000.000 Client Ver#: 101.01,(sh_min=1,sh_max=2); Server Ver# 101.01"
DSRVR-MISC "Microsoft SQL Server"
CODEPAGE-NAME "iso8859-1"
ADD TABLE "table_name" TYPE MSS
AREA "Schema Area"
.. etc