[JBoss JIRA] (TEIID-4190) Enabling/Disabling a Datasource prompts for server restart
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4190?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4190:
------------------------------
Attachment: Capture.PNG
> Enabling/Disabling a Datasource prompts for server restart
> ----------------------------------------------------------
>
> Key: TEIID-4190
> URL: https://issues.jboss.org/browse/TEIID-4190
> Project: Teiid
> Issue Type: Bug
> Environment: Red Hat JBoss Data Virtualization 6.2.4 on EAP patched to version 6.4.6, on Oracle Linux 6
> JBoss Developer Studio 8.1.0GA with Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: Capture.PNG
>
>
> When I enable or disable a Datasource in EAP (tested only in domain mode), I get a message that prompts me to restart my server because configurations have changed. This is a new warning because it didn't do this in earlier version of EAP6.4. If I go to the topology screen, none of the servers are marked with the symbol that says it needs to be restarted. If I drill down into the specific node and server, the Datasource was marked as disabled in the UI, so I think it did actually turned off the Datasource correctly.
> I think the prompt is wrong, and should be removed. Also, this might be an EAP bug and not JDV related.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4190) Enabling/Disabling a Datasource prompts for server restart
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4190?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4190:
------------------------------
Steps to Reproduce:
Steps to reproduce:
1, Start server in domain mode
2, Go to admin console
3. On Configuration tab, navigate to appropriate profile
4. Enable or disable a Datasource
was:
Steps to reproduce:
1, Start server in domain mode
2, Go to admin console
3. On Deployments tab, choose to replace an existing VDB
4. Check logs
> Enabling/Disabling a Datasource prompts for server restart
> ----------------------------------------------------------
>
> Key: TEIID-4190
> URL: https://issues.jboss.org/browse/TEIID-4190
> Project: Teiid
> Issue Type: Bug
> Environment: Red Hat JBoss Data Virtualization 6.2.4 on EAP patched to version 6.4.6, on Oracle Linux 6
> JBoss Developer Studio 8.1.0GA with Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Getting an error while replacing an existing VDB with JDV 6.2.4. I think the logging level is inappropriate since the VDB has full functionality since I am able to connect and execute some queries. Could lead to something more serious though, so reporting it as a bug until proven innocent.
> {code}
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,954 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=UFCESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,955 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=GMSESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,957 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=STABLEESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,958 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=UNICAST2ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,959 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=NAKACKESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,961 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=BARRIERESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,961 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=VERIFY_SUSPECTESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,962 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
> ="STEVE.1",protocol=FDESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,963 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=FD_SOCKESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,964 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=MERGE2ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,964 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=TCPPINGESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,965 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=TCPESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,968 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=channel,cluster="STEVE.1"ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[31m22:08:39,969 ERROR [org.teiid.RUNTIME] (teiid-async-threads - 8) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl@6518dd87: java.lang.IllegalStateException: cluster 'STEVE.1' is already connected to singleton transport: [dummy-1461636444525, dummy-1461636519952, PHX_ODS_DMM_LEGACY.1, PHX_ODS_DBA.1, Odata_TEST.1, ProjectionsUSHSI.1, ImputationV1.1, GMR_SQLDB_TEST.1, UK_PBS_VDB.1, EDE_US.1, BDF_CorrectionsVDB_V1.1, ImputationV1_DEV.1, HSISIT.1, UKPROJECTION.1, Gossip.1, HCR_CADM_CR_PROC.1, HSIWIP.1, MyVDB.1, dummy-1460722343623, HSIRES.1, KnowledgeFactory_Job.1, HSITEST.1, HCR_CADM_SYNDICATED.1, COL_VDB.1, dummy-1460722100133, $TEIID_BM$, BDF_CorrectionsVDB_SIT.1, dummy-1460720870935, PROJECTIONTEMPVDB.1, UK_PBS_Project_VDB.1, PROJECTIONVDB.1, $TEIID_ED$, DeployVDB.1, GMR_SQLDB_DBA.1, teiid-cache, STEVE.1, dummy-1460722176622, HCR_CADM.1, HSI.1, dummy-1461636277237, DedupsVdb.1, IMPUTATION_FRANCE.1, dummy-1460720872393, MSTRTestVdb.1]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.stack.ProtocolStack.startStack(ProtocolStack.java:919) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.startStack(JChannel.java:827) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel._preConnect(JChannel.java:525) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.connect(JChannel.java:277) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.connect(JChannel.java:268) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.replication.jgroups.JGroupsObjectReplicator.replicate(JGroupsObjectReplicator.java:564) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.CompositeGlobalTableStore.createInstance(CompositeGlobalTableStore.java:57) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$1.finishedDeployment(VDBService.java:156) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:348) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:304) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$6.run(VDBService.java:408) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$7.run(VDBService.java:439) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]ESC[0m
> [Server:cdtssoa126d-jdv-one] ESC[31m at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]ESC[0m
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4190) Enabling/Disabling a Datasource prompts for server restart
by Steve Tran (JIRA)
Steve Tran created TEIID-4190:
---------------------------------
Summary: Enabling/Disabling a Datasource prompts for server restart
Key: TEIID-4190
URL: https://issues.jboss.org/browse/TEIID-4190
Project: Teiid
Issue Type: Bug
Environment: Red Hat JBoss Data Virtualization 6.2.4 on EAP patched to version 6.4.6, on Oracle Linux 6
JBoss Developer Studio 8.1.0GA with Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
64-bit Windows 7 environment
Reporter: Steve Tran
Assignee: Steven Hawkins
Getting an error while replacing an existing VDB with JDV 6.2.4. I think the logging level is inappropriate since the VDB has full functionality since I am able to connect and execute some queries. Could lead to something more serious though, so reporting it as a bug until proven innocent.
{code}
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,954 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=UFCESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,955 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=GMSESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,957 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=STABLEESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,958 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=UNICAST2ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,959 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=NAKACKESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,961 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=BARRIERESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,961 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=VERIFY_SUSPECTESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,962 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster
="STEVE.1",protocol=FDESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,963 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=FD_SOCKESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,964 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=MERGE2ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,964 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=TCPPINGESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,965 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=TCPESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,968 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=channel,cluster="STEVE.1"ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[31m22:08:39,969 ERROR [org.teiid.RUNTIME] (teiid-async-threads - 8) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl@6518dd87: java.lang.IllegalStateException: cluster 'STEVE.1' is already connected to singleton transport: [dummy-1461636444525, dummy-1461636519952, PHX_ODS_DMM_LEGACY.1, PHX_ODS_DBA.1, Odata_TEST.1, ProjectionsUSHSI.1, ImputationV1.1, GMR_SQLDB_TEST.1, UK_PBS_VDB.1, EDE_US.1, BDF_CorrectionsVDB_V1.1, ImputationV1_DEV.1, HSISIT.1, UKPROJECTION.1, Gossip.1, HCR_CADM_CR_PROC.1, HSIWIP.1, MyVDB.1, dummy-1460722343623, HSIRES.1, KnowledgeFactory_Job.1, HSITEST.1, HCR_CADM_SYNDICATED.1, COL_VDB.1, dummy-1460722100133, $TEIID_BM$, BDF_CorrectionsVDB_SIT.1, dummy-1460720870935, PROJECTIONTEMPVDB.1, UK_PBS_Project_VDB.1, PROJECTIONVDB.1, $TEIID_ED$, DeployVDB.1, GMR_SQLDB_DBA.1, teiid-cache, STEVE.1, dummy-1460722176622, HCR_CADM.1, HSI.1, dummy-1461636277237, DedupsVdb.1, IMPUTATION_FRANCE.1, dummy-1460720872393, MSTRTestVdb.1]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.stack.ProtocolStack.startStack(ProtocolStack.java:919) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.startStack(JChannel.java:827) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel._preConnect(JChannel.java:525) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.connect(JChannel.java:277) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.connect(JChannel.java:268) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.replication.jgroups.JGroupsObjectReplicator.replicate(JGroupsObjectReplicator.java:564) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.CompositeGlobalTableStore.createInstance(CompositeGlobalTableStore.java:57) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$1.finishedDeployment(VDBService.java:156) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:348) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:304) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$6.run(VDBService.java:408) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$7.run(VDBService.java:439) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]ESC[0m
[Server:cdtssoa126d-jdv-one] ESC[31m at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]ESC[0m
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4054) OData - creation of entity (POST) returns exception (status code 500)
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4054?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4054:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316490|https://bugzilla.redhat.com/show_bug.cgi?id=1316490] from MODIFIED to ON_QA
> OData - creation of entity (POST) returns exception (status code 500)
> ---------------------------------------------------------------------
>
> Key: TEIID-4054
> URL: https://issues.jboss.org/browse/TEIID-4054
> Project: Teiid
> Issue Type: Sub-task
> Components: OData
> Reporter: Juraj Duráni
> Assignee: Ramesh Reddy
> Labels: alpha3
> Fix For: 9.0, 8.12.5
>
>
> Creation of entity returns exception \[1\]. Representation of entity \[2\]. Http request \[3\]. Header \[4\]. Same exception with of JSON format.
> \[1\]
> {code:plain}
> TEIID10076 Invalid conversion from type class java.lang.Object with value 'java.util.GregorianCalendar[time=4000,areFieldsSet=true,areAllFieldsSet=true,
> lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],f
> irstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=1970,MONTH=0,WEEK_OF_YEAR=1,
> WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=1,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=1,
> AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=4,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
> to type class java.sql.Time
> {code}
> \[2\]
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <entry xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://docs.oasis-open.org/odata/ns/data" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" xmlns:m="http://docs.oasis-open.org/odata/ns/metadata">
> <category scheme="http://docs.oasis-open.org/odata/ns/scheme" />
> <content type="application/xml">
> <m:properties>
> <d:intkey m:type="Int32">4</d:intkey>
> <d:intnum m:type="Int32">4</d:intnum>
> <d:stringkey>4</d:stringkey>
> <d:stringval>value_4</d:stringval>
> <d:booleanval m:type="Boolean">false</d:booleanval>
> <d:decimalval m:type="Double">-20.4</d:decimalval>
> <d:timeval m:type="TimeOfDay">00:00:04</d:timeval>
> <d:dateval m:type="Date">2004-04-04</d:dateval>
> <d:timestampval m:type="DateTimeOffset">2004-01-01T00:00:04Z</d:timestampval>
> <d:clobval m:type="Binary">Y2xvYl92YWx1ZV8wMDAwNA==</d:clobval>
> </m:properties>
> </content>
> </entry>
> {code}
> \[3\]
> POST http://localhost:8080/odata4/olingo_basic/Source/PostTable(4)
> \[4\]
> Content-type: application/xml
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4115) XMLTABLE single element in sequence invalid conversion
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4115?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4115:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1323996|https://bugzilla.redhat.com/show_bug.cgi?id=1323996] from MODIFIED to ON_QA
> XMLTABLE single element in sequence invalid conversion
> ------------------------------------------------------
>
> Key: TEIID-4115
> URL: https://issues.jboss.org/browse/TEIID-4115
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.5
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> There is a possibility to handle xml element sequences as arrays when using XMLTABLE function.
> When there's only one element in the sequence, an exception is thrown:
> {code:plain}
> org.teiid.jdbc.TeiidSQLException: TEIID10076 Invalid conversion from type class java.lang.String with value 'first' to type class [Ljava.lang.String;
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:703)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:542)
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
> at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:268)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:306)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy6.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:405)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:404)
> at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:338)
> at org.jboss.qe.functions.xml.XmlTableTest.testXmlTableSequenceArrayOneElement(XmlTableTest.java:74)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:80)
> at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
> at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
> at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
> at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
> at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
> at org.testng.TestRunner.privateRun(TestRunner.java:767)
> at org.testng.TestRunner.run(TestRunner.java:617)
> at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
> at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
> at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
> at org.testng.SuiteRunner.run(SuiteRunner.java:240)
> at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
> at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
> at org.testng.TestNG.runSuitesSequentially(TestNG.java:1198)
> at org.testng.TestNG.runSuitesLocally(TestNG.java:1123)
> at org.testng.TestNG.run(TestNG.java:1031)
> at org.apache.maven.surefire.testng.TestNGExecutor.run(TestNGExecutor.java:70)
> at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.execute(TestNGDirectoryTestSuite.java:108)
> at org.apache.maven.surefire.testng.TestNGProvider.invoke(TestNGProvider.java:111)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
> at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
> at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:172)
> at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:104)
> at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:70)
> Caused by: org.teiid.core.types.TransformationException: TEIID10076 Invalid conversion from type class java.lang.String with value 'first' to type class [Ljava.lang.String;
> at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:940)
> at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:928)
> at org.teiid.query.function.FunctionDescriptor.importValue(FunctionDescriptor.java:322)
> at org.teiid.query.processor.relational.XMLTableNode.getValue(XMLTableNode.java:376)
> at org.teiid.query.processor.relational.XMLTableNode.processRow(XMLTableNode.java:341)
> at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:225)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:470)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
> The invocation of XMLTABLE function is as follows:
> {code:sql}
> CREATE VIEW SEQUENCE_AS_ARRAY_ONE_ELEMENT(x string[]) AS select * from xmltable('/a' passing convert('<a><b>first</b></a>', xml) columns x string[] path 'b') as x;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4159) Hive translator - select distinct count(*) is not supported
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4159?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4159:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1329170|https://bugzilla.redhat.com/show_bug.cgi?id=1329170] from MODIFIED to ON_QA
> Hive translator - select distinct count(*) is not supported
> -----------------------------------------------------------
>
> Key: TEIID-4159
> URL: https://issues.jboss.org/browse/TEIID-4159
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.12.x
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5
>
>
> Hive does not support query like SELECT DISTINCT COUNT\(*\) ...
> Example query:
> SELECT DISTINCT COUNT\(*\) FROM Source.SmallA AS g_0
> Exception:
> {code:plain}
> 0:23:47,771 WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue106) TEIID30020 Processing exception for request NRTyWX7OfkHZ.19 'TEIID30504 Source: 10128 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT COUNT(*) FROM smalla g_0]'. Originally TeiidProcessingException 'org.apache.hadoop.hive.ql.parse.SemanticException:Line 1:16 Not yet supported place for UDAF 'COUNT'' TypeCheckProcFactory.java:844.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 10128 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT COUNT(*) FROM smalla g_0]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:374) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:470) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
> Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 10128 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT COUNT(*) FROM smalla g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:359) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) [:1.8.0-internal]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal]
> at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy47.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> ... 6 more
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 1:16 Not yet supported place for UDAF 'COUNT'
> at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:258)
> at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:244)
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:247)
> at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:378)
> at org.apache.hive.jdbc.HivePreparedStatement.executeQuery(HivePreparedStatement.java:109)
> at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
> ... 17 more
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 1:16 Not yet supported place for UDAF 'COUNT'
> at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:112)
> at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
> at org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:419)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:406)
> at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:274)
> at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1317)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1302)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.8.0-internal]
> ... 1 more
> Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.parse.SemanticException:Line 1:16 Not yet supported place for UDAF 'COUNT'
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.validateUDF(TypeCheckProcFactory.java:844)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:979)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1316)
> at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:95)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:79)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:133)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:110)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:213)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:157)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genAllExprNodeDesc(SemanticAnalyzer.java:10507)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10463)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10431)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10425)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanMapGroupByOperator(SemanticAnalyzer.java:4628)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanMapAggrNoSkew(SemanticAnalyzer.java:5723)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:8883)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9743)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9636)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10109)
> at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:329)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10120)
> at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:211)
> at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:227)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:456)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1181)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1175)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
> ... 15 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4146) Using JDG Library Mode, unable to perform insert (
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4146?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4146:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1327752|https://bugzilla.redhat.com/show_bug.cgi?id=1327752] from MODIFIED to ON_QA
> Using JDG Library Mode, unable to perform insert (
> --------------------------------------------------
>
> Key: TEIID-4146
> URL: https://issues.jboss.org/browse/TEIID-4146
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.5
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Critical
> Fix For: 9.0, 8.12.5
>
>
> Trying to run the JDG local cache quickstart, get the following error when trying to perform an insert:
> 15:09:34,027 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue12) TEIID30020 Processing exception for request O25SlCY41bD5.6 'TEIID30492 Element StockCache.Stock.StockObject of StockCache.Stock is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:330. Enable more detailed logging to see the entire stacktrace.
> The issue is because the StockObject column is set to be NullType.unknown, instead of NullType.Nullable. This is because the metadata processor in the translator-object is setting it incorrectly.
> Workaround:
> - Using Teiid Designer to import the source model and change the null type.
> - use dynamic vdb and define the DDL metadata to set the null type.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months