Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Importing from Development install to production "runtime only" installation (Apex 4.0)
Importing from Development install to production "runtime only" installation [message #484784] Thu, 02 December 2010 14:08 Go to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
Good afternoon all,

I've configured a development installation of apex 4.0, plus a production runtime only install. (actually, i created the production as full dev at first to create the workspace, and then converted it back to runtime only)

I attempted to export an application created in the development side and then import that into the production run time only (by executing the sql export as the apex schema owner).

It looks like the security ID that the development APEX assigns to the application has a problem with the security id expected in the production side.

Is there a way around this without manually editing every exported application we do?

Enter user-name: aeproduction
Enter password: 

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @f102.sql
APPLICATION 102 - aer_vendor_consignment
Set Credentials...
Illegal security group id value for this schema.
Check Compatibility...
API Last Extended:20100513
Your Current Version:20100513
This import is compatible with version: 20100513
COMPATIBLE (You should be able to run this import without issues.)
Set Application ID...
begin
*
ERROR at line 1:
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_040000.WWV_FLOW_API", line 51
ORA-06512: at "APEX_040000.WWV_FLOW_API", line 304
ORA-06512: at line 4



15:07:21 >select * from v$version
15:07:23   2  ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Re: Importing from Development install to production "runtime only" installation [message #484865 is a reply to message #484784] Fri, 03 December 2010 06:42 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
i must've stumped everyone on this one?
Re: Importing from Development install to production "runtime only" installation [message #484908 is a reply to message #484865] Fri, 03 December 2010 13:03 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
If others can explain how they currently go about deployed APEX apps from a dev environment to production, i'd like to hear them. Does everyone setup their production environment with a full development install and then just import the apps from the GUI?

Thanks
Re: Importing from Development install to production "runtime only" installation [message #484909 is a reply to message #484908] Fri, 03 December 2010 13:16 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not that I'm underestimating OraFAQ forum members (who visit Apex forum) or scaring you away, but - note that this (Apex) forum isn't among the most visited forums here. For example, I chose to display 40 topics per page. These 40 topics in Apex forum cover 5 months. 40 topics in SQL & PL/SQL forum cover 5 days, 10 days in Forms forum, a month in Server administration forum.

I hope I'm wrong, but I'm afraid you might wait quite long before you get the answer here. Perhaps you should take a look at OTN Apex forum; I *think* that this is the most visited Apex forum on the web at the moment. Moreover, (some) people who answer questions there are members of the Apex development team so ... you know what I mean.

Anyway: best of luck, wherever you search for it.
Re: Importing from Development install to production "runtime only" installation [message #484911 is a reply to message #484909] Fri, 03 December 2010 13:21 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
Thanks Littlefoot. That's a good suggestion. (although i'm not a big fan of the otn forums Smile ).
Re: Importing from Development install to production "runtime only" installation [message #484916 is a reply to message #484911] Fri, 03 December 2010 14:21 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Fan or not, but ... what is the alternative?

Forms (for example) is here for ages and you'll find the answer to (most) Forms questions simply by Googling. As far as I can tell, not many people really used Apex since recently (say, since version 3). There aren't many resources available. Several blogs, a forum or two, official documentation, half a dozen of books. Did I miss something?
Re: Importing from Development install to production "runtime only" installation [message #485058 is a reply to message #484916] Sun, 05 December 2010 20:01 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
OTN came through. If anyone else comes searching for the same thing, this blogpost seems to outline it pretty thorougly.
http://joelkallman.blogspot.com/2010/07/apexapplicationinstall.html
Re: Importing from Development install to production "runtime only" installation [message #485070 is a reply to message #485058] Mon, 06 December 2010 01:01 Go to previous message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think that Joel Kallman is Apex development team member (so I'm not surprised his blog entry helped).
Previous Topic: Master Details Form
Next Topic: unable to login after successful installation
Goto Forum:
  


Current Time: Wed Aug 12 02:24:24 CDT 2020