-
1. Re: problem in executing VDB
akhilkg1987 Aug 17, 2011 7:46 AM (in response to akhilkg1987)I am also facing the following error at times
"Your VDB was Deployed but is Inactive
Datasource Sit not accessible"
in the log I get
the specified session ID "null" is invalid. It cannot be found in the userbase.
-
2. Re: problem in executing VDB
calebwc Aug 17, 2011 8:25 AM (in response to akhilkg1987)Hi Akhil,
Have you attempted to remap the Sit datasource and test that the connection is working with the given username and password? Has anything changed on the database side (enabling SSL, etc...?) At times I've gotten this error and the only way I was able to resolve it was to remove all of the VDB (deployed and temporary "PREVIEW" VDBs) and datasources from our JBoss deploy folder and then redeploy them.
-
3. Re: problem in executing VDB
akhilkg1987 Aug 17, 2011 8:45 AM (in response to calebwc)Hey Calebwc,
thanks a lot for the reply.Actually I was getting this error as I was trying to create the datasource directly from the instance.I tried doing it from the model and it succeded !! Hit and try rocks
but I am still wondering what to do with the first problem that I posted.
-
4. Re: problem in executing VDB
rareddy Aug 17, 2011 8:30 PM (in response to akhilkg1987)Did you create the "Sit" model manually or did you do a "JDBC Import". It is a relational model right?
If you used jdbc import, then it should have created the data source automatically from the userid/password provided during the import. If you created manually, then you can right click on the model, Modeling -> create data source.
Ramesh..
-
5. Re: problem in executing VDB
akhilkg1987 Aug 18, 2011 1:37 AM (in response to rareddy)Hi Ramesh,
I made "Sit " by Importing Metadata from JDBC database.Then I created a datasource by modeling --> create Datasource feature, as mentioned by you.
When I deploy the VDB it successfully gets deployed but when I hit a sql in the scrapbook,I get the model connection not available error.
I just noticed that I have teiid 7.4.0 final client jar in the lib,though I am using(actually have to use) teiid 7.1
Can this be a reason ?
-
6. Re: problem in executing VDB
rareddy Aug 18, 2011 9:32 AM (in response to akhilkg1987)Teiid does support backwards compatible for the client driver, however it is recommended to use the drivers from same versions. Just make sure that when you deploy a VDB you have all the needed data sources created for the VDB for it to function correctly.
Ramesh..
-
7. Re: problem in executing VDB
mathangi Aug 18, 2011 10:45 AM (in response to rareddy)Akhil,
I faced a similar issue and the reason was that I had not placed the jar used to import datasource under /server/default/lib directory. Once I placed the jar and restatred the jboss server, this issue was gone.
Thanks,
Mathangi
-
8. Re: problem in executing VDB
akhilkg1987 Aug 19, 2011 4:51 AM (in response to rareddy)Hi Ramesh,
Actually my server configuration was distorted somehow.
I mapped it once again with teiid runnable and that was an easy trick.
and the error that I was facing in execution went away the moment I placed the connection jar(JTDS) in lib folder of server's default profile.[courtsey mathangi]
some sigh of relief now,finally executed my first VDB.