11 Replies Latest reply on Apr 17, 2015 3:27 PM by rareddy

    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.

        • 1. Re: Error: GETTEXTFILES does not exists
          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

          • 2. Re: Error: GETTEXTFILES does not exists
            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.

            • 3. Re: Error: GETTEXTFILES does not exists
              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

              • 4. Re: Error: GETTEXTFILES does not exists
                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..

                • 5. Re: Error: GETTEXTFILES does not exists
                  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

                  • 6. Re: Error: GETTEXTFILES does not exists
                    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..

                    • 7. Re: Error: GETTEXTFILES does not exists
                      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

                      • 8. Re: Error: GETTEXTFILES does not exists
                        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

                        • 9. Re: Error: GETTEXTFILES does not exists
                          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..

                          • 10. Re: Error: GETTEXTFILES does not exists
                            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.