Not able to access data after deleting one datasource out of two datasources, without server restart.

[akshy_harale]

Hi,

We are using teiid 8.7 with patch provided for the following issue:

https://issues.jboss.org/browse/TEIID-3079
https://developer.jboss.org/thread/243594

Now we are able to delete the data-source and security domain but after deleting security domain we are not able to access data from any other data-source.  And while deleting security domain it’s get deleted successfully but server throws an exception as follows:
ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC00001: Failed to start service jboss.teiid.transport.embedded: org.jboss.msc.service.StartException in service jboss.teiid.transport.embedded: Failed to start service

To reproduce this follow these steps:

1. Create two data-sources
2. Access data from both data-sources.
3. Try to delete one of them(First delete datasource and delete security domain related to the datsource)
4. While removing security domain look at the server log you will get exception as described above.

It seems that the teiid query engine/embedded service is not getting restarted after security domain deletion.

Any help is appreciated.

Thanks,

Akshay.

[rareddy]

May be in my approach in the fix is wrong way, looks like making the service required optional is not enough. I have to eliminate security-domain dependency, and add from VDB perspective.

[rareddy]

I provided the fix here https://issues.jboss.org/browse/TEIID-3079

[kchen007]

Thanks Ramesh, If I want to merge this to Teiid-8.7.0.final, how can I do it? I am using git to check out the 8.7.0.final.

Kevin