ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tomcat - HTTP Status 500 - System Unavailable. Please try again later.

721224Feb 23 2011 — edited Mar 1 2011

HI,
I installed ORACLE XE + TOMCAT 7 + ORACLE XE on windows XP.
All seems to work under debug session but on normal session I found the following message only when I put a specific parameter on my query.
The same query with the same parameter runs in the sqldev client whitout errors

Here below the massages:

HTTP Status 500 - System Unavailable. Please try again later.

type Status report

message System Unavailable. Please try again later.

description The server encountered an internal error (System Unavailable. Please try again later.) that prevented it from fulfilling this request.
Apache Tomcat/7.0.2

and in the log file:

2011-02-23 18:04:19 Commons Daemon procrun stdout initialized
APEX Listener version : 1.0.2.238.15.24
APEX Listener server info: Apache Tomcat/7.0.2
Using Config file:C:\Programmi\Apache Software Foundation\Tomcat 7.0\temp\apex\apex-config.xml
-- listing properties --
PropertyCheckInterval=60
ValidateConnection=true
MinLimit=1
MaxLimit=10
InitialLimit=3
AbandonedConnectionTimeout=900
MaxStatementsLimit=10
InactivityTimeout=1800
MaxConnectionReuseCount=50000

***********ERROR***********
init: # headers=46
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:18
CALL:
begin
f(p=>?);
commit;
end;
BINDS

p:106:3:4503262208013405:::::PAGE CALL:
declare
nlns number := 999999;
l_clob CLOB;
lines htp.htbuf_arr;
l_buff varchar2(32767);
l_clob_init boolean:= false;
l_file varchar2(5);
begin
OWA.GET_PAGE(lines, nlns);
if (nlns > 1) then
for i in 1..nlns loop
if ( length(lines(i)) > 0 ) then
if ( ( lengthb(l_buff) + lengthb(lines(i))) > 32767) then
if (NOT l_clob_init) then
dbms_lob.createtemporary(l_clob, TRUE);
dbms_lob.open(l_clob, dbms_lob.lob_readwrite);
l_clob_init:=true;
end if;
dbms_lob.writeappend(l_clob,length(l_buff),l_buff);
l_buff := lines(i);
else
l_buff := l_buff || lines(i);
end if;
end if;
end loop;
end if;
if (l_clob_init) then
dbms_lob.writeappend(l_clob,length(l_buff),l_buff);
l_buff := '';
end if;
? := l_clob;
? := l_buff;
if (wpg_docload.is_file_download) then l_file:='TRUE'; else l_file := 'FALSE'; end if; ? := l_file;
end;
get_page FAILED:ORA-06502: PL/SQL: errore : buffer della stringa di caratteri troppo piccolo di numero o valore
ORA-06512: a line 32

^^^^^^^^^^^^ERROR^^^^^^^^
ORA-06502: PL/SQL: errore : buffer della stringa di caratteri troppo piccolo di numero o valore
ORA-06512: a line 32

***********ERROR***********
init: # headers=46
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:18
CALL:
begin
f(p=>?);
commit;
end;
BINDS

p:106:3:3777982020408238:::::PAGE CALL:
declare
nlns number := 999999;
l_clob CLOB;
lines htp.htbuf_arr;
l_buff varchar2(32767);
l_clob_init boolean:= false;
l_file varchar2(5);
begin
OWA.GET_PAGE(lines, nlns);
if (nlns > 1) then
for i in 1..nlns loop
if ( length(lines(i)) > 0 ) then
if ( ( lengthb(l_buff) + lengthb(lines(i))) > 32767) then
if (NOT l_clob_init) then
dbms_lob.createtemporary(l_clob, TRUE);
dbms_lob.open(l_clob, dbms_lob.lob_readwrite);
l_clob_init:=true;
end if;
dbms_lob.writeappend(l_clob,length(l_buff),l_buff);
l_buff := lines(i);
else
l_buff := l_buff || lines(i);
end if;
end if;
end loop;
end if;
if (l_clob_init) then
dbms_lob.writeappend(l_clob,length(l_buff),l_buff);
l_buff := '';
end if;
? := l_clob;
? := l_buff;
if (wpg_docload.is_file_download) then l_file:='TRUE'; else l_file := 'FALSE'; end if; ? := l_file;
end;
get_page FAILED:ORA-06502: PL/SQL: errore : buffer della stringa di caratteri troppo piccolo di numero o valore
ORA-06512: a line 32

^^^^^^^^^^^^ERROR^^^^^^^^
ORA-06502: PL/SQL: errore : buffer della stringa di caratteri troppo piccolo di numero o valore
ORA-06512: a line 32

Could you kindly help me.
Thanks in advance for your help
Best Regards

Karthick2003

945400 wrote:
create index ts_portfolio_dm.instrument_ref_dim_indx1 on ts_portfolio_dm.instrument_reference_dim(instrument_type_dvd, revenue_source_dvd, pricing_dt, instrument_dim_key);

when I execute this command the process is taking too long to create an index .is there any additional coding that can help create index fast.

The time taken to create an index depends largely on the the volume of data in the table and number of columns being indexed.

fjfranken

Hi

You could add the "NOLOGGING" option.
This might speed it up a bit, because no redo logging is written for the index-creation. But it is only a small improvement

Your statement would then look like:

CREATE INDEX ts_portfolio_dm.instrument_ref_dim_indx1
   ON ts_portfolio_dm.instrument_reference_dim (instrument_type_dvd
,                                               revenue_source_dvd
,                                               pricing_dt
,                                               instrument_dim_key) nologging ;

Maybe also add the PARALLEL clause to force parallel execution. But for the remainder I agree with the other reply. It is simply the amount of data that makes the time here

948403

Hi ,

thanks for the reply .

could you please give me the statement that contains both

1.parllel creation 2.no logging.

Is there any further improvements that can be done on this .
The table is very huge and lot of procedures use this .Hence the reson we are not able to allow the statement to execute for more time .
cheers,
P

1 - 3

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2011

Added on Feb 23 2011

4 comments

447 views

ORDS, SODA & JSON in the Database

Tomcat - HTTP Status 500 - System Unavailable. Please try again later.

Comments

Post Details