Oracle DB repository: setting column width to > 50

[miku1981]

Hello forum,

we are using EA 9.2 and a database-backed repository (Oracle XE 11). We are repeatedly running into the following EA error when importing models:

OraOLEDB
ORA-12899: value too large for column "REPOUSER"."T_CONNECTOR"."BTM_MID_LABEL" (actual: 52, maximum: 50)

It appears that some columns have been created with a width of only 50 characters. I would like to increase this size. Therefore, the questions are:

1) does EA 9.2 support wider columns?
2) if "yes": how would EA 9.2 react to a DB-side increase of the values? would I need to re-create the connection?
3) if the answer to both questions is "yes": has anyone any experiences with "broadening" the columns of Oracle XE 11 *at runtime*, without dumping-and-reimporting into a new schema?

Many thanks,

MiKu

[qwerty]

The simple answer: just try it or send in a feature request.

If EA does not crash immediately, chances are good it will work with a wider column. AFAIR this works with tagged values. But for other columns EA fails after making it larger.

q.

[miku1981]

Hi querty,

The simple answer: just try it or send in a feature request.

I cannot try it on an empty database, and reconfiguring the existing one would incur the high risk of disturbing/interrupting some production users, so the overhead of trial-and-error-and-restore would be prohibitive.

Also, "if EA does not crash immediately", it does not mean the setup is correct, and I prefer the minimal-risk strategy.

I suspect that tagged values are mapped to columns whose names are starting with "T_"?

Thanks,

miku1981

[qwerty]

Well, if you want the risk free way then the suggested alternative applies: ask Sparx for a new feature.

q.