• RELEVANCY SCORE 5.47

    DB:5.47:Output Messages In Sql Teiid 8c






    is there anyway to trace a teiid procedure with output messages?

    Thanks,

    Mnica

    DB:5.47:Output Messages In Sql Teiid 8c


    You'll want to log a JIRA against Designer. If you are using the latest, that procedure should be available at design time. You can also verify that against the server you can directly execute "call logMsg(level='ERROR', msg='an error')" and see that you get an error log.

  • RELEVANCY SCORE 3.51

    DB:3.51:Using Native Sql In Teiid 97






    Need help in using Native SQL within Teiid Designer. Is there documentation explaining the usage?

    Softwares - Teiid Designer, Runtime 7.7, Jboss SOA platform 5.3.1, Eclipse Indigo

    Regards

    Sanjay

    DB:3.51:Using Native Sql In Teiid 97


    With the 7.7 runtime the only option you have is to use the native-query extension metadata property. On a source table/procedure you should be able to set the native-query extension property in the properties panel. If Designer does not show that as an option you may need something newer like 7.8.

  • RELEVANCY SCORE 3.28

    DB:3.28:Unable To Resolve The Errors While Creating Webservice And Genearting Input/Output Xsd, Output_View View_Ws Teiid Designer 7.7 3d






    Hi,

    We are getting errors while creating WebService and genearting input/output xsd, output_view View_WS Teiid Designer 7.7.

    These errors are in xxxView_WS.xmi and xxxview_output_view.xmi as follows (please see attached files).


    DB:3.28:Unable To Resolve The Errors While Creating Webservice And Genearting Input/Output Xsd, Output_View View_Ws Teiid Designer 7.7 3d


    Hi,

    We are getting errors while creating WebService and genearting input/output xsd, output_view View_WS Teiid Designer 7.7.

    These errors are in xxxView_WS.xmi and xxxview_output_view.xmi as follows (please see attached files).


  • RELEVANCY SCORE 3.20

    DB:3.20:Teiid 8.6 Beta1 Is Not Available In Maven Repository ac



    Would you mind to put Teiid 8.6 beta 1 in Index of /nexus/content/groups/public-jboss/org/jboss/teiid/teiid/ maven repository, please? Thanks a lot! =)

  • RELEVANCY SCORE 3.19

    DB:3.19:Way To Get Native Sql Pushed Down Into Sources From Execution Plan? 87



    What's the best way to see the actual SQL that TEIID sends into the individual datasources in a federated query? I've tried looked at the execution plan with Designer, but it looks like that contains more of a logical breakdown of the query, but does not include the translated SQL sent to the sources.

    Thanks in advance!

    DB:3.19:Way To Get Native Sql Pushed Down Into Sources From Execution Plan? 87


    Hi Mark,

    Unfortunately the command log contains the logical form of the pushdown query, each souce will be different in how or whether an actual source query is logged. For JDBC a trace log is made to org.teiid.CONNECTOR. You can adjust your log4j settings to see the trace logs. Other possibilities include checking into additional logging options in your drivers, usage of a spy driver, or logging an enhancement request.

    Steve

  • RELEVANCY SCORE 3.17

    DB:3.17:Reading Clob Data That Is Over 4000 Characters jj



    Hello Teiid Community,

    I am having issues trying to read a data that is over 4000 characters from a CLOB column exposed through a custom translator that very closely extends the Microsoft SQL Server translator.

    Through this site:

    https://docs.jboss.org/author/display/teiid89final/Large+Objects​

    I see that Teiid will convert LOB's to streaming objects automatically for performance reasons. I can also see that one to do this, it is necessary to set ExecutionContext.keepAlive(). For the time being, i'm looking into alternatives to keeping alive the context.

    The other route i noticed in documentation is to set the CopyLobs tab on the translator:

    Translator Properties - Teiid 8.10 (draft) - Project Documentation Editor

    However, in both cases (CopyLobs set and otherwise), I still get a streaming object back from the Teiid ResultSet. When i attempt to read from that, either a single character, or several at a time, i get a Teiid exception stating the connection was closed (I'm guessing due to the ExecutionContext not being kept alive). Reading other data types, or CLOBS under 4000 characters cause no issues, only this particular data type and size.

    Is there any other steps necessary to get CopyLobs to work?

    Thanks,

    Joe

    DB:3.17:Reading Clob Data That Is Over 4000 Characters jj


    Does this mean that even with CopyLobs enabled, since it is still a steaming object, ExecutionContext.keepAlive() is still required to stream from the temporary Teiid storage location, particularly if we are reading from a remote Teiid Server?

    No keep alive is not needed with copy lobs enabled. With copy lobs enabled, we are free to close the source resultset/statement and allow the connection to return to the pool (which may or may not leave it open).

    Or is this not the case, and you simply feel that the Teiid ResultSet/Statement is closed when it should still be open in JDBC?

    To minimize the number of live lob objects held in memory and/or the amount of temporary space held, we proactively cleanup when a Teiid statement/resultset is closed so that any non-inline lob become unusable. Teiid lob streaming is used for any lob over the allowable inline size, which is typically 4000 characters - regardless of whether that lob is backed by Teiid or a source.

  • RELEVANCY SCORE 3.14

    DB:3.14:Regarding Type Convertion mm



    I am writting SQL in Teiid Designer. It looks like: "SELECT null as START_DATE, null as OT_ID, ab.C1 as DESCRIPTION from AAA.BBB as ab, AAA.CCC as ac".

    I use "null as COLUMN_NAME" here since I do not want to set these values but Designer force me to set them otherwise error will prompt.

    The error messages are:

    The column 'START_DATE' with runtime type 'date' does not match the runtime type 'string' from the query transformation.

    The column 'OT_ID' with runtime type 'biginteger' does not match the runtime type 'string' from the query transformation.

    How should I write this SQL? I remember in the documentation, "null" can be converted into any types implicitly.

    DB:3.14:Regarding Type Convertion mm


    Hi Jalen,

    Use "cast(null as date) as START_DATE". While null is implicitly convertable, the desiger does not currently automatically change the types of the select clause to match the view. You can use the reconsiler dialog to have designer add the conversion functions for you.

    Steve

  • RELEVANCY SCORE 3.13

    DB:3.13:How Does Modeshape Compare With Teiid? pf



    Is ModeShape an implementation of JCR over Teiid? Does it implement data virtualization in parallel to Teiid? Someting else?

    Thank you

    Ittay

    DB:3.13:How Does Modeshape Compare With Teiid? pf


    No, ModeShape is a JCR implementation that has no relationship to Teiid. Well, that's not completely true, because there are some ways that ModeShape can work with a Teiid instance (see below).

    ModeShape and Teiid both federation information, but they do it in very different ways using very different technology.

    To client applications, a Teiid VDB looks like a relational database (accessible via JDBC, ODBC, and even data services), but this database is "virtual" because the data doesn't exist in this form. Whenever the client issues a statement, Teiid figures out which how to execute that statement by pushing down statements to the data sources that really have the data. In fact, Teiid excels at making multiple disparate data sources look to client applications like a single, unified, integrated database, with surprisingly little overhead. At its core, Teiid does all this integration using a relational query engine (this is why Teiid is so blazingly fast), and it has connectors that translate and adapt the relationally-oriented query plans to store-specific forms. (For all the details on Teiid, look at their Reference Guide.)

    At the very highest levels, this may sound similar to what ModeShape. ModeShape also has connectors, but our connector framework is very different than Teiids, and the connectors are not compatible. ModeShape uses these connectors to access all its content, includes several connectors out-of-the-box, and can even federate content from multiple sources. But that's really where the similarities start to fade away.

    Content in ModeShape is organized hiearchically and allows references; in other words, it's graph-oriented not relationally-oriented. ModeShape (via JCR) doesn't constrain your information to a static schema like relational databases (and Teiid) do, so your information can evolve and adapt to changing needs. And ModeShape uses JCR for it's primary API, though we have developed a JDBC driver for ModeShape that makes it possible to connect to a workspace in a ModeShape repository and issue JCR-SQL2 queries and view the results using the JDBC API.

    So ModeShape and Teiid are independent projects that are not typically used together nor depend on each other. But, as they are both JBoss.org projects, there are two ways in which ModeShape and Teiid can be integrated:

    Teiid models and VDB files can be uploaded into a ModeShape repository, and the semantic structure of those files will be sequenced and extracted into the repository. ModeShape does via its Teiid relational model sequencer and its Teiid VDB file sequencer.Teiid contains a connector to ModeShape. It's basically a specialization of Teiid's basic relational translator, because it simply exposes some of the non-standard functions and dialect nuances defined by the JCR-SQL2 grammar. If ModeShape and Teiid are deployed to the same JBoss AS instance (see the ModeShape kit for JBoss AS), then Teiid can query the content of a ModeShape repository. To do this, you use the Teiid Designer to import a relational model from ModeShape (using Teiid Designer's JDBC import wizard), create a virtual database with that model (and any other physical and virtual models), and deploy the VDB to Teiid.

    ModeShape and Teiid are both being included in the upcoming 5.1 release of the SOA-P JBoss platform, and will be integrated as I describe above.

    I hope this helps.

  • RELEVANCY SCORE 3.13

    DB:3.13:Os And Software Requirements s8



    Hi Guys

    Sorry, but i didn`t find anything about, pls advice, questions:

    1. Im going to upgreade from teiid 8.3 - is 8.7 good option? i want to have teiid designer support, so current teiid designer v8.6 supports teiid engine up to v8.7

    (so i assume i cant use teiid engine lastest version 8.9 with teiid designer 8.7).

    Isn`t teiid engine 8.7 buggy or something? (perhaps for eg. 8.6 is more stable than 8.7?)

    2. Which version of java is recommended? (64-bits) - but 1.6/1.7/1.8 ?

    3. Is windows server 2012 ok for os?

    thanks in advance

    DB:3.13:Os And Software Requirements s8


    Thanks Lukas. Be sure let us know if you write any blogs or utilities, we will show case them on the Teiid blog.

  • RELEVANCY SCORE 3.11

    DB:3.11:Ldap Metadata Fetching In Teiid Designer k9



    Hi

    I am Working Teiid Designer 8.2, in teiid designer i need to fetch metadata from Ldap server. can any one help me regarding this.

    DB:3.11:Ldap Metadata Fetching In Teiid Designer k9


    Hi

    I am Working Teiid Designer 8.2, in teiid designer i need to fetch metadata from Ldap server. can any one help me regarding this.

  • RELEVANCY SCORE 3.07

    DB:3.07:Runtime Binding For Teiid Source Models 8c



    Hi,

    Is it possible to provide a feature in Teiid which will allow to create a dynamic runtime binding for the Teiid Source Model?

    With this process,
    One can create a Source Model manuallyBind the model to a SQL query The SQL Query will be excuted at runtime using a JDBC connection

    With the above process it will be possible to develop models without reading metadata from sources and this could be really useful in case of JDBC drivers/Data Sources which doesn't allow access to metadata (https://community.jboss.org/thread/213985) .

    Any thoughts?

    -

    Regards

    Tanmoy

    DB:3.07:Runtime Binding For Teiid Source Models 8c


    Tanmoy,

    Yes. You can create a Dynamic VDB (it is just a XML file) using the DDL for metadata for your source and deploy it using Admin API into Teiid. Once you deploy it, then you can access it using JDBC connection to the VDB.

    example (loopy-vdb.xml)

    ?xml version="1.0" encoding="UTF-8" standalone="yes"?
    vdb name="Loopy" version="1"
    property name="UseConnectorMetadata" value="true" /
    model name="MarketData"
    source name="text-connector" translator-name="loopback" /
    metadata type="DDL"![CDATA[
    CREATE FOREIGN TABLE G1 (e1 string, e2 integer);
    ]] /metadata
    /model
    /vdb

  • RELEVANCY SCORE 3.06

    DB:3.06:Teiid For Excel Data Source 8s



    We have created one client program to fetch data from text and csv data files taking Teiid support. This is working fine. We are using Teiid 7.6.0 and the JBoss 5.1.0 GA. But facing problem for excel (.xls) and xml files through we have followed the same approach.

    The config are as below:

    1.excel-file-ds.xml:

    ?xml version="1.0" encoding="UTF-8"?datasources no-tx-datasource jndi-nameExcelDS/jndi-nameconnection-urljdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=${jboss.server.home.dir}/teiid-examples/dynamicvdb-portfolio/data/abcd.xls/connection-url driver-classsun.jdbc.odbc.JdbcOdbcDriver/driver-classtransaction-isolationTRANSACTION_NONE/transaction-isolation min-pool-size1/min-pool-size max-pool-size1/max-pool-size idle-timeout-minutes5/idle-timeout-minutes/no-tx-datasource /datasources

    2. Added entry in portfolio-vdb.xml:

    model name="ExcelDS"source name="text-connector" translator-name="file" connection-jndi-name="java:excel-file"//model

    3. abcd.xls

    Name Address Country ZipCodeJohn 1st Street USA 12222Mac 2nd Street USA 34421Peter 3rd Street USA 54321

    The connection Code:

    url = "jdbc:teiid:" + vdb + "@mm://" + host + ":" + port + ";showplan=on"; Class.forName("org.teiid.jdbc.TeiidDriver"); DriverManager.getConnection(url, user, password);

    The connection is getting created successfully.

    But while executing the query we are not getting any result output. code snipet looks like this

    sql = "SELECT NAME, ADDRESS, COUNTRY, ZIPCODE FROM (call ExcelDS.getTextFiles('abcd.xls')) f, TEXTTABLE(f.file COLUMNS NAME string,ADDRESS string,COUNTRY string,ZIPCODE bigdecimal HEADER) as stock ";

    statement = connection.createStatement();

    results = statementForCSV.executeQuery(sql);

    results.next();

    Running the program in debugging mode in eclipse we can see that the connection and statement all are created successfully but not getting any data from the ResultSet results.

    Observations: We have also tried to change the query but not succeed.

    a. sql = "SELECT * from [Sheet1$]"; // not working

    b. sql = "SELECT * from (call ExcelData.getTextFiles('Sheet1$'))"; // not working

    c. sql = "select * from (call ExcelDS.getTextFiles('abcd.xls'[Sheet1$])) "; // not working

    Same Exception : org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException

    d. sql = "select stock.* from (call ExcelDS.getTextFiles('abcd.xls')) f, TEXTTABLE(f.file COLUMNS NAME string,ADDRESS string,COUNTRY string,ZIPCODE bigdecimal HEADER) stock"; //not working

    Exception: org.teiid.jdbc.TeiidSQLException: Input length = 1

    Pls help us to resolve the issues soon.

    Regards,

    Ripan K

    DB:3.06:Teiid For Excel Data Source 8s


    Hi Ramesh,

    Thanks a lot for your reply !

    Hope this will really helpful to us and solve the purpose.We are trying to deploy and test your project.

    It will be great if you kindly send us the VDB (xml) and a simple standalone client for above project as well. As we have followed this approach earlier.

    Thank you again for your help.

    Regards,

    Ripan K

  • RELEVANCY SCORE 3.03

    DB:3.03:Return_Generated_Keys In Teiid Jdbc Client 8.1 x7



    Hello,

    I'm doing some tests against an embedded verstion of Teiid 8.1.

    I try to put Teiid inside an already existing web application to be able to access different databases without having to adapt my SQL queries to each one but only for Teiid.

    Some of these queries (INSERT) are based on PreparedStatement with a Statement.RETURN_GENERATED_KEYS.

    I discover that this feature is not supported inside Teiid JDBC driver as it could be seen inside the client code :

    public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)

    throws SQLException {

    throw SqlUtil.createFeatureNotSupportedException();

    }

    It seems that I need to adapt my queries to avoid this capability but I don't see how to achieve this ?

    Thanks in advance for your help.

    Jean

    DB:3.03:Return_Generated_Keys In Teiid Jdbc Client 8.1 x7


    Jean,

    Unfortunately we don't yes support returning generated keys - https://issues.jboss.org/browse/TEIID-1557. The workaround is cumbersome then as you have to lookup whatever the source specific strategy is for getting at the key information after a statement execution and then call to that using a custom procedure that is under the same transaction as your statement.

    Steve

  • RELEVANCY SCORE 3.02

    DB:3.02:How To Remove The Column Alias Names ss



    Hi all,

    I am using teiid 7.6 with some patches applied.

    I have a SQL Select name, age, salary from employee.

    When I run this sql against teiid I get the following SQL in my custom translator

    Select g_0.name AS c_0, g_0.age AS c_1, g_0.salary AS c_2 from employee as g_0

    I do not want the alias names to be applied the columns. Is there any way that we can tell teiid not to add the Alias names to the columns?

    Thanks,

    Rakesh.

    DB:3.02:How To Remove The Column Alias Names ss


    Hi Steven,

    Our translator should support select expressions and inline views as there are many SQL's which gets executed through this translator.

    Also, I think we need to make changes in our translator to support this.

    The SQL which we get in the translator has some extra columns and we need to remove those columns from the SQL before passing it to our product which executes it and returns the results.

    My translator extends the ExecutionFactory. I have a regular expression which checks the SQL and removes the unnecessary columns from the SQL.

    Thanks,

    Rakesh

  • RELEVANCY SCORE 3.02

    DB:3.02:Infinispan Teiid 88



    Hi,

    I am new to infinispan. Is there an option to allow infinispan to sit in front of teiid engine to speed up read and put (e.g.: write behind to teiid virtual database and query is basically objects sitting on data cache)?

    Thanks in advance

    DB:3.02:Infinispan Teiid 88


    Thanks for the input. Yup having teiid to query all the data on infinispan would work as infinispan provides the scalability while teiid provide the jdbc API for app access so there is less impact for code change. I assume I will need to implement a Infinispan connector for teiid.

  • RELEVANCY SCORE 3.02

    DB:3.02:How To Capture Database Changes In Teiid 11



    Hi

    How can we find any database changes in TEIID

    DB:3.02:How To Capture Database Changes In Teiid 11


    Kavith,

    Please open another discussion with full details about versions of the software you are using and JDK etc.

    Ramesh..

  • RELEVANCY SCORE 2.98

    DB:2.98:Teiid And L10n Support zk



    Can someone point me to documentation that discusses Teiid support for localization of messages?

    I see that messages have been externalized to i18n.properties files, but do not see any localized versions of these files.

    Is there any work underway to support localization of these messages? If so, would the translated strings be packaged up and included in a future release?

    DB:2.98:Teiid And L10n Support zk


    Do you have a need for an alternative client or server localization?

    Localization readiness is a requirement for all internal development we do. Actual localization is performed when it can be justified based on ROI. Right now I am just gathering information to feed into the decision making process.

    Reddy and your response is sufficient for my needs now.

    Thanks!

  • RELEVANCY SCORE 2.95

    DB:2.95:Does Teiid Support Auto-Update/Auto-Delete If There Are Many Third-Party Systems? ks



    For example, the Teiid connect to many third-party systems like that:

    So when updating/deleting data using Teiid, does Teiid internally know which systems to update/delete? Or User must mannually write in the update/delete procedure of Teiid to retrieve the data? What would happen if Teiid uses WS to retrieve/update data from/to third-party systems?

    DB:2.95:Does Teiid Support Auto-Update/Auto-Delete If There Are Many Third-Party Systems? ks


    Please see https://jira.jboss.org/browse/TEIID-1349 and https://jira.jboss.org/browse/TEIID-1351 for upcoming enhancments to update processing. If your scenario is described by TEIID-1349, then we'll be able to handle the update automatically. If it's not (cascading deletes, multiple table updates, check option, etc.), there's still time to get in an enhancement request.

    Steve

  • RELEVANCY SCORE 2.95

    DB:2.95:Hierarchial Data Using Teiid cz



    Hi,

    I have two scenerios for getting the hierarchial data .Please let me know if its possible with teiid or not.

    1.I have a source which is sql server table A using whihc I need to build hierarchial data with vdb or whatever using recursive sql .Is it possible ?If so what is the procedure?

    2.I have two sources one is sql and the other is also sql server.Need to build hierarchial data from these two sources

    ex:country is present in one source,state is present in second source .Using recursive sql or some other mechanism of teiid, does it allow ?If so what is the procedure?

    Thanks in advance,

    Preeti

    DB:2.95:Hierarchial Data Using Teiid cz


    There are primarily three mechanisms for building complex results:

    XML Document Models (developed in Desinger)

    SQL/XML

    JSON functions (8.3+)

    XML Document Models are best suited when starting from an xml schema. They also have a concept of recursive subsections of the document. See the Designer docs for more.

    SQL/XML and JSON functions are for creating XML and JSON repectively from just SQL statements. This is quite useful in may simplistic situations. Going off of the #2 example:

    SELECT jsonObject(country.name, (SELECT jsonArray_agg(state.name order by state.name) FROM state where state.country_name = country.name) as "states") FROM country

    or with a join and aggregation as:

    SELECT jsonObject(country.name, jsonArray_agg(state.name order by state.name) as "states") FROM country left outer join state where country.name = state.country_name GROUP BY country.name

    Either would produce a row result similar to:

    {"name":USA,"states":["Alabama","Alaska"...]}

  • RELEVANCY SCORE 2.95

    DB:2.95:Getadmin() Using Embedded Mode In Teiid 8.1 19



    I am new to Teiid. I am trying to create datasource dynamicly using embedded mode in Teiid 8.1. I found out that there was an API call, createDataSource() in AdminAPI. It would be nice if someone could tell me how get the AdminAPI instance from embeddedServer. Thanks a lot!

    - Man-Kit

    DB:2.95:Getadmin() Using Embedded Mode In Teiid 8.1 19


    Awesome news! I will give it a try! Thank you. =)

    - Man-Kit

  • RELEVANCY SCORE 2.95

    DB:2.95:Teiid And Load Balancing fx



    Can you explain a bit more how to load balance a clustered TEIID installation?

    Use case:

    JBoss AS 7.1.1 + TEIID 8.1

    JBoss clustered (profile HA and dedicated server group) so two different hosts are there:

    Was it a simple war with a third host with http + mod_cluster I could achieve load balancing.

    Since I'm connecting to a VDB using JDBC How do I load balance (which is the equivalent option of mod_cluster for http?)

    It seems that the TEIID connector is able to do something on itself, but is not clear to me.

    Do I have to use a load balancer (let's say nginx to do the pure tcp balancing and pointing the connector to the balancer address)?

    Am I assured that caching is consistent on all nodes and that all will work well and scale for performance and fail over?

    In the docs there is this example of data source for load balancing:
    What {host} do we have to use since there will be at least two nodes in the cluster?
    datasources
    datasource jndi-name="java:/teiidDS" pool-name="teiidDS"
    connection-urljdbc:teiid:{vdb}@mm://{host}:31000/connection-url
    driverteiid/driver
    pool
    prefillfalse/prefill
    use-strict-minfalse/use-strict-min
    flush-strategyFailingConnectionOnly/flush-strategy
    check-valid-connection-sqlSET NEWINSTANCE TRUE/check-valid-connection-sql
    /pool
    security
    user-name{user}/user-name
    password{password}/password
    /security
    /datasource
    drivers
    driver name="teiid" module="org.jboss.teiid.client"
    driver-classorg.teiid.jdbc.TeiidDriver/driver-class
    xa-datasource-classorg.teiid.jdbc.TeiidDataSource/xa-datasource-class
    /driver
    /drivers
    /datasources

    DB:2.95:Teiid And Load Balancing fx


    Luca,

    There is no one prescriptive way. Multiple host/port combinations on the URL is our built in way, that may satisfy your needs. HAProxy is another option, where if you have nodes are coming in and going out all the time then you have single place you can configure all the node information, instead of at every single client.

    As per clustering the AS7 just follow the AS7 documents. Also note the installtion of Teiid in Domain mode is different check the Admin Guide. I would very much like you to test this out and give us feed back on domain mode.

    Thanks.

    Ramesh..

  • RELEVANCY SCORE 2.92

    DB:2.92:Java.Lang.Outofmemoryerror: Gc Overhead Limit Exceeded j8



    Hi all,

    We meet a urgency question. When we do endurance test, Teiid server throw this exeception: java.lang.OutOfMemoryError: GC overhead limit exceeded. In this case, we do many deploy and undeloy VDB. And we do many "select " SQL command to Teiid. After a few time, Teiid server will throw this exeception. I analysed dump file of teiid server. We can see. XAManagedConnection used 49.59% memory. Our VDB has 2 datasource . Those datasource are XA. One of both connect oracle. Another datasource connect another VDB. This VDB has 2 datasoure ,too. They are XA. So from my architecture, if clieet use one connection to connect VDB, our VDB will use 4 XA Datasouce as lease. In memory of Teiid, we can find 169 org.jboss.resource.adapter.jdbc.xa.XAManagedConnection. They used 817m memory. Our teiid server java arguments is below.

    -Xms1303m -Xmx2048m -XX:PermSize=256m -XX:MaxPermSize=512m -XX:+UseParallelGC -XX:+UseParallelOldGC -XX:+HeapDumpOnOutOfMemoryError

    I want to know whether this result is ok or memory of teiid has been leak?

    Biggest Top-Level Dominator Classes
    LabelNumber Of ObjectsUsed Heap SizeRetained Heap SizeRetained Heap, %org.jboss.resource.adapter.jdbc.xa.XAManagedConnection16921,632817,211,12849.59%org.jboss.mx.server.MBeanServerImpl296175,107,83210.63%org.teiid.metadata.Schema1008,800113,696,2646.90%oracle.jdbc.driver.T4CConnection56,88099,099,1206.01%org.jboss.virtual.plugins.context.zip.ZipEntryContext43752,44088,327,7285.36%char[]32,34863,251,65663,251,6563.84%org.jboss.classloader.spi.base.BaseClassLoader20133,76834,585,2002.10%java.util.jar.JarFile76160,88025,504,1041.55%org.jboss.classloading.spi.vfs.policy.VFSClassLoaderPolicy20128,94419,894,7521.21%org.jboss.profileservice.management.ManagementViewImpl122417,445,3281.06%

    Problem Suspect 1

    One instance of "org.jboss.mx.server.MBeanServerImpl" loaded by "org.jboss.classloader.spi.base.BaseClassLoader @ 0x2aaace604b50" occupies 174,974,024 (10.62%) bytes. The memory is accumulated in one instance of "EDU.oswego.cs.dl.util.concurrent.ConcurrentReaderHashMap$Entry[]" loaded by "org.jboss.bootstrap.NoAnnotationURLClassLoader @ 0x2aaace603d38".

    Keywordsorg.jboss.classloader.spi.base.BaseClassLoader @ 0x2aaace604b50org.jboss.mx.server.MBeanServerImplorg.jboss.bootstrap.NoAnnotationURLClassLoader @ 0x2aaace603d38EDU.oswego.cs.dl.util.concurrent.ConcurrentReaderHashMap$Entry[]

    DB:2.92:Java.Lang.Outofmemoryerror: Gc Overhead Limit Exceeded j8


    Hello Steve,

    I have used 7.4 beta, And I am testing it now. By now, it looks better than 7.2

    Allen

  • RELEVANCY SCORE 2.91

    DB:2.91:How A Query Is Processed In Embedded Teiid pp



    Hi everyone,

    I'm using Teiid in embedded mode. I was trying to debug the Teiid source code to see how Teiid processes an SQL query and fetches data. I saw that OioOjbectChannelFactory's write method is used to write request details (that includes the method name, class that contains the method, method arguments, and the SQL query to execute) to the socket. Now, I'm unable to find how the message written to the socket is used to execute the given SQL query and fetch data. It'd be great if someone can give me pointers on which class(es) I should add debug points to see how the SQL queries are processed by Teiid runtime.

    regards

    ashish

    DB:2.91:How A Query Is Processed In Embedded Teiid pp


    Thanks Steven. I realized my mistake. The connection string I was using was wrong. It was connecting to the standalone Teiid server.

  • RELEVANCY SCORE 2.91

    DB:2.91:Ldap Data Source Importer In Teiid Designer 8.4? 87



    From Teiid Designer 8.3 What's New, it seems that a LDAP data source importer was added. I am using Teiid designer 8.4. I could not find the LDAP importer when right click "Source" - Import. Here is the screen shot. Did I miss anything? Thanks in advance.

    DB:2.91:Ldap Data Source Importer In Teiid Designer 8.4? 87


    After the upgrade to teiid designer 8.4.0.Final-v20140312-0402-B253, the LDAP shows up.

  • RELEVANCY SCORE 2.91

    DB:2.91:Client Applications Connection To Teiid Server 9s



    Hi,

    I have deployed VDBs to Teiid server.

    Next, i need to query the Teiid server from following clients:

    1. Create a data source in SQL server reporting services that connected to Teiid server using ODBC or JDBC.

    2. Create a linked server in SQL Server 2008 R2 that i can use in SQL queries to query Teiid server.

    3. Create a data source in Business Objects that point to Teiid server.

    All three clients are on different servers. I see lot of documentation with code examples to connect to Teiid server. Can you please refer me a step-to-step quide to setup JDBC or ODBC clients for Teiid server.

    Thanks in advance

    Ahmad

    DB:2.91:Client Applications Connection To Teiid Server 9s


    The only help I could point to would be to follow the online help - http://msdn.microsoft.com/en-us/library/ms712362%28v=vs.85%29.aspx

    I don't think we've had any community experience with this combination before. You could also try other ODBC applications to see if you can get further or a better error.

  • RELEVANCY SCORE 2.89

    DB:2.89:Unable To Connect To Teiid Server From Designer In 7.0 x1



    this issue copied from http://community.jboss.org/docs/DOC-15627

    I had created a VDB using Designer in 7.0 and created the Teiid Server connection in Database Development Perspective.

    When I try to connect to Teiid I am getting the following Error

    Error creating SQL Model Connection connection to Teiid Server. (Error: Remote org.teiid.client.security.LogonException: VDB "SecAdmin" version "latest" is not active.)

    ...

    Could you please help me in solving this problem

    DB:2.89:Unable To Connect To Teiid Server From Designer In 7.0 x1


    No problem. Also, I found out that, the "admin-console" uses a test query to check up or down status. So, when you created the -ds.xml file, and it does not specify the test query to check the connection's health, this could be the symptom. I have not verified this myself, but if you do please let us know.

    For Teiid you could use something like "select 1" as test query.

    Thanks

    Ramesh..

  • RELEVANCY SCORE 2.87

    DB:2.87:Teiid Designer 8.4 With Teiid 8.4 dx



    The project roadmap states that Teiid Designer 8.4 is adding support for Teiid 8.6.

    Would it work with Teiid 8.4 as well ?

    Is is still expected to release in Jan 2014 ?

    DB:2.87:Teiid Designer 8.4 With Teiid 8.4 dx


    The project roadmap states that Teiid Designer 8.4 is adding support for Teiid 8.6.

    Would it work with Teiid 8.4 as well ?

    Is is still expected to release in Jan 2014 ?

  • RELEVANCY SCORE 2.87

    DB:2.87:Import Database Via Jdbc Issue c7



    I am trying to import a SQL Server database, located on a remote server, as a JDBC source in TEIID designer by creating a new connection profile.The connection profile works fine as the ping is successful. However, when I click next and move on to the 'Select Database Metadata' screen the Table Types section (tables and views) shows blank and I am unable to proceed further. Same database and teiid version on different machine works fine. But I am not sure if there is any settings or something on the server that is not alowing me to view the table types. Please advise.

    DB:2.87:Import Database Via Jdbc Issue c7


    Thanks Ramesh for the help. There was an issue with the driver. Fixed now

  • RELEVANCY SCORE 2.87

    DB:2.87:Exception While Using Biginteger Column With Sum Function c7



    Hi,

    I have column which is of "BigInteger" type and when I am trying to execute an SQL which contains the SUM function I am getting the following exception.

    The following is the SQL:

    SELECT SUM(age) FROM test

    My understanding is that the sum of all the BigInteger's is not fitting in the size of the BigInteger and Teiid is trying to convert it into a BigDecimal and end up in an exception.

    How to fix this problem? Do we have a woraround for this?

    Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype biginteger for column 0 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.

    at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:851) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:317) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1443) [rt.jar:1.7.0_03]

    at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1414) [rt.jar:1.7.0_03]

    at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1174) [rt.jar:1.7.0_03]

    at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346) [rt.jar:1.7.0_03]

    at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1443) [rt.jar:1.7.0_03]

    at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1414) [rt.jar:1.7.0_03]

    at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1174) [rt.jar:1.7.0_03]

    at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346) [rt.jar:1.7.0_03]

    at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    ... 25 more

    Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.math.BigInteger

    at org.teiid.client.BatchSerializer$BigIntegerColumnSerializer.writeObject(BatchSerializer.java:681) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:506) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:840) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

    ... 36 more

    Thanks

    Rakesh

  • RELEVANCY SCORE 2.87

    DB:2.87:Sql Dialect In Teiid Designer aj



    I am using an Oracle data source and have been sucessful in connecting to the data source and getting a connector setup in teiid designer. I used the generic jdbc driver connector, not the oracle8 jdbc connector that appears in the connectors list. Got errors when attempting to setup the oracle 8 connector. Configuration appears to be Oracle Datadirect driver specific.Importing schema information into the model is working fine. When I Preview Data for the imported objects, I get a ORA-00933 SQL command not properly ended. Looking at the teiid generated query, a table alias is being used. An "AS" clause is being used to map the table to the alias which appears to be causing the oracle error. I don't think is standard SQL alias syntax. Is there some way to configure the sql dialect configuration in teiid? Can the auto generated queries be manually modified?Kirk

    DB:2.87:Sql Dialect In Teiid Designer aj


    You can select "Oracle ANSI Connector", but you need to change the Driver name in the properties panel in the Designer and also provide the correct JAR in the class path entry.By using the "Oracle ANSI" entry, the command will be properly converted to be consumed by the Oracle. The auto generated queries are SQL-92 compatible, they are not Oracle specific.In future releases, (6.1.0), Teiid would provide Oracle templates for the native Oracle drivers, but until then, if you want to add your own type you can follow the procedure as described inhttp://www.jboss.org/index.html?module=bbop=viewtopict=152908

  • RELEVANCY SCORE 2.86

    DB:2.86:Insert Multiple Rows To Datasource Through Teiid ac



    Hi,

    If I run SQL like:

    INSERT INTO tablename SELECT * from tablename2.....

    insert multiple rows to data source through Teiid, how does Teiid handle this SQL? Run multiple INSERT statement or some other way? I need to understand it to write my translator for INSERT.

    Thanks.

  • RELEVANCY SCORE 2.86

    DB:2.86:Teiid Client On Jboss Eap 6.1.0.Final Error d8



    Hi

    I'm using teiid XA datasouce in jboss EAP 6.1.0 with JPA/Hibernate

    When I query data, Teiid throws Exception as following:

    11:10:57,637 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (MSC service thread 1-3) SQL Error: 20013, SQLState: 50000
    11:10:57,637 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (MSC service thread 1-3) TEIID20013 java.net.SocketException: Socket is closed

    DB:2.86:Teiid Client On Jboss Eap 6.1.0.Final Error d8


    I has adjusted all objects Serializable, but the exceptions still occured.

    That may not be suffient as they must be fully transitively Serializable. Also that is only the likely cause and has yet to be confirmed, and without access to the server logs you will have a hard time resolving this as not enough information is exposed to the client. https://issues.jboss.org/browse/TEIID-2534 may help you resolve this when you can use 8.4 Final client/server sometime next week.

    Steve

  • RELEVANCY SCORE 2.86

    DB:2.86:Ntlm In Teiid ks


    Hi
    I want to use NTLM based authentication using jdbc connector in teiid. I'm using JBDS 7 with Teiid Designer 8.4. i have downloaded Microsoft JDBC Driver 4.0 for SQL Server" fromhttp://www.microsoft.com/en-us/download/details.aspx?id=11774 and In JBDS teiid designer i have enabled integrated Authentication then I edited Microsoft SQL Server driver definition, on the Jar list tab i have added the sqljdbc_auth.dll from the \sqljdbc_4.0\enu\auth\x64 path ,but my am getting this error

    java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)

    at java.security.AccessController.doPrivileged(Native Method)

    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)

    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)

    at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:789)

    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)

    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:297)

    at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

    at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:81)

    at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)

    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

    at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

    at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

    On the jar list i have added sqljdbc4.jar as well as sqljdbc_auth.dll and tried that time my jbossstudio is getting crash .
    Can anyone help me here? How do i do integrated Authentication in teiid.

    DB:2.86:Ntlm In Teiid ks


    please use the Teiid forum for that question. thanks.

  • RELEVANCY SCORE 2.85

    DB:2.85:Pros And Cons Of Teiid Development To Implement Data Security 9a



    I want to evalaute Teiid implementation based on different parameters.

    My scneario is

    - Create VDB to point to Oracle and SQL Server (Either 2 seperate VDBs or one multi-source VDB). User will be connected any source at a time

    - Develop procedures on this VDB to define the security policies (row level securities - to obtain the data based on some inout paarameter by joining few tables)

    - Why Teiid - Same procedures can be used for both the data sources since they are created on VDB

    Can some one give me more details or their views on following points

    - Pros and Cons of using Teiid

    - Performance (If huge amount of data is rerieved by joining multiple tables. Transaction can be Select/Insert/Update etc)

    - Maintainability

    - Scalability

    - Robustness

    - Teiid Support provided by community

    Please help to understand above points

    Thanks in advance

    Neeta

    DB:2.85:Pros And Cons Of Teiid Development To Implement Data Security 9a


    Thanks Ramesh for response to all the queries.

    I have always been getting answers from the community for all my queries.

    I am thankful to entire community for all their support

    Thanks,

    Neeta

  • RELEVANCY SCORE 2.84

    DB:2.84:Kerberos Authentication With Jboss Eap 6.1alpha +Teiid 8.6 Beta 2 Running As A Windows Service 1z



    Hello

    I'm trying to get Kerberos authentication to work with my development environment. Looking at the example in the Security document the default Kerberos module is expecting a KeyTab file. However since I'm running JBoss EAP as a Windows service with its own service account. That account should have a krbtgt session ticket already.

    I tested the connection to the SQL server by using a simple Java program. In my connection string I've specified authenticationScheme=JavaKerberos to ensure it is not using the sqjdbc_auth.dll module. Everything worked fine. I was able to authenticate using Kerberos.

    I've applied my setting to the Teiid configuration as much as possible but I am still getting Integrated authentication failed. Client ConnectionID ...

    I've tried using the Kerberos module and com.sun.security.auth.module.Krb5LoginModule but both are not connecting.

    What is the different between the Kerberos Login Module in Teiid/Jboss vs. com.sun.security.auth.module.Krb5LoginModule?

    DB:2.84:Kerberos Authentication With Jboss Eap 6.1alpha +Teiid 8.6 Beta 2 Running As A Windows Service 1z


    Andy,

    Here is the code reference if you want to debug against.

    http://grepcode.com/file/repository.jboss.org/nexus/content/repositories/releases/org.picketbox/jbosssx-bare/4.0.1/org/jboss/security/auth/spi/UsersRolesLoginModule.java

    Ramesh..

  • RELEVANCY SCORE 2.84

    DB:2.84:Kerberos Support In Jboss Teiid ? 89



    Hello,

    I am connecting to SQL Server 2008 database from Teiid using jdbc username and password. Now, i want to connect to db using Kerberos authentication .From the Kerberos support through GSSAPI - Teiid 8.9 (draft) - Project Documentation Editor i am not able to understand if Teiid supports Kerberos authentication.

    If it does , do we have more material related to it ?

    DB:2.84:Kerberos Support In Jboss Teiid ? 89


    OK, here is what is supported and not

    1) Your Application -- Kerberos Auth -- Teiid (supported)

    2) Teiid -- Kerberos Auth -- SQL Server 2008 (should be supported)

    3) Your Application -- Kerberos Auth -- Teiid -- Use same logged in kerberos token (No reauth) -- SQL Server 2008 (not supported TEIID-3005)

    If you are only looking for (2), then consult JBoss EAP documents for configuration, it will be like configuring a security-domain in JBoss EAP then configuring data source with that security domain.

    For ex:

    Add following system properties

    JAVA_OPTS = "$JAVA_OPTS -Djava.security.krb5.conf=/path/to/krb5.conf -Djava.security.krb5.debug=false -Djavax.security.auth.useSubjectCredsOnly=false"

  • RELEVANCY SCORE 2.83

    DB:2.83:Teiid Designer Can Connect To Teiid Embeddedserver ? xk



    Hi,

    I' using EmbeddedServer in my application,

    can i connect from teiid designer to this embedded ?

    Thx.

    DB:2.83:Teiid Designer Can Connect To Teiid Embeddedserver ? xk


    I want to deploy on the Teiid Embedded a VDB using the Admin

    That will not work. Again the server's admin interface is all through AS/EAP logic, so that does not exist for embedded.

  • RELEVANCY SCORE 2.83

    DB:2.83:Problem Installing Teiid 7.6 On Jboss 5.1.0 7z



    I am trying to install Teiid 7.6 in JBoss AS 5.1.0 but the JBoss profile service does not seem to be picking up the teiid directory. I followed the instructions on the admin guide about unzipping the file "teiid-7.6.0.Final-jboss-dist.zip" into ${jboss.install}/server/default/ but it doesn't install Teiid. The log doesn't indicate anything about the Teiid service being up.

    I am using Mac OS X 10.5.8 and JDK 1.6.

    DB:2.83:Problem Installing Teiid 7.6 On Jboss 5.1.0 7z


    Jay,

    Just make sure there is a "teiid" directory available after the install in the ${jboss.install}/server/default/deploy" directory. Watch the console log messages to see any errors.

    Ramesh..

  • RELEVANCY SCORE 2.83

    DB:2.83:Source Table Metadata Overrides 9k



    Teiid Designer's Komodo development will focus on replacing EMF metamodel with Teiid DDL dialect relational constructs. One of our goals is to minimize the footprint of our new VDB, which will replace XMI + Index file with a DDL file.

    If a user utilizes the simple pass-thru source table definitions in their VIEW's SQL transformation, then Komodo will only use the simple model and source elements in the VDB and NOT include the data source's DDL.

    If a user chooses to override a source table definition (changed property, datatype, etc.) this will result in an included DDL file for the source model (i.e. CREATE FOREIGN TABLE ( ..... ) ).

    Will this DDL file need to include the whole DDL representation of the source schema, or can Teiid work with individual overridden source tables and merge the metadata?

    Barry

    Teiid Designer

    DB:2.83:Source Table Metadata Overrides 9k


    Will this DDL file need to include the whole DDL representation of the source schema, or can Teiid work with individual overridden source tables and merge the metadata?

    Metadata repositories can be layered, so you can use ddl with native/source metadata. There are very few supported alter constructs though.

  • RELEVANCY SCORE 2.83

    DB:2.83:Teiid 7.2/Designer 7.2 Beta 1: Lots Of Errors In Eclipse Message Log... as



    Hi, i'm trying to learn "full" vdb modeling, using teiid 7.2 and designer 7.2 beta 1 connecting from a remote workstation to the server.

    I can import source models from jdbc datasource, and preview sql results from the sources

    my project is teiid1, source model is apimix_prenotazioni_test. i attach my current project screenshot

    as soon as i test sql preview from the source model, i see three new files created on the teiid server through ssh or jboss admin web console

    on designer teiid server instance appeared only the second for a while then disappeared... ?

    -rw-r--r-- 1 jbadmin jbadmin 1882 2010-12-21 12:45 PREVIEW_aaca5f8a-57fd-4a2b-9039-f5237c1c2bea_teiid1_apimix_prenotazioni_test-ds.xml-rw-r--r-- 1 jbadmin jbadmin 22243 2010-12-21 12:46 PREVIEW_aaca5f8a-57fd-4a2b-9039-f5237c1c2bea_teiid1_apimix_prenotazioni_test.vdb-rw-r--r-- 1 jbadmin jbadmin 308 2010-12-21 12:46 PREVIEW_aaca5f8a-57fd-4a2b-9039-f5237c1c2bea_teiid1_project.vdb

    if i go further, strange things happen, and my impression is they're not so easy to reproduce... the only rock solid thing is: i can't delete anything i create under project, it has no effect, and some error messages in the eclipse log console, often about: com.metamatrix.modeler.internal.core.workspace.WorkspaceResourceFinderUtil.getDependentResources(WorkspaceResourceFinderUtil.java:399)

    i'd like to proceed only when i'm sure the base setup is working, so, what to check to make sure that:

    - teiid server is connected without problems

    - the model is imported without problems

    and what to do next?

    Marco

    DB:2.83:Teiid 7.2/Designer 7.2 Beta 1: Lots Of Errors In Eclipse Message Log... as


    Marco,

    Good eye for detail, I like that! Now for the explanation as to what is happening under the hood.

    Teiid exposes its admin functionality through "Admin API", with this API a client can write a management console Teiid. Designer is also such client to Teiid that uses API to deploy VDBs, data sources etc.

    Since a single Teiid instance can be shared by multiple Designers, Designer uses a UUID prefix to all its artifacts so that it can uniquely identify them, thus the naming of these artifacts. For preview to work, Designer deploys each individual model as its own *internal* VDB into Teiid along with required datasource. Since these are temporary artifacts that are maintained only for the duration of session, it tries to hide them as they do not provide any meaningful information to the user. If you would like to see them, you can set the preference to view "Show Preview VDBs" and "Show Preview Data Sources" on the "Teiid" property window.

    So, everything is working as designed.

    Hope this helps.

    Ramesh..

  • RELEVANCY SCORE 2.82

    DB:2.82:How Do I Delete Existing Connection Profiles From The "Import Database Via Jdbc" Wizard? k8



    Hello, I am trying to troubleshoot how to preview data in teiid designer, however, through the experimentation process of creating connections the profile list has grown and is throwing error messages in the error logs. I'd like to clean out this list so the designer isn't throwing unnecessary redflags against connection profiles I will never use again. Unfortunately I am not seeing how to manage the connection profiles to delete them. Any ideas?

    I am using JBDV 6.1 beta with Teiid 8.7.1 redhat runtime-5.

    Any ideas?

    DB:2.82:How Do I Delete Existing Connection Profiles From The "Import Database Via Jdbc" Wizard? k8


    I came across something called "Data Source Explorer". Eventually found the "Database Development" perspective as well. Thanks.

  • RELEVANCY SCORE 2.82

    DB:2.82:Teiid Udf With String Return Type Limiting The Return Value To 4000 Characters zm



    We have User Defined Function in teiid that take some input params like object name, where clause etc. and returns a string as an outparam which an SQL. The metadata of this function look like this-

    final FunctionParameter policyId = new FunctionParameter("ID", DefaultDataTypes.STRING);

    inParamList.add(policyId);

    final FunctionParameter objectName = new FunctionParameter("OBJ_NAME", DefaultDataTypes.STRING);

    inParamList.add(objectName);

    final FunctionParameter columnName = new FunctionParameter("COLUMN", DefaultDataTypes.STRING);

    inParamList.add(columnName);

    final FunctionParameter comparator = new FunctionParameter("OPERATOR", DefaultDataTypes.STRING);

    inParamList.add(comparator);

    final FunctionParameter constValue = new FunctionParameter("VALUE", DefaultDataTypes.STRING);

    inParamList.add(constValue);

    final FunctionParameter whereClause = new FunctionParameter("WHERE_CLAUSE", DefaultDataTypes.STRING);

    inParamList.add(whereClause);

    final FunctionParameter outParam = new FunctionParameter("SQL", DefaultDataTypes.STRING);

    sqlFn.setPushDown("NEVER");

    sqlFn.setInvocationClass(UDFExectionFactory);

    sqlFn.setInvocationMethod("prepare_sql");

    sqlFn.setCategory("string");

    sqlFn.setInputParameters(inParamList);

    sqlFn.setOutputParameter(outParam);

    The implementation looks like this-

    public static String prepare_sql (final String Id,

    final String objName,

    final String column,

    final String operator,

    final String value,

    final String whereClause) throws TranslatorException

    {

    String preparedSql = some calculated value

    return preparedSql;

    }

    This function is called like this-

    SELECT prepare_sql ( ID,OBJ_NAME,COLUMN,OPERATOR,VALUE,WHERE_CLAUSE ) as SQL

    In some cases this preparedSql becomes very large and goes beyong 4000 characters but teiid only return the first 4000 characters from it making it a bad sql.

    How can we tell teiid to return the full SQL and not limit to 4000?

  • RELEVANCY SCORE 2.82

    DB:2.82:How To Connect Qlikview With Virtual Database Like "Teiid" aj



    hi guys,

    I am trying to connect qlikview with a virtual database "teiid" which inturn will be connected to various other data sources like oracle, sql.

    but m not able to find any odbc driver for "teiid" from the option provided in the qlikview personal edition.

    is there any other way to connect to it,.

    i also came across this custom data source, but it is asking for licence key etc before doing anything with it.

    pls let me know of any alternatives which i can use to connect to teiid.

    Thanks

    DB:2.82:How To Connect Qlikview With Virtual Database Like "Teiid" aj


    hi guys,

    I am trying to connect qlikview with a virtual database "teiid" which inturn will be connected to various other data sources like oracle, sql.

    but m not able to find any odbc driver for "teiid" from the option provided in the qlikview personal edition.

    is there any other way to connect to it,.

    i also came across this custom data source, but it is asking for licence key etc before doing anything with it.

    pls let me know of any alternatives which i can use to connect to teiid.

    Thanks

  • RELEVANCY SCORE 2.82

    DB:2.82:Teiid Under Tomcat pf



    Hi,

    can i deploy teiid under Apache/ Tomcat as standalone teiid (Not in Embedded mode)

    and if yes, in this case, can Teiid Designer connect use this Teiid Instance ?

    Thx.

    DB:2.82:Teiid Under Tomcat pf


    can i deploy teiid under Apache/ Tomcat as standalone teiid (Not in Embedded mode)

    No. There is no server package for Tomcat. Embedded is possible and there is OSGI bundling for other containers as well.

    and if yes, in this case, can Teiid Designer connect use this Teiid Instance ?

    It's the same as the other thread. The admin functions of Designer are only available against Teiid deployed in JBoss EAP/AS. Any other scenario the best that you can do is just have a JDBC source.

  • RELEVANCY SCORE 2.82

    DB:2.82:Old Test Setup Can't Login At Web Console Anymore... kf



    Hi all, been a while...

    I'm going to revamp my teiid tests, since now I could really try to go in production, hopefully.

    on my win7x64 pc in the past I tried several setups, with many teiid versions, and now I would like to

    * use last old test install again, and/or

    * start from scratch with a ccompletely new install, and newest versions

    but with the old install I have this issue:

    - the server starts, and I can query with squirrelsql, a MSSQL test model I still have, loading, with user/user permissions... so it is working.

    - on cli, server starts with good output, I think (will append this below)

    - but I can't log in to web console anymore... or forgot how

    firefox (24esr) on localhost:9990 asks for user/password, and

    - I have two of those different test credentials saved in the browser, with different passwords (users: "admin", "teiid")

    - but both do not work... anymore...?

    - I could have installed also admin console (cli) if this helps but I'm not sure, how to check?

    - those login could also belong to other tests, but... frankly, I have no chance to reconstruct which, and they could be gone, it was nearly 1 year ago, and I kept no docs, since they were really simple tests to verify my backend DBs (I know I should have anyway)

    none of the standard (or I guess so) credentials work, and I'm stuck there, is there any way to reset those users passwords or else?

    I admit that I left behind user roles/permissions configuration topics, at the time, since it was all new to me, and I explored VDB models, drivers, and so on...

    otherwise I could try with a brand new AS + teiid, but I need a new step-by-step "getting started" guide, because my main memory (brain) is apparently faulty...

    thanks, Marco

    ===============================================================================

    JBoss Bootstrap Environment

    JBOSS_HOME: D:\sviluppo\teiid\jboss-eap-6.1

    JAVA: C:\Program Files (x86)\Java\jre7\bin\java

    JAVA_OPTS: -client -Dprogram.name=standalone.bat -Dorg.teiid.backslashDefaultMatchEscape=true

    ===============================================================================

    14:35:43,946 INFO [org.jboss.modules] (main) JBoss Modules version 1.2.0.CR1

    14:35:44,372 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA

    14:35:44,436 INFO [org.jboss.as] (MSC service thread 1-2) JBAS015899: JBoss Teiid + Teiid 8.4 (AS 7.2.0.Alpha1-redhat-4) starting

    14:35:46,099 INFO [org.xnio] (MSC service thread 1-4) XNIO Version 3.0.7.GA

    14:35:46,104 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)

    14:35:46,123 INFO [org.xnio.nio] (MSC service thread 1-4) XNIO NIO Implementation Version 3.0.7.GA

    14:35:46,131 INFO [org.jboss.remoting] (MSC service thread 1-4) JBoss Remoting version 3.2.14.GA

    14:35:46,288 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 30) JBAS010280: Activating Infinispan subsystem.

    14:35:46,326 INFO [org.jboss.as.connector.logging] (MSC service thread 1-1) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.15.Final)

    14:35:46,384 INFO [org.jboss.as.security] (ServerService Thread Pool -- 43) JBAS013171: Activating Security Subsystem

    14:35:46,388 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem

    14:35:46,465 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

    14:35:46,467 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 36) JBAS012605: Activated the following JSF Implementations: [main, 1.2]

    14:35:46,525 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension

    14:35:46,569 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)

    14:35:46,589 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)

    14:35:46,653 INFO [org.jboss.as.security] (MSC service thread 1-4) JBAS013170: Current PicketBox version=4.0.15.Final

    14:35:46,965 INFO [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting Naming Service

    14:35:47,148 INFO [org.jboss.as.mail.extension] (MSC service thread 1-4) JBAS015400: Bound mail session [java:jboss/mail/Default]

    14:35:47,206 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003001: Coyote HTTP/1.1 initializing on : http-/0.0.0.0:8080

    14:35:47,210 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003000: Coyote HTTP/1.1 starting on: http-/0.0.0.0:8080

    14:35:47,535 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/google/main/./

    14:35:47,550 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./

    14:35:47,596 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/infinispan/main/./

    14:35:47,607 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/file/main/./

    14:35:47,608 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/ldap/main/./

    14:35:47,639 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/google/main/./

    14:35:47,639 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/infinispan/main/./

    14:35:47,645 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/google/main/./

    14:35:47,648 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/file/main/./

    14:35:47,649 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/infinispan/main/./

    14:35:47,652 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/ldap/main/./

    14:35:47,653 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/file/main/./

    14:35:47,654 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/ldap/main/./

    14:35:47,691 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]14:35:47,709 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 44) TEIID50011 Security enabled for transport "odata" with security-domain set to teiid-s

    ecurity14:35:47,715 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 44) TEIID50011 Security enabled for transport "jdbc" with security-domain set to teiid-security

    14:35:47,716 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 44) TEIID50011 Security enabled for transport "odbc" with security-domain set to teiid-security

    14:35:47,799 INFO [org.jboss.ws.common.management] (MSC service thread 1-4) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.1.3.Final

    14:35:47,810 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./

    14:35:47,828 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./

    14:35:47,841 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./

    14:35:47,852 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./

    14:35:47,858 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/mongodb/main/./

    14:35:47,863 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/salesforce/main/./

    14:35:47,874 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/mongodb/main/./

    14:35:47,897 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/D:/sviluppo/teiid/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/mongodb/main/./

    14:35:47,933 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "jdbc-simple" added.

    14:35:47,943 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "jdbc-ansi" added.

    14:35:47,965 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "access" added.

    14:35:48,017 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "db2" added.

    14:35:48,012 INFO [org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 50) ISPN000128: Infinispan version: Infinispan 'Delirium' 5.2.1.Final

    14:35:48,054 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "derby" added.

    14:35:48,083 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "h2" added.

    14:35:48,101 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "hsql" added.

    14:35:48,121 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "informix" added.

    14:35:48,158 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "metamatrix" added.

    14:35:48,202 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "mysql" added.

    14:35:48,408 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "mysql5" added.

    14:35:48,450 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "oracle" added.

    14:35:48,483 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "postgresql" added.

    14:35:48,536 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "sqlserver" added.

    14:35:48,580 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "sybase" added.

    14:35:48,616 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "teiid" added.

    14:35:48,658 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 51) ISPN000031: MBeans were successfully registered to the platformMBean server.

    14:35:48,657 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 52) ISPN000031: MBeans were successfully registered to the platformMBean server.

    14:35:48,667 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 52) JBAS010281: Started preparedplan cache from teiid container

    14:35:48,659 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 50) ISPN000031: MBeans were successfully registered to the platformMBean server.

    14:35:48,666 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 51) JBAS010281: Started resultset-repl cache from teiid container

    14:35:48,677 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 50) JBAS010281: Started resultset cache from teiid container

    14:35:48,689 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "teradata" added.

    14:35:48,718 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "modeshape" added.

    14:35:48,734 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ingres" added.

    14:35:48,749 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ingres93" added.

    14:35:48,771 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "intersystems-cache" added.

    14:35:48,796 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "netezza" added.

    14:35:48,811 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "file" added.

    14:35:48,858 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ldap" added.

    14:35:48,867 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "loopback" added.

    14:35:48,876 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "olap" added.

    14:35:48,913 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "ws" added.

    14:35:48,922 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "salesforce" added.

    14:35:48,968 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "hive" added.

    14:35:48,992 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "jpa2" added.

    14:35:48,998 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "infinispan-cache" added.

    14:35:49,002 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "map-cache" added.

    14:35:49,084 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "odata" added.

    14:35:49,118 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 44) TEIID50006 Teiid translator "mongodb" added.

    14:35:49,218 INFO [org.jboss.as.remoting] (MSC service thread 1-2) JBAS017100: Listening on 127.0.0.1:9999

    14:35:49,221 INFO [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on 0.0.0.0:4447

    14:35:49,232 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "mysql-connector-java-5.1.22-bin.jar" (runtime-name: "mysql-connector-java-5.1.22-bin.jar")

    14:35:49,224 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mssql-vdb.xml" (runtime-name: "mssql-vdb.xml")

    14:35:49,261 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-odata-8.4.0.Final.war" (runtime-name: "teiid-odata-8.4.0.Final.war")

    14:35:49,264 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mssql-ds.xml" (runtime-name: "mssql-ds.xml")

    14:35:49,276 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) JBAS015012: Started FileSystemDeploymentService for directory D:\sviluppo\teiid\jboss-eap-6.1\standalone\deployments

    14:35:49,278 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "jtds-1.3.0.jar" (runtime-name: "jtds-1.3.0.jar")

    14:35:49,285 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mysql-ds.xml" (runtime-name: "mysql-ds.xml")

    14:35:49,551 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teiid Engine 8.4.0.Final Started = Fri Sep 12 14:35:49 CEST 2014

    14:35:49,979 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/embedded

    14:35:50,095 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/odata

    14:35:50,162 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50012 Teiid JDBC - Name = jdbc, Host = 0.0.0.0, Port = 31000, SSL = OFF, security-domains = [teiid-security]

    14:35:50,162 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50037 Teiid ODBC - Name = odbc, Host = 0.0.0.0, Port = 35432, SSL = OFF, security-domains = [teiid-security]

    14:35:50,286 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)

    14:35:50,431 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010404: Deploying non-JDBC-compliant driver class net.sourceforge.jtds.jdbc.Driver (version 1.3)

    14:35:50,573 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data source [java:/testmysql]

    14:35:50,574 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:/magoDS]

    14:35:51,174 INFO [org.jboss.web] (ServerService Thread Pool -- 51) JBAS018210: Register web context: /odata

    14:35:51,316 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB TestMSsql.1 model "TestMSsql" metadata is currently being loaded. Start Time: 12/09/14 14.35

    14:35:51,919 INFO [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 51) HV000001: Hibernate Validator 4.3.1.Final

    14:35:52,113 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 51) Deploying javax.ws.rs.core.Application: class org.teiid.odata.TeiidODataApplication

    14:35:52,437 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mysql-ds.xml" (runtime-name : "mysql-ds.xml")

    14:35:52,439 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mysql-connector-java-5.1.22-bin.jar" (runtime-name : "mysql-connector-java-5.1.22-bin.jar")

    14:35:52,440 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mssql-vdb.xml" (runtime-name : "mssql-vdb.xml")

    14:35:52,443 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mssql-ds.xml" (runtime-name : "mssql-ds.xml")

    14:35:52,447 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "jtds-1.3.0.jar" (runtime-name : "jtds-1.3.0.jar")

    14:35:52,455 INFO [org.jboss.as.server] (ServerService Thread Pool -- 44) JBAS018559: Deployed "teiid-odata-8.4.0.Final.war" (runtime-name : "teiid-odata-8.4.0.Final.war")

    14:35:52,548 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management

    14:35:52,549 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

    14:35:52,550 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss Teiid + Teiid 8.4 (AS 7.2.0.Alpha1-redhat-4) started in 9346ms - Started 392 of 47

    6 services (83 services are passive or on-demand)

    DB:2.82:Old Test Setup Can't Login At Web Console Anymore... kf


    Thanks, worked like a charm!

    reading "add-user" remindend me something, and trying to update the existing user password, i failed several ways because I forgot password requirements

    - not identical to username

    - must contain alpha + numeric + not alphanumeric digits...

    [edit]

    before, while struggling to regain access, I looked at the relevant mgmt-users.properties files, saw a bunch of numbers, so I could not regain the original password, or replace with another one because I don't know how is encrypted/salted

    and also saw those admin scripts, but thought I would need a valid user to actually run them... which is not, locally. ok. [/edit]

    Thank you very much... (going to document this in the internal wiki...)

    Marco

  • RELEVANCY SCORE 2.80

    DB:2.80:How To Write The Update Script xj



    I need a update script to update A column in Table A to B column in Table B, below is the update script which can run in MS SQL SERVER

    update a set a.COL_A = b.COL_B

    from TABLE_A a, TABLE_B b

    where a.ID = b.ID

    How can I write the script in Teiid?

    DB:2.80:How To Write The Update Script xj


    Thank you Ramesh, I find another way, I created a linked server in ms sqlserver, and the problem solved

  • RELEVANCY SCORE 2.80

    DB:2.80:Catch Exception In Procedure For Each Row jk



    Hi,

    In Teiid procedure FOR EACH ROW, is there any way to catch exception or put debug information in Teiid Designer?

    Because in runtime, when something is wrong in the procedure, Teiid doesnt invoke the call to real data source, we have no idea what's wrong.

    Thanks.

    DB:2.80:Catch Exception In Procedure For Each Row jk


    THEN is not used in an if statement. Did you see an errant example somewhere? Otherwise you should follow the Reference and you can always just check the grammar - https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQLGrammar-ifStatement

    Steve

  • RELEVANCY SCORE 2.80

    DB:2.80:Teiid30499 No Sources Were Given For The Model "Xyz" c9



    HI,

    I have created a VDB for Northwind database on Teiid-8.0.0.Final, JBoss-as-7.1.1.Final and SQL Server 2008.

    VDB deployed successfully, i able to query data, all select queries are working fine.

    But when i tried to create/update a record i got error as metioned below:

    Caused by: TEIID30499 No sources were given for the model Northwind

    at org.teiid.dqp.internal.process.CachedFinder.findCapabilities(CachedFinder.java:95) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.metadata.TempCapabilitiesFinder.findCapabilities(TempCapabilitiesFinder.java:61) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.canPushLanguageObject(CriteriaCapabilityValidatorVisitor.java:680) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.canPushLanguageObject(CriteriaCapabilityValidatorVisitor.java:666) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.relational.RelationalPlanner.addNestedProcedure(RelationalPlanner.java:615) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.relational.RelationalPlanner.createUpdatePlan(RelationalPlanner.java:533) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:497) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:154) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]

    ... 8 more

    NOTE: if i remove view model from vdb and only create vdb with source model then create/update works fine.

    Please find the VDB in attachments...

    Am i missing anything?

    any Help?

    regards,

    Nabeel Ahmed

    DB:2.80:Teiid30499 No Sources Were Given For The Model "Xyz" c9


    Nabeel,

    Hopefully you got the JIRA email, but just to make sure this has been resolved on trunk. We'll be releasing an alpha 2 this week that includes the fix.

    Thanks,

    Steve

  • RELEVANCY SCORE 2.79

    DB:2.79:How Are Meds Used By The Teiid Server sp



    I see in figure 6.5.0 at documentation link:

    http://docs.jboss.org/teiid/designer/8.5/user-guide/en-US/html/editing-model-objects-chapter.html#model-object-extension-properties-section

    a checkbox "Will be used by TeiiD server"

    I cannot find any other info relating to this..

    How can I 'find' the associated extensions and their values within a running vdb on TeiiD Server?

    DB:2.79:How Are Meds Used By The Teiid Server sp


    To allow extension properties to be altered at runtime.

  • RELEVANCY SCORE 2.79

    DB:2.79:Teiid In Maven Repository sx



    Hi all,Is TEIID server 6.2.0 deploy in an Maven repository somewhere ?In JBoss maven repo, I only see the 6.0.0(http://repository.jboss.com/maven2/org/jboss/teiid/)Is it possible to deploy this version in this repo ?Thanks for you help.RegardsDavid G.

    DB:2.79:Teiid In Maven Repository sx


    Sorry, it was an oversight on our part as this is a manual process. Note that the kit will not be available through maven, only compiled libraries. I have added a JIRA for thishttps://jira.jboss.org/jira/browse/TEIID-872. You can watch this JIRA to notify you when this task is completed.

  • RELEVANCY SCORE 2.79

    DB:2.79:How To Separate Result Into Pages Using Teiid kf



    We are trying to separate the search result of VDB into different pages since if there are many rows, performance is not accepted.

    Is there anyway to use Teiid to separate result into different pages? Or the client side of Teiid (the SQL executor) must implement this logic itself?

    DB:2.79:How To Separate Result Into Pages Using Teiid kf


    Jalen,

    There is a minor amount of batch caching (max of 3 batches using lru) on the client side when using scroll insensitive results, but full resultset caching is the job of the server. The cached results will be used by clients as if they were the real results on demand.

    Steve

  • RELEVANCY SCORE 2.79

    DB:2.79:Sql Subquery Question 9z


    As Teiid is required to handle the subquery in this way:

    "SELECT count(*) FROM ( QUERY_TO_BE_CALL) AS X" -- Adding "AS X"

    Is there any alternative way for Teiid to handle subquery ?

    DB:2.79:Sql Subquery Question 9z


    You can submit a request for Teiid to handle oracle style anonymous derived tables.

    Steve

  • RELEVANCY SCORE 2.77

    DB:2.77:Teiid Version On Jboss Server Not Same As Installed Runtime 9k



    I'm testing out Teiid runtime 8.9.1 and am wondering why the JBoss server management overview is showing the Teiid version as "+ Teiid 8.7"? I can deploy vdb's without issue but am seeing an error "This VDB was created in a newer version of Designer hence may contain properties that are not compatible with this version.", is the server to Designer "mismatch" the cause?

    Thanks

    Les

    DB:2.77:Teiid Version On Jboss Server Not Same As Installed Runtime 9k

    Can can safely ignore that. We only build "web-console" project only when there are any issues are features fixed/added, and version number as it designed currently takes static string for version. The last time we built it was around 8.7 release time, thus the display. BTW, if you want to fix your install you can edit "modules/system/layers/base/org/jboss/as/product/main/META-INF/MANIFEST.MF" file and update the version and restart the server.

    Thanks, that makes sense. Also, I couldn't figure out where that value was coming from so thanks for identifying where it is configured.

    I'm running Designer 9.0 and have just updated to 9.0.1

  • RELEVANCY SCORE 2.77

    DB:2.77:Help With Teiid Embedded Deployvdbzip x7



    I am getting started with teiid. I used teiid designer to create a vdb, and it works fine with jboss. I now want to use that vdb in teiid embedded, but I get exception on deployVDBZip

    Exception in thread "main" org.teiid.deployers.VirtualDatabaseException: TEIID40095 TEIID31070 Empty model;There are no tables, procedures or functions defined in this model mysql

    Here is my code...what am I missing ?

    public static void main(String[] args) throws Exception {

    final MysqlDataSource sql = new MysqlDataSource();

    sql.setURL("jdbc:mysql://localhost");

    sql.setUser("xxxx");

    sql.setPassword("xxxx");

    EmbeddedServer.ConnectionFactoryProviderDataSource jdbcProvider = new EmbeddedServer.ConnectionFactoryProviderDataSource() {

    @Override

    public DataSource getConnectionFactory() throws TranslatorException {

    return sql;

    }

    };

    Connection conn = jdbcProvider.getConnectionFactory().getConnection();

    // now start Teiid in embedded mode

    EmbeddedConfiguration ec = new EmbeddedConfiguration();

    ec.setUseDisk(true);

    EmbeddedServer teiidServer = new EmbeddedServer();

    teiidServer.start(ec);

    // configure the connection provider and translator for jdbc based source

    teiidServer.addConnectionFactoryProvider("mysql", jdbcProvider);

    teiidServer.addTranslator("mysql",new MySQLExecutionFactory());

    teiidServer.deployVDBZip(new URL("file:///tmp/empvdb.vdb"));

    }

    DB:2.77:Help With Teiid Embedded Deployvdbzip x7


    Thanks Ramesh for the response.

    I have the translator and data source defined and added (See code snippet in the first post), and I edited my vdb.xml to be what you suggested.

    I still get the same error about empty model, I guess there is something amiss with how I am setting up my datasource.

    Requesting assistance on another thread Teiid Embedded, TIMESTAMPDIFF with MYSQL DataBase for a working mysql datasource.

  • RELEVANCY SCORE 2.77

    DB:2.77:Problem With Using Web Services As Relational Source Model 9a



    Hello,

    I am new to Teiid and I am researching how Teiid can help me in solving some specific integration tasks. I was really impressed when I saw how easy it is to integrate MS SQL Server and text files as a data provider. This is really great!!! Now I try to use Web Service as data provider but here I have some problems. Could anybody help me, please?

    I use one free web service (just for testing and researching purposes) - http://www.webservicex.net/WeatherForecast.asmx?wsdl. The steps that I am performing are the following:
    1) Create new Model Project in Teiid Designer (I use Designer 6.3_v20100118).
    2) Right click on the project created, select import.
    3) In the Import dialog select Web Service as Relational Source Model.
    4) Enter the following wsdl URL - http://www.webservicex.net/WeatherForecast.asmx?wsdl (this is free web service which I use for testing)
    5) Select both WeatherForecastSoap operations, click finish.
    6) New connector was created.
    7) Drag and Drop Weather.xmi (my project is names Weather) into WeatherForecast connector.
    8) Select GetWeatherByPlaceName operation in Model Explorer. After double click I see three tables: WeatherData, GetWeatherByPlaceNameSoapIn and GetWeatherByPlaceNameSoapOut.
    9) Now I select GetWeatherByPlaceNameSoapIn and after clicking the running man I expect to see the dialog for input data (PlaceName parameter) but I see error message instead (Error occurred on connector WeatherForecast35 - Value not found for parameter PlaceName).

    I do not know what is wrong, why don't I see the output? Does anybody know what I do wrong? Thanks in advance!

    DB:2.77:Problem With Using Web Services As Relational Source Model 9a


    Thank you, John!

    I will try the steps you described.

    I am looking forward for the next release.

    - Denys

  • RELEVANCY SCORE 2.77

    DB:2.77:Transaction Error When Accessing 2 Data Source 97



    We created a simple vdb that will access 2 data sources(both are Microsoft SQL Server 2008 R2), for simplicity, each data source contains only one table. Then we create a view model that will contains only one table that will combine the 2 source table with INNER join.

    If we started a transaction and call the select the view model table, I got the following exception, how can I fix it?

    Thanks.

    14:15:27,249 WARN [com.arjuna.ats.arjuna] (Worker1_QueryProcessorQueue17) ARJUNA012140: Adding multiple last resources is disallowed. Trying to add LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@278195ae[connectionListener=65010b20 connectionManager=2c89e6c5 warned=false currentXid= formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffff2201e92e:-54aa0af2:53fe2e31:9, node_name=1, branch_uid=0:ffff2201e92e:-54aa0af2:53fe2e31:d, subordinatenodename=null, eis_name=java:/PROC_FIELD productName=Microsoft SQL Server productVersion=10.50.1617 jndiName=java:/PROC_FIELD])), but already have LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@184684cb[connectionListener=38dd6c5 connectionManager=118da65b warned=false currentXid= formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffff2201e92e:-54aa0af2:53fe2e31:9, node_name=1, branch_uid=0:ffff2201e92e:-54aa0af2:53fe2e31:c, subordinatenodename=null, eis_name=java:/PROC_WELL productName=Microsoft SQL Server productVersion=10.50.1617 jndiName=java:/PROC_WELL]))14:15:27,268 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue17) Connector worker process failed for atomic-request=lBsM4BVUJsmj.1.3.1: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@65010b20[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@389e98fa connection handles=0 lastUse=1409166927267 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@344d6220 pool internal context=SemaphoreArrayListManagedConnectionPool@b54b047[pool=PROC_FIELD] xaResource=LocalXAResourceImpl@278195ae[connectionListener=65010b20 connectionManager=2c89e6c5 warned=false currentXid=null productName=Microsoft SQL Server productVersion=10.50.1617 jndiName=java:/PROC_FIELD] txSync=null] at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:285) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:57) at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:186) [teiid-api-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:289) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:163) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:563) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:356) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:283) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:257) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.0.Final.jar:8.7.0.Final] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_60] at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_60]Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@65010b20[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@389e98fa connection handles=0 lastUse=1409166927267 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@344d6220 pool internal context=SemaphoreArrayListManagedConnectionPool@b54b047[pool=PROC_FIELD] xaResource=LocalXAResourceImpl@278195ae[connectionListener=65010b20 connectionManager=2c89e6c5 warned=false currentXid=null productName=Microsoft SQL Server productVersion=10.50.1617 jndiName=java:/PROC_FIELD] txSync=null] at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:281) ... 47 moreCaused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@65010b20[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@389e98fa connection handles=0 lastUse=1409166927267 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@344d6220 pool internal context=SemaphoreArrayListManagedConnectionPool@b54b047[pool=PROC_FIELD] xaResource=LocalXAResourceImpl@278195ae[connectionListener=65010b20 connectionManager=2c89e6c5 warned=false currentXid=null productName=Microsoft SQL Server productVersion=10.50.1617 jndiName=java:/PROC_FIELD] txSync=null] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:604) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139) ... 48 moreCaused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:474) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599) ... 50 moreCaused by: javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple ac, BasicAction: 0:ffff2201e92e:-54aa0af2:53fe2e31:9 status: ActionStatus.ABORT_ONLY at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:552) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:282) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467) ... 51 more

    DB:2.77:Transaction Error When Accessing 2 Data Source 97


    Are you still seeing the exception after using xa data sources?

  • RELEVANCY SCORE 2.77

    DB:2.77:Accessing Admin Api In Teiid 7.0 ff


    Hi,

    DB:2.77:Accessing Admin Api In Teiid 7.0 ff


    Thank you very much for the prompt reply. My bad that I couldn't spend more time to find it in the docs, I will spend more time next time onwards as it proves lot of things are well documented.You guys are awesome.

    Thanks,

    Abraham

  • RELEVANCY SCORE 2.77

    DB:2.77:How To Run Teiid 8.1 In Embedded Mode 3f



    I heard Teiid 8.1 could run in embedded mode like Teiid 6.2. Is it true? Does it still require JBoss for Teidd 8.1 to run in embedded mode? I have downloaded Teiid 8.1 Alaph 2, but I couldn't find any example about running in embedded mode. If someone can point a link/ example how to run Teiid 8.1 in embedded mode, I will be greatly appreciated. Thanks a lot!

    - Ivan C.

    DB:2.77:How To Run Teiid 8.1 In Embedded Mode 3f


    Thanks for your quick response! You guys are just awesome! Thank you so much!

    Man-Kit

  • RELEVANCY SCORE 2.76

    DB:2.76:Interaction Php And Teiid 7m



    I want to use teiid to combine data from sql and oracle for web-project. Will I be able to make a connection to the teiid of php script. If so, is there a manual for working with teiid of PHP. I apologize for my English. Use google translate

    DB:2.76:Interaction Php And Teiid 7m


    There are a couple of options for using JDBC with PHP, but it seems simpler to use Teiid ODBC access instead. See https://docs.jboss.org/author/display/TEIID/ODBC+Support to setup a PostgreSQL client DSN on your system that points to Teiid. You would then use something like http://php.net/manual/en/function.odbc-connect.php to consume it from PHP. I don't think that anyone has reported using Teiid through PHP, but it should work given you're using a known PostgreSQL client.

  • RELEVANCY SCORE 2.75

    DB:2.75:How To Replace The Cfg And Hbm Files In Hibernate When Using Teiid For Persistence cz



    previously i used hibernate for persistence.Now i need to use teiid for persistence. in hibernate we have cfg and hbm mapping files. in teiid what we have for mapping and for configuration?

    how to map and configure them?

    DB:2.75:How To Replace The Cfg And Hbm Files In Hibernate When Using Teiid For Persistence cz


    Teiid provides Hibernate Dialect and JDBC driver. Use those to configure the hibernate configuration files. See https://docs.jboss.org/author/display/teiid84final/Using+Teiid+with+Hibernate

    Ramesh..

  • RELEVANCY SCORE 2.75

    DB:2.75:Insert Data From Sql To Mysql Using Teiid dp



    Hi,

    Can someone point me to documentation or give me pointers on how to insert data to a MySQL table from SQL table using Teiid designer?

    Cheers

    DB:2.75:Insert Data From Sql To Mysql Using Teiid dp


    Thanks Stephen and Ramesh.

    I was able to insert data after trying on a local scaled down database as opposed to a remote MySQL complex MySQL.

    Could be connection problems or validation issues.

    i will find out.

  • RELEVANCY SCORE 2.75

    DB:2.75:What Is The Replacement Of "Selectsymbol" And "Singleelementsymbol" In Teiid 8.1.0beta1 mx



    Hi,

    I am upgrading my application from Teiid 7.6 to Teiid 8.1.0Beta1. Earlier i had these two classes(mentioned below) but i can't see these classe in new Teiid jars. Can you please let me what is the replacement of these java classes ?

    org.teiid.query.sql.symbol.SelectSymbol;

    org.teiid.query.sql.symbol.SingleElementSymbol;

    Thanks!

  • RELEVANCY SCORE 2.75

    DB:2.75:Teiid Jndi Sql Server Connection Settings - Implicit_Transactions Off And Persistent Connection a9



    I am testing the database connection using the Microsoft sqljdbc4 driver. I noticed that teiid uses the following connection settings by default:

    transaction isolation level read committed

    implicit_transactions on

    I want to change them to so that I do not need to worry about the blocking.

    set transaction isolation level read uncommitted

    set implicit_transactions off

    1. Teiid designer does not support changing these settings. So I modified the data source in the standalone_teiid.xml file as below. But from SQL server profiler, it still uses the default settings. Does anyone know where to override the default connection setting? By the way applicationIntent=ReadOnly is for the SQL 2012 HA.

    datasource jndi-name="java:/AdventureWorks" pool-name="AdventureWorks" enabled="true"

    connection-urljdbc:sqlserver://server1:1433;databaseName=AdventureWorks2012;applicationIntent=ReadOnly;InitializationString=set transaction isolation level read uncommitted;/connection-url

    driversqljdbc4.jar/driver

    security

    user-nameuser1/user-name

    passwordxxxxx/password

    /security

    /datasource

    2. After I disconnect connection (e.g.SQL workbenchfrom Teiid, I noticed that Teiid runtime still have a connection on the SQL server. Why Teiid still hold the connection after client application disconnects? Is it because Teiid uses connection pooling? If yes, is there a way to turn off? Will Teiid ever release the connection at all?

    3. By this MS doc - http://docs.oracle.com/cd/E13157_01/wlevs/docs30/jdbc_drivers/mssqlserver.html, we can set multiple options for the InitializationString parameter, but if I do that, teiid will not run. Could someone advise if this is possible in Teiid? As I mentioned, I mainly use Teiid for data warehousing type of read. The default settings can cause performance issue on SQL server.

    InitializationString=(set transaction isolation level read uncommitted;set implicit_transactions off);

    Thanks in advance.

  • RELEVANCY SCORE 2.74

    DB:2.74:Error When Using Teiid Client Jdbc - Cause : Package Sun.Uti kx



    Hi all,Here is our problem.We are embedding the teiid client jdbc in one of our bundle on OSGI to connect to teiid server in order to request a Virtual Database previously created on teiid designer.When our bundle is requesting for teiid client jdbc we have an error saying that class sun.util.calender.Zoneinfo cannot be loaded by our OSGI framework.Is this class used in Teiid client jdbc ?Thanks for your help

    DB:2.74:Error When Using Teiid Client Jdbc - Cause : Package Sun.Uti kx


    No, It not being used directly anywhere in the code, however in Sun JDK it is used byjava.util.Datejava.util.Calenderclasses. These Teiid certainly uses them in the code. Are you using Sun JDK? This exception happening during the creation of the jdbc connection?During the connection time if you are using "File path profile", we do use a post-delegation model to load all the Teiid libraries, and we properly delegate any java or javax classes to higher class loader. The Designer tool uses Teiid in the Eclipse as a plug-in module too, we have not seen this specific issue.may be you can debug and find the source class which is trying to load this class?

  • RELEVANCY SCORE 2.73

    DB:2.73:How Teiid Behaves In Distributed System ? k1



    Hi,

    I am new to Teiid and looking some of the experienced folks with teiid wo can answer my queries. I would like to know that how teiid behaves in distributed system. If i configure the teiid in such a way that it caches the result set , than how does that cached data gets distributed over the distributed system. Say i have four instances of teiid (data nodes) , than how would i define the data replication strategy. Does there is a 100% data replication at each data node ?

    What about failovers , how its reacts to that , are there any controller nodes over data nodes and how to configure them ?

    It will be great if some one can explain the brief architecture of teiid in Distributed system.

    Also if i like to use the teiid in embedded mode than, is clustering supported in teiid in embedded mode ?

    Thanks

    Himanshu Kapoor

    DB:2.73:How Teiid Behaves In Distributed System ? k1

    Is there any plan to implement the feature like below in embedded mode in near future
    No, it would be a different for each environment based on services the environment it provides. What Teiid provides you is framework and hooks into Teiid, such that inclined individuals like you can fill in those services to make it work for your needs.

    teiid run times talking to each other in distributed environment ?

    propogation of metadata in in distributed environment ?

    I do not know what u mean by talking, Yes, as I mentioned in my previous post, if you use the Teiid deployed in the AS7 environment in the domain mode, caching services are distributed. The deployment of metadata (deploying of VDBs, translators, data sources) are done across the cluster. Pls read the Caching Guide for more information.

    Ramesh..

  • RELEVANCY SCORE 2.72

    DB:2.72:Reading Teiid-Connector-File.Rar Resource Adapter Configuration And Properties k1



    Hi Evryone!

    How can i read the connection properties of any teiid resource adaptor defined in ra.xml programatically. e.g teiid-connector-file.rar or teiid-connector-ldap.rar or teiid-connector-salesforce.rar.

    So that i could make a standard app that allows user to create resource adapter connections.

    Thanks

    Kamran

    DB:2.72:Reading Teiid-Connector-File.Rar Resource Adapter Configuration And Properties k1


    Thanks Ramesh.

    i have logged it

    https://issues.jboss.org/browse/TEIID-2314

    Thanks

    Kamran

  • RELEVANCY SCORE 2.72

    DB:2.72:Quoted Column Name Bug? mz



    I had a problem with this on Teiid 7.3 that I was hoping 7.6 would resolve.

    But unfortunately it did not Anyone have a suggested workaround or quick fix ?

    Teiid query:

    select "__objecttype__" from SECCM.CMCOMMONVIEW LIMIT 10

    Error Code:0 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:0 Message:SECCM: Error Code:0 Message:'Lexical error: Lexical error at line 1, column 12. Encountered: "_" (95), after : ""' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.__objecttype__ AS c_0 FROM ( select "__objecttype__", evttypecode, evtversion , evtcatcode , evtsysid , evtsysplex , evtutctod , evtsystod ,

    Note that teiid view is defined with column as __objecttype__ .

    Ex.

    models

    model name="SECCM"

    view name="CMCOMMONVIEW"

    definition

    select datamart_name, "__objecttype__", evttypecode, evtversion , evtcatcode , evtsysid , evtsysplex , evtutctod , evtsystod ,

    evtesmcode , evtpuuid , evtuserid , evtusername, evtjobname , evtsource , admtarget , Commandstr, oprcode ,

    vio1code , vio2code , evttypedesc , evtcatdesc

    FROM (

    #foreach($t in $db.query("select DATAMART_NAME, MODEL_NAME from security_db.config WHERE TYPE = 'DM'"))

    select u.datamart_name, u."__objecttype__", u.evttypecode, u.evtversion , u.evtcatcode , u.evtsysid , u.evtsysplex , u.evtutctod , u.evtsystod ,

    u.evtesmcode , u.evtpuuid , u.evtuserid , u.evtusername, u.evtjobname , u.evtsource , u.admtarget , u.Commandstr, u.oprcode ,

    u.vio1code , u.vio2code , tp.evttypedesc , ct.evtcatdesc

    FROM (

    select '${t.DATAMART_NAME}' as DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' as "__objecttype__", a.evttypecode , a.evtversion , a.evtcatcode , a.evtsysid ,

    a.evtsysplex , a.evtutctod , a.evtsystod , a.evtesmcode , a.evtpuuid , a.evtuserid , a.evtusername, a.evtjobname ,

    a.evtsource , a.admtarget , a.admacctstr as Commandstr, a.oprcode , a.vio1code , a.vio2code

    from ${t.MODEL_NAME}.ADMACCOUNT a

    Please see attached for showplan output.

    Thanks,

    Jeff

    ...

    DB:2.72:Quoted Column Name Bug? mz


    In the attached log I see an access node with the source query 'SELECT g_0."__objecttype__" AS c_0 FROM SECCM.CMCOMMONVIEW AS g_0 LIMIT 10', then the exception with a query that has an inlineview, but does not have the __objecttype__ column properly aliased. There's nothing in between. Anything that shows what formed that invalid query would be useful.

    Steve

  • RELEVANCY SCORE 2.72

    DB:2.72:Jboss And Teiid Federated Plans km



    hello ,

    now i use jboss AS 7.1 with teiid 8.2 。And after i see the Federated Plans chapter in Federated Planning - Teiid 8.2 - Project Documentation Editor

    i knew the plan of executing a query by muti-source. this is part of my programmes :

    String url = "jdbc:teiid:myvdb@mm://192.168.7.83:31000";

    String sql = "select hour(start_time) cnt From GPRS_USER_SERVICE_BDR030427 where roam_city=20 group by hour(start_time)";

    try

    {

    Class.forName("org.teiid.jdbc.TeiidDriver").newInstance();

    Connection connection = DriverManager.getConnection(url, "user", "user");

    Statement statement = connection.createStatement();

    statement.execute("set showplan on");

    statement.execute("set partialResultsMode true");

    ResultSet results = statement.executeQuery(sql);

    TeiidStatement tstatement = statement.unwrap(TeiidStatement.class);

    PlanNode queryPlan = tstatement.getPlanDescription();

    System.out.println(queryPlan);}

    and follow is my output plan:

    ProjectNode

    + Output Columns:cnt (integer)

    + Statistics:

    0: Node Output Rows: 2

    1: Node Process Time: 0

    2: Node Cumulative Process Time: 266

    3: Node Cumulative Next Batch Process Time: 37

    4: Node Next Batch Calls: 48

    5: Node Blocks: 47

    + Cost Estimates:Estimated Node Cardinality: -1.0

    + Child 0:

    GroupingNode

    + Output Columns:gcol0 (integer)

    + Statistics:

    0: Node Output Rows: 2

    1: Node Process Time: 12

    2: Node Cumulative Process Time: 266

    3: Node Cumulative Next Batch Process Time: 37

    4: Node Next Batch Calls: 48

    5: Node Blocks: 47

    + Cost Estimates:Estimated Node Cardinality: -1.0

    + Child 0:

    UnionAllNode

    + Output Columns:start_time (timestamp)

    + Statistics:

    0: Node Output Rows: 24306

    1: Node Process Time: 0

    2: Node Cumulative Process Time: 254

    3: Node Cumulative Next Batch Process Time: 5

    4: Node Next Batch Calls: 69

    5: Node Blocks: 57

    + Child 0:

    AccessNode

    + Output Columns:start_time (timestamp)

    + Statistics:

    0: Node Output Rows: 12153

    1: Node Process Time: 226

    2: Node Cumulative Process Time: 226

    3: Node Cumulative Next Batch Process Time: 3

    4: Node Next Batch Calls: 35

    5: Node Blocks: 29

    + Query:SELECT g_0.start_time FROM mysql5.zhangwf.GPRS_USER_SERVICE_BDR030427 AS g_0 WHERE g_0.roam_city = 20

    + Model Name:mysql5

    + Model Name:mysql5

    + Child 1:

    AccessNode

    + Output Columns:start_time (timestamp)

    + Statistics:

    0: Node Output Rows: 12153

    1: Node Process Time: 254

    2: Node Cumulative Process Time: 254

    3: Node Cumulative Next Batch Process Time: 2

    4: Node Next Batch Calls: 63

    5: Node Blocks: 57

    + Query:SELECT g_0.start_time FROM mysql5.zhangwf.GPRS_USER_SERVICE_BDR030427 AS g_0 WHERE g_0.roam_city = 20

    + Model Name:mysql5

    + Model Name:mysql5

    + Grouping Columns:hour(start_time)

    + Sort Mode:false

    + Select Columns:anon_grp0.gcol0 AS cnt

    and i make a conclude that it execute query first : SELECT g_0.start_time FROM mysql5.zhangwf.GPRS_USER_SERVICE_BDR030427 AS g_0 WHERE g_0.roam_city = 20 in every source node ,then in teiid it will integrate data by

    sql :select hour(start_time) cnt From GPRS_USER_SERVICE_BDR030427 where roam_city=20 group by hour(start_time) ; and i want to know if we can set convert rules . we hope that in source node it can exeute the original sql:select hour(start_time) cnt From GPRS_USER_SERVICE_BDR030427 where roam_city=20 group by hour(start_time) which can get less data than SELECT g_0.start_time FROM mysql5.zhangwf.GPRS_USER_SERVICE_BDR030427 AS g_0 WHERE g_0.roam_city = 20 . after that ,teiid integrate the data from the resultsset. it means that we don't need the convert to internal form. Is there some solutions?

    DB:2.72:Jboss And Teiid Federated Plans km


    Yes, you need to unzip the resteasy modules zip file over the JBoss EAP modules directory and merge them, so that new version of RestEasy is installed.

  • RELEVANCY SCORE 2.71

    DB:2.71:Error Executing Sql Query With Order By Case When... ms



    I am using a Teiid (version 8.3) VDB as a source for a Mondrian cube. Modrian is issuing a query as below:

    select "V_DIM_JOB"."JOB_ID" as "c0" from "BIRTView"."V_DIM_JOB" as "V_DIM_JOB" group by "V_DIM_JOB"."JOB_ID" order by CASE WHEN "V_DIM_JOB"."JOB_ID" IS NULL THEN 1 ELSE 0 END, "V_DIM_JOB"."JOB_ID" ASC

    We are getting the following exception from Teiid:

    org.teiid.jdbc.TeiidSQLException: TEIID30088 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30088 Unrelated order by column CASE WHEN V_DIM_JOB.JOB_ID IS NULL THEN 1 ELSE 0 END cannot be used in a SET query, with SELECT DISTINCT, or GROUP BY)

    What is wrong with the query?

    Thanks

    DB:2.71:Error Executing Sql Query With Order By Case When... ms


    We are not allowing a unrelated expression (a ordering column that does not appear in the select clause) when grouping (or any non-simple select) is used. I believe this comes from the specification although it is something that can obviously be relaxed but would require an enhancement.

    In this specific case we would prefer the use of an explicit null ordering:

    select "V_DIM_JOB"."JOB_ID" as "c0" from "BIRTView"."V_DIM_JOB" as "V_DIM_JOB" group by "V_DIM_JOB"."JOB_ID" order by "V_DIM_JOB"."JOB_ID" ASC NULLS FIRST

    In general you could also use inline views.

    Steve

  • RELEVANCY SCORE 2.71

    DB:2.71:Out Join Exception z1



    When we do this sql

    SELECT

    NVL(o.optionvalue,dp.Value_) AS PARM_VAL_TXT,

    FROM

    Drillstring_Prm dp LEFT OUTER JOIN

    OPTIONLIST o ON dp.parameter_=o.nameinsource and dp.value_=o.number

    WHERE dp.Value_ IS NOT NULL;

    we got the followng exception, what does the assertion mean?

    16:22:29,963 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue68) TEIID30019 Unexpected exception for request PvsT90Mvv9wD.7: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.4.0.Final.jar:8.4.0.Final] at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.4.0.Final.jar:8.4.0.Final] at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.4.0.Final.jar:8.4.0.Final] at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:302) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:64) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:85) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.SourceState.sort(SourceState.java:312) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.MergeJoinStrategy.loadRight(MergeJoinStrategy.java:348) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadRight(EnhancedSortMergeJoinStrategy.java:257) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:208) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:101) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:149) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_27] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_27] at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27]

    thanks,

    Kevin

    DB:2.71:Out Join Exception z1


    You are seeing [TEIID-2681] Test Case failures in teiid-engine - JBoss Issue Tracker which is due to running on windows (as you can imagine all of the devs / build servers were on linux). The bulk if not all of the test issues discovered were addressed in 8.6. It was left as unresolved as there was still an odd difference that Rakesh saw with the postgres jdbc driver in an integration test which could not be explained nor was he able to debug to fully understand. You can cherry pick the commits to your fork or assuming that you are in a standard timezone, then all you may need to do is just set the line.separator.

  • RELEVANCY SCORE 2.70

    DB:2.70:Create Persistent Vdb With Teiid mp



    Hi guys,

    someone can say me if it's possible to create a persistent VDB with Teiid like a physical table??Or It works in caching mode??

    Thanks a lot

    Giuseppe

  • RELEVANCY SCORE 2.70

    DB:2.70:How Teiid 8.1final Support Stored Procedure With Out Parameters? pk



    I am trying to call a stored procedure with OUT parameter from eclipselink, I got the following exceptions:

    org.teiid.core.TeiidProcessingException: TEIID30490 Remote org.teiid.api.exception.query.QueryValidatorException: TEIID30490 The query does not return an update count.

    at org.teiid.dqp.internal.process.Request.createCommandContext(Request.java:211) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:469) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:390) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_32]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_32]

    The stored procedure is a simple dummy one, it will take no input parameter, has only one output parameter as Integer, and I just put a number into it, when running from SQL server studio, it would give out value 77.

    CREATE PROCEDURE [dbo].[CustOrdersDetail] @OrderID int OUTPUT AS SELECT @OrderID = COUNT(*) FROM PRODUCTS

    But If I called the same stored procedure from eclipselink, before it reached the SQL Server, the teiid validataion throws the above exception, the eclipselink code is like this:

    StoredProcedureCall spcall = new StoredProcedureCall();

    spcall.setProcedureName("CustOrdersDetail");

    spcall.addNamedOutputArgument("OrderID", "OrderID", Integer.class);

    ValueReadQuery query = new ValueReadQuery();

    query.setCall(spcall);

    Object orderId = em.getActiveSession().executeQuery(query);

    The place that throw the exception is from Request.createCommandContext(), in this case the returnsResultSet=false, returunsUpdateCount=fase becasue the command is StoredProcedure, the ResultsMode is UPDATECOUNT

    protected void createCommandContext(Command command) throws QueryValidatorException {

    boolean returnsResultSet = command.returnsResultSet();

    this.returnsUpdateCount = !(command instanceof StoredProcedure) !returnsResultSet;

    if ((this.requestMsg.getResultsMode() == ResultsMode.UPDATECOUNT !returnsUpdateCount)

    || (this.requestMsg.getResultsMode() == ResultsMode.RESULTSET !returnsResultSet)) {

    throw new QueryValidatorException(QueryPlugin.Event.TEIID30490

    From the 8.1 documentatin it mentions it supports OUT parameters, how can I get it to work with eclipselink?

    Thanks.

    DB:2.70:How Teiid 8.1final Support Stored Procedure With Out Parameters? pk


    By the Statement javadoc, yes you could make the case that our check goes too far. All we need to check for is that the query does not return a resultset, not that it does return an update count.

  • RELEVANCY SCORE 2.70

    DB:2.70:What Is Replacement Of Supportsbetweencriteria() Method In Teiid 8 mz



    Hi,

    We are upgrading our application to Teiid 8.1.0 Final from Teiid 7.6.

    What is the replcement of these methods in Teiid 8 -

    public boolean supportsBetweenCriteria()public boolean supportsCaseExpressions()public boolean supportsInsertWithIterator()

    Moreover "org.teiid.language.IteratorValueSource" object is also not available in Teiid 8. Please suggest how to handle it.

    Thanks !

    Manoj

  • RELEVANCY SCORE 2.69

    DB:2.69:Recent Blog Post Concerning Teiid 8.4 And Jboss Eap 6.1 9m



    You mentioned in your recent blog post that Teiid 8.4 is going to be based on JBoss EAP 6.1. Will all future versions of Teiid be based on EAP? Or is this an interim decision until such time as JBoss AS 8 is released GA?

    Also, do you forsee any compatibility problems with using Teiid 8.4+ with JBoss 7.1.1. Requiring JBoss EAP raises complications for us.

    DB:2.69:Recent Blog Post Concerning Teiid 8.4 And Jboss Eap 6.1 9m


    Thank you for the link to this other post. That clarifies the situation for me.

  • RELEVANCY SCORE 2.69

    DB:2.69:Error Querying A View Model Using Multi-Source Source Models cz



    I am using Teiid 8.4

    I have two multi-source source models

    I created a view model with one table that does a join across the tables in the source models.

    When I run a query against the View table, I get the following error:

    If I change my source models to single source, then there is a no problem.

    Is it not possible to build a federated view that uses multi-source source models?

    Thanks in advance

    Srini

    18:16:44,065 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue68) TEIID30019 Unexpected exception for request 18LSw7tJq5dy.13: org.teiid.core.TeiidComponentException: TEIID30554 A single source is not assigned to model OW5000 in VDB name EDMOWMultiFederated.1
    at org.teiid.dqp.internal.process.DataTierManagerImpl.createRequest(DataTierManagerImpl.java:924) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:647) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:175) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:412) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:195) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:140) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:230) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:136) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_27]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_27]
    at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27]

    DB:2.69:Error Querying A View Model Using Multi-Source Source Models cz


    [TEIID-2895] Missing message for multi-source validation - JBoss Issue Tracker corrected the error message.

  • RELEVANCY SCORE 2.69

    DB:2.69:Postgresql Limit, Offset And Order By Clauses Omitted By Teiid During Translation 9x



    Hello guys. Sorry I'm kind of new to Teiid and I encountered this problem.

    Please see below for the details:

    Input PostgreSQL statements:

    a) SELECT column FROM table ORDER BY column OFFSET offset ROW FETCH NEXT limit ROWS ONLY

    b) SELECT column FROM table ORDER BY column LIMIT limit

    Output from Teiid Driver (after translation/optimization):

    a) b) SELECT column FROM table

    Questions:

    (1) I would like to know what could be the possible causes why LIMIT, OFFSET and ORDER BY are removed.

    (2) Is there a way to "skip" optimization of SQL statements?

    I saw one post (not JBoss site) that adding NON_STRICT would do the trick but it didn't work for me.

    Additional Information:

    Teiid Driver Version: teiid-7.7.0.Final-client.jar

    PostgreSQL Version: 9.0.4

    Thank you very much guys.

    DB:2.69:Postgresql Limit, Offset And Order By Clauses Omitted By Teiid During Translation 9x


    Hello Ramesh,

    OK. I'll try your suggestion (re: SimpleClient.java) and post feedback here.

    Thanks.

  • RELEVANCY SCORE 2.68

    DB:2.68:Unable To Deploy The Vdb After Applying The Nightly Build On Eap 6.1 as



    I applied the nightly build teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip on JBoss EAP 6.1 installation and tried to deploy my vdb on to teiid server.

    The vdb is failing to deploy giving this error.

    "One or more models in VDB are either missing a translator name or have a translator name that is not found on the current Teiid server. Cannot Execute INACTICE VDB.

    Here is the console output when i start the server (attached.).I don't see any error in my output after the server is up. but not sure why i am unable to deploy the vdb.

    DB:2.68:Unable To Deploy The Vdb After Applying The Nightly Build On Eap 6.1 as


    Also is the message from Designer? I don't see a message similar to that on our side.

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Quickly Add 1 More Table/View To My Source Model? z1



    Using Teiid Designer 8.3

    I have a database in SQL Server as my data source that contains a few tables and a few views.

    I created a source model for this data source using the "Create Source Model for JDBC data source" wizard (see below)

    Now, the underlying data source has added 1 extra view.

    How do I add just the 1 view to my source model? I couldn't figure out how to do this in the Teiid designer. I'm hoping I won't have to recreate my Source Model and therefore the View Model.

    DB:2.68:How To Quickly Add 1 More Table/View To My Source Model? z1


    Fixed. If I re-launch the same wizard ("Create source model for JDBC data source") and specify the existing source model name and it allows me to manage the differences.

    Thanks.

  • RELEVANCY SCORE 2.68

    DB:2.68:Teiid Hibernate Project x8



    Hi,

    previously i used hibernate for persistence.now i need to use teiid for persistence.How Can i do it by using the hibernate code?How to configure the db properties in hibernate.cfg file? what about hbm files in teiid?

    DB:2.68:Teiid Hibernate Project x8


    Take a look at the Teiid hibernate quickstart: https://github.com/teiid/teiid-quickstarts/tree/master/hibernate-on-top-of-teiid

    This might be able to help.

    Van

  • RELEVANCY SCORE 2.68

    DB:2.68:Does Teiid Support Normal Sql To Insert/Update/Delete Database? a1



    For SELECT, it can be done directly.

    For INSERT/UPDATE/DELETE, I have several questions:

    1) I must write virtual procedures for these SQLs in Teiid Designer, right?

    2) From end user side, he can use normal SQL to INSERT/UPDATE/DELETE database directly, instead of calling the virtual procedure. Am I right?

    3) For #2, can I also call the procedure from end user side, right?

    4) Are above items documented in the offical documentation?

    Thanks a lot.

    DB:2.68:Does Teiid Support Normal Sql To Insert/Update/Delete Database? a1


    1) virtual procedures are not required. Based upon your needs you can optionally use virtual procedures or view update procedures to handle updates.

    2) you can issues updates directly to the physical model, but that is not quite the same as issuing directly to the database. The SQL must still be targeted to Teiid.

    3) imported stored procedure and virtual procedures may be called from the client.

    4) you may be looking more for a recommended approach rather than a specific section of doc. The docs do cover issuing update statements and calling stored procedures and do not mandate that you must create virtual procedures. Is there something that you need procedure logic for?

    Steve

  • RELEVANCY SCORE 2.68

    DB:2.68:Teiid Jdbc And Odbc Transport Services Don't Startup? x1



    My Teiid 8.2 Final,Teiid Designer 8.0, Eclipse Juno 4.2 on RHEL 6.2, uses standard teiid-standalone.xml configured with mysql-connector-java-5.1.22-bin.jar in modules under jbossinstalldir.

    When I click jdbc connection test in teiid server properties page in eclipse, ILogon Exception is thrown with componentnotfoundexception error, and can not establish jdbc connection for vdb.

    Any hint is appreciated, thanks.

    Console output, where the problems arise, is as follows:

    10:49:06,773 WARN [com.arjuna.ats.arjuna] (Transaction Expired Entry Monitor) ARJUNA012210: Unable to use InetAddress.getLocalHost() to resolve address.

    10:49:07,451 INFO [org.infinispan.jmx.CacheJmxRegistration] (pool-11-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.

    10:49:07,466 INFO [org.infinispan.jmx.CacheJmxRegistration] (pool-10-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.

    10:49:07,467 INFO [org.jboss.as.clustering.infinispan] (pool-11-thread-1) JBAS010281: Started resultset-repl cache from teiid container

    10:49:07,467 INFO [org.jboss.as.clustering.infinispan] (pool-10-thread-1) JBAS010281: Started resultset cache from teiid container

    10:49:07,805 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

    10:49:07,821 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data source [java:jboss/datasources/MySqlDS]

    10:49:08,232 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teiid Engine 8.2.0.Final Started = Wed Dec 26 10:49:08 EET 2012

    10:49:08,266 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine

    10:49:28,681 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service

    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_09]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_09]

    at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09]

    Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address

    at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82)

    at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103)

    at org.teiid.transport.SocketListener.init(SocketListener.java:55)

    at org.teiid.jboss.TransportService.start(TransportService.java:171)

    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

    ... 3 more

    10:49:38,656 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC00001: Failed to start service jboss.teiid.transport.odbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.odbc: Failed to start service

    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_09]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_09]

    at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09]

    Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address

    at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82)

    at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103)

    at org.teiid.transport.SocketListener.init(SocketListener.java:55)

    at org.teiid.transport.ODBCSocketListener.init(ODBCSocketListener.java:43)

    at org.teiid.jboss.TransportService.start(TransportService.java:195)

    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

    ... 3 more

    10:49:38,886 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

    JBAS014777: Services which failed to start: service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service

    service jboss.teiid.transport.odbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.odbc: Failed to start service

    10:49:39,363 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "teiid-connector-ldap.rar"

    10:49:39,336 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-connector-file.rar"

    10:49:39,336 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "teiid-connector-ws.rar"

    10:49:39,363 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "teiid-connector-google.rar"

    10:49:39,402 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-connector-salesforce.rar"

    10:49:39,403 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "teiid-connector-infinispan.rar"

    10:49:43,705 WARN [org.jboss.as.dependency.private] (MSC service thread 1-2) JBAS018567: Deployment "deployment.teiid-connector-ws.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

    10:49:43,706 WARN [org.jboss.as.dependency.private] (MSC service thread 1-2) JBAS018567: Deployment "deployment.teiid-connector-ws.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

    10:49:43,711 WARN [org.jboss.as.dependency.private] (MSC service thread 1-3) JBAS018567: Deployment "deployment.teiid-connector-salesforce.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

    10:49:43,732 WARN [org.jboss.as.dependency.private] (MSC service thread 1-3) JBAS018567: Deployment "deployment.teiid-connector-salesforce.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

    10:49:43,796 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.client.hotrod:main") which may be changed or removed in future versions without notice.

    10:49:43,798 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.cachestore.remote:main") which may be changed or removed in future versions without notice.

    10:49:43,800 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.jboss.as.clustering.infinispan:main") which may be changed or removed in future versions without notice.

    10:49:43,801 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.client.hotrod:main") which may be changed or removed in future versions without notice.

    10:49:43,804 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.cachestore.remote:main") which may be changed or removed in future versions without notice.

    10:49:43,805 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.jboss.as.clustering.infinispan:main") which may be changed or removed in future versions without notice.

    10:49:45,030 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-ldap.rar-281802927d6ee376/contents/

    10:49:45,030 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-infinispan.rar-4925f4a8b1ad681e/contents/

    10:49:45,278 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-salesforce.rar-675841adf342758e/contents/

    10:49:45,344 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-google.rar-21c5436daa9ca3/contents/

    10:49:45,350 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-file.rar-a92525716a9a3b28/contents/

    10:49:45,355 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-ws.rar-6bd64c425c53dff5/contents/

    10:49:45,475 INFO [org.jboss.as] (MSC service thread 1-4) JBAS015951: Admin console listening on http://127.0.0.1:9990

    10:49:45,475 ERROR [org.jboss.as] (MSC service thread 1-4) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 80736ms - Started 327 of 431 services (2 services failed or missing dependencies, 100 services are passive or on-demand)

    10:49:46,034 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-infinispan.rar"

    10:49:46,036 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-salesforce.rar"

    10:49:46,036 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-file.rar"

    10:49:46,037 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-google.rar"

    10:49:46,038 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ldap.rar"

    10:49:46,038 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ws.rar"

    DB:2.68:Teiid Jdbc And Odbc Transport Services Don't Startup? x1


    AS by default binds to 127.0.0.1, if for whatever reason your networking configuration does not allow the default localhost host address, then you would get these "Failed to resolve the bind address" and "Unable to use InetAddress.getLocalHost() to resolve address." errors. See https://community.jboss.org/message/746902 for a similar situation. Check if you have a firewall preventing access and/or use a different default bind address in the standalone.xml.

    Steve

  • RELEVANCY SCORE 2.68

    DB:2.68:Set Up Teiid Vdb To Use Ldap Authentication fa



    I am new to Teiid data virtualization. Does Teiid VDB (not admin console or LDAP data source adapter) support LDAP authentication at all? If yes, could someone list the steps or files to modify? I googled around, but could not find any detailed steps. I am using jboss-eap-6.1.0.Alpha with teiid-8.6.0.Final-jboss-dist.

    Thanks in advance

  • RELEVANCY SCORE 2.68

    DB:2.68:Accessing Teiid Server From A Remote Designer 8x



    Hi,

    I'm facing a connection pb when I try to access my Teiid Server from a remote Designer.

    I create my connection with mm://IP@:31443 admin/admin and use the "Test" button.

    I get the error message "Unable to connect to the specific Teiid Server ....."

    I checked on the server side

    - could get traffic arriving on port 31443 (tshark -R "tcp.port=31443" -i any). But just a TCP request/response (when I do it on localhost I get a bunch of socket messages both ways)

    - No log in server.log

    The error message says that my server is perhaps offline, but could not find any doc in the Teiid-admin guide about "offline" mode. ....

    A bit lost ..

    Could somebody help me ?

    Regards

    vplanat

    DB:2.68:Accessing Teiid Server From A Remote Designer 8x


    Thanks very much for your answer,

    Yes -b 0.0.0.0 with firewall selinux down resolved the issue ..!

    Thanks a lot

    Regards

    vplanat

  • RELEVANCY SCORE 2.68

    DB:2.68:Default Allow Creation Of Temporary Tables In Teiid 8? 9x



    Hi,

    In teiid 7 we could use the setting

    allowCreateTemporaryTablesByDefault

    In the teiid-jboss-beans.xml to allow all users to be able to create temporary tables by default.

    With teiid 8 that file no longer exists (makes sense), so I'm wondering what is the new correct way to change that property so we can allow all users to create temporary tables?

    Thanks in advance,

    Graeme

    DB:2.68:Default Allow Creation Of Temporary Tables In Teiid 8? 9x


    The resolution to TEIID-2708 will allow you to get the backwards compatible behavior using a system property instead.

    The workaround would be to add an any authenticated role to your vdb with the allow create temp tables permission.

    Steve

  • RELEVANCY SCORE 2.68

    DB:2.68:Help Import Package From Oracle By Teiid Designer am



    Hi everyone,

    I used Teiid designer to design VDB and everything so good. But now, i meet a problem that i can not use Teiid designer to import PACKAGES type from Oracle database.

    I see Teiid designer to support the types of objects in databases:

    + SYNONYM

    + VIEW

    + TABLE

    + Procedure

    and i don't see Package types.

    I hope everyone help me to find solution for this problem.

    Thanks,

    DB:2.68:Help Import Package From Oracle By Teiid Designer am


    I could not find the way to create packages manually. Do I have to create procedures of package as virtual procedures manually?

    Thanks,

    Neeta

  • RELEVANCY SCORE 2.67

    DB:2.67:Teiid Designer - Unable To Preview Data - Teiid30498 Capabilities For Oracleconnection Were Not Avaialable. The Command Could Not Be Planned Properly z8



    Hi Folks,

    I could use some help. I'm unable to preview oracle table after successfully creating JDBC connection to back end Oracle source.

    Windows 7 - 64 bit

    JDK 1.7.0_51

    JBoss-eap-6.1 (jboss-dv-installer-6.0.0.GA-redhat-4.jar)

    JBoss Developer Studio for Windows (jbdevstudio-product-eap-universal-7.1.1.GA-v20140314-2145-B688.jar)

    -Version: 7.1.1.GA

    -Build id: GA-v20140314-2145-B688

    -Build date: 20140314-2145

    Installed Software

    -Teiid DataTools Connectivity 8.4.1.Final-v20140508-1221-B2598 org.teiid.datatools.connectivity.feature.feature.group JBoss by Red Hat

    -Teiid Designer 8.4.1.Final-v20140508-1221-B2598 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.

    -Teiid Designer Runtime 8.4.1.Final-v20140508-1221-B2598 org.teiid.designer.runtime.feature.feature.group JBoss by Red Hat

    -Teiid Runtime Clients 8.4.1.Final-v20140508-1221-B2598 org.teiid.designer.teiid.client.feature.feature.group JBoss by Red Hat

    -JBoss Developer Studio (Branded Product) 7.1.1.GA-v20140314-2145-B688 com.jboss.jbds.all null

    -JCR Compact Node Definition (CND) Editor 3.6.0.Final-v20140108-1636-B144 org.jboss.tools.modeshape.jcr.feature.feature.group JBoss by Red Hat

    -ModeShape Client 3.6.0.Final-v20140108-1636-B144 org.jboss.tools.modeshape.rest.feature.feature.group JBoss by Red Hat

    Steps:

    1.) Install jboss-eap-6.1 data virtualization server

    2.) Install JBoss Developer Studio for windows

    3.) Install Teiid plugins

    4.) Associate JBoss Developer Studio with Teiid server

    5.) Create new Teiid Model Project

    6.) Start Teiid server in Developer Studio

    7.) Create JDBC Oracle Connection. Provide Oracle connection information so that .xmi element is successfully created.

    8.) Select table object

    9.) Select 'Preview Data' icon

    SQL Results tab:

    select * from "OracleConnection"."ACCT_TYPE"

    TEIID30498 Capabilities for OracleConnection were not available. The command could not be planned properly.

    Elapsed Time: 0 hr, 0 min, 0 sec, 319 ms.

    Stack Trace:

    12:19:20,344 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request sW3xTEP7u4dh.0 'TEIID30498 Capabilities for OracleConnection were not avaialable. The command could not be planned properly.'. Originally QueryPlannerException PlanToProcessConverter.java:324.: org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for OracleConnection were not avaialable. The command could not be planned properly.

    at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertNode(PlanToProcessConverter.java:324) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertPlan(PlanToProcessConverter.java:150) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.relational.PlanToProcessConverter.convert(PlanToProcessConverter.java:127) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:247) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:409) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.Request.processRequest(Request.java:436) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:600) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:309) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]

    at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

    Entire Stack Trace:

    12:18:37,956 INFO [org.jboss.modules] (main) JBoss Modules version 1.2.2.Final-redhat-1

    12:18:38,149 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA-redhat-1

    12:18:38,272 INFO [org.jboss.as] (MSC service thread 1-8) JBAS015899: JBoss EAP 6.1.1.GA (AS 7.2.1.Final-redhat-10) starting

    12:18:39,606 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found teiid-dashboard-builder.war in deployment directory. To trigger deployment create a file called teiid-dashboard-builder.war.dodeploy

    12:18:39,626 INFO [org.xnio] (MSC service thread 1-2) XNIO Version 3.0.7.GA-redhat-1

    12:18:39,627 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)

    12:18:39,631 INFO [org.xnio.nio] (MSC service thread 1-2) XNIO NIO Implementation Version 3.0.7.GA-redhat-1

    12:18:39,639 INFO [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 3.2.16.GA-redhat-1

    12:18:39,735 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.

    12:18:39,740 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 39) JBAS011800: Activating Naming Subsystem

    12:18:39,747 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

    12:18:39,750 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 37) JBAS012605: Activated the following JSF Implementations: [main, 1.2]

    12:18:39,764 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013171: Activating Security Subsystem

    12:18:39,770 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension

    12:18:39,774 INFO [org.jboss.as.naming] (MSC service thread 1-4) JBAS011802: Starting Naming Service

    12:18:39,886 INFO [org.jboss.as.mail.extension] (MSC service thread 1-2) JBAS015400: Bound mail session [java:jboss/mail/Default]

    12:18:39,899 INFO [org.jboss.as.security] (MSC service thread 1-7) JBAS013170: Current PicketBox version=4.0.17.SP2-redhat-2

    12:18:39,926 INFO [org.jboss.as.connector.logging] (MSC service thread 1-2) JBAS010408: Starting JCA Subsystem (IronJacamar 1.0.19.Final-redhat-2)

    12:18:39,930 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)

    12:18:39,931 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)

    12:18:40,027 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.modeshape.jdbc.LocalJcrDriver (version 3.3)

    12:18:40,035 INFO [org.jboss.ws.common.management] (MSC service thread 1-1) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.1.4.Final-redhat-7

    12:18:40,468 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003001: Coyote HTTP/1.1 initializing on : http-/0.0.0.0:8080

    12:18:40,542 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003000: Coyote HTTP/1.1 starting on: http-/0.0.0.0:8080

    12:18:40,925 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 51) TEIID50011 Security enabled for transport "odata" with security-domain set to teiid-security

    12:18:40,928 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 51) TEIID50011 Security enabled for transport "jdbc" with security-domain set to teiid-security

    12:18:40,929 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 51) TEIID50011 Security enabled for transport "odbc" with security-domain set to teiid-security

    12:18:41,033 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "jdbc-simple" added.

    12:18:41,042 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "jdbc-ansi" added.

    12:18:41,048 INFO [org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 52) ISPN000128: Infinispan version: Infinispan 'Delirium' 5.2.7.Final

    12:18:41,073 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "access" added.

    12:18:41,092 INFO [org.infinispan.factories.TransactionManagerFactory] (ServerService Thread Pool -- 54) ISPN000161: Using a batchMode transaction manager

    12:18:41,136 INFO [org.infinispan.factories.TransactionManagerFactory] (ServerService Thread Pool -- 52) ISPN000161: Using a batchMode transaction manager

    12:18:41,174 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "db2" added.

    12:18:41,238 INFO [org.infinispan.factories.TransactionManagerFactory] (ServerService Thread Pool -- 53) ISPN000161: Using a batchMode transaction manager

    12:18:41,240 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "derby" added.

    12:18:41,275 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

    12:18:41,288 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/./

    12:18:41,296 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

    12:18:41,296 INFO [org.modeshape.jcr.JcrRepository] (MSC service thread 1-3) ModeShape version 3.3.6.GA-redhat-4

    12:18:41,298 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/main/./

    12:18:41,308 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/./

    12:18:41,312 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-8) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/./

    12:18:41,313 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/./

    12:18:41,317 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/./

    12:18:41,326 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/./

    12:18:41,327 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

    12:18:41,329 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

    12:18:41,332 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/main/./

    12:18:41,333 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/./

    12:18:41,334 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Bound data source [java:/datasources/ModeShapeDS]

    12:18:41,334 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/./

    12:18:41,340 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:jboss/datasources/DashboardDS]

    12:18:41,341 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

    12:18:41,341 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/./

    12:18:41,352 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

    12:18:41,354 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/./

    12:18:41,356 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/./

    12:18:41,360 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "h2" added.

    12:18:41,414 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "hsql" added.

    12:18:41,495 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "informix" added.

    12:18:41,512 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/main/./

    12:18:41,514 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/./

    12:18:41,516 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/./

    12:18:41,514 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/./

    12:18:41,517 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/./

    12:18:41,542 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-7) JBAS010406: Registered connection factory java:/PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource

    12:18:41,546 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

    12:18:41,551 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-4) JBAS010401: Bound JCA ConnectionFactory [java:/PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource]

    12:18:41,576 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "metamatrix" added.

    12:18:41,630 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 54) ISPN000031: MBeans were successfully registered to the platform MBean server.

    12:18:41,631 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 52) ISPN000031: MBeans were successfully registered to the platform MBean server.

    12:18:41,632 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 53) ISPN000031: MBeans were successfully registered to the platform MBean server.

    12:18:41,634 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 52) JBAS010281: Started preparedplan cache from teiid-cache container

    12:18:41,634 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 54) JBAS010281: Started resultset cache from teiid-cache container

    12:18:41,635 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 53) JBAS010281: Started resultset-repl cache from teiid-cache container

    12:18:41,645 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "mysql" added.

    12:18:41,710 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "mysql5" added.

    12:18:41,769 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50001 Teiid Engine 8.4.1-redhat-7 Started = Wed May 21 12:18:41 MDT 2014

    12:18:41,776 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/odata

    12:18:41,776 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/embedded

    12:18:41,777 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "oracle" added.

    12:18:41,862 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "postgresql" added.

    12:18:41,864 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50012 Teiid JDBC - Name = jdbc, Host = 0.0.0.0, Port = 31000, SSL = OFF, security-domains = [teiid-security]

    12:18:41,864 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50037 Teiid ODBC - Name = odbc, Host = 0.0.0.0, Port = 35432, SSL = OFF, security-domains = [teiid-security]

    12:18:42,018 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "sqlserver" added.

    12:18:42,052 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "sybase" added.

    12:18:42,087 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "teiid" added.

    12:18:42,136 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "teradata" added.

    12:18:42,149 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "modeshape" added.

    12:18:42,159 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ingres" added.

    12:18:42,176 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ingres93" added.

    12:18:42,189 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "intersystems-cache" added.

    12:18:42,208 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "netezza" added.

    12:18:42,214 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "file" added.

    12:18:42,219 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ldap" added.

    12:18:42,225 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "loopback" added.

    12:18:42,232 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "olap" added.

    12:18:42,240 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ws" added.

    12:18:42,246 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "salesforce" added.

    12:18:42,252 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "hive" added.

    12:18:42,255 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "infinispan-cache" added.

    12:18:42,259 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "map-cache" added.

    12:18:42,265 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "google-spreadsheet" added.

    12:18:42,278 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "odata" added.

    12:18:42,285 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "sap-nw-gateway" added.

    12:18:42,292 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "mongodb" added.

    12:18:42,328 INFO [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on 0.0.0.0:4447

    12:18:42,329 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "ojdbc14.jar" (runtime-name: "ojdbc14.jar")

    12:18:42,330 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb" (runtime-name: "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb")

    12:18:42,331 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb" (runtime-name: "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb")

    12:18:42,332 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "ModeShape.vdb" (runtime-name: "ModeShape.vdb")

    12:18:42,332 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "teiid-dashboard-builder.war" (runtime-name: "teiid-dashboard-builder.war")

    12:18:42,334 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "modeshape-webdav.war" (runtime-name: "modeshape-webdav.war")

    12:18:42,329 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "teiid-odata-8.4.1-redhat-7.war" (runtime-name: "teiid-odata-8.4.1-redhat-7.war")

    12:18:42,335 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "modeshape-rest.war" (runtime-name: "modeshape-rest.war")

    12:18:42,336 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb" (runtime-name: "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb")

    12:18:42,337 INFO [org.jboss.as.remoting] (MSC service thread 1-4) JBAS017100: Listening on 127.0.0.1:9999

    12:18:42,338 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

    12:18:42,338 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:18:42,347 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-5) JBAS015012: Started FileSystemDeploymentService for directory C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments

    12:18:43,908 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB ModeShape.1 model "ModeShape" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

    12:18:44,021 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 model "OracleConnection" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

    12:18:44,153 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.1 model "customerList_View" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

    12:18:44,353 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.1 model "XMLFileSource" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

    12:18:44,608 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.1 is set to ACTIVE

    12:18:44,649 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 3) TEIID31080 View customerList_View.customerListView validation error: QueryResolverException-TEIID30352 XMLFILESOURCE.GETTEXTFILES does not exist.-QueryMetadataException

    12:18:44,650 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40073 The metadata for the VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

    12:18:44,650 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.1 is set to ACTIVE

    12:18:45,026 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

    12:18:45,026 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 is set to ACTIVE

    12:18:45,032 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.1 is set to ACTIVE

    12:18:45,037 INFO [org.jboss.web] (ServerService Thread Pool -- 52) JBAS018210: Register web context: /modeshape-webdav

    12:18:45,070 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

    12:18:45,071 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1 is set to ACTIVE

    12:18:45,282 INFO [org.jboss.web] (ServerService Thread Pool -- 56) JBAS018210: Register web context: /odata

    12:18:45,281 INFO [org.jboss.web] (ServerService Thread Pool -- 53) JBAS018210: Register web context: /modeshape-rest

    12:18:45,814 INFO [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 56) HV000001: Hibernate Validator 4.3.1.Final-redhat-1

    12:18:46,132 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 53) Deploying javax.ws.rs.core.Application: class org.modeshape.web.jcr.rest.JcrApplication

    12:18:46,205 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 56) Deploying javax.ws.rs.core.Application: class org.teiid.odata.TeiidODataApplication

    12:18:46,289 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB ModeShape.1 is set to ACTIVE

    12:18:46,440 WARN [org.jboss.as.dependency.unsupported] (MSC service thread 1-1) JBAS018568: Deployment "deployment.teiid-dashboard-builder.war" is using an unsupported module ("org.jdom:main") which may be changed or removed in future versions without notice.

    12:18:46,440 WARN [org.jboss.as.dependency.unsupported] (MSC service thread 1-1) JBAS018568: Deployment "deployment.teiid-dashboard-builder.war" is using an unsupported module ("org.jdom:main") which may be changed or removed in future versions without notice.

    12:18:46,440 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.lang:main") which may be changed or removed in future versions without notice.

    12:18:46,441 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.lang:main") which may be changed or removed in future versions without notice.

    12:18:46,441 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.io:main") which may be changed or removed in future versions without notice.

    12:18:46,441 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.io:main") which may be changed or removed in future versions without notice.

    12:18:46,442 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.collections:main") which may be changed or removed in future versions without notice.

    12:18:46,442 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.collections:main") which may be changed or removed in future versions without notice.

    12:18:46,442 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.codec:main") which may be changed or removed in future versions without notice.

    12:18:46,442 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.codec:main") which may be changed or removed in future versions without notice.

    12:18:46,443 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.jboss.ironjacamar.jdbcadapters:main") which may be changed or removed in future versions without notice.

    12:18:46,443 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.jboss.ironjacamar.jdbcadapters:main") which may be changed or removed in future versions without notice.

    12:18:46,571 INFO [org.jboss.weld.deployer] (MSC service thread 1-2) JBAS016002: Processing weld deployment teiid-dashboard-builder.war

    12:18:46,636 INFO [org.jboss.weld.deployer] (MSC service thread 1-6) JBAS016005: Starting Services for CDI deployment: teiid-dashboard-builder.war

    12:18:46,694 INFO [org.jboss.weld.Version] (MSC service thread 1-6) WELD-000900 1.1.13 (redhat)

    12:18:46,726 INFO [org.jboss.weld.deployer] (MSC service thread 1-6) JBAS016008: Starting weld service for deployment teiid-dashboard-builder.war

    12:18:48,925 INFO [org.jboss.web] (ServerService Thread Pool -- 60) JBAS018210: Register web context: /dashboard

    12:18:48,951 INFO [org.jboss.dashboard.ui.controller.ControllerServlet] (ServerService Thread Pool -- 60) Application Directory: C:/JBoss/DataVirtualizer/jboss-eap-6.1/standalone/deployments/teiid-dashboard-builder.war/.

    12:18:48,952 INFO [org.jboss.dashboard.ui.controller.ControllerServlet] (ServerService Thread Pool -- 60) Application Config Directory: C:/JBoss/DataVirtualizer/jboss-eap-6.1/standalone/deployments/teiid-dashboard-builder.war/./WEB-INF/etc

    12:18:48,976 INFO [org.jboss.dashboard.factory.Factory] (ServerService Thread Pool -- 60) Configuring Factory from directory: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\factory

    12:18:49,097 INFO [org.jboss.dashboard.factory.Factory] (ServerService Thread Pool -- 60) Factory configured.

    12:18:49,506 INFO [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 60) HCANN000001: Hibernate Commons Annotations {4.0.1.Final-redhat-2}

    12:18:49,512 INFO [org.hibernate.Version] (ServerService Thread Pool -- 60) HHH000412: Hibernate Core {4.2.0.SP1-redhat-1}

    12:18:49,515 INFO [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 60) HHH000206: hibernate.properties not found

    12:18:49,517 INFO [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 60) HHH000021: Bytecode provider name : javassist

    12:18:49,539 INFO [org.hibernate.cfg.Configuration] (ServerService Thread Pool -- 60) HHH000042: Configuring from file: hibernate.cfg.xml

    12:18:49,678 INFO [org.hibernate.cfg.Configuration] (ServerService Thread Pool -- 60) HHH000041: Configured SessionFactory: null

    12:18:52,041 INFO [org.jboss.dashboard.database.hibernate.HibernateInitializer] (ServerService Thread Pool -- 60) The underlying database is: h2

    12:18:52,566 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 60) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

    12:18:52,571 WARN [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 60) HHH000431: Unable to determine H2 database version, certain features may not work

    12:18:52,584 INFO [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (ServerService Thread Pool -- 60) HHH000399: Using default transaction strategy (direct JDBC transactions)

    12:18:52,588 INFO [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 60) HHH000397: Using ASTQueryTranslatorFactory

    12:18:53,673 INFO [org.jboss.dashboard.cluster.ClusterNodesManager] (ServerService Thread Pool -- 60) Registering cluster node with ip address 10.128.2.252

    12:18:53,705 INFO [org.jboss.dashboard.cluster.ClusterNodesManager] (ServerService Thread Pool -- 60) Successfuly resgister cluster node with ip address 10.128.2.252 and identifier 2312

    12:18:53,705 INFO [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.EnvelopesManagerImpl

    12:18:53,789 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Envelope Default_Envelope

    12:18:53,881 INFO [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.LayoutsManagerImpl

    12:18:53,990 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Default_Layout

    12:18:53,995 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Default_template_with_sliding_menu

    12:18:53,999 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Template_25-50-25

    12:18:54,003 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Template_25-75

    12:18:54,007 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Template_75-25

    12:18:54,021 INFO [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.SkinsManagerImpl

    12:18:54,034 INFO [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Skin Default_Skin

    12:18:54,057 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Loading panels. Scanning dir: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\WEB-INF\etc\panels

    12:18:54,062 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_filter.panel

    12:18:54,093 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_html_editor.panel

    12:18:54,096 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_kpi.panel

    12:18:54,100 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_providermgr.panel

    12:18:54,103 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\breadCrumb\breadCrumb.panel

    12:18:54,107 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\logout\logout.panel

    12:18:54,110 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_language_horiz.panel

    12:18:54,114 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_sections.panel

    12:18:54,116 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_sections_horiz.panel

    12:18:54,118 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_sections_vert.panel

    12:18:54,120 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_workspace.panel

    12:18:54,121 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_workspace_horiz.panel

    12:18:54,123 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_workspace_vert.panel

    12:18:54,125 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\tree\treeMenu.panel

    12:18:54,127 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\dashboardExport\dashb_export.panel

    12:18:54,129 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\dashboardImport\dashb_import.panel

    12:18:54,133 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\dataSourceManagement\DataSourceManager.panel

    12:18:54,135 INFO [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\workspaceExport\workspaceImportexport.panel

    12:18:54,330 INFO [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.ResourceGalleryManagerImpl

    12:18:54,542 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:18:54,543 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

    12:18:54,543 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb" (runtime-name : "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb")

    12:18:54,543 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb" (runtime-name : "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb")

    12:18:54,543 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb" (runtime-name : "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb")

    12:18:54,543 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "ojdbc14.jar" (runtime-name : "ojdbc14.jar")

    12:18:54,544 INFO [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "teiid-dashboard-builder.war" (runtime-name : "teiid-dashboard-builder.war")

    12:18:54,544 INFO [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "ModeShape.vdb" (runtime-name : "ModeShape.vdb")

    12:18:54,544 INFO [org.jboss.as.server] (ServerService Thread Pool -- 50) JBAS018559: Deployed "modeshape-webdav.war" (runtime-name : "modeshape-webdav.war")

    12:18:54,544 INFO [org.jboss.as.server] (ServerService Thread Pool -- 51) JBAS018559: Deployed "teiid-odata-8.4.1-redhat-7.war" (runtime-name : "teiid-odata-8.4.1-redhat-7.war")

    12:18:54,544 INFO [org.jboss.as.server] (ServerService Thread Pool -- 50) JBAS018559: Deployed "modeshape-rest.war" (runtime-name : "modeshape-rest.war")

    12:18:54,593 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management

    12:18:54,593 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

    12:18:54,593 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.1.1.GA (AS 7.2.1.Final-redhat-10) started in 17027ms - Started 798 of 911 services (110 services are passive or on-demand)

    12:18:56,692 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50026 VDB "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1[]" undeployed.

    12:18:56,692 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50026 VDB "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1[OracleConnection{OracleConnection=OracleConnection, oracle, PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection}]" undeployed.

    12:18:56,701 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb (runtime-name: PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb) in 12ms

    12:18:56,739 INFO [org.jboss.as.repository] (management-handler-thread - 3) JBAS014901: Content removed from location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\0c\ac8244c5880d74b11257c3ef6ce84e1fbe6c7c\content

    12:18:56,739 INFO [org.jboss.as.server] (management-handler-thread - 3) JBAS018558: Undeployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

    12:18:56,752 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015877: Stopped deployment PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb (runtime-name: PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb) in 8ms

    12:18:56,818 INFO [org.jboss.as.repository] (management-handler-thread - 4) JBAS014901: Content removed from location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\49\1aaca1c9aadbe5d138764e1ae30666b9876e9e\content

    12:18:56,818 INFO [org.jboss.as.server] (management-handler-thread - 4) JBAS018558: Undeployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:19:14,930 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015877: Stopped deployment ojdbc14.jar (runtime-name: ojdbc14.jar) in 13ms

    12:19:14,932 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "ojdbc14.jar" (runtime-name: "ojdbc14.jar")

    12:19:15,150 INFO [org.jboss.as.server] (management-handler-thread - 2) JBAS018565: Replaced deployment "ojdbc14.jar" with deployment "ojdbc14.jar"

    12:19:16,496 INFO [org.jboss.as.repository] (management-handler-thread - 1) JBAS014900: Content added at location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\0f\9fce832dbf27ee0bb829054915935f35cb14ce\content

    12:19:16,497 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

    12:19:16,531 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 model "OracleConnection" metadata is currently being loaded. Start Time: 5/21/14 12:19 PM

    12:19:16,566 INFO [org.jboss.as.server] (management-handler-thread - 1) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

    12:19:16,622 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 model "OracleConnection" metadata loaded. End Time: 5/21/14 12:19 PM

    12:19:16,796 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

    12:19:16,797 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 is set to ACTIVE

    12:19:17,124 INFO [org.jboss.as.repository] (management-handler-thread - 4) JBAS014900: Content added at location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\f6\ceb2ff6a18a0dd4c551e365b1bd6aa5d9ecf0e\content

    12:19:17,126 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:19:17,148 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1 is set to ACTIVE

    12:19:17,170 INFO [org.jboss.as.server] (management-handler-thread - 4) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:19:17,757 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50026 VDB "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1[]" undeployed.

    12:19:17,761 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015877: Stopped deployment PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb (runtime-name: PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb) in 5ms

    12:19:17,776 INFO [org.jboss.as.repository] (management-handler-thread - 3) JBAS014901: Content removed from location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\f6\ceb2ff6a18a0dd4c551e365b1bd6aa5d9ecf0e\content

    12:19:17,776 INFO [org.jboss.as.server] (management-handler-thread - 3) JBAS018558: Undeployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:19:17,817 INFO [org.jboss.as.repository] (management-handler-thread - 2) JBAS014900: Content added at location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\81\1d0c49fcb90359eb544ce68756a9fe45a34417\content

    12:19:17,818 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:19:17,835 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

    12:19:17,836 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1 is set to ACTIVE

    12:19:17,848 INFO [org.jboss.as.server] (management-handler-thread - 2) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

    12:19:20,341 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue0)

    ============================================================================

    USER COMMAND:

    SELECT * FROM OracleConnection.ACCT_TYPE

    ----------------------------------------------------------------------------

    OPTIMIZE:

    SELECT * FROM OracleConnection.ACCT_TYPE

    ----------------------------------------------------------------------------

    GENERATE CANONICAL:

    SELECT * FROM OracleConnection.ACCT_TYPE

    CANONICAL PLAN:

    Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

    Source(groups=[OracleConnection.ACCT_TYPE])

    ============================================================================

    EXECUTING PlaceAccess

    AFTER:

    Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

    Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc})

    Source(groups=[OracleConnection.ACCT_TYPE])

    ============================================================================

    EXECUTING RaiseAccess

    AFTER:

    Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc})

    Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

    Source(groups=[OracleConnection.ACCT_TYPE])

    ============================================================================

    EXECUTING AssignOutputElements

    AFTER:

    Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc, OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

    Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

    Source(groups=[OracleConnection.ACCT_TYPE], props={OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

    ============================================================================

    EXECUTING CalculateCost

    AFTER:

    Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc, OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_CARDINALITY=-1.0})

    Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_CARDINALITY=-1.0})

    Source(groups=[OracleConnection.ACCT_TYPE], props={OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_COL_STATS={OracleConnection.ACCT_TYPE.ACCT_TYPE_CD=[-1.0, -1.0], OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC=[-1.0, -1.0], OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1=[-1.0, -1.0], OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})

    ============================================================================

    EXECUTING PlanSorts

    AFTER:

    Access(groups=[OracleConnection.ACCT_TYPE])

    Project(groups=[OracleConnection.ACCT_TYPE])

    Source(groups=[OracleConnection.ACCT_TYPE])

    ============================================================================

    EXECUTING CollapseSource

    AFTER:

    Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc, OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3 FROM OracleConnection.ACCT_TYPE})

    ============================================================================

    CONVERTING PLAN TREE TO PROCESS TREE

    12:19:20,344 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request sW3xTEP7u4dh.0 'TEIID30498 Capabilities for OracleConnection were not avaialable. The command could not be planned properly.'. Originally QueryPlannerException PlanToProcessConverter.java:324.: org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for OracleConnection were not avaialable. The command could not be planned properly.

    at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertNode(PlanToProcessConverter.java:324) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertPlan(PlanToProcessConverter.java:150) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.relational.PlanToProcessConverter.convert(PlanToProcessConverter.java:127) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:247) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:409) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.Request.processRequest(Request.java:436) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:600) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:309) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]

    at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

    Message was edited by: Jhon Kehmeier

    Added an additional step.

    DB:2.67:Teiid Designer - Unable To Preview Data - Teiid30498 Capabilities For Oracleconnection Were Not Avaialable. The Command Could Not Be Planned Properly z8


    Hey Steven. Thanks for the help. I was able to get passed my issue by downloading the latest odbc5.jar from Oracle and re-creating a new connection in Teiid Designer. The 'Preview Data' feature now works without throwing any errors.

  • RELEVANCY SCORE 2.67

    DB:2.67:Virtual Procedure Erroring With Error: Procedure Partsvirtual.Partsbycolour1 Does Not Have A Return Value. d9



    I'm trying to port a VDB from MetaMatrix 5.5.3 to Teiid 7.3.

    I have successfully followed the Migrating Metmatrix projects to Teiid Designer, the problem is with VP code from MMx 5.5.3 where a VP was calling another VP with a 1 column, 1 row output;

    CREATE VIRTUAL PROCEDURE

    BEGIN

    DECLARE STRING o_PRODUCT_NAME;

    o_PRODUCT_NAME = EXEC PartsVirtual.partsbyColour1(colorIn = 'BLUE');

    END

    Results with ERROR: Procedure PartsVirtual.partsbyColour1 does not have a return value.

    Where as;

    CREATE VIRTUAL PROCEDURE

    BEGIN

    EXEC PartsVirtual.partsbyColour1(colorIn = 'BLUE');

    END

    Results with my VP inheriting the results set being passed backed from PartsVirtual.partsbyColour1, the problem is, I'd like to be able to utilise the value being returned by the called VP within the calling VP, and not just pass it back.

    CREATE VIRTUAL PROCEDURE

    BEGIN

    SELECT PartsSourceB.PARTS.PART_ID FROM PartsSourceB.PARTS WHERE PartsSourceB.PARTS.PART_COLOR = PARTSVIRTUAL.PARTSBYCOLOUR1.colorIn;

    END

    Also reading the current Teiid documentation, http://docs.jboss.org/teiid/7.3.0.Final/reference/en-US/pdf/teiid_reference.pdf, section 6.2.5 states the following Limitations for VPs;

    Teiid virtual procedures can only be defined in Teiid Designer. They also cannot use IN/OUT, OUT or RETURN parameters and may only return 1 result set.

    Which would then mean to me, that the error being returned by the Designer is incorrect, also I cannot find any properties in the designer to specify a parameters as OUT parameter, only an IN can be defined.

    DB:2.67:Virtual Procedure Erroring With Error: Procedure Partsvirtual.Partsbycolour1 Does Not Have A Return Value. d9


    I've found the answer to my problem, rewriting the EXEC statement as SELECT .... FROM (EXEC .... ) AS ...;

    CREATE VIRTUAL PROCEDURE

    BEGIN

    DECLARE STRING o_PRODUCT_NAME;

    o_PRODUCT_NAME = SELECT tmp.part_id FROM (EXEC PartsVirtual.partsbyColour1(colorIn = 'BLUE')) AS tmp;

    END

  • RELEVANCY SCORE 2.66

    DB:2.66:Vdb Not Accessible After Restarting Datasource kk



    Hi,

    After restarting the MS SQL server that is being used by the VDB as a datasource, I am not able to access the views in the VDB. I see the exception below in the server.log. The only way Ive been able to get around this is by setting the datasource to inactive then back to active (redeploying the VDB doesnt help).

    Is there any other workaround? Could the functionality be enhanced so that the translator automatically reconnects?

    Thanks

    08:54:36,899 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue57) Connector worker process failed for atomic-request=9Ei/a665D9n8.7.1.11: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT COUNT(*) FROM "DB1"."dbo"."Project" g_0]

    at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)

    at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:177) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:174) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [rt.jar:1.7.0_10]

    at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0_10]

    at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_10]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_10]

    at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_10]

    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388)

    at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2166)

    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:677)

    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:663)

    at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:404)

    at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:181)

    at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:82)

    DB:2.66:Vdb Not Accessible After Restarting Datasource kk


    Is there any other workaround? Could the functionality be enhanced so that the translator automatically reconnects?

    We see this as more of a pooling issue, than as a Teiid issue. You'll want to set a test query or just perform a flush of the connection pool on a restart if there is a problem with stale connections.

    Steve

  • RELEVANCY SCORE 2.66

    DB:2.66:Connecting To Teiid Vdb In Jasper/Ireport 37



    Has anyone successfully used Teiid Embedded to connect to a VDB using Jasper iReport?

    DB:2.66:Connecting To Teiid Vdb In Jasper/Ireport 37


    I see some kind of class loading issue the way you have the classpath creation. I not familiar with iReport's JDBC driver definition mechanism.I would suggest you use the "File path Profile" specified in this documenthttp://www.jboss.org/community/docs/DOC-13182With this profile, you copy your VDB into "deploy" directory and only put the embedded client jar in the iReport's classpath.

  • RELEVANCY SCORE 2.66

    DB:2.66:New To Sql/Xml: Convert Traditional Result Set Into Xml Doc? fx



    Suppose I have two tables:

    user:
    user_idNamemaddlemanMark Addleman

    phonenumber:
    user_idphone_numbermaddleman123-123-1234maddleman456-456-4567

    I want to produce the following XML output:

    userMark Addleman/user

    phone_number123-123-1234/phone_number

    phone_number456-456-4567/phone_number

    /user

    I can't figure out how to nest the SELECT of the phonenumber table in the outter SELECT in a way that makes Teiid happy.

    I'm brand new to SQL/XML so if there is some tutorial website you can point me to, I'd really appreciate it.

    DB:2.66:New To Sql/Xml: Convert Traditional Result Set Into Xml Doc? fx


    fwiw, I found a pretty decent site for SQL/XML that includes some good examples: http://courses.ischool.berkeley.edu/i290a-2/s06/week2/homework-week2.htm

  • RELEVANCY SCORE 2.66

    DB:2.66:I Am Newbie In This, Need To Connect To Sql Server fd



    HiI am totally new to this java and Teiid stuff. So can you please help me with a link or with a working document which i can use to pull the data from SQL Server and CSV via Teiid, Join it in and Present it to the VB.NET application.Please help meThanks -- Vijaya Kadiyalawww.DotNetVJ.com

    DB:2.66:I Am Newbie In This, Need To Connect To Sql Server fd


    add the following to the your "schema.txt" file?

    MarketData.PRICE.skipHeaderLines=1

  • RELEVANCY SCORE 2.66

    DB:2.66:Authentication Not Working For Teiid 8.3 Alpha 2 sa



    I am trying to get data from VDB using Teiid 8.3 Alpha 2 and my application has securuty domain setup. The application login works fine but it is failing when the application tries to get data from the VDB using a socket connection. This was working fine in Teiid 8.1 final.

    When I looked at the logs, it seems to be failing with a ClassNotFoundException which seems to happen because the "teiid client" module is calling code in "teiid-common core" while the code in "teiid common core" is trying to call a class defined in "teiid client" module. My assumption was that the module classloader would be parent first and the class definitions would be passed to "teiid common core" based on the dependencies defined in the teiid-client module.xml but that doesn't seem to be happening.

    Caused by: org.teiid.net.CommunicationException: TEIID20018 Unable to find a component used authenticate on to Teiid
    at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:144) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerConnection.init(SocketServerConnection.java:92) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    ... 64 more
    Caused by: org.teiid.core.TeiidComponentException: TEIID10006 Decryption failed: java.lang.ClassNotFoundException org.teiid.client.security.LogonResult from [Module "org.jboss.teiid.common-core:main" from local module loader @7e1a9d1b (roots: F:\Softwares\jboss-as-7.1.1.Final\modules)]
    at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:59) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:374) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at $Proxy85.logon(Unknown Source) at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    ... 67 more
    Caused by: org.teiid.core.crypto.CryptoException: TEIID10006 Decryption failed: java.lang.ClassNotFoundException org.teiid.client.security.LogonResult from [Module "org.jboss.teiid.common-core:main" from local module loader @7e1a9d1b (roots: F:\Softwares\jboss-as-7.1.1.Final\modules)]
    at org.teiid.core.crypto.BasicCryptor.unsealObject(BasicCryptor.java:181) [teiid-common-core-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.convertResult(SocketServerInstanceImpl.java:326) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:116) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:357) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:366) [teiid-client-8.3.0.Alpha2.jar:8.3.0.Alpha2]
    ... 70 more

    DB:2.66:Authentication Not Working For Teiid 8.3 Alpha 2 sa


    Please see https://community.jboss.org/message/792230#792230 for more information on what our use case and architecture is.

    Since we create dynamic socket connection to VDB to get the data, we only have the option of in-vm socket connection. So I'll wait for Beta-1

  • RELEVANCY SCORE 2.66

    DB:2.66:Deploy And Execute Vdb In Teiid fj



    Hi,

    I wish to deploy and execute a VDB in teiid server. I am using the VDB that was working properly in legacy metamatrix and tried to deploy and execute but i am faing javanullpointerexception..I am a new user to teiid..

    Pointers will be very helpful..

    Thanks in advance

    DB:2.66:Deploy And Execute Vdb In Teiid fj


    As mentioned above the VDB from Metamatrix will not work as is. You need to extract models from the Metamatrix VDB project, and rebuild/validate the project in Teiid Designer. Then rebuild VDB (make note that configuring connectors in Metamatrix and Translators in Teiid are different) before deploying to the Teiid server. You also need to configure the data sources in Teiid.

    Also delete the "teiid" directory under the "jboss-as/server/profile/data" to remove any cached content, then re-start.

    I suggest you taking quick tour of "Quick Start Example", to understand the basics of Teiid, before diving into migration.

    Ramesh..

  • RELEVANCY SCORE 2.66

    DB:2.66:How To Get Salesforce Metadata Using Teiid Odbc? sa



    Hello guys,

    I have successfully connected to Salesforce using Teiid and performed standard SQL operations using Teiid ODBC. I have also successfully managed to retrieve Salesforce metadata from JDBC, but I do not know how to access Salesforce metadata using Teiid ODBC. Can you guys suggest me an SQL query that help me to retrieve all the Salesforce metadata?

    Tarif

    DB:2.66:How To Get Salesforce Metadata Using Teiid Odbc? sa


    This really depends upon the client program you are using to access the metadata. If you are writing a C/C++ program, this link provides the ODBC API you can use http://msdn.microsoft.com/en-us/library/ms714562%28v=vs.85%29.aspx BTW, there is no single query to make this happen, it is a combination multiple API calls.

  • RELEVANCY SCORE 2.66

    DB:2.66:Model Api Data To Teiid a1



    Is there a way to model data which is gotten through API call into teiid and query those data by standard sql statement? I'm using embedded Teiid.

    Thanks.

    DB:2.66:Model Api Data To Teiid a1


    https://github.com/teiid/teiid

    https://github.com/teiid/teiid/tree/master/connectors/translator-loopback

    https://github.com/teiid/teiid/tree/master/connectors/sandbox/translator-yahoo

  • RELEVANCY SCORE 2.66

    DB:2.66:Error While Importing Rest Web Service As Source In Teiid Designer sx



    Hello all -

    I am trying to import REST API as a source in Teiid Designer but I am getting the following error message.

    Description
    Resource
    Path
    Location
    Type
    The number of columns/elements in RestToODataProcedure are less than the number defined in the SQL transformation.
    RestViewModel.xmi/RestToOData
    RestToODataProcedure
    Problem

    The JSON response is very simple:

    {"Root":{

    "ElementKey": "Value"

    }

    }

    Can someone please help?

    Thanks,

    DB:2.66:Error While Importing Rest Web Service As Source In Teiid Designer sx


    Thanks so much Ramesh. I just did what you said in the last statement "create data source". I could deploy my VDB and see the metadata. Now one last question (promise !). What is my entity in this metadata, http://localhost:8080/odata/RestVDB/$metadata. Thanks again!

  • RELEVANCY SCORE 2.66

    DB:2.66:Errors While Installing Data Virtualization In Jbds 7.1.1 Ga p1



    I am trying to install Data Virtualization on JBDS 7.1.1GA using http://download.jboss.org/jbosstools/updates/release/kepler/integration-stack/teiiddesigner/8.6.0.Final/. But I am getting multiple error messages. Can someone help? Thanks

    Cannot complete the install because one or more required items could not be found.

    Software being installed: Teiid Runtime Clients 8.6.0.Final-v20140919-1550-B2865 (org.teiid.designer.teiid.client.feature.feature.group 8.6.0.Final-v20140919-1550-B2865)

    Missing requirement: org.teiid.datatools.connectivity.ui 8.6.0.Final-v20140919-1550-B2865 (org.teiid.datatools.connectivity.ui 8.6.0.Final-v20140919-1550-B2865) requires 'bundle org.eclipse.birt.report.data.oda.hive.ui [4.3.2,5.0.0)' but it could not be found

    Cannot satisfy dependency:

    From: Teiid DataTools Connectivity 8.6.0.Final-v20140919-1550-B2865 (org.teiid.datatools.connectivity.feature.feature.group 8.6.0.Final-v20140919-1550-B2865)

    To: org.teiid.datatools.connectivity.ui [8.6.0.Final-v20140919-1550-B2865]

    Cannot satisfy dependency:

    From: Teiid Runtime Clients 8.6.0.Final-v20140919-1550-B2865 (org.teiid.designer.teiid.client.feature.feature.group 8.6.0.Final-v20140919-1550-B2865)

    To: org.teiid.datatools.connectivity.feature.feature.group [8.6.0.Final-v20140919-1550-B2865]

    DB:2.66:Errors While Installing Data Virtualization In Jbds 7.1.1 Ga p1


    Hey,

    Looks like the documentation is referring to what was the old 'Teiid View' which is now in fact the 'Servers View'. The Servers View is not unique to Teiid but provides a view on all configured Jboss servers.

    Hope this helps.

  • RELEVANCY SCORE 2.66

    DB:2.66:Dynamic Vdb Deployment Fails When Using Importer.Importindexes In The Case Of A Index Returned From Sql Metadata Containing A Null Entry 17



    Hi Teiid Developer:

    This is anothier case of dynamic VDB deployment failure.

    For some VDBs we are testing with, the vdb deployment fails when using property name="importer.importIndexes" value="true"/ to input the index from our datasource , the error in the server.log is not clear:

    01:04:53,093 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB testvdb.1 model "testds" metadata failed to load. Reason:null

    Debugging through teiid code, it looks like that some indexInfo returned from the sql metadata contains a column list with one "null "entry (at SQL database, this index does contain a real column, not sure where the column name got lost).

    Anyway, when teiid (MetadataFactory.java) tries to handle this indexInfo, it fails with some unhandled exception, here is the code

    public KeyRecord addIndex(String name, boolean nonUnique, ListString columnNames, Table table) {
    KeyRecord index = new KeyRecord(nonUnique?KeyRecord.Type.Index:KeyRecord.Type.Unique);
    index.setParent(table);
    index.setColumns(new ArrayListColumn(columnNames.size()));
    index.setName(name);
    setUUID(index);
    assignColumns(columnNames, table, index);
    if (nonUnique) {
    table.getIndexes().add(index);
    }
    else {
    table.getUniqueKeys().add(index);
    }
    return index;
    }

    in the particular case, the columnNames list only contains one "null" entry. When teiid tries to add this index to this column, it fails at "Column column = table.getColumnByName(columnName);" call since columnName is "null".

    Should teiid handle this case correctly to skip adding index into "null" column?

    Thanks

    Jack

    DB:2.66:Dynamic Vdb Deployment Fails When Using Importer.Importindexes In The Case Of A Index Returned From Sql Metadata Containing A Null Entry 17


    Yes, the TreeMap will throw an NPE and we end up swallowing the stacktrace. https://issues.jboss.org/browse/TEIID-2368 corrects both the missing/null column and ensures that the stacktrace should be displayed for any similar errors.

    Thanks,

    Steve

  • RELEVANCY SCORE 2.65

    DB:2.65:Using Keycloak As The Teiid Jdbc Loginmodule mk



    Hello Teiid Community,

    I am trying to use JBoss KeyCloak as the LoginModule for Teiid through JDBC, but experiencing issues with Teiid not knowing how to authenticate. I am trying to connect using the Teiid MS SQL Server Translator, with login users and passwords i know are authenticated through KeyCloak and/ the database.

    For details, firstly the KeyCloak security domain is defined in standalone-dsds.xml:

    security-domain name="keycloak"
    authentication
    login-module code="org.keycloak.adapters.jboss.KeycloakLoginModule" flag="required" module="org.keycloak.keycloak-jboss-adapter-core"/
    /authentication
    /security-domain

    DB:2.65:Using Keycloak As The Teiid Jdbc Loginmodule mk


    Joe,

    If you want to attach your standalone.xml file, I can take a look, otherwise I can't seem to think why that would be the case.

    Ramesh..

  • RELEVANCY SCORE 2.65

    DB:2.65:Teiid Instance Configuration In Jboss mp



    Hi,

    I am new to Teiid and currently trying to install the product and get started.

    I have installed EAP 6.1 Final and attempted to install teiid 8.5 on top of that. The server startup log does not show any error ( and having messages of understanding all the translators and drivers specified in the standalone xml, but when I look at the console, it does not have any teiid runtime deployments present.

    Can you help in identifying the issue?

    Currently, I am trying to get the EAP Alpha installed and see whether it works. What I did previously is the EAP 6.1 final version.

    Thanks

    DB:2.65:Teiid Instance Configuration In Jboss mp


    BTW, Teiid currently does not support EAP 6.1 Final with community Teiid releases due to EAP 6.1 Final licencing restrictions. If you want you can get Data Virtualization 6, Teiid in product form from Redhat, that is fully supported by Redhat that works with EAP 6.1 Final. For that you need to contact Redhat, or if you have access to Redhat customer portal you can download a evaluation copy. See http://www.redhat.com/products/jbossenterprisemiddleware/data-services/

    Ramesh..

  • RELEVANCY SCORE 2.65

    DB:2.65:Compiling Virtual Procedure In Plain Sql 99



    Is there way to compile virtual procedures in plain SQL (as in http://docs.jboss.org/teiid/7.7.0.Final/reference/en-US/html/procedures.html#virtual_procedures ) by calling some Java API and including static resource file with plain text in SQL rather than using tool like Teiid Designer ?

    Thank you.

    DB:2.65:Compiling Virtual Procedure In Plain Sql 99


    Dynamic sql executes withint the scope of a procedure. So the temp table would have to be defined with-in the procedure to be referenced. We don't yet support cursor/table type references so you have to do fairly messy workarounds if you want to pass a resultset/table reference into a procedure as a parameter. So while you can do something like:

    EXECUTE IMMEDIATE 'select * from ' || tblName AS x string, y integer INTO #TEMP;

    fom within a procedure and then operate over #temp, tblName would have to reference a table created in the procedure or be a non-session table.

  • RELEVANCY SCORE 2.65

    DB:2.65:Stackoverflowerror For A Simple Select * Query Over A Simple View And Sql Server jz



    Hi,

    I'm new to Teiid but I think I've found a problem in the query processor of Teiid.

    I'm testing Teiid 7.2 (final) on JBoss AS 5.1. I have created a simple VDB with 2 models, in teiid designer 7.1. The first (Northwind.xmi) is a source model which connects to SQL Server 2000 trough JDBC (Jtds 1.2.5), and imports all tables from the Notrhwind database (the sample database in SQL server 2000). The other model (logical_northwind.xmi) is a simple view model which includes all the objects of the source model. It doesn't apply any transformation to the data from the source model. The VDB includes these two models, but only the view model is visible.

    I've found that a simple query over the view, like SELECT * FROM "logical_northwind"."Northwind.dbo.Categories" fails with a StackOverflowError. And this is the same with all the tables in the view. After some trials, I renamed the table in the view model from "Categories" to "Cat", and now the query works. So it seems that the query fails if the view model uses the same table name used by the source model. Can it be a bug in the query processor, or am I doing something wrong?

    In the attachments there are the log files:

    - command.log: contains the messages of the COMMAND_LOG, in case of a query which fails (it is on the Employees tables, but is the same with all the tables)

    - command_ok.log: contains the messages of the COMMAND_LOG, in case of a query which works (it is on the renamed table)

    - server.log: the general log which includes the StackOverflowError. It includes several queries, but the only one which works is at the top of the file. All the following failed.

    By reading the log files, the problem seems to be something like an infinite loop in the query optimizer. Or maybe is this issue related to https://issues.jboss.org/browse/TEIID-912 ??

    If there are workarounds, please let me know. By now, the only thing I can do is to rename all the tables in the view...

    Thanks in advance,

    Claudio

    DB:2.65:Stackoverflowerror For A Simple Select * Query Over A Simple View And Sql Server jz


    Claudio,

    You are not guarenteed to have a problem even if the suffixes are the same. That is what I meant by your vdb having the right load order of index files to cause the issue. Changing the model names, even with the same suffix, probably made it so that the physical loaded last. In any case having unique suffixes is sufficient to prevent the issue from happening.

    Steve