Kbase P100787: ProxyGen fails to create .NET proxies w too many TT unique indexes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/11/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
Windows
SYMPTOM(s):
ProxyGen fails to create .NET proxies w too many TT unique indexes
Generating .NET proxies using the .r version of the following NON-PERSISTENT procedure:
DEFINE TEMP-TABLE TT-Pallets_GA
FIELD Date-Added AS DATE FORMAT "99/99/9999"
FIELD Added-By AS CHARACTER FORMAT "x(6)"
FIELD Date-Changed AS DATE FORMAT "99/99/9999"
FIELD Changed-By AS CHARACTER FORMAT "x(6)"
FIELD Company-Id AS CHARACTER FORMAT "x(5)"
FIELD Seq-Num AS INTEGER FORMAT ">>>>>>>9"
FIELD Lot-Code AS CHARACTER FORMAT "x(3)"
FIELD GA-category AS CHARACTER FORMAT "x(6)"
FIELD Amount AS DECIMAL FORMAT "->>>,>>>,>>>.99"
FIELD Currency AS CHARACTER FORMAT "x(3)"
FIELD Home-Amount AS DECIMAL FORMAT "->>>,>>>,>>>.99"
FIELD Fiscal-yr AS CHARACTER FORMAT "X(4)"
FIELD Fiscal-mo AS CHARACTER FORMAT "xx"
FIELD GL-control-acct AS CHARACTER FORMAT "xxxxx-xxxx-xxxx"
FIELD Src-appl AS CHARACTER FORMAT "X(5)"
FIELD Operator-id AS CHARACTER FORMAT "xxxxx"
FIELD Control-no AS INTEGER FORMAT "zzzzzz"
FIELD Trx-no AS INTEGER FORMAT "zzzzzz"
FIELD Line-no AS INTEGER FORMAT "zzzz"
FIELD Posted AS LOGICAL FORMAT "yes
o"
FIELD Tot-Ctns AS INTEGER FORMAT "->,>>>,>>9"
FIELD Rebuild-flag AS CHARACTER FORMAT "x"
FIELD Exception-skip AS LOGICAL FORMAT "yes
o"
FIELD Reattach AS LOGICAL FORMAT "yes
o"
FIELD Counter AS INTEGER FORMAT ">>9"
FIELD trigctrl AS CHARACTER FORMAT "X(20)"
FIELD cmpmainper AS CHARACTER FORMAT "X(15)"
INDEX KEY IS UNIQUE PRIMARY Company-id Seq-num
INDEX Accounting-key IS UNIQUE Operator-id Src-appl Control-no Trx-no Line-no Lot-code GA-category Counter
INDEX Accounting-key2 IS UNIQUE Operator-id Control-no Trx-no Line-no GL-control-acct Lot-code GA-category Counter
INDEX Accounting-key3 IS UNIQUE Company-id GL-control-acct Lot-code GA-category Fiscal-yr Fiscal-mo Seq-num
INDEX Category&n.bsp; IS UNIQUE GA-category Company-id Seq-num
INDEX cmpmainper cmpmainper
INDEX Entry-key IS UNIQUE Operator-id Src-appl Control-no Trx-no Line-no Counter Lot-code GA-category
INDEX Fiscal-period IS UNIQUE Fiscal-yr Fiscal-mo Src-appl Company-id Seq-num
INDEX GL-acct IS UNIQUE GL-control-acct Company-id Seq-num
INDEX GL-Lot-cat IS UNIQUE GL-control-acct Lot-code GA-category Company-id Seq-num
INDEX Lot IS UNIQUE Lot-code Company-id Seq-num
INDEX Lot-Category IS UNIQUE Company-id Lot-code GA-category Seq-num
INDEX Posted IS UNIQUE Posted Company-id Seq-num
INDEX Reattach IS UNIQUE Lot-code Reattach Company-id Seq-num
INDEX Rebuild IS UNIQUE Rebuild-flag Company-id Seq-num
.
DEFINE TEMP-TABLE TT-Pallets_GABU
FIELD Date-Added AS DATE FORMAT "99/99/9999"
FIELD Added-By AS CHARACTER FORMAT "x(6)"
FIELD Date-Changed AS DATE FORMAT "99/99/9999"
FIELD Changed-By AS CHARACTER FORMAT "x(6)"
FIELD Company-Id AS CHARACTER FORMAT "x(5)"
FIELD Seq-Num AS INTEGER FORMAT ">>>>>>>9"
FIELD Lot-Code AS CHARACTER FORMAT "x(3)"
FIELD GA-category AS CHARACTER FORMAT "x(6)"
FIELD Amount AS DECIMAL FORMAT "->>>,>>>,>>>.99"
FIELD Currency AS CHARACTER FORMAT "x(3)"
FIELD Home-Amount AS DECIMAL FORMAT "->>>,>>>,>>>.99"
FIELD Fiscal-yr AS CHARACTER FORMAT "X(4)"
FIELD Fiscal-mo AS CHARACTER FORMAT "xx"
FIELD GL-control-acct AS CHARACTER FORMAT "xxxxx-xxxx-xxxx"
FIELD Src-appl AS CHARACTER FORMAT "X(5)"
FIELD Operator-id AS CHARACTER FORMAT "xxxxx"
FIELD Control-no AS INTEGER FORMAT "zzzzzz"
FIELD Trx-no AS INTEGER FORMAT "zzzzzz"
FIELD Line-no AS INTEGER FORMAT "zzzz"
FIELD Posted AS LOGICAL FORMAT "yes
o"
FIELD Tot-Ctns AS INTEGER FORMAT "-.>,>>>,>>9"
FIELD Rebuild-flag AS CHARACTER FORMAT "x"
FIELD Exception-skip AS LOGICAL FORMAT "yes
o"
FIELD Reattach AS LOGICAL FORMAT "yes
o"
FIELD Counter AS INTEGER FORMAT ">>9"
FIELD trigctrl AS CHARACTER FORMAT "X(20)"
FIELD cmpmainper AS CHARACTER FORMAT "X(15)"
INDEX KEY IS UNIQUE PRIMARY Company-id Seq-num
INDEX Accounting-key IS UNIQUE Operator-id Src-appl Control-no Trx-no Line-no Lot-code GA-category Counter
INDEX Accounting-key2 IS UNIQUE Operator-id Control-no Trx-no Line-no GL-control-acct Lot-code GA-category Counter
INDEX Accounting-key3 IS UNIQUE Company-id GL-control-acct Lot-code GA-category Fiscal-yr Fiscal-mo Seq-num
INDEX Category IS UNIQUE GA-category Company-id Seq-num
INDEX cmpmainper cmpmainper
INDEX Entry-key IS UNIQUE Operator-id Src-appl Control-no Trx-no Line-no Counter Lot-code GA-category
INDEX Fiscal-period IS UNIQUE Fiscal-yr Fiscal-mo Src-appl Company-id Seq-num
INDEX GL-acct IS UNIQUE GL-control-acct Company-id Seq-num
INDEX GL-Lot-cat IS UNIQUE GL-control-acct Lot-code GA-category Company-id Seq-num
INDEX Lot IS UNIQUE Lot-code Company-id Seq-num
INDEX Lot-Category IS UNIQUE Company-id Lot-code GA-category Seq-num
INDEX Posted IS UNIQUE Posted Company-id Seq-num
INDEX Reattach IS UNIQUE Lot-code Reattach Company-id Seq-num
INDEX Rebuild IS UNIQUE Rebuild-flag Company-id Seq-num
.
DEFINE DATASET dsetPallets FOR TT-Pallets_GA, TT-Pallets_GABU.
DEFINE INPUT-OUTPUT PARAMETER DATASET FOR dsetPallets.
.
Log file contains info similar to:
** ProxyGen, Progress Version 10.0B
** Checking for existence of .r files ...
** Processing non-persistent procedures ...
** Processing: C:\DotNetTest\Test\TestProxyErr.r ...
-- Parsing r-code ...
MAIN c:\DotNetTest\Test\TestProxyErr.p
INPUT-OUTPUT dsetPallets DATASET
TABLE: TT-Pallets_GA
Date-Added date
Added-By character
Date-Changed date
¼¨­? ©­?@ ¬?$!¬?@"¬?
>>WARNING during r-code parsing.
The parameter/return type: ¬?$!¬?@"¬? is not supported from an open client. (7263)
** Processing persistent procedures ...
** Checking method and parameter names ...
** Generation failed
Search for '>>ERROR' and '>>WARNING' in this log to find any problems.
CAUSE:
Bug# OE00113411
FIX:
Upgrade to OpenEdge 10.0B02 or later