Kbase P182138: Error SEND-SQL FAILED SENDING sql statement to the MS SQL Server reported on the schema holder .log
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/02/2011 |
|
Status: Unverified
SYMPTOM(s):
Error SEND-SQL FAILED SENDING sql statement to the MS SQL Server reported on the schema holder .log file during protoMSS with utf-8 client with revised sequence generator option selected
SEND-SQL FAILED SENDING: if not exists (select * from dbo.sysobjects where id = object_id(N'_SEQT_REV_SEQTMGR') and OBJECTPROPERTY(id, N'IsTable') = 1) create table _SEQT_REV_SEQTMGR ( seq_name varchar(30) not null, initial_value bigint, increment_value bigint, upper_limit bigint, cycle bit not null ) if (select name from sysobjects where name = '_SEQT_REV_<ABL_SEQUENCE_NAME>' and uid = (select uid from sysusers where sid = (select sid from master.dbo.syslogins where UPPER(name) = UPPER('dbo')))) is not NULL drop table _SEQT_REV_<ABL_SEQUENCE_NAME> if (select name from sysobjects where name = '_SEQT_<ABL_SEQUENCE_NAME>' and uid = (select uid from sysusers where sid = (select sid from master.dbo.syslogins where UPPER(name) = UPPER('dbo')))) is not NULL drop table _SEQT_<ABL_SEQUENCE_NAME>
: Stored Procedure failed execution. See previous errors for more information (14958)
Stored Procedure failed execution. See previous errors for more information (14958)
The protoMSS process completes successfully without any errors reported to the terminal
The error message are reported on the <schema holder name>.log file
FACT(s) (Environment):
Windows
OpenEdge 10.2B
OpenEdge10.2B03
MS SQL DataServer
CAUSE:
Bug# OE00204360
FIX:
Currently there is no fix available.
The workaround is to
1. unselect the load sql option from the protoMSS selection screen. This will create the schema holder.sql file.
2. run the the content of the .sql file on the MS SQL Server using transact-sql (t-sql) utility.
3. create schema holder
4. adjust the schema holder against the original OpenEdge database.