6 Replies Latest reply on Jul 30, 2014 6:00 PM by Satish Kanchi

    teiid preview data throws an error

    Satish Kanchi Newbie

      Using

      Please see attached error....

      teiid_previewdata_error.JPG

       

      Also in the server.log I see the message

       

      18:35:35,446 WARN  [org.teiid.SECURITY] (New I/O worker #3) 9LHBHsLI6ohL TEIID40011 Processing exception 'TEIID40042 Invalid Session 9LHBHsLI6ohL. Session may have already been terminated.' for session 9LHBHsLI6ohL.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:365). Enable more detailed logging to see the entire stacktrace.


      Also when I stop and restart the server, after successful start, it gives a set of lines in the server.log.... (also attached)


      When I search the forum, I see this issue mentioned but could not find a resolution. 

      Since all my installation is on Win 7, I rebooted several times now....but this error still persists.


      (I am able to get the metadata using the connection, but not preview the data... is there a different mechanism for these two functionalities?)


      What am I doing wrong?  How do I resolve this error?


      Thanks in advance.

      - Satish Kanchi


      PS. The announcement regarding userid/password management for teiid really helped! Thanks !

        • 1. Re: teiid preview data throws an error
          Steven Hawkins Master

          What designer / server versions are you using?

           

          > Also when I stop and restart the server, after successful start, it gives a set of lines in the server.log.... (also attached)

           

          That looks like designer attempting to clean up preview resources.

           

          > (I am able to get the metadata using the connection, but not preview the data... is there a different mechanism for these two functionalities?)

           

          No, they should be the same.  Can you put the server in a debug log level and attach the log?

          • 2. Re: Re: teiid preview data throws an error
            Satish Kanchi Newbie

            Hi Steven,

             

            Versions I have using:

            Platform :  Win 7 Enterprise (64 bit OS)

                JDK : C:\Program Files (x86)\Java\jdk1.6.0_41

            JBOSS EAP 6.1 GA :  jboss.home.dir = C:\Users\SKanchi\Downloads\jboss-eap-6.1.0\jboss-eap-6.1

                Teiid runtime :  teiid-8.8.0.Final-jboss-dist.zip


            (I first tried running with EAP 6.1 alpha (as Ramesh pointed out thats the LGPL version)  but realized I needed a JAXRS patch?... I got lazy and continued to use EAP6.1GA. 


            Attached is the server log when I started in debug mode.  Then I validated jdbc connection in teiid server and then attempted a preview data for one table (PER_ALL_PEOPLE_F under MDMCRP2jdbc.xmi)


            Thanks for your prompt response,

            - Satish Kanchi

            • 3. Re: Re: teiid preview data throws an error
              Steven Hawkins Master

              With Teiid 8.8, you should be using EAP 6.1 Alpha with the JAXRS patch.  We don't validate the community version against the product releases since we make productized versions of Teiid available as the Data Virtualization product.

               

              What Designer version are you using and do you still see an error when using EAP 6.1 Alpha?

              • 4. Re: teiid preview data throws an error
                Satish Kanchi Newbie

                Hi Steven,

                 

                I installed the JAXRS patch for EAP6.1 Alpha.  Now for one of the data sources, preview data is working. 

                For the other data source I am facing an error.  I will open a new discussion thread for that.  Also, I am unable to update connection properties for a data source.  Do you have any tips for me?

                Thanks.

                - Satish

                • 5. Re: teiid preview data throws an error
                  Steven Hawkins Master

                  > Also, I am unable to update connection properties for a data source.  Do you have any tips for me?

                   

                  You'll just have to provide some more details.  Do you mean change the properties on the server side or in Designer?  What type of source is it?

                  • 6. Re: teiid preview data throws an error
                    Satish Kanchi Newbie

                    I have created a separate discussion thread.  Thanks Steven.