DB error: table 'Schema.t_taggedValue' doesn't exist, found via RAS

[Shegit Brahm]

Hi there,

while exploring the world of RAS (Reusable Asset Service), I stumbled upon this error while I do the mandatory dependency check before registering an asset:

Microsoft OLE DB Provider for ODBC Drivers [-2147217865]

[MySQL][ODBC 5.3(w) Driver][mysql-5.7.24-0ubuntu0.16.04.1]Table 'EA_RAS_Client.t_taggedValue' doesn't exist

the creation code says:

Code: [Select]

CREATE TABLE `t_taggedvalue`
(
`PropertyID` VARCHAR(40) NOT NULL,
`ElementID` VARCHAR(40) NOT NULL,
`BaseClass` VARCHAR(100) NOT NULL,
`TagValue` MEDIUMTEXT ,
`Notes` MEDIUMTEXT ,
CONSTRAINT `pk_taggedvalue` PRIMARY KEY (`PropertyID` ASC)
)
ENGINE=InnoDB
DEFAULT CHARSET utf8
COLLATE utf8_general_ci

;
This page https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html indicates, that there might be a problem with different OS and their settings - just the EA script uses only lower case.

And the DB also shows me the table, all lower case.

Any idea what I could do about it?
Searching for first error line brings up (mostly) "you are connecting to a mispelled table" - so the mysql statement might be all.
Just ... the table created by Sparx' script is lower case.

I would claim that after the initial setup, there was no such error.
Maybe it was only an error on one of three DB's and while I moved assets from a to b to c and vice versa - this error got "exported"?

Or is it a bug inside RAS feature?

Thanks, Shegit

[Geert Bellekens]

Probably a bug. Best to report it to Sparx

Geert

[Eve]

What build of EA are you using?

The error is the table name is case sensitive, and has been referred to wrong. I think it's already been corrected.

[Shegit Brahm]

What build of EA are you using?

I'm using build 1351. (Version 13.5.1351)

Sounds I can ignore it as it does no harm, just thinning my nerves as long as I think it harms?

[Geert Bellekens]

Sounds like it would do harm if you actually used it.

AFAIK t_taggedValue is used to store tagged values for connector roles, operation parameters, and maybe a few others.

Geert

[Shegit Brahm]

Sounds like it would do harm if you actually used it.[...]

Right now no error occured.
After this error report started, I set some tagged values, registered them, imported these assets somewhere else - and these tagged values got imported as well (and stored in the origin database).

Maybe I could create some own types and do more complicated stuff with tv to see if it gets broken.
On the other hand I do almost nothing in automation, so my explorative tests are clearly limited.

Cheers, Shegit