Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » difficult to import application in Appex-3.2 (APEX 3.2, Oracle database 10g XE)
difficult to import application in Appex-3.2 [message #400188] Mon, 27 April 2009 01:29 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear experts,

I could not import my exported application as i did easily in Apex 3.1.2.

i am using the Import wizard to import my exported (app10.sql) file. but it showing "The page cannot be found". but previously in APex 3.1.2 i could do it easily the same way. when i refresh/reload that page showing this message:
Expecting p_company or wwv_flow_company cookie to contain security group id of application owner

ERR-7621 Could not determine workspace for application (:) on application accept.


** i tried it by manually using SQL*Plus.... but it can not complete. showing message :
ORA-20001: Application ID and current security group ID are not consistent.


help required.

-kamal hossain

[Updated on: Mon, 27 April 2009 03:39]

Report message to a moderator

Re: difficult to import application in Appex-3.2 [message #400362 is a reply to message #400188] Mon, 27 April 2009 20:21 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
one of my assistant also faced this type of the problem. I insisted to uninstall 3.1.2 and then install 3.2. He said that having 3.1.2 he has already installed 3.2. I reqested him to uninstall whatever the version, and freshly install the higher version. He did and he has no problem on importing the application developed in 3.1.0. No supporting logic for this action. It is only a crude imagination to wipe the registry through uninstall and reinstall It worked. By the way what is the OS you are having?
This is not the suggestion but sharing the crude act done.
yours
dr.s.raghunathan
Re: difficult to import application in Appex-3.2 [message #400410 is a reply to message #400362] Tue, 28 April 2009 01:42 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

hi dr.s.raghunathan,

Thank you for your reply.

Before upgrading version 3.1.2 to 3.2 i backed up my application (app1.sql). and i imported that application to newer version (3.2) and it did not show any problem. But later what ever the file i export from 3.2 version and try to re-import in same (3.2) version never been able. it showing problem.

i dont find any way. please help me.
i am using OS Windows XP pro.


Regards

-kamal hossain


[Updated on: Tue, 28 April 2009 02:05]

Report message to a moderator

Re: difficult to import application in Appex-3.2 [message #400881 is a reply to message #400410] Thu, 30 April 2009 04:21 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Still i am experiencing the problem although i find out the solution using "SQL Developer" tools easily. if i select the 'app1.sql' file and press upload its getting import successfuly using 'SQL developer'.
But i want to know, why in Apex 3.2 built in import utility showing error? and what is the exact way to export and import operation in 3.2?

Regards,

-Kamal hossain

[Updated on: Thu, 30 April 2009 04:32]

Report message to a moderator

Re: difficult to import application in Appex-3.2 [message #400981 is a reply to message #400881] Thu, 30 April 2009 18:55 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
dear kamal,

excellent. you have reached solution. Behaviour analysis leave it to old people (jobless research oriented personalities like me) In a way, i have to thank you since i have learnt many new areas of learning from you.
yours
dr.s.raghunathan
Re: difficult to import application in Appex-3.2 [message #401228 is a reply to message #400981] Sat, 02 May 2009 23:18 Go to previous message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

hi dr.s.raghunathan,

First of all, i would like to remember with thanks, l learnt so many basic and important functionality about APEX from you that encouraged me to work 12 hours (minimum) a day with APEX.

Thank you for providing your continuous ideas,suggestions and solutions.

-Regards,

Kamal hossain

Previous Topic: Pass value of Item in page101 to anather pages
Next Topic: Scheduling Reports
Goto Forum:
  


Current Time: Thu Mar 28 18:31:11 CDT 2024