Kbase 21559: SEND-SQL FAILED errors seen via Protoora via SQLNET/NET8; Alter connection string to fix issue
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
Oracle DataServer
SYMPTOM(s):
ORACLE error -955 error "ORACLE error Messages and Codes Manual". (1252)
ERROR: 1252
: ** name is already used by an existing object
ERROR: 1502
SEND-SQL FAILED SENDING: CREATING SEQUENCE tablename_SEQ START WITH 1 INCREMENT BY1
SEND-SQL FAILED SENDING: CREATE TABLE tablename fldname,etc.)
SEND-SQL FAILED SENDING: CREATE UNIQUE INDEX idxname##fldname etc
SEND-SQL FAILED SENDING: CREATE INDEX idxname##fldname etc
Progress to ORACLE migration done via sqlnet
et8 configuration
Exact Object name(s) already exists for the current user/owner
ORACLE Username entered: username@domain
ORACLE Password entered by itself
Can not create another user for migration task
CAUSE:
Bug# 20011126-011
FIX:
Upgrade to 9.1E, 10.0A or higher.
If unable to upgrade follow this workaround:
Enter the information this way:
ORACLE Owner's Username: username/password@net8service
ORACLE User's Password: <LEAVE THIS FIELD BLANK>
(NOTE that there is a 32-character limitation for both fields)