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

    teiid preview data throws an error

    skanchi
    skanchi Jul 29, 2014 11:10 AM

      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 !

      • 359 Views
      • Tags:
        • 1. Re: teiid preview data throws an error
          shawkins
          shawkins Jul 29, 2014 2:18 PM (in response to skanchi)

          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?

            • Actions
          • 2. Re: Re: teiid preview data throws an error
            skanchi
            skanchi Jul 29, 2014 5:03 PM (in response to shawkins)

            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

              • Actions
            • 3. Re: Re: teiid preview data throws an error
              shawkins
              shawkins Jul 29, 2014 6:44 PM (in response to skanchi)

              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?

                • Actions
              • 4. Re: teiid preview data throws an error
                skanchi
                skanchi Jul 30, 2014 3:41 PM (in response to shawkins)

                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

                  • Actions
                • 5. Re: teiid preview data throws an error
                  shawkins
                  shawkins Jul 30, 2014 3:44 PM (in response to skanchi)

                  > 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?

                    • Actions
                  • 6. Re: teiid preview data throws an error
                    skanchi
                    skanchi Jul 30, 2014 6:00 PM (in response to shawkins)

                    I have created a separate discussion thread.  Thanks Steven.

                      • Actions