1 Reply Latest reply on Aug 31, 2019 7:59 PM by rareddy

    Teiid Error VDB Mysql

    ferdinakusumah
      <brCREATE VIEW tbl_permissions (
       id string,
       slug timestamp,
       name string
       ) AS
       SELECT A.id, A.slug, C.name
       FROM Accounts.tbl_permissions A;
      ]]>

       

      This is error when trying to connect with Mysql VDB

       

       

      [org.teiid.PROCESSOR] (NIO2) KOaoo/pGkYTM TEIID40011 Processing exception 'TEIID31099 VDB VDB.1[RestSource{webservice=webservice, ws, java:/CustomerRESTWebSvcSource}, HIDRest{}, Accounts{mysql-connector=mysql-connector, translator-mysql, java:/accounts-ds}, tbl_permissions{}] is not active, but LOADING. If loading you can resubmit your query after loading has completed or after the errors have been corrected.' for session KOaoo/pGkYTM. Exception type org.teiid.core.TeiidProcessingException thrown from org.jboss.teiid//org.teiid.dqp.internal.process.DQPCore.checkActive(DQPCore.java:883). Enable more detailed logging to see the entire stacktrace.