Questo contenuto non è disponibile nella lingua selezionata.

Chapter 2. Issues


2.1. Known Issues

The following issues are known to exist in JBoss Data Virtualization 6.2.0 and will be fixed in a subsequent release.
Bug 1257202 - Oracle JDBC driver is not able to work with forwardable Kerberos ticket (TGT)
The Oracle JDBC driver does not accept a forwardable Kerberos ticket (TGT). If you try to use a TGT, you will encounter an exception. To work around this issue, disable Kerberos (set "forwardable = false" in the krb5.conf/krb5.ini file on both Linux and Windows). Note that this will work only for static kerberos authentication. Teiid's pass-through authentication will fail as it depends on forwardable tickets.
Bug 1257196 - MSSQL connection invalidates Kerberos ticket (TGT)
The MSSQL JDBC connection invalidates Kerberos tickets because it calls the GSSCredentials.dispose() method during close(). The Kerberos ticket (TGT) is shared among connections which means that the first closed connection in EAP's connection pool invalidates TGT and every subsequent attempt to obtain a new connection fails. This is cause by the MSSQL JDBC driver' architecture. To wrk around this issue, set the datasource's "idle-timeout-minutes" property to a high value.
Bug 1202847 - Mixed result with (double) full outer join and where clause
There are known issues with Oracle 10 databases when you try to use full outer joins. These issues have been fixed in Oracle 11. As a work around, Oracle 10 users should preserve the hint around FROM clauses containing multiple FULL OUTER JOINs so that they can be pushed to the database. Here is an example workaround:
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT1.MediumB.IntKey AS MediumB_IntKey, 
BQT1.MediumA.IntKey AS MediumA_IntKey FROM 
/*+ preserve */ ((BQT1.SmallA FULL OUTER JOIN BQT1.MediumB ON BQT1.SmallA.IntKey = BQT1.MediumB.IntKey) 
FULL OUTER JOIN BQT1.MediumA ON BQT1.MediumB.IntKey = BQT1.MediumA.IntKey) 
WHERE BQT1.MediumA.IntKey < 1500 ORDER BY MediumA_IntKey, MediumB_IntKey, SmallA_IntKey
Copy to Clipboard Toggle word wrap
Bug 1211539 - Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver
If you are using the IBM Java Development Kit, Kerberos identification will fail under some circumstances. This is because the Kerberos principal is not passed to the driver. As a result, the user will see an exception. MSSQL is affected (pass-through configuration only) as is Impala (for both static and pass-through configurations).
Bug 1232236 - Infinispan-dsl-cache translator: can't insert null into column of type boolean
If the JDG protobuf definition does not define a default value for a boolean attribute, and a value is not passed when an insert is executed, the Hot Rod client will thrown an exception. To work around this issue, you must assign defaults in the proto def file or always pass a value for the boolean attribute.
Bug 1167784 - Language labels hard to see
The language labels on JBoss Data Virtualization Dashboard are hard to read because of the font colours of these labels.
Bug 1157269 - Dashboard Builder Login screen not properly displayed in JBoss Data Virtualization
The background image in the Dashboard Builder login screen does not display correctly. This does not impact upon functionality.
Bug 1168636 - Dashboard login page is broken when non-logged user uses direct URL to dashboard home
When a user, who has not been assigned the appropriate role, tries to login to JBoss Data Virtualization Dashboard by entering the URL directly, they are redirected from the JBoss Data Virtualization Dashboard login page to a blank screen.
Bug 1244149 - Update README.md files of quickstarts
The README.md files for the quick starts contain outdated information in some cases.
Bug 1022650 - Quickstart - drools-integration uses drools 5 instead of drools 6
The 'drools-integration' quick start has not been included in this release of JBoss Data Virtualization. It needs to be updated for the latest version of the rules management software before it can be included in the product.
Bug 1018996 - On failed install, feedback cannot be reported back to JBoss/Red Hat
There is no indication that a failed install will be reported to Red Hat. Furthermore, the content in the install log cannot be copied into the clipboard to email details manually.
Bug 1197789 - Deprecate support for using Lucene search to query JDG
If you use Red Hat JBoss Data Virtualization to create a cache via an Infinispan configuration file, you will encounter an exception when you try to use Lucene search to query that cache.
Bug 1167321 - Timezone of DV server has influence on Date and Timestamp columns in some data sources
For JDG, MongoDB and Solr data sources, it has been observed that Date and Timestamp columns in the resultset are affected by a time zone of JBoss Data Virtualization server. For these data sources, there is no remote notion of Calendar based time-stamp. The acceptable approach would be to have the respective translators updated with a server time zone setting (similar to JDBC) and have the translator adjust the UTC value to keep the calendar fields consistent. This way the server will always return the same values for Date and Timestamp columns even though the time zone of the server is changed.
Bug 1234826 - Minor inaccuracy when removing vdb in domain mode
When removing a VDB in domain mode, the server will show a dialog asking the user if they want to "Remove loopback-vdb.xml from other-server-group?". When the user clicks "Confirm" the VDB is removed from all server groups, not just from other-server-group. Hence, the wording of the dialog box is misleading and needs to be changed.
Bug 1237049 - Infinispan fails under high load
In high load/high contention cases, the client should change the ISPN configuration and increase the locking timeout.
Bug 1226323 - INSERT statement with Object value fails - Unsupported Types value: 2,000 [postgres]
If an insert statement is used with an object value on Postgres, it will fail. As a result, the user will encounter an exception.
Bug 1226824 - IN clause - teradata does not support "CAST( ... AS ...)" statement in "IN(...)"
Teradata does not support Cast statements. If one is sued, an exception will be thrown.
Bug 1227214 - MySQL translator (mysql, mysql5) - convert( ..., float [double]) uses "+ 0.0" construction
When the convert(... , float) and convert(..., double) functions are used in complex operations, the translator does not take into account the priority of the operators.
Bug 1234270 - Missing status of VDB in jboss-cli console
The get-vdb command's failure description is lacking a status. Therefore, it does not give the user all of the information they need when a problem is encountered obtaining a VDB.
Bug 1240565 - Teradata15 - teiid shifts date/time/timestamp values according to timezone.
Red Hat JBoss Data Virtualization shifts date/time/timestamp values returned from Teradata according to the user.timezone value. However, when a source-specific command is run, the correct values are returned.
Bug 1242999 - Infinispan-dsl-cache translator: Operator incorrectly handles NULL values
The Infinispan-dsl-cache translator operator incorrectly handles NULL values. This is because SupportNot and SupportNull have been incorrectly set.
Bug 1243466 - Teiid ODBC driver inconsistent error logs
The Teiid ODBC driver handles errors inconsistently. As a result, log information may be incomplete.
Bug 1245204 - MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value)
If an INSERT statement contains an object value then execution fails and users will encounter this exception: "java.sql.SQLException: Unknown Types value".
Bug 1247976 - MongoDB string functions - different handling of NULL values
Red Hat JBoss Data Virtualization handles nulls incorrectly in the UCASE,LCASE and SUBSTRING functions when working with MongoDB. It preserves Mongo's results, which are different from what is expected from the SQL function.
Bug 1248489 - DB2 - error getting substring if "from position" is out of range
When using DB2, if the second argument of a SUBSTRING(x,y,z) function is out of the range of the first argument, users will encounter an exception.
Bug 1252307 - HBase translator - INSERT and UPDATE statements have no effect
When using the HBase translator, Teiid's INSERT and UPDATE statement have no effect. Both statements are translated to UPSERT which needs Connection.commit() to take effect.
Bug 1211539 - Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver
If you are using the IBM Java Development Kit, Kerberos identification will fail under some circumstances. This is because the Kerberos principal is not passed to the driver. As a result, the user will see an exception. MSSQL is affected (pass-through configuration only) as is Impala (for both static and pass-through configurations).
Bug 1252914 - JDG translator has disabled capabilities for GT and LT
When issuing a query to the JDG data source that contains GT or LT criteria, the GT/LT criteria will not be pushed down to the source for execution. The reason the GT/LT criteria is not pushed down is because JDG handles comparing "null" values different than how SQL is expected to compare.
JDG resolves this to TRUE and would include that object in the result set, but SQL would indicate FALSE and excluded the object.
As a consequence, pPerformance maybe be slow. If this is the only criteria specified in the query, then Teiid must read all the objects from the cache in order to perform the GT/LT filtering.
Bug 1098405 - Imported VDB as source model can not be updated using a wizard provided by Teiid Designer
It is not possible to update VDB which has been imported as source model as Update(if existing model selected) check box is not visible for imported VDB as source model.
Bug 1095159 - Unable to connect google spreadsheet
Users cannot connect to the Google resource adapter in some cases. They will encounter an exception when they try to deploy a dynamic VDB.
Bug 1258546 - (TEIID-3629) Teiid DDL columns options for Salesforce column have wrong name for "Calculated" property
The SalesForceMetadataProcessor.java contains an extension property key that is incompatible with Teiid Designer and prevents users from importing SF tables via Teiid COnnection importer. To work around this, save the DDL during the import, editing the DDL to fix the mis-spelled keys and re-importing via a different (DDL) importer.
Bug 1243875 - (TEIID-2936) Combining multiple 'in' criteria can prevent pushing criteria to database
If you combine multiple "in" criteria, the criteria might not be pushed to the database.
Bug 1244803 - (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow
There is a performance issue when the Hive 0.13.1 JDBC JARs are running on HDP 2.1 leading to very slow execution of queries.
Bug 1259736 - (TEIID-3671) Odata filter on child table not working correctly
Odata filters do not work correctly on child tables, hence filter results may sometimes be inaccurate.
Bug 1260596 - Problem with New Model Wizard If you try to change the model class in the Teiid Designer New Model wizard, those changes are not applied.
Bug 1260690 - Copying Model to another Project
If you try to copy a view model that references a source model from one project to another, Teiid Designer does not warn the user that the model is broken.
Bug 1260723 - Copying Model problem
If you try to create a new view model by copying from an existing one, the name is not updated and the location data may be broken.
Bug 1097482 - Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
When Teiid Designer generates a web service for a source model, it does not check for a RETURN direction type. This can cause the generation of the web service model gto fail with an error stating that there is no root.
Bug 1253602 - Error setting the value for property salesforce:calculated when importing from Teiid Connection
If you try to import a SalesForce model with the Teiid Connection, you will encounter log errors. This is due to a Teiid property not being renamed.
Bug 1259592 - Odata - if table does not contain element with required key then teiid throws NPE
If a table does not contain an element with a required key, then the user will encounter a null-pointer error.
Bug 1260621 - RoleBasedCredentialMapIdentityLoginModule throws exception at startup time
If a data source is configured to use the RoleBasedCredentialMapIdentityLoginModule, then the user will encounter an exception on launching the product. This is because the default username and password are null.
Bug 1231769 - Solr translator - batched update with more than one query gets stack
If a Solr translator PreparedStatement.executeBatch() has more than one query the user will encounter an error.
Bug 1242938 - Infinispan-dsl-cache translator: Incorrect ordering of NULL values
Null values are not sorted correctly when the Infinispan-dsl-cache translator is used.
Bug 1231613 - Missing ODBC port number in the log during shutdown
The ODBC port number is not written to the log during shutdown.
Bug 1180144 - MongoDB: EmptyStackException when joining tables
If the user attempts to join data from a MongoDB table that has teiid_mongo:MERGE property enabled, they will encounter a java.util.EmptyStackException.
Bug 1194292 - NPE while accessing VDB via OData access
A null-pointer exception occurs if the user supplies the wrong address when attempting to access a virtual database via OData.
Bug 1246153 - MongoDB metadata import fails with NPE
The MongoDB metadata import filter does not currently work. Users will encounter null-pointer errors if they use it.
Bug 1199401 - Set connection profile action uses wrong driver info.
If a new connection profile is imported and its driver is changed afterward, the Set Connection Profile action will use the wrong driver information.
Bug 1205110 - Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15
If you try to import a source model from Sybase 15, the "name-in-source" property value will be wrong.
Bug 1208334 - Required to Save in order to delete physical source in Teiid model explorer
In the Teiid Model Explorer, you cannot delete physical sources. The workaround is to save them first, then you can delete them.
Bug 1219036 - Problems with starting DV server from Teiid Designer 9.0.2.Beta1
Users can encounter exceptions if they attempt to launch the Data Virtualization server from within JBoss Developer Studio.
Bug 1220749 - Saving View Model with syntax error in Transformation breaks it completely
If you save a view model with a syntax error in the transformation, the whole model becomes broken. There is a lack of adequate syntax checking at present.
Bug 1222579 - 1024 x 768 Issue with XML model editor - can not reach red "Staging table arrow" when scrolling
There are a number of problems with scrolling XML diagrams, such as an inabiity to reach icons.
Bug 1223265 - No connection to Teiid instance after starting DV from JBDS - refresh needed
If the user attempts to start the data virtualization server from JBoss Developer Studio, there is no connection established to the Teiid instance. To workaround this, you must refresh the server or the Teiid Instance.
Bug 1223287 - Problem with saving username and password for JDBC connection using key shortcut
You cannot save the JDBC connection username and password using the keyboard shortcut. To workaround this error, use File-Save.
Bug 1223298 - Problems with preserving JDBC username and password on MAC OS X
If you try to change the JDBC connection usrename and password on Mac OS X, it is not saved and you will have to re-enter it the next time you restart the server and JBDS.
Bug 1228557 - REST connection profile wizard creates URL with parameters in wrong order
The REST connection profile wizard can create a URL with the parameters in the wrong order, leading to errors if the URI parameter is after the QWuery parameter.
Bug 1249567 - Add or Remove input variables for WS operation not working correctly
When the user edits a web service model, clicking Add or Remove variables shows the Edit Input Variables editor with all the variables deselected. Selecting some of the variables adds them to the transformation, resulting in invalid SQL.
Bug 1250620 - Model refactoring: view model is missing imports after moving into or out of folder
When the user moves a view model into a directory from the project root or vice versa, the model imports are not updated correctly.
Bug 1252832 - Model editor blank after restarting JBDS
If the user exits JBoss Developer Studio and then relaunches it, the model editor is blank.
Bug 1253377 - When I resize transformation editor window in XML document model, developer studio crash.
If the user attempts to resize the Transformation Editor window, JBoss Developer Studio crashes.
Bug 1257503 - User can access import dialogues after clicking "Cancel" in New project dialogue
The user can access import dialogues after clicking 'Cancel" in the "New Project" dialogue box.
Bug 1255251 - DDL importer does not properly set Materialized table options
If the user attempts to import a DDL, the Materialized property of the view table is set, but the Materialized Table property is not. To workaround this issue, the user must manually set the Materialized Table property after import.
Bug 1257649 - Different projects can be selected for location of source and view models when importing from SOAP and REST
You can select different projects for the source and view models when importing from SOAP or REST.
Bug 1233040 - Transformation editor does not save the code, "create virtual procedure"
Transformation editor does not save when the users attempt to edit a virtual procedure.
Bug 1243831 - Problems to preserve host in server settings page
If the user attempts to set a remote host, saves the change and restarts JBoss Developer Studio, it defaults back to localhost.
Bug 1248987 - User can edit connection profile and save it without password
Users can edit their connection profile and save it without being required to enter their password for it.
Bug 1222890 - 1024 x 768 - Reconciler - not all buttons are visible
Some icons in the Teiid Designer plugin's Reconciler screen are obscured at 1024*768 resolution.
Torna in cima
Red Hat logoGithubredditYoutubeTwitter

Formazione

Prova, acquista e vendi

Community

Informazioni sulla documentazione di Red Hat

Aiutiamo gli utenti Red Hat a innovarsi e raggiungere i propri obiettivi con i nostri prodotti e servizi grazie a contenuti di cui possono fidarsi. Esplora i nostri ultimi aggiornamenti.

Rendiamo l’open source più inclusivo

Red Hat si impegna a sostituire il linguaggio problematico nel codice, nella documentazione e nelle proprietà web. Per maggiori dettagli, visita il Blog di Red Hat.

Informazioni su Red Hat

Forniamo soluzioni consolidate che rendono più semplice per le aziende lavorare su piattaforme e ambienti diversi, dal datacenter centrale all'edge della rete.

Theme

© 2025 Red Hat