Error Err-7620 Could Not Determine Workspace For Application 100
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript 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 error err-7620 could not determine workspace for application (4950). ora-01403: no data found message. Please type your message and try again. More discussions in Oracle Application Express there is a problem with your environment because the application express files have not been loaded (APEX) All PlacesDatabaseDatabase Application DevelopmentOracle Application Express (APEX) This discussion is archived 10 Replies Latest reply on Apr 16, 2015 8:37 apex could not determine workspace for application PM by TexasApexDeveloper ERR-7620 Could not determine workspace for application (4950), ORA-01403: no data found marussig Apr 16, 2015 5:30 PM Hi, I'm trying to upgrade XE APEX 4 to 5 with this tutorialhttps://docs.oracle.com/cd/E59726_01/install.50/e39144/oracle_xe.htm#HTMIG29430Everything err 7620 could not determine workspace for application 4500 was fine, no errors, but after upgrade I can't run apex anymore and get this err message.Laptop with MS 8.1 PRO, 64What to do? Thanks for help. 7384Views Tags: none (add) This content has been marked as final. Show 10 replies 1. Re: ERR-7620 Could not determine workspace for application (4950), ORA-01403: no data found TexasApexDeveloper Apr 16, 2015 5:50 PM (in response to marussig) What err message?? I think
Http://hostname:port/apex/apex_admin
you need to include more information..Thank you,Tony MillerLuvMuffin SoftwareRuckersville, VA Like Show 0 Likes(0) Actions 2. Re: ERR-7620 Could not determine workspace for application (4950), ORA-01403: no data found marussig Apr 16, 2015 5:57 PM (in response to TexasApexDeveloper) Tony, err 7620 as I specified in the tittle. Like Show 0 Likes(0) Actions 3. Re: ERR-7620 Could not determine workspace for application (4950), ORA-01403: no data found TexasApexDeveloper Apr 16, 2015 6:34 PM (in response to marussig) That is the database Admin application. Once you upgrade the version of APEX in 11g XE, that application is not available any longer... You will need to try accessing application id 4550 to log into the workspace..Thank you,Tony MillerLuvMuffin SoftwareRuckersville, VA Like Show 0 Likes(0) Actions 4. Re: ERR-7620 Could not determine workspace for application (4950), ORA-01403: no data found marussig Apr 16, 2015 6:50 PM (in response to TexasApexDeveloper) Tony, if I understand you I removed admin application when I upgraded to 5? I changed id to 4550 as you recommend but now i need to know the workspace name... Does 5 has any default workspace? Like Show 0 Likes(0) Actions 5. Re: ERR-7620 Could not determine workspace for application (4950), ORA-01403: no data found TexasApexDeveloper Apr 16,
contain security group id of application owner. Error ERR-7620 Could not determine workspace for application (). The application had been working fine and it puzzled me why the link wasn't working. A direct link to the application worked but when using an alias in the URL it failed. If I changed the alias the error went away ... but I didn't want to change the alias because it meant I would have to find all the links that used it. Which sort of defeats the point of using an alias in the first place! The solution was to find out if any other https://community.oracle.com/thread/3701446 applications were using the same alias. So I ran the following query against the main APEX tables in my FLOWS schema : SELECT * FROM (SELECT COUNT(ALIAS) "COUNT",ALIAS FROM APEX_APPLICATIONS GROUP BY ALIAS) WHERE COUNT>1 ORDER BY COUNT DESC; This highlighted another application in a different workspace that was using the same application alias. An Oracle developer had cloned my application for development purposes and it ended http://www.mattsbits.co.uk/item-143.html up with the same alias as the live application. Once I changed the alias in the copy my application links started working again! Author : MattHawkinsLast Edit By : Matt Hawkins Permalink Navigation Homepage Top 20 Posts Our Files Categories All (167) Android (9) APEX (13) ecommerce (2) General (35) HTML & CSS (10) JavaScript (16) Microsoft .NET (3) Mobile Phones (15) Multimedia (25) Oracle (15) PHP & MySQL (5) Python (2) Raspberry PI (5) Reviews (7) Sharepoint (6) VBScript (6) Windows (11) Links »APEX APEX Blog Aggregator APEX on Wikipedia Application Express Documentation Application Express Home Application Express Official Forum Denes Kubicek ApEx BLOG »JavaScript DynamicDrive JavaScript on Wikipedia »Oracle Official Oracle Forums Oracle SQL Developer »Web Tools Binary Decimal Hexadecimal Co... Hash Generator HTML List Generator LED Current Limiting Resistor... Mortgage Calculator Oracle BI Publisher Chart Generator Rounded Corner Generator Secure Password Generator ShopIntegrator Button Generator Text to HTML Converter ... Show More Follow @MattScript Archive 2014 (3) 2013 (7) 2012 (23) 2011 (59) 2010 (52) 2009 (23) Site Search Google Web Search Login User Name: Password: If you wish to contact us please email webmaster@mattsbits.co.uk - [Privacy Policy] MattHawkins CMS
installation part 5: Glassfish configuration part 6: Oracle HTTP server installation part 7: Oracle http://warp11.nl/2011/12/import-apex-application-at-command-line/ HTTP server configuration addendum: using email Contact us Categories Apex http://www.htmldb.de/htmldb/read.php?1,2220 Apex Reports Configuration Development Tools Oracle DB PL/SQL SQL Ajax Search Import Apex Application at command line Posted on December 12, 2011 by rmartens | 6 Replies Recently (since 4.1 update) I've experienced issues when importing an application into an Apex environment. After could not a little bit of searching I found the way to do the import on the command-line. It is documented in the Apex documentation, but as you know I'd like this blog to be an "OPI" (one point of information) 🙂 Please have a look at the script, alter it whenever appropriate. declare -- the could not determine name of the workspace in wich to import t_workspace varchar2(30):= 'MERIDA'; -- an application number of an existing application in the workspace. t_existing_app number := 100; -- the "new" application number, an existing number will be dropped first. t_new_app number := 100; -- security group id, you don't have to set this variable t_secgrp_id number; begin -- get the Security Group ID select workspace_id into t_secgrp_id from apex_applications where application_id = t_existing_app; -- Set the Security Group ID wwv_flow_api.set_security_group_id(p_security_group_id => t_secgrp_id); -- Set the Application ID to use apex_application_install.set_application_id(t_new_app); -- This procedure generates the offset value used during application import. -- The offset value is used to ensure that the metadata for the Application -- Express application definition does not collide with other metadata on -- the instance. For a new application installation, it is usually sufficient -- to call this procedure to have Application Express generate this offset -- value for you. apex_application_install.generate_offset; -- Set th
(x). geschrieben von: THoekstra (IP gespeichert) Datum: 14. April 2010 14:53 Hallo zusammen, zunächst einmal muss ich leider zugeben, dass ich kein großer APEX Experte bin. Ich habe folgendes Problem: Eine APEX Anwendung musste auf einen anderen DB Server "umziehen". Der alter Server war Oracle 10.2.0.2, 32 Bit, der neue ist 11.1.0.7, 64 Bit. Wir haben keinen Zugriff auf die APEX Administration bzw. Entwicklung. Ich habe das Schema flows_02020 und das Anwendungs-Schema via DataPump exportiert und importiert und das Konto apex_public_user entsperrt und das Passwort entsprechend der marvel.conf angepasst. In %APEX_HOME%\Apache\modplsql\conf habe ich die marvel.conf angepasst, damit auf die neue Datenbank zugegriffen wird. Weitere Änderungen wurden an dem APEX OracleHome nicht vorgenommen. Nach der Eingabe von Benutzername und Passwort kommt jetzt folgende Fehlermeldung: Error ERR-7620 Could not determine workspace for application (100). Hat einer von den Experten eine Idee, woran das liegt? Apex greift doch jetzt auf die neue Datenbank zu, und die Inhalte dort müssen doch mit denen auf der alten Datenbank identisch sein. Wo also ist der Fehler? Vielen Dank im voraus, gruß, Thomas Hoekstra navigieren:nächste Fundstellen•nächster Eintrag Optionen:Diesem Eintrag antworten•Diesen Eintrag zitieren•Diesen Eintrag melden Thema Neugierige geschrieben von geschrieben Error ERR-7620 Could not determine workspace for application (x). 2503 THoekstra 14.04.10 14:53 Navigation:Foren Liste•Themen-Übersicht•Suche•Anmelden In diesem Forum dürfen nur registrierte Benutzer schreiben. RSS-Feed. This forum powered by Phorum.