[JBoss JIRA] (TEIIDDES-2078) TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2078?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2078:
-----------------------------------
Git Pull Request: https://github.com/Teiid-Designer/teiid-designer/pull/301, https://github.com/Teiid-Designer/teiid-designer/pull/302
> TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2078
> URL: https://issues.jboss.org/browse/TEIIDDES-2078
> Project: Teiid Designer
> Issue Type: Bug
> Components: Validation
> Affects Versions: 8.3.1
> Reporter: Debbie Steigner
> Fix For: 8.3.2, 8.5
>
>
> Reproduced with ease. I have JBDS 7.1.0 with the same Teiid Designer as customer Teiid Designer 8.3.1.Final-v20140122-1920-B21. Created a new Model Project, new Teiid View Model, new Child Procedure and entered below[1] as SQL transformation, validate and you immediately get the error. Obviously I have no other tables with the same name so the error message is bogus. Found this jira, but supposedly fixed in teiid designer 8.1 https://issues.jboss.org/browse/TEIIDDES-1554
> Looking at the documentation, the syntax is correct: https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Data_Vir... in fact you can create a virtual procedure with the example[2] in the doc and get the same error!
> [1] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE MY_TEMP (MY_COL string);
> END
> ERROR: TEIID30118 Cannot create temporary table "MY_TEMP". An object with the same name already exists.
> [2] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE TEMP (a integer, b integer, c integer);
> SELECT * INTO temp FROM Src1;
> SELECT * INTO temp FROM Src2;
> INSERT INTO temp VALUES (1, 2, 3);
> SELECT a, b, c FROM Src3, temp WHERE Src3.a = temp.b;
> END
> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2071) Teiid connection import timeouts for oracle, salesforce data sources
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2071?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-2071.
-------------------------------------
Resolution: Rejected
Increasing the timeout should address this. If not, please reopen.
> Teiid connection import timeouts for oracle, salesforce data sources
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2071
> URL: https://issues.jboss.org/browse/TEIIDDES-2071
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3.1
> Environment: JBTIS 4.1.3.Final, JBDS 7.1.0.GA, DV 6 CR2, Fedora 19
> Reporter: Lucie Fabrikova
> Assignee: Mark Drilling
>
> Teiid importer teiid connection >> source model fails for oracle and salesforce data sources, with "Loading did not complete within 120 sec for VDB: "importVDB". The error log is empty, the server log for oracle:
> 14:47:58,281 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")
> 14:47:58,326 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 3/4/14 2:47 PM
> 14:47:58,447 INFO [org.jboss.as.server] (management-handler-thread - 8) JBAS018559: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml")
> 14:50:15,641 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, oracle, java:/oracle}]" undeployed.
> 14:50:15,651 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015877: Stopped deployment importVDB-vdb.xml (runtime-name: importVDB-vdb.xml) in 17ms
> 14:50:15,744 INFO [org.jboss.as.repository] (management-handler-thread - 5) JBAS014901: Content removed from location /home/lfabriko/Work/tools/DV-6.0.0.GA-redhat-4/server03/jboss-eap-6.1/standalone/data/content/2b/cf8c1e1f29d03c6541693843b60a33d5b30747/content
> 14:50:15,745 INFO [org.jboss.as.server] (management-handler-thread - 5) JBAS018558: Undeployed "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2048) TEIID70026 RAR file name supplied on operation is wrong or no such RAR file is currently deployed.
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2048?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-2048.
-------------------------------------
Resolution: Cannot Reproduce Bug
More specifics are required in order to address this issue. Please re-open if you have more information.
> TEIID70026 RAR file name supplied on operation is wrong or no such RAR file is currently deployed.
> --------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2048
> URL: https://issues.jboss.org/browse/TEIIDDES-2048
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Windows 7 64 bit,ram 4gb,jdk 1.6 update 31
> Reporter: Pachaimuthu S
> Assignee: Mark Drilling
> Priority: Critical
>
> Dear sir/madam,
> After installed Data Virtualization v 6 GA i tried to connect DB2 10.1,mysql 5.1 and mssql server 2008 database i was getting error message:
> TEIID70026 RAR file name supplied on operation is wrong or no such RAR file is currently deployed.
> at org.teiid.adminapi.AdminFactory$AdminImpl$BuildPropertyDefinitions.onFailure(AdminFactory.java:1191)
> at org.teiid.adminapi.AdminFactory$AdminImpl.cliCall(AdminFactory.java:1475)
> at org.teiid.adminapi.AdminFactory$AdminImpl.getTemplatePropertyDefinitions(AdminFactory.java:1156)
> at org.teiid84.runtime.ExecutionAdmin.refreshTranslators(ExecutionAdmin.java:659)
> at org.teiid84.runtime.ExecutionAdmin.refresh(ExecutionAdmin.java:618)
> at org.teiid84.runtime.ExecutionAdmin.connect(ExecutionAdmin.java:607)
> at org.teiid.designer.runtime.TeiidServer.connect(TeiidServer.java:192)
> at org.teiid.designer.runtime.TeiidServer.reconnect(TeiidServer.java:221)
> at org.teiid.designer.runtime.TeiidParentServerListener.serverChanged(TeiidParentServerListener.java:165)
> at org.eclipse.wst.server.core.internal.ServerNotificationManager.broadcastChange(ServerNotificationManager.java:125)
> at org.eclipse.wst.server.core.internal.Server.fireServerStateChangeEvent(Server.java:742)
> at org.eclipse.wst.server.core.internal.Server.setServerState(Server.java:650)
> at org.eclipse.wst.server.core.model.ServerBehaviourDelegate.setServerState(ServerBehaviourDelegate.java:143)
> at org.jboss.ide.eclipse.as.core.server.internal.DeployableServerBehavior.setServerStarted(DeployableServerBehavior.java:210)
> at org.jboss.ide.eclipse.as.core.server.internal.DelegatingServerBehavior.setServerStarted(DelegatingServerBehavior.java:100)
> at org.jboss.ide.eclipse.as.core.server.internal.launch.AbstractJBossStartLaunchConfiguration.handleAlreadyStartedScenario(AbstractJBossStartLaunchConfiguration.java:132)
> at org.jboss.ide.eclipse.as.core.server.internal.launch.AbstractJBossStartLaunchConfiguration.preLaunchCheck(AbstractJBossStartLaunchConfiguration.java:103)
> at org.jboss.ide.eclipse.as.core.server.internal.v7.LocalJBoss7StartLaunchDelegate.preLaunchCheck(LocalJBoss7StartLaunchDelegate.java:39)
> at org.jboss.ide.eclipse.as.core.server.internal.launch.DelegatingStartLaunchConfiguration.preLaunchCheck(DelegatingStartLaunchConfiguration.java:67)
> at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:813)
> at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:707)
> at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:700)
> at org.eclipse.wst.server.core.internal.Server.startImpl2(Server.java:3537)
> at org.eclipse.wst.server.core.internal.Server.startImpl(Server.java:3473)
> at org.eclipse.wst.server.core.internal.Server$StartJob.run(Server.java:367)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1843) could installation of Teiid Designer be made simpler via p2 metadata <references> to upstream sites?
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1843?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-1843.
-------------------------------------
Resolution: Done
This can now be closed. Instructions have been updated - https://www.jboss.org/teiiddesigner/downloads
> could installation of Teiid Designer be made simpler via p2 metadata <references> to upstream sites?
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1843
> URL: https://issues.jboss.org/browse/TEIIDDES-1843
> Project: Teiid Designer
> Issue Type: Bug
> Components: Build, Documentation, Usability
> Affects Versions: 8.2
> Reporter: Nick Boldt
> Assignee: Mark Drilling
> Fix For: 8.5
>
> Attachments: InstallError.png, TEIIDDES1843.png, TEIIDDES1843_2.png
>
>
> Current instructions for installing Teiid Designer 8.2 [1] involve multiple steps, installs, and restarts of Eclipse. This is more complex than it needs to be.
> [1] https://www.jboss.org/teiiddesigner/downloads
> Instead, the Teiid Designer update site could simply reference the upstream URLs that it needs to perform the installation, and as long as all of Teiid Designer's features & plugins properly define dependencies on the required upstream features and plugins on these update sites, installation should be able to proceed from a single URL, rather than a handful. It would allow installation via a single step, rather than several iterative steps.
> I'll attach a PR to demonstrate this.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2030) Querying webservice of VDB throws javax.naming.NameNotFoundException
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2030?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2030:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1057076|https://bugzilla.redhat.com/show_bug.cgi?id=1057076] from MODIFIED to CLOSED
> Querying webservice of VDB throws javax.naming.NameNotFoundException
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2030
> URL: https://issues.jboss.org/browse/TEIIDDES-2030
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3.1
> Environment: JBTIS 4.1.3.Final, JBDS 7.1.0.GA, DV 6 CR2, Fedora 19, Java oracle jdk 1.7.0_45, teiid translator 8.4 (https://repository.jboss.org/nexus/content/repositories/public-jboss/org/...)
> Reporter: Lucie Fabrikova
> Attachments: ConsumeWSNoJNDI.zip, countryInfoNoJNDI.vdb, countryInfoNoJNDI.war
>
>
> Querying (via soapui) a webservice created from VDB which contains a model without a JNDI name (model MarketData with yahoo translator, viz TDES-2024), server throws exception javax.naming.NameNotFoundException.
> If the model without JNDI is removed from VDB, the query is successful.
> (the models in project were created via "Consume a SOAP web service" cheat sheet from DV6 doc., detailed instructions in TestSpecs/Designer8-updatedE2eConsumeSoapWS-cheatSheetCompletion.odt)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2078) TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2078?page=com.atlassian.jira.plu... ]
Bram Gadeyne edited comment on TEIIDDES-2078 at 3/17/14 5:31 AM:
-----------------------------------------------------------------
I'm having the same issue in teiiddesigner 8.4. Is there a workaround?
was (Author: gadeyne.bram):
I'm having the same issue. Is there a workaround?
> TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2078
> URL: https://issues.jboss.org/browse/TEIIDDES-2078
> Project: Teiid Designer
> Issue Type: Bug
> Components: Validation
> Affects Versions: 8.3.1
> Reporter: Debbie Steigner
> Fix For: 8.3.2, 8.5
>
>
> Reproduced with ease. I have JBDS 7.1.0 with the same Teiid Designer as customer Teiid Designer 8.3.1.Final-v20140122-1920-B21. Created a new Model Project, new Teiid View Model, new Child Procedure and entered below[1] as SQL transformation, validate and you immediately get the error. Obviously I have no other tables with the same name so the error message is bogus. Found this jira, but supposedly fixed in teiid designer 8.1 https://issues.jboss.org/browse/TEIIDDES-1554
> Looking at the documentation, the syntax is correct: https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Data_Vir... in fact you can create a virtual procedure with the example[2] in the doc and get the same error!
> [1] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE MY_TEMP (MY_COL string);
> END
> ERROR: TEIID30118 Cannot create temporary table "MY_TEMP". An object with the same name already exists.
> [2] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE TEMP (a integer, b integer, c integer);
> SELECT * INTO temp FROM Src1;
> SELECT * INTO temp FROM Src2;
> INSERT INTO temp VALUES (1, 2, 3);
> SELECT a, b, c FROM Src3, temp WHERE Src3.a = temp.b;
> END
> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2078) TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2078?page=com.atlassian.jira.plu... ]
Bram Gadeyne commented on TEIIDDES-2078:
----------------------------------------
I'm having the same issue. Is there a workaround?
> TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2078
> URL: https://issues.jboss.org/browse/TEIIDDES-2078
> Project: Teiid Designer
> Issue Type: Bug
> Components: Validation
> Affects Versions: 8.3.1
> Reporter: Debbie Steigner
> Fix For: 8.3.2, 8.5
>
>
> Reproduced with ease. I have JBDS 7.1.0 with the same Teiid Designer as customer Teiid Designer 8.3.1.Final-v20140122-1920-B21. Created a new Model Project, new Teiid View Model, new Child Procedure and entered below[1] as SQL transformation, validate and you immediately get the error. Obviously I have no other tables with the same name so the error message is bogus. Found this jira, but supposedly fixed in teiid designer 8.1 https://issues.jboss.org/browse/TEIIDDES-1554
> Looking at the documentation, the syntax is correct: https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Data_Vir... in fact you can create a virtual procedure with the example[2] in the doc and get the same error!
> [1] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE MY_TEMP (MY_COL string);
> END
> ERROR: TEIID30118 Cannot create temporary table "MY_TEMP". An object with the same name already exists.
> [2] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE TEMP (a integer, b integer, c integer);
> SELECT * INTO temp FROM Src1;
> SELECT * INTO temp FROM Src2;
> INSERT INTO temp VALUES (1, 2, 3);
> SELECT a, b, c FROM Src3, temp WHERE Src3.a = temp.b;
> END
> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2078) TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2078?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2078:
----------------------------------------
org.teiid.designer.transformation.metadata.TransformationMetadata.hasProcedure() method is returning TRUE if an Exception is caught. Teiid's equivalent methods are throwing exceptions if a procedure IS located in the metadata. So the behavior is different.
Need to change to FALSE is exception is caught.
> TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2078
> URL: https://issues.jboss.org/browse/TEIIDDES-2078
> Project: Teiid Designer
> Issue Type: Bug
> Components: Validation
> Affects Versions: 8.3.1
> Reporter: Debbie Steigner
> Fix For: 8.3.2, 8.5
>
>
> Reproduced with ease. I have JBDS 7.1.0 with the same Teiid Designer as customer Teiid Designer 8.3.1.Final-v20140122-1920-B21. Created a new Model Project, new Teiid View Model, new Child Procedure and entered below[1] as SQL transformation, validate and you immediately get the error. Obviously I have no other tables with the same name so the error message is bogus. Found this jira, but supposedly fixed in teiid designer 8.1 https://issues.jboss.org/browse/TEIIDDES-1554
> Looking at the documentation, the syntax is correct: https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Data_Vir... in fact you can create a virtual procedure with the example[2] in the doc and get the same error!
> [1] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE MY_TEMP (MY_COL string);
> END
> ERROR: TEIID30118 Cannot create temporary table "MY_TEMP". An object with the same name already exists.
> [2] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE TEMP (a integer, b integer, c integer);
> SELECT * INTO temp FROM Src1;
> SELECT * INTO temp FROM Src2;
> INSERT INTO temp VALUES (1, 2, 3);
> SELECT a, b, c FROM Src3, temp WHERE Src3.a = temp.b;
> END
> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2078) TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2078?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2078:
-----------------------------------
Fix Version/s: 8.3.2
8.5
> TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2078
> URL: https://issues.jboss.org/browse/TEIIDDES-2078
> Project: Teiid Designer
> Issue Type: Bug
> Components: Validation
> Affects Versions: 8.3.1
> Reporter: Debbie Steigner
> Fix For: 8.3.2, 8.5
>
>
> Reproduced with ease. I have JBDS 7.1.0 with the same Teiid Designer as customer Teiid Designer 8.3.1.Final-v20140122-1920-B21. Created a new Model Project, new Teiid View Model, new Child Procedure and entered below[1] as SQL transformation, validate and you immediately get the error. Obviously I have no other tables with the same name so the error message is bogus. Found this jira, but supposedly fixed in teiid designer 8.1 https://issues.jboss.org/browse/TEIIDDES-1554
> Looking at the documentation, the syntax is correct: https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Data_Vir... in fact you can create a virtual procedure with the example[2] in the doc and get the same error!
> [1] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE MY_TEMP (MY_COL string);
> END
> ERROR: TEIID30118 Cannot create temporary table "MY_TEMP". An object with the same name already exists.
> [2] CREATE VIRTUAL PROCEDURE
> BEGIN
> CREATE LOCAL TEMPORARY TABLE TEMP (a integer, b integer, c integer);
> SELECT * INTO temp FROM Src1;
> SELECT * INTO temp FROM Src2;
> INSERT INTO temp VALUES (1, 2, 3);
> SELECT a, b, c FROM Src3, temp WHERE Src3.a = temp.b;
> END
> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-2078) TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
by Debbie Steigner (JIRA)
Debbie Steigner created TEIIDDES-2078:
-----------------------------------------
Summary: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
Key: TEIIDDES-2078
URL: https://issues.jboss.org/browse/TEIIDDES-2078
Project: Teiid Designer
Issue Type: Bug
Components: Validation
Affects Versions: 8.3.1
Reporter: Debbie Steigner
Reproduced with ease. I have JBDS 7.1.0 with the same Teiid Designer as customer Teiid Designer 8.3.1.Final-v20140122-1920-B21. Created a new Model Project, new Teiid View Model, new Child Procedure and entered below[1] as SQL transformation, validate and you immediately get the error. Obviously I have no other tables with the same name so the error message is bogus. Found this jira, but supposedly fixed in teiid designer 8.1 https://issues.jboss.org/browse/TEIIDDES-1554
Looking at the documentation, the syntax is correct: https://access.redhat.com/site/documentation/en-US/Red_Hat_JBoss_Data_Vir... in fact you can create a virtual procedure with the example[2] in the doc and get the same error!
[1] CREATE VIRTUAL PROCEDURE
BEGIN
CREATE LOCAL TEMPORARY TABLE MY_TEMP (MY_COL string);
END
ERROR: TEIID30118 Cannot create temporary table "MY_TEMP". An object with the same name already exists.
[2] CREATE VIRTUAL PROCEDURE
BEGIN
CREATE LOCAL TEMPORARY TABLE TEMP (a integer, b integer, c integer);
SELECT * INTO temp FROM Src1;
SELECT * INTO temp FROM Src2;
INSERT INTO temp VALUES (1, 2, 3);
SELECT a, b, c FROM Src3, temp WHERE Src3.a = temp.b;
END
ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years