Kbase P148071: Getting errors 869 and 916 during the workspace deployment of Roundtable with OE 10.x Microsoft SQL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/17/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting errors 869 and 916 during the workspace deployment of Roundtable with OE 10.x Microsoft SQL Server DataServer schema holder
<program name> Database <dbname> has type <type> (869)
rtb/p/rtb_s_schupd.p Database dbname> has type MSS (869)
But connection to type <type> was requested. (916)
But connection to type PROGRESS was requested. (916)
Roundtable session hangs and fails to make a valid deployment
FACT(s) (Environment):
Workspace setup with Xref Level = No Schema
Workspace has 3 PDBASE objects - 2 DB Type = PROGRESS, 1 DB Type = MSS
Windows
OpenEdge 10.1C02 Service Pack
Roundtable 10.1C
Roundtable TSMS Version 10.1C02
OpenEdge Category: Roundtable
CAUSE:
Roundtable TSMS sets the DICTDB alias for the first connected database in the Workspace. Since the MS SQL Server DataServer Schema holder is set first on the workspace with database type (-dt) MSS, the DICTDB alias references in rtb/p/rtb_s_schupd.p has MSS database type connection during the the launch of the procedure, which cause this issue. Roundtable TSMS 10.103 resolves this issue by allowing multiple logical name (-ld) parameters.
FIX:
Upgrade to Roundtable TSMS OE10.1C03 patch
Or, if upgrade is not possible, use the following workaround to resolve this issue:
Change the Connect Order of the foreign PDBASE object(s) to a value higher than the Connect Order of a Progress PDBASE, so that the Progress database will connect before the foreign databases, and therefore get the DICTDB alias.