1 2 Previous Next 15 Replies Latest reply on Dec 3, 2014 10:32 AM by tomaat

    Test JDBC Connection fails

    tomaat

      Teiid Test JDBC Connection Failure.jpgHi,

       

      I am new to Teiid designer. I get the JDBC connection fail error in my Teiid instance as shown in the attachment. Can someone please help? There is another discussion on this forum where a user forgot his user/pwd but I didn't change the password and the default was empty. If the issue is with password, how can i reset it? The results in the log are:

       

       

      09:45:02,513 WARN [org.teiid.SECURITY] (New I/O worker #4) null TEIID40011 Processing exception 'TEIID50072 The username "admin" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid.jboss.JBossSessionService.authenticate(JBossSessionService.java:74). Enable more detailed logging to see the entire stacktrace.


      Thanks

      Ahmad


       

        • 1. Re: Test JDBC Connection fails
          shawkins

          You can delete the entry from the application-users.properties for your user then use the add-user script to add it back with a new password.

          • 2. Re: Test JDBC Connection fails
            tomaat

            Thanks Steven! I have created a connection to flat file. However, i get following error when i try to preview data:

             

            select * from "ViewModel"."table"

             

            org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModel: TEIID30481 Failed to find the Connection Factory with JNDI name PREVIEW_417d2074-3a70-4094-b6cd-e2e77d355d0c_Test1_sources_SourceModel. Please check the name or deploy the Connection Factory with specified name.

             

            What could be the issue?

             

            Thanks

            Ahmad

            • 3. Re: Test JDBC Connection fails
              shawkins

              Sounds like Designer did not create the data source.  It should create one automatically for you.

              • 4. Re: Test JDBC Connection fails
                tomaat

                Hi Steven,

                 

                I have not been able to solve the issue yet. Can there be some issue with my installation? I am bit puzzled!

                 

                Thanks

                Ahmad

                • 5. Re: Test JDBC Connection fails
                  rareddy

                  Ahmad,

                   

                  Typically when you create a source model (which represents your physical data source), Designer automatically creates a connection to the data source and maintains it automatically. However sometimes it gets out of sync, or in your case did not get created for some reason. Then when you create any views on this model and try to preview you will see the above error.

                   

                  The simple solution is, right click on the source model in left navigation explorer, and choose modeling -> set data source, this will either assign a existing connection or let you create a new connection. One this is set then preview will work.

                   

                  Ramesh..

                  • 6. Re: Test JDBC Connection fails
                    tomaat

                    Hi Ramesh,

                     

                    I do following steps:

                     

                    Right click source model -> modeling -> set connection profile (i don't see set data source option)

                    I get the error as shown in attachment

                     

                    I am getting this error even if i try to rename the source model (Refactor -> Rename).

                     

                    Thanks

                    Ahmadteiid designer preview error dec 2.png

                    • 7. Re: Test JDBC Connection fails
                      rareddy

                      Right Click on Model -> Modeling -> Set Connection Profile  (if you already have connection)

                       

                      Right Click on Model -> Modeling -> Create Data Source  (if you trying to create a new connection)

                      • 8. Re: Test JDBC Connection fails
                        tomaat

                        Hi Ramesh,

                         

                        Yes, i see the both options for set connection and create data source. However, i am still getting the exception on preview data despite following your recommendations. Can i setup a session to show you my screen?

                         

                        Thanks

                        Ahmad

                        • 9. Re: Test JDBC Connection fails
                          rareddy

                          Try "project -> clean" or starting the browser once to avoid sync issues.

                          • 10. Re: Test JDBC Connection fails
                            tomaat

                            Ramesh, i am still stuck with the error listed above. Even i created new project, connection, etc. Is there a way i can share a session with you?

                            • 11. Re: Test JDBC Connection fails
                              rareddy

                              Unfortunately I will not able to provide that level of support!

                               

                              In the Teiid Server window, click on VDB folder and select to show "preview" VDBs, then delete all of them. Then do a project->clean, then preview.

                              • 12. Re: Test JDBC Connection fails
                                blafond

                                There is also a "Clear Preview Artifacts" action in the Server view when selecting a Teiid object in the tree

                                • 13. Re: Test JDBC Connection fails
                                  tomaat

                                  Thanks all for the help so far. I still need more guidance. I notice that the xmi files in the model explorer carry a 'yellow alert' sign.

                                   

                                  after i complete the 'create source model for flat file source', the xmi files are generated with this yellow alert sign as shown in the attached figure.

                                   

                                  I have now installed both Red Hat JBoss Developer Studio 7.1.1.GA and eclipse-standard-kepler-SR2-win32. Both installations are giving me the same error.

                                   

                                  The eap version is jboss-eap-6.3.0.Alpha and teiid version is teiid-8.9.0.CR2-jboss-dist.

                                   

                                  Do you guys see any issue with my installation? One point i notice is that i have to provide JDBC connection credentials each time i start the Teiid instance as these are not saved permanently as shown in the attachment.

                                   

                                  Thanks

                                  Ahmadteiid screen shot dec 3.pngteiid credentials dec 3.png

                                  • 14. Re: Test JDBC Connection fails
                                    blafond

                                    If you are running JBDS 7.1.1 GA, then the compatible version for Teiid Designer is 8.6 Final which officially supports up to Teiid 8.7 runtime and EAP 6.1.

                                     

                                    We're working on a 9.0 (Luna-based release) compatible with JBDS 8.0 and Teiid 8.8 and it should be out in a couple weeks.  Teiid Designer 9.1 will follow in Jan/Feb and support Teiid 8.9

                                    1 of 1 people found this helpful
                                    1 2 Previous Next