Error when executing VDB in Teiid Designer

[shiloh.jordan]

I am following the Guides view in Teiid Designer and I have done the following:

• defined Teiid Model Project
• Created JDBC connection
• created source model for jdbc data source
• I am able to preview my data (although I do get the following error):

• I have defined my VDB

My problem is that I am not able to execute my VDB.  I get this error message:

Below is the stack trace:

java.lang.NumberFormatException: For input string: "1.0.0"

at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.lang.Integer.parseInt(Integer.java:580)

at java.lang.Integer.parseInt(Integer.java:615)

at org.jboss.dmr.StringModelValue.asInt(StringModelValue.java:61)

at org.jboss.dmr.ModelNode.asInt(ModelNode.java:226)

at org.teiid.adminapi.jboss.VDBMetadataMapper.unwrap(VDBMetadataMapper.java:92)

at org.teiid.adminapi.jboss.VDBMetadataMapper.unwrap(VDBMetadataMapper.java:1)

at org.teiid.runtime.client.admin.v9.AdminConnectionManager.getList(AdminConnectionManager.java:168)

at org.teiid.runtime.client.admin.v9.AdminConnectionManager.getDomainAwareList(AdminConnectionManager.java:244)

at org.teiid.runtime.client.admin.v9.VdbCacheManager.getRawVDBs(VdbCacheManager.java:335)

at org.teiid.runtime.client.admin.v9.VdbCacheManager.refresh(VdbCacheManager.java:92)

at org.teiid.runtime.client.admin.v9.VdbCacheManager.deploy(VdbCacheManager.java:177)

at org.teiid.runtime.client.admin.v9.Admin9Spec.deploy(Admin9Spec.java:73)

at org.teiid.runtime.client.admin.v9.VdbCacheManager.doDeploy(VdbCacheManager.java:382)

at org.teiid.runtime.client.admin.v9.VdbCacheManager.deploy(VdbCacheManager.java:377)

at org.teiid.runtime.client.admin.ExecutionAdmin.deployVdb(ExecutionAdmin.java:180)

at org.teiid.designer.runtime.TeiidServer.deployVdb(TeiidServer.java:626)

at org.teiid.designer.runtime.ui.vdb.VdbDeployer.deploy(VdbDeployer.java:318)

at org.teiid.designer.runtime.ui.actions.DeployVdbAction$1.run(DeployVdbAction.java:335)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

What could be causing this error?  I am following the Teiid Designer User Guide and have completed all pre-reqs.

Thanks,

All help is appreciated

[rareddy]

For Teiid VDB version use like 1 not "1.0.0". This canonical version support was provided in 10.x versions of Teiid but Designer support still needs to catch up to that.

[shiloh.jordan]

Hi Ramesh,

Thanks for the quick response.

So, my vdb version is already set to 1 (as shown below)

however, I am still getting the same error.

Any more suggestions?

Would be greatly appreciated.

Thanks

--Shiloh

[rareddy]

Can you delete the previous VDB and create a new one? Or it looks like it is not updated.

[shiloh.jordan]

So I resolved my issue by opening the ping and PREVIEW vdb's xml.  This was very hard to locate at first because the files are encrypted.  I had to change the version number from 1.0 to 1

I had to use the shutdown command to shutdown my Wildfly server and restarted it in standalone mode.

Issue was resolved

Thanks for your help Ramesh

Much appreciated.

[rareddy]

preview vdb files are temporary files, I was talking about deleting the VDB in Designer. Also, you are not required to restart the server either.

[shiloh.jordan]

I understand that they are temporary files but even the vdbs that I deleted and re-created were not deploying because of this.  Once I changed the version numbers in the PREVIEW vdb.xml, and restarted the server (because my server is "remote"), I no longer was seeing the "for input string" error and I successfully established a JDBC connection to jdbc:teiid:ping@mm://localhost:31000  (I was stuck with this issue for days)

[rareddy]

Can you tell us exact version of Designer you are using?

[shiloh.jordan]

Hi Ramesh,

I am using Teiid Designer 11.1

• with Teiid 9.0.6 & Wildfly 9.0.2

Thanks,

Shiloh

[blafond]

Shiloh can you verify in the Teiid Instance server tab (server editor page) that the Teiid version of 9.0.x was discovered correctly?

Barry

[shiloh.jordan]

Hi Barry,

The Teiid Runtime Verison number is correct - it is set to 9.0.6, so it was discovered correctly

When I was getting the error, the Administration Connection would be successful but the JDBC Connection would never work.  Once I changed the version number in PREVIEW xmls (in back end), I could make the JDBC connection.

Thanks

[shiloh.jordan]

Hi Ramesh,

Can I report this as a bug in Teiid Designer?

Thanks,
Shiloh

[rareddy]

Absolutely !!!

[shiloh.jordan]

rareddy

Bug has been reported

[TEIIDDES-3128] For input string "1.0.0" - JBoss Issue Tracker

Thanks for all of your help