An Error Occurred In Exec_query_action Service While Executing Query
Help - SpagoBI Server - CORE 1 2 ► Go Go to page... Author Message 04/03/2012 08:23:54 Subject: An error occurred in EXEC_QUERY_ACTION service while executing query: [SOLVED] anilvjava.spw Newby Joined: 01/03/2012 09:07:50 Messages: 23 Offline Dear Forum, I have uploaded the BM from SpagoBI studio to SpagoBI server and it is available under "biadmin" folder. Once I click on my BM which is available in SpagoBI biadmin floder, I have the tabs like Query,Results,Worksheet designer, and Worksheet Preview. I have a table "TEST_TABLE1" where ID,NAME,ADDRESS are columns. I drag and dropped the ID column with SELECT clause. Now the problem is when I click on "Execute Query" symbol then it is giving the below error alert and I dont know how "compId" is adding and even dont know from where it is. An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT t_0.compId.id FROM TestTable1 t_0] Can anybody please help in this regard and as well how can I write if I want to write query manually instead of generating it from SpagoBI features. Regards, Anil This message was edited 1 time. Last update was at 07/03/2012 09:45:28 04/03/2012 08:37:24 Subject: An error occurred in EXEC_QUERY_ACTION service while executing query: anilvjava.spw Newby Joined: 01/03/2012 09:07:50 Messages: 23 Offline Any update please 04/03/2012 10:52:17 Subject: An error occurred in EXEC_QUERY_ACTION service while executing query: anilvjava.spw Newby Joined: 01/03/2012 09:07:50 Messages: 23 Offline Can any of folks pls let me know the solution? 05/03/2012 10:10:48 Subject: Re:An error occurred in EXEC_QUERY_ACTION service while executing query: chrisdoudet.spw Newby Joined: 22/12/2011 15:57:16 Messages: 45 Offline hi, does your 'BM' have been linked to a datasource ? 05/03/2012 10:38:31 Subject: An error occurred in EXEC_QUERY_ACTION service while executing query: anilvjava.spw Newby Joined: 01/03/2012 09:07:50 Messages: 23 Offline Hi, First I have created Oracle datasource connection and then created the BM using SpagoBI Studio and after that I uploaded the BM to server. There should be link b/w those two as the BM will be created
vie du logiciel ALM Merise UML JavaPlateforme et langage Java Java Java Web Spring Android Eclipse NetBeans .NETMicrosoft Framework .NET Microsoft DotNET Visual Studio ASP.NET C# VB.NET Windows Phone Microsoft Azure Dév. WebDéveloppement Web et Webmarketing Développement Web AJAX Apache ASP CSS Dart Flash / Flex JavaScript PHP Ruby & Rails TypeScript Web sémantique Webmarketing (X)HTML EDIEnvironnements de Développement Intégré EDI 4D Delphi Eclipse LabVIEW NetBeans MATLAB Scilab Visual Studio WinDev Visual Basic 6 Lazarus Qt Creator ProgrammationProgrammation et langages de programmation applicatifs Programmation Débuter - Algorithmique 2D - 3D - Jeux https://www.spagoworld.org/jforum/posts/list/1138.page Assembleur C C++ Go Objective C Pascal Perl Python Swift Qt XML Autres SGBDSystèmes de Gestion de Bases de Données SGBD & SQL 4D Access Big Data DB2 Firebird InterBase MySQL NoSQL PostgreSQL Oracle Sybase SQL-Server OfficeBureautique pour l'entreprise Microsoft Office Access Excel Word Outlook PowerPoint SharePoint Microsoft Project OpenOffice & LibreOffice Solutions d'entrepriseAutres logiciels pour l'entreprise Solutions d'entreprise Big Data http://www.developpez.net/forums/d1061750/logiciels/solutions-d-entreprise/business-intelligence/autres-outils-decisionnels/spagobi/an-error-occurred-in-exec_query_action-service-while-executing-query-select-t_0-from-t_0-a/ BPM Business Intelligence ERP / PGI CRM SAS Cloud Computing SAP Microsoft BizTalk Server Talend IBM Bluemix ApplicationsApplications logicielles Applications Libres & Open Source OpenOffice & LibreOffice Projets MobilesLogiciels et matériels mobiles Mobiles Android iOS Windows Phone SystèmesLogiciels et matériels systèmes Systèmes Windows Linux Sécurité Hardware Mac Raspberry Pi Réseau Green IT Systèmes Embarqués Virtualisation Solutions d'entreprise Big Data BPM Business Intelligence ERP / PGI CRM SAS Cloud Computing SAP Microsoft BizTalk Server Talend IBM Bluemix ACCUEIL BI JASPERSOFT FORUMS BI TUTORIELS BI LIVRES BI FAQs BI GLOSSAIRE BI SOURCES BI BLOGS BI S'inscrire Aide Quoi de neuf ? Forum Actions Marquer les forums comme lus Bugs & Suggestions Réseau social Groupes Liste des utilisateurs FAQ forum Voir l'équipe du site Blogs Agenda Règles Blogs Projets Recherche avancée Index du forum Logiciels Solutions d'entreprise Business Intelligence Autres outils décisionnels SpagoBI [SBI QBE] An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT t_0. FROM t_0] + Répondre à la discussion Discussion: An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT t_0. FROM t_0] Outils de la discussion Afficher une version imprim
AdvocacyBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)HelpCommunities TipsCommunities YouTubeBMC Social Central (BMC Only)CommunitiesFree TrialsLog inRegisterCommunities Free TrialsSupportDocumentationAbout BMCNewsLog inRegister Products Events BMC https://communities.bmc.com/thread/62074?start=0&tstart=0 Engage CommunityAgenda & RegistrationDevelopersDeveloper CommunityDeveloper PortalPartners Partner DirectoriesTechnology Alliance Program (TAP)Solution Provider Portal (SPP)User Groups All groupsLocal User GroupsEvent CalendarCustomer ProgramsBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)Help Communities TipsCommunities YouTubeBMC Social Central (BMC Only)Search the BMC CommunitiesSearch the BMC CommunitiesCancelError: You don't have JavaScript an error enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Atrium Orchestrator All PlacesProductsAtriumAtrium an error occurred Orchestrator 4 Replies Latest reply on Nov 6, 2014 2:34 AM by Sowmiya Swaminathan Error occurred while querying for field IDs on Remedy schema. Josep NameToUpdate Jan 24, 2012 4:15 AM Hello,I have a problem when I try to execute the process "Get Entries" with BAO, BMC Atrium Orchestrator v7.5.02.07. I have checked the adapters configuration, the query, etc. and I think everything is ok.The error message I get is: