Application Express :: Error When Migrating Supporting Objects
Nov 16, 2012
We're migrating our first APEX application from one server to another. The export and import are done, but we're having problems with supporting objects (we get a login prompt but no images). Okay, so I figured out how to get the supporting objects into a script.
When I run it I get:
declare
*
ERROR at line 1:
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_040100.WWV_FLOW_IMAGE_API", line 12
ORA-06512: at "APEX_040100.WWV_FLOW_IMAGE_API", line 32
ORA-06512: at "APEX_040100.WWV_FLOW_API", line 10508
ORA-06512: at line 6
connecting as the parsing_schema user to run the script. I did that but still get the same error.
View 2 Replies
ADVERTISEMENT
Mar 31, 2013
is it currently possible to install the supporting objects using sqlplus?
When I export an APEX application which contains supporting objects (scripts to install images, css files, tables and seed data) I can run this script on the command line using sqlplus to install the application into the target environment.
After installing the application (which works fine), I cannot invoke the installation of the supporting objects nor the upgrade of the the supporting objects.
Am I overlooking the obvious, have checked APEX_APPLICATION_INSTALL but there is no function available for that purpose?
View 0 Replies
View Related
Jul 5, 2013
APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error.
After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue??
View 1 Replies
View Related
Jul 23, 2013
I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
View 2 Replies
View Related
Aug 6, 2012
version 4.0.2.00.07
I had an error importing an application into Production that was exported from Development. The application exists and I was trying to replace it.
The error I received was:
ORA-20001: GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful.
ORA-20001: Error creating dynamic action sub-action name="NATIVE_JAVASCRIPT_CODE" id="9503820976918886"
ORA-02291: integrity constraint (APEX_040000.WWV_FLOW_PAGE_DA_A_AR_FK) violated - parent key not found<pre>
begin wwv_flow_api.create_page_da_event ( p_id => 9504132415918888 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_page_id =>I
opened the SQL that was created from the export utility and this is where it errored:
begin
wwv_flow_api.create_page_da_event (
p_id => 9503820976918886 + wwv_flow_api.g_id_offset
,p_flow_id => wwv_flow.g_flow_id
,p_page_id => 6
,p_name => 'Add tooltip to Numeric filter operators'
,p_event_sequence => 40
[code]....
Unless I'm not understanding this error it means that it can find the ACTION part that is attached to the WHAT part of this Dynamic Action? The Dynamic Action does work when the application is run (in Development)also, there are 3 others that are similar to this one. The export was created by the export utility in the Application Builder.
If I export only the page and import that into Production the import is successful and the page runs correctly. This is error is happening only when I try to import the entire Application.There are many other changes made which is why I was trying to do an Application export/import instead of individual pages.
View 3 Replies
View Related
Jul 18, 2013
I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.
Begin Package call...... If v_error_code <> '0' Then Raise SC_Error; End if;Exception When SC_Error Then RAise_Application_error(v_err_code, v_err_msg);End;
But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:
Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.
Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..
An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59
View 4 Replies
View Related
Aug 21, 2013
We just upgraded from Application Express 4.0.2.00.07 to Application Express 4.2.2.00.11. We are using one common application to authenticate and redirect to other applications.
We use the following code:
wwv_flow_custom_auth_std.login( P_UNAME => :P101_USERNAME, P_PASSWORD => :P101_PASSWORD, P_SESSION_ID => v('APP_SESSION'), P_FLOW_PAGE => '2000:1' );
We start to get the following authentication error after the upgrade. There is no authentication configured for this application.
ORA-1403: no data found This is the same code we used from htmldb 2.x through Apex 4.0.2.00.07.
View 0 Replies
View Related
Nov 9, 2012
URL....The upgade from 4.0 to 4.2 went fine, existing applications work, Builder works fine. But none of the packaged applications install, all of them fail with that error. Is there some post-upgrade step to complete to get this to work?
Also, it doesn't appear like we can select the application id when installing these applications! Our environment has a convention, of sorts, for application ids. Is there a way to over-ride the app id?
View 14 Replies
View Related
Aug 27, 2012
I receive this error. In my opinion the problem could be related to the presence of one personalized authentication schemas, based on a DB function, taken from a Packaged application, some years ago, called "menu_framework".
This is the error report:
........
-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
begin
*
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x26962168], [0x1A1042F4], [], [], [], [], [], [], [], [], []
1) after the error trap, I copied the Image folder and tried to launch APEX. It was possible to lunch the development pages, but impossible to execute any application with the error: Authentication Schema not Supported
2) then decided to downgrade to APEX 4.0, following the proper instructions: received a similar error:
.......
SQL> exec apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000
');
BEGIN apex_040000.wwv_flow_upgrade.switch_schemas('APEX_040100','APEX_040000');
END;
ERRORE alla riga 1:
ORA-00600: codice di errore interno, argomenti: [kgiinb_invalid_obj],
[0x16D5D9E4], [0x27F2074C], [], [], [], [], [], [], [], [], []
The execution of application reported the same problem.Then decided to restore the entirre DB.
Where is my problem?Are my suspects real or the Authentication schema malfunctiong is a conseguence of the upgrade error?
View 4 Replies
View Related
Apr 11, 2013
i have ir report and one column value coming from function,when open the IR report its giving error..
IR report code
SELECT CS_ID ,CS_NAME, Util_func(PASS_ID) as "ALERT_DAYS" from "CSD_MASTERS" Function code
FUNCTION Util_func(PASS_ID NUMBER) RETURN number
IS
ALERT_DAYS NUMBER:=0;
BEGIN
[code]........
View 8 Replies
View Related
Jun 12, 2012
I am getting many warning messages in the error console using Firefox V 13. This one seems to be the most prevalent. It's not causing problems except that on some machines it causes the error console to pop up and is distracting for the users.
"Warning: Unknown property '-moz-box-shadow'. Declaration dropped. "
My suspicion is there will always be warning messages, is there a way to suppress the Error Console in v 13 ?
View 6 Replies
View Related
Jun 20, 2012
I got error "Upload New Image must be specified. Click browse to select an image from your local computer" while i upload image in shared components>image>create ...
my logo is saved in local drive D. when i browse file and click to upload it gives error that i mentioned. This is happening with every uploading weather its image or weather its plugin.
View 1 Replies
View Related
Aug 3, 2013
i'm trying to get the difference between two dates so i have two date itemsthen i did daynamic action (set Value) and choose pl/sql function then added the following codeDecalrestart_date date;end_date datebeginstart_date:=to_date(:p20_start_date,'dd/mm/rrrr');select to_date (sysdate,' dd/ mm /rrrr')into end_datefrom dual;return end_date-start_date;end; but when i run the page i got error ora-01861
View 1 Replies
View Related
Oct 15, 2012
REVNUMBER is a VARCHAR2. I've set it to increment by letter in alphabet to note the revision of a document, i.e. IR*, A, B, C... . This works beautifully.
VERNUMBER is a VARCHAR2. I've set it to increment by number but starts from null to 'IR' to 1, 2, 3...
Until now, I've been incrementing VERNUMBER without problem if, instead of IR as the first incremented value I leave the field null. The user has asked that IR display. I've tried using IR as the default but I still need to increment from there so I don't see it making a difference between that or dumping it as the first condition of the following. The problem is I get an invalid number error either way.
*'IR' = 'Initial Release'
SELECT CASE
WHEN VERNUMBER IS NULL THEN 'IR'
WHEN VERNUMBER = 'IR' THEN '1'
ELSE REGEXP_REPLACE(VERNUMBER, '[0-9]+$', REGEXP_SUBSTR(UPPER(VERNUMBER), '[0-9]+$') + 1)
END NEW_VERSION
FROM DOC_INFO
WHERE DOC_INFO_ID = :P3_DOC_INFO_ID
View 4 Replies
View Related
May 20, 2013
A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,
I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?
View 2 Replies
View Related
Jun 25, 2012
I tried to create my EA workspace for APEX 4.2 and got the following Error.
ORA-20987: APEX - GET_BLOCK Error. - ORA-20001: Execution of the statement was unsuccessful. ORA-01653: unable to extend table APEX_040200.WWV_FLOW_PAGE_PLUGS by 1024 in tablespace APEX_REL42 <pre>declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 6594522669003504543 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 0, p_plug_name=> 'Menu', p_region_name=&g
View 14 Replies
View Related
Feb 21, 2013
I am using APEX 4.1.Using the documentation [URL]... I'm trying to implement my own custom error message.My problem: The placeholders in the text message are not replaced and I don't know what I'm doing wrong.
Example:
APEX_ERROR.ADD_ERROR (
p_error_code => 'This is a text message with one placeholder: %0',
p0 => my_variable,
p_display_location => apex_error.c_inline_with_field_and_notif,
p_page_item_name => 'P13_MY_PAGE_ITEM'
);The result is an error message as follows:
This is a text message with one placeholder: %0 (Go to error)
View 2 Replies
View Related
Oct 2, 2012
I actually have tried to read the Customizing Templates chapter of the Users Guide. According to that guide, the following substitution strings are supported in the the Error Template Control section of page templates.
#MESSAGE# and #ADDITIONAL_INFO# - Places the error message.
#TECHNICAL_INFO# - Displays detailed internal error information which will just be visible for developers.
#BACK_LINK# - Displays a link back to the previous page.
#OK# and #RETURN_TO_APPLICATION# - Returns to translated text strings.
However, if I enter the follow code
<p> message: #MESSAGE# </p>
<p> additional info: #ADDITIONAL_INFO# </p>
<p> techie stuff: #TECHNICAL_INFO# </p>
<p> back link: #BACK_LINK# </p>
[code]........
return to application: Return to application.
It appears that only the first substitution string is doing anything. I'm especially interested in additional info and technical info. The back_link just looks like an html snippet, not sure why I would use a substitution string for this. I imagine the last two could facilitate site translation, but that doesn't work much if there is no machinery for translating error messages themselves.
View 5 Replies
View Related
Jan 28, 2013
I have a tabular form, when salve at data, works fine. But when update at data following error occurs: Error in mru internal routine: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum.
View 4 Replies
View Related
Jan 15, 2013
I use the "Media Resource" RESTful service type to generate custom JSON objects via CLOB-returning functions. This worked great in APEX Listener 1.1.3. However, on APEX Listener 2.0 I get status 500 on a RESTful service which works fine on 1.1.3 (which generates a clob > 4000 bytes), and the following in the server log:
SEVERE: ORA-22922: nonexistent LOB value
oracle.dbtools.common.UnrecoverableException: ORA-22922: nonexistent LOB valueThis seems to be the same issue as reported here:
APEX Listener EA2 Standalone CLOB error
As stated by thoechst in that thread:
>
It is as though the function is getting cast as a varchar2 somewhere. I verified that the function will correctly return a large result to other sources (dbms_output, for instance).
>
Versions:
APEX Listener 2.0
WebLogic 10.3.6 on Windows 2008 SE R2 x64
Oracle DB 11.2.0.3
View 1 Replies
View Related
Sep 14, 2012
I have completed the installation of APEX and HTTP server on an instance. But while configuring , I got the following error in the login page.
Service Temporarily Unavailable. The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Oracle-Application-Server-10g/10.1.3.1.0 Oracle-HTTP-Server Server at y0319t345 Port 7777 Access log has the following error:
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:14:41:22 -0700] "GET /pls/apex/apex_admin HTTP/1.1" 503 442
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:14:42:07 -0700] "GET /pls/apex/apex_admin HTTP/1.1" 503 442
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:14:42:10 -0700] "GET /pls/apex/apex_admin HTTP/1.1" 503 442
10.12.26.109 - APEX_PUBLIC_USER [14/Sep/2012:15:02:17 -0700] "GET /pls/apex/INTERNAL HTTP/1.1" 503 442
The database was on Solaris recently we upgraded to 11.2.0.2 and migrated it to Linux. I have tried [URL]... and the metalink note 1289136.1 with no success.
View 3 Replies
View Related
Sep 30, 2013
We just upgraded to APEX 4.2.2.00.11 and we are getting ORA-24247: network access denied by access control list (ACL) errors form apex_mail. This had been working correctly prior to the upgrade.
View 4 Replies
View Related
Jul 9, 2012
While I try to download a file using the below code; an HTTP 404 error is coming although the proc is being called and the parameter is correctly being passed.
create or replace procedure download_myfile1(p_id in number)
as
v_mime varchar2(255);
v_length number;
[code]...
It shows a POP up window by which u can save or opens the file. But no pop up displayed in this case.
View 7 Replies
View Related
Nov 23, 2012
I am using APEX 4.1 to build the application. I have 2 select list region in the page where one region consist of certain values.On calling a javascript function it is able to move the value from one select region to another. After this I click on the modify button where in the value move out of the first select list region to the second will be updated in the table.
Although I could see the values are not being updates. On putting alerts after the value being fetched in the javascript function and clicking the Modify button I can see that no data is being reflected in the alert. Hence the data is not being passed from the second select list APEX item to the javascript function.
View 1 Replies
View Related
Feb 15, 2013
I am doing a simple AJAX call test with the emp table. In my page I have a search field and a report and a button. You put in a text and click search and you will get the result which all works.
I have a requirement where if you click the button and there is no matching search you will get redirected to another page, else just reload the report to display the result as usual.
So I took the AJAX route where I am running a concurrent search when user enters a text and clicks the button. If the search count(*) > 0 then return return count else return 0.
The code for application process is:
DECLARE
begin
CCOUNT number;
begin
Select count(*) into ccount
[code]......
The code for my Java script (still working on this) is :
<script language="JavaScript" type="text/javascript">
function search_count()
var get = new htmldb_Get(null,null,'APPLICATION_PROCESS=SEARCH',0);
get.add('F_SEARCH_RESULT', $v('P1_ENAME'));
var gReturn = get.get();
[code].......
i am testing this code in Firebug and when I do a console.log(gReturn) on the output of the AJax call I am getting this error which stops me from processing the result of gReturn and finish off the code. The error looks like:
<html><body>
<h1>Error occurred while painting error page: ORA-01403: no data found</h1>
</body></html>I have tried adding exeption when no_data_found but with no luck. Still throws the same error. My APEX version is 4.2,
View 7 Replies
View Related
Jul 5, 2013
I have an application which includes a certain page with a tabular form.After I copied this to a second schema, Apex threw an error
'Unable to bind ':126_ENG_PROJ_ID'
It took me quite a while before I found out that one of my fields in that tabular form has a Popup Key LOV.The SQL for the LOV was:
select dv, rv from (select loop_short dv, cmpnt_id rv from SPI_MAIN_TAG where eng_proj_id in (:P126_ENG_PROJ_ID, -:P126_ENG_PROJ_ID) ) order by dv
Turned out that the view SPI_MAIN_TAG didn't exist in the second schema.Apex error message would have been more clear, like a simple 'Table or view does not exist' error, where possible even with the table name.I had Debug turned on, but in the debug window there was no reference to above SQL,
View 0 Replies
View Related
Jan 15, 2013
Using apex 4.2. I have created form item on page and item attribute DISABLES IN SETTINGS , set value as YES and SESSION STATE value as YES.
SETTINGS->DISABLES-> SESSION STATE
by doing this i am getting the error. Error is
Session state protection violation: This may be caused by manual alteration of protected page item P98_CHECK_AMOUNT. If you are unsure what caused this error, please contact the application administrator for assistance.
View 8 Replies
View Related
Jan 24, 2013
I am trying to refresh a report with dynamic action. And getting the following errors:
{"dialog":{"uv":true,"row":[{"V":"Widget Failure
ORA-20876: Stop APEX Engine,
classic_report"}]}}
I have identified the problematic part. I have a multi-select select list and my query goes like this:
select o.order_id, s.salesrep_name
from ml_orders o, ml_order_salesrep_mapping m
where m.order_id(+) = o.order_Id
and case when :P22_SALESREP is null then 1
[code]...
View 4 Replies
View Related
Aug 22, 2012
I'm getting the error below when downloading IR report in csv format. I'm getting that whenever the records is more than 108,000. Is there a limit in records to download? Is there a resolution.
I am using apex 4.1, EXCEL 2010.
View 6 Replies
View Related
Feb 24, 2013
i'm on apex.oracle.com creating a mobile application. When creating a new region of type report -> Listview it results in an error if the query is too big (or returns too many columns).The error is: Error during rendering of region "Add Javascript code for Plugins". ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The query i used: SELECT * FROM APEX_APPLICATION_PAGE_ITEMS
get Syntax Highlighting for the Application Builder: URL....
View 1 Replies
View Related
