Deployment Exceptions for VDB created for WS View Generated FromRelational Model

[darnowsi]

I am trying to create a web service for a relational model. with Teid 7.7, Eclipse 3,7. Jboss 5.1.

WS service model view if generated from relational view as described in section 5.4.1 of Teiid Designer User's Guide.

I have tested this relational view successfully from a SQL client.

I then create a VDB for ws model.

When I try to deploy the vdb I get the following exception indicating validity errors with VDB. However the validation passes when I try it separately for the VDB..

Remote org.teiid.adminapi.AdminComponentException: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

*** DEPLOYMENTS IN ERROR: Name -> Error

vfszip:/C:/Jboss-5.1/jboss-5.1.0.GA/server/default/deploy/oracle_view_Ws.vdb/ -> org.jboss.deployers.spi.DeploymentException: VDB has validity errors; failed to deploy - oracle_view_Ws.1[Oracle_Output_View[], Oracle_WS[], Oracle[Oracle/oracle/Oracle], Oracle_Input[], Oracle_Output[]]

DEPLOYMENTS IN ERROR:
  Deployment "vfszip:/C:/Jboss-5.1/jboss-5.1.0.GA/server/default/deploy/oracle_view_Ws.vdb/" is in error due to the following reason(s): org.jboss.deployers.spi.DeploymentException: VDB has validity errors; failed to deploy - oracle_view_Ws.1[Oracle_Output_View[], Oracle_WS[], Oracle[Oracle/oracle/Oracle], Oracle_Input[], Oracle_Output[]]

Attached isthe server log.

[rareddy]

You can open the .vdb file with a zip utility and take look at the vd.xml file, it should list the errors why VDB is not valid. The same errors should be in eclipse problem view too. I suggest cleaning the project and rebuilding it.

Ramesh..

[darnowsi]

Ramesh,

I tried cleaning the project and rebuilding but the persist.

When I look at the vdb I do find errors for 2 of the models. But these are the models created by the desinger during web service generation.

Attached is thecomplete vdb file.

</model> 

- <model visible="true" type="OTHER" name="Oracle_Input" path="/wrts/Oracle_Input.xsd">

<property value="3759526602" name="checksum" />

<property value="XML Schema (XSD)" name="modelClass" />

<property value="false" name="builtIn" />

<property value="2864732308.INDEX" name="indexName" />

<validation-error severity="ERROR">Referenced file contains errors (http://www.metamatrix.com/metamodels/SimpleDatatypes-instance). For more information, right click on the message in the Problems View and select "Show Details..."</validation-error>

</model>

- <model visible="true" type="OTHER" name="Oracle_Output" path="/wrts/Oracle_Output.xsd">

<property value="4192914346" name="checksum" />

<property value="XML Schema (XSD)" name="modelClass" />

<property value="false" name="builtIn" />

<property value="2654916427.INDEX" name="indexName" />

<validation-error severity="ERROR">Referenced file contains errors (http://www.metamatrix.com/metamodels/SimpleDatatypes-instance). For more information, right click on the message in the Problems View and select "Show Details..."</validation-error>

</model>

</vdb

Steve

[rareddy]

Which version of Teiid Designer? with Teiid 7.7 you want to use Teiid Designer 7.8

If the problem still exists, please check with latest Designer version, then log a JIRA.

Ramesh..

[darnowsi]

Ramesh,

I have actually been using Teiid Designer 7.8. Just to be clear my understanding is  the final stable version of Teiid Designer is 8.0 . 8.1 is released but still Alpha.

So is the recommendation is to install Teiid runtime 8.3, Teiid Designer 8.0, Eclipse 4.2 and Jboss 7.1

Also you can you tell me how these versions line up with product version from Red hat?

[rareddy]

Steve,

Designer 8.x versions support --> Teiid 8.x versions.

Redhat EDS is based on

EDS 5.3 is based on --> Teiid 7.7.x version, only Teiid 7.7 is released in community

JBDS is has Teiid Designer plugin based Designer  7.8.x

If you are working with community version, you can go up latest Teiid 8.3, and Teiid Designer 8.1.Alpha versions. if problen exists open a JIRA.

If you are already using the product then you have the stable version, and you can open a ticket with Redhat for resolution.

Ramesh..

[darnowsi]

Ramesh,

I have instllaed Teiid 8.3 and 8.1 designer.

I can create an oracle data source but oracle translator is not being deployed What do I have to do for this to happen?

Also what version of jbossws-cxf should I install?

Steve

[rareddy]

Steve,

Not sure what you mean by "oracle" translator not deployed? If you installed Teiid correctly (unzip over JBoss AS 7.1.1.Final), then you should see it in the deployment. If you are talking about, not showing up in the Teiid Designer, you need to configure the Server instance before installed translators show up in the VDB explorer window.

Teiid 8.3 only works with JBoss AS 7.1.1, and AS 7.1.1 comes with "cxf" installed, no further installation required as before with JBoss AS 5.1.0

Ramesh..

[darnowsi]

Ramesh,

I was not specifying the standalone teiid config as a parameter to JBoss AS 7.1 server. I corrected this and am now getting all the expected translators deployed. I also followed the instructions for configure the oralcle jdbc driver as a data source that are in the teiid doc directory. The oracle ds is listed as deployed in the teiid server however the following error appears in the log: JBAS014775:    New missing/unsatisfied dependencies:
      service jboss.jdbc-driver.oraclejdbc (missing) dependents: [service jboss.data-source.java:/OracleDS] . I have attached the teid standalone config and the oracle module file. I am now able to generate a web service now after the upgrade to 8.3/8.1. I had to manaully build the war since the teiid web service generator did not find a jdk in the project build path.The jbossws-cxf file generated by teiid for web service project does not verify but I was able to go ahead and generate a war file and deploy it to the server.  One other hitch I had to manually copy the xsd schema file for WSDL to the same directory and the WSDL. After doing that I was able to publish the wsdl so that it can be loaded into Soap UI and the also the Eclipse built web service explorer. When I try a request from Soap UI I get a text message back that the resource was not available. From web service explorer in eclipse I get the error: IWAB0135E An unexpected error has occurred.403 Forbidden. I don;'t see anything the server log so this maybe a web access problem. The test tool and the server are on my local system. Any suggestions on how to troubleshoot these problems would be appreciated.

Steve
.

[rareddy]

Steve,

Did you place the "module.xml" along with "ojdbc6.jar" in the "<jboss-as>/modules/com/oracle/main"  directory? Your configuration inside the "standalone-teiid.xml" look correct.

I had to manaully build the war since the teiid web service generator did not find a jdk in the project build path.The jbossws-cxf file generated by teiid for web service project does not verify but I was able to go ahead and generate a war file and deploy it to the server.

Did you configure the JDK inside the Eclipse? go into Eclipse preferences, JAVA and configure JDK, then it should work.

One other hitch I had to manually copy the xsd schema file for WSDL to the same directory and the WSDL.

hmm, that is not good. You should open a JIRA on this.

After doing that I was able to publish the wsdl so that it can be loaded into Soap UI and the also the Eclipse built web service explorer. .

The war deployed correctly in that case. Make sure you se log message on the JBoss log that war deployed and shows the WSDL url and context for it. See if you can access the wsdl from the browser.

When I try a request from Soap UI I get a text message back that the resource was not available. From web service explorer in eclipse I get the error: IWAB0135E An unexpected error has occurred.403 Forbidden. I don;'t see anything the server log so this maybe a web access problem. The test tool and the server are on my local system. Any suggestions on how to troubleshoot these problems would be appreciated

I suspect there is still an issue with deployment, check to make sure that is right and endpoint is correct. SOAP-UI has http-logs see those.

If you want share your vdb and xsd file, war file I can take a look.

Ramesh..

[darnowsi]

Did you place the "module.xml" along with "ojdbc6.jar" in the "<jboss-as>/modules/com/oracle/main"  directory? Your configuration inside the "standalone-teiid.xml" look correct.

Yes, I checked and the jar is in the same folder.

I had to manaully build the war since the teiid web service generator did not find a jdk in the project build path.The jbossws-cxf file generated by teiid for web service project does not verify but I was able to go ahead and generate a war file and deploy it to the server.

Did you configure the JDK inside the Eclipse? go into Eclipse preferences, JAVA and configure JDK, then it should work.

I have jdk 1.6 set as the jre in windows preferences. Is there something else I need to check.

One other hitch I had to manually copy the xsd schema file for WSDL to the same directory and the WSDL.

hmm, that is not good. You should open a JIRA on this.

After doing that I was able to publish the wsdl so that it can be loaded into Soap UI and the also the Eclipse built web service explorer. .

The war deployed correctly in that case. Make sure you se log message on the JBoss log that war deployed and shows the WSDL url and context for it. See if you can access the wsdl from the browser.

When I try a request from Soap UI I get a text message back that the resource was not available. From web service explorer in eclipse I get the error: IWAB0135E An unexpected error has occurred.403 Forbidden. I don;'t see anything the server log so this maybe a web access problem. The test tool and the server are on my local system. Any suggestions on how to troubleshoot these problems would be appreciated

I suspect there is still an issue with deployment, check to make sure that is right and endpoint is correct. SOAP-UI has http-logs see those.

The endpoint is wrtws/wrtsviewbase- the SOAP UI log indicates this resource can't be found. Looking at the war deployment on the server it looks like this does not match the directory structure. There is no directory wrtsws??

If you want share your vdb and xsd file, war file I can take a look.

I have attached the war file as deployed on the server , wdb, soapUI log and console output after publishing the war.

[darnowsi]

Ramesh,

I tried creating a the war the same name (wrtsws) as the vdb and got a little further.

When running from SOAPUI I now get an internal server error. Looking at the console the ws provider code got a naming exception trying to do a jndi lookup for java:wrtsws to use as part of the connection. Isn't this name for the vdb?

4:34:04,657 SEVERE [org.teiid.soap] (http-localhost-127.0.0.1-8080-2) Exception in executeDataservice: {0}: java.lang.Throwable:

javax.naming.NameNotFoundException

: java:wrtsws

.

Steve

[tejones]

Hi Steve,

The JNDI name should be the Teiid VDB datasource defined in your standalone-teiid.xml.. for example:

               <datasource jndi-name="java:/someJNDIName" pool-name="somePoolName" enabled="true">
                    <connection-url>jdbc:teiid:MyVDB@mm://localhost:31000</connection-url>
                    <driver>teiid-local</driver>
                    <security>
                        <user-name>user</user-name>
                        <password>password</password>
                    </security>
                </datasource>

Also w.r.t. compilation of the WAR, you can specify the JDK in the shortcut to your Designer instance.For example, append something like this in your Eclipse shortcut:

...install_dir\eclipse.exe -vm "C:\Program Files\Java\jdk1.6.0_16\bin\javaw.exe"

That will allow you to compile the WAR in Designer.

Thanks,

Ted

[darnowsi]

Ted,

I added the data source as you suggested. When I run the server I can see the ds deplyoyed in the teiid server. I also can see the data source and a jndi string of "java:wrtsws" in the admin console. However whenr I try to connect from my SOAP UI client I am still getting the name not found error for java:wrtsws error in the console log.  Any suggestions on how to troubleshoot this problem further would be very much apprecaited. I also the run -vm option for eclipse and this did result in the war being generated from the designer. However I was not succesful when deplyong the resultant WAR, so I remove this option in the Eclipse startup since  being able to breakpoint the source seems to be useful when troubleshooting this problem.

Steve

[tejones]

Steve,

I think the format of the JNDI name is wrong. It should be java:/wrtsws. You can enter that in the WAR Generation wizard and regenerate or edit the teiidsoap.properties file directly. It is in the web-inf/classes folder.

Thanks,

Ted