Kbase P53556: Can not log in to the database with SQL-92.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Can not log in to the database with SQL-92.
ODBC connection gives the following error on the client:
-22109
SQL-92 explorer gives the following error on the client:
Unhandled Exception has occured
No error in database log file
CAUSE:
The following views and system meta tables are missing:
_Repl-Agent
_Repl-AgentControl
_Repl-Server
_Sysattachtbls
_Sysbigintstat
_Syscalctable
_Syscharstat
_Syschkcolusage
_Syschkconstrs
_Syscolauth
_Syscolstat
_Sysdatatypes
_Sysdatestat
_Sysdbauth
_Sysdblinks
_Sysfloatstat
_Sysidxstat
_Sysintstat
_Syskeycolusage
_Sysncharstat
_Sysnumstat
_Sysnvarcharstat
_Sysprocbin
_Sysproccolumns
_Sysprocedures
_Sysproctext
_Sysrealstat
_Sysrefconstrs
_Syssmintstat
_Syssynonyms
_Systabauth
_Systblconstrs
_Systblstat
_Systimestat
_Systinyintstat
_Systrigcols
_Systrigger
_Systsstat
_Sysvarcharstat
SYSBIGINTSTAT
SYSCALCTABLE
SYSCHARSTAT
SYSCOLAUTH
SYSCOLSTAT
SYSCOLUMNS_FULL
SYSDATATYPES
SYSDATESTAT
SYSDBAUTH
SYSDBLINKS
SYSFLOATSTAT
SYSIDXSTAT
SYSINDEXES
SYSINTSTAT
SYSNCHARSTAT
SYSNUMSTAT
SYSNVARCHARSTAT
SYSPROCBIN
SYSPROCCOLUMNS
SYSPROCEDURES
SYSPROCTEXT
SYSREALSTAT
SYSSMINTSTAT
SYSSYNONYMS
SYSTABAUTH
SYSTABLES_FULL
SYSTBLSTAT
SYSTIMESTAT
SYSTINYINTSTAT
SYSTRIGCOLS
SYSTRIGGER
SYSTSSTAT
SYSVARCHARSTAT
SYS_CHKCOL_USAGE
SYS_CHK_CONSTRS
SYS_KEYCOL_USAGE
SYS_REF_CONSTRS
SYS_TBL_CONSTRS
FIX:
Dump your database, create new empty database with same structure (.st) file and load database.