UnhandledException: java.lang.NoClassDefFoundError:org/teiid/odata/ODataSQLBuilder

[sagarika1in]

Hi Team,

I am trying to establish OData connectivity to VDB published in Openshift. VDB is configured to access PostgreSQL database table residing in RHEL.

I am able to access the same table through local EAP server and see the data through OData. But while accessing the VDB deployed on Openshift Pod. I am getting following error.

Can anyone please let me know how to troubleshoot this issue.

[shawkins]

Can you provide more details about the openshift deployment - what image are you using, what version of teiid?

[sagarika1in]

Hi Stev,

I am using teiid-8.12.3 and datavirt with extension image from openshift. PostgreSQL is located on RHEL and outside of openshift.

Please let me know incase of any further information required.

[rareddy]

Are you using the RedHat supplied templates? Also, is this public OpenShift instance or you testing something locally inside the firewall?

[sagarika1in]

Hi Ramesh,

I am using Red Hat JBoss Data Virtualization 6.3 (with SSL and

Extensions).Please find the detailed steps mentioned in

OData_Issue_0201.doc which I followed while deploying VDB on openshift

pod.

Today, we also tried to implement docker approach to deploy VDB as

mentioned in the OData_Issue_0202.doc but it seems, it is not able to find

the VDB in the second approach.

I am uploading both the documents for your reference.

Regards

Sagarika Singh

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[rareddy]

I see both approaches are same, as we have a single way to do OpenShift deployment, which you are using. I see you are getting metadata but while you issue a query for getting the data you run into ClassNotFound Issues. You can also open a support case with Redhat if you a customer, then they can investigate and can get a fix for you.

The NoClassDef error suggests somehow the OData file has been modified. The required class is in the WAR file under WEb-INF/classes. You can use the terminal in OpenShift to log into the Pod and try to crack open the war file and see you can find the .class file.

Otherwise, there is also OData V4 war file should be there also, try using the OData V4 URL. It is slightly different in URL semantics, check the documentation for details.

[sagarika1in]

Hi Ramesh,

We have raised support case for this issue. For OData V4 also we are

facing the same issue. Today We tried connecting with postgresql placed on

Openshift Pod. For that also we can see metadata of the but unable to see

the data.

{

"error" : {

"code" : "ServerErrorException", "message" : {

"lang" : "en-US", "value" : "TEIID30498 Capabilities for test_openshift

were not available. The command could not be planned properly."

}

}

}

Please the detailed document covering the steps followed to access

postgresql present in Openshift.Kindly let us know you suggestion to

resolve the issue.

Regards

Sagarika Singh

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[rareddy]

I believe this exception is saying that it can not reach the Postgres database. Take a look at the log of the pod, that should show more details.