Hi,

i just deleted a previous post of mines, because what I felt as a different error/problem turned out to be a stupid but weird other issue. The problem was: I could not use anymore an old dynamic multimodel vdb that worked in the past, but a more complex version of that, adding another virtual model, creating two virtual views, worked and I could not explain why, because I got no errors from the web gui and from the server console log.

Then I got an inspiration and tried again, and discovered that the problem was the naming of the xml files. I duplicated a "mydatabase-vdb.xml" file which loaded and worked perfectly ( I could query the vdb) and named the copy "mydatabase-vdb2.xml". That was the problem! That xml deploys perfectly, no errors anywhere, I can enable it, no errors, but no virtual database appears in the teiid console... and I can't query it of course (I mean is not a web gui display issue: the vdb is not shown, and is, really, not active).

If I name that copied file, instead of "mydatabase-vdb2.xml" -> "mydatabase2-vdb.xml" it works perfectly! The virtual database is shown on teiid console and of course you can use it!

Weird... I always thought that I could deploy whatever named xml, in teiid, provided that the xml was valid and made sense... It just happened that until now I always named all my xml files making them end in "-ds.xml" (for data sources) and "-vdb.xml" (for virtual databases). It was just luck... :-D

Only now I see that here Dynamic VDBs - Teiid 8.4 - Project Documentation Editor it is clearly stated:

"The VDB name pattern must adhere to "-vdb.xml" for the Teiid VDB deployer to recognize this file."

but I guess some other user noob like me could be fooled by a subtle rule like that, because teiid seems to "recognize" the file: there is no error or warning of any kind... the system gives you no clue that the only problem is in the xml file name... could this be better handled in teiid or is a eap issue?

Thanks

Marco