Error: GETTEXTFILES does not exists

[nandini123]

Hi Everyone,

I am trying to create a vdb using flat file source in Teiid Designer. I have followed the steps mentioned in the link given How to create a virtual database from a text file using Teiid - Sergio Moral Ruiz . I created a source model by name TextFileModel and created a connection profile by name TextFileDataConnection. When i try to preview data by clicking on getTextFiles in the Source Model (TextFileModel) i get this error. May i know what mistake i'm doing here.

org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: Remote TEIID30352 TEXTFILEMODEL.GETTEXTFILES does not exist.

[blafond]

your TEXTFILEMODEL and it's GETTEXTFILES procedure are generated during the Text File importer. This model and it's procedure are required by the Teiid Server and are used/referenced in your actual, queryable procedure in your generated virtual model.  So you should be able to query your virtual table.  See the last step in this example:  Connect to a Flat File using Teiid

Barry

[nandini123]

Hi,

I followed the tutorials which you have mentioned, but i am getting the same error when tried to preview the data in the Zones table (clicked on the running man). I'm not able to figure out what's going wrong

org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30352 CLIMATEZONESSOURCE.GETTEXTFILES does not exist.

[blafond]

You could first try creating, deploying and executing a VDB containing your view and source models.

In the Server view, when clicking on the Teiid Configuration element you can show the deployed Preview VDBs by checking the "Show Preview VDBs" option. There should be a VDB named something like PREVIEW__8255daf7-d4d7-49c2-ae99-970845e46cd1_CLIMATEZONESSOURCE.  You could also check that your local model project on the file system contains that VDB zip file.

Could you also check your log file for any stack trace prior to your  TEIID30352 error?

Barry

[rareddy]

Nandini,

Attach your VDB  the whole model project) that you generated going through the example that Barry mentioned. It is apparent that something else is at play here.

Ramesh..

[nandini123]

Hi,

I have attached my whole project below. I have even attached standalone-teiid.xml file for your reference. Please let me know if anything is wrong.

Thanks

Nandini K J

[rareddy]

Nandini,

Whaen you created the Designer project you created under

C:\Documents and Settings\nandini_jayaram\workspace\TeiidDemo

and Designer is known to not work with directories with "spaces" in them. Also I am not sure how the server will handle for data source connection either. Recreate the project using a different directory with no spaces and it should work. That is only thing I saw, once I fixed in my workspace it worked for me.

Ramesh..

[blafond]

The attached project set had a PREVIEW vdb for your source model, however, for some reason the PREVIEW_....._project vdb didn't have an <importVdb> element for that source preview vdb, so the server wasn't told to merge the metadata, hence the error.

So there's an issue somewhere that is preventing Designer from adding that <importVdb> element. It may be the "spaces in the folder" issue, or may not. Can you check your error logs and attach to this thread just in case somethings getting logged?

Thx

[nandini123]

Hi,

Thanks for your response. You people were correct. I have created a new workspace in this location C:\TeiidWorkspace and also my server location was C:\Documents and Settings\nandini_jayaram\Desktop\Server and i changed it to C:\Server. It resolved my problem and now i'm able to preview the data. There is no error. Thank you all so much.

Nandini K J

[rareddy]

Barry,

Is there any way you can determine that there is spaces in path of parent directory while creating the "Flat FileConnection Profile" so that this can be avoided? Let me know I will file a JIRA.

Ramesh..

[blafond]

Ramesh,

Log a JIRA, I think we already extend/override the Data Tools Flat File profile wizard, so hopefully we can add validation too.

[rareddy]

[TEIIDDES-2493] Check for spaces in the parent directory Flat File connection importer - JBoss Issue Tracker