oracle dislike,500 internal server error — oracle-tech

Thanks for reply all,

By enable detailed request error messages,

add the following setting to the Oracle REST Data Services configuration file: defaults.xml

true

then i got the error message

WebException [statusCode=500]

at oracle.dbtools.rt.web.WebException.webException(WebException.java:343)

at oracle.dbtools.rt.web.WebException.internalError(WebException.java:262)

at oracle.dbtools.rt.web.WebErrorResponse.internalError(WebErrorResponse.java:101)

at oracle.dbtools.rt.web.WebErrorResponse.error(WebErrorResponse.java:75)

at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:134)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Caused by: java.lang.OutOfMemoryError: Java heap space

i gave 1gb hava heap space but still it showing error message

i created code like this and it is retrieving 268 rows only.

select APEX_ITEM.HIDDEN(19,c001,NULL,NULL,NULL)||APEX_ITEM.TEXT(1,c002,10,100,NULL,'f01_'||rownum,NULL) "Voucher Number",

APEX_ITEM.HIDDEN(17,C018,null,'f17_'||rownum,NULL)||APEX_ITEM.TEXT(2,C003,6,100,NULL,'f02_'||rownum,NULL) "Line No",

APEX_ITEM.DATE_POPUP2(3,C005,null,10,2000,null,'f03_'||rownum, null, null, null,null,'button',null,'NONE',null,null) "Voucher Date",

APEX_ITEM.HIDDEN(24,C016,NULL,'f24_'||rownum,NULL)||APEX_ITEM.TEXT(4,C006,20,100,NULL,'f04_'||rownum,NULL) "Payee",

APEX_ITEM.TEXT(5,C007,30,100,NULL,'f05_'||rownum,NULL) "Payment Details",

APEX_ITEM.SELECT_LIST_FROM_QUERY(6,C008,'Select ACCOUNT_CODE||'' ''||ACCOUNT_DESCRIPTION d,ACCOUNT_CODE r from COA',NULL,'YES',NULL,'-select-','f06_'||rownum,NULL,'NO') "Debit Account Code",

APEX_ITEM.SELECT_LIST_FROM_QUERY(25,c020,'Select EMPLOYEE_NUM||'' ''||EMPLOYEE_NAME d,EMPLOYEE_NUM r from EMPLOYEES',NULL,'YES',NULL,'-select-','f25_'||rownum,NULL,'NO') "DR Sub Code",

APEX_ITEM.SELECT_LIST_FROM_QUERY(8,C009,'Select ACCOUNT_CODE||'' ''||ACCOUNT_DESCRIPTION d,ACCOUNT_CODE r from COA',NULL,'YES',NULL,'-select-','f08_'||rownum,NULL,'NO') "Credit Account Code",

APEX_ITEM.SELECT_LIST_FROM_QUERY(26,c021,'Select EMPLOYEE_NUM||'' ''||EMPLOYEE_NAME d,EMPLOYEE_NUM r from EMPLOYEES',NULL,'YES',NULL,'-select-','f26_'||rownum,NULL,'NO') "CR Sub Code",

APEX_ITEM.TEXT(10,C012,10,100,NULL,'f10_'||rownum,NULL) "Payment Mode",

APEX_ITEM.TEXT(11,C014,10,100,NULL,'f11_'||rownum,NULL) "Payment Amount",

APEX_ITEM.TEXT(12,C013,10,100,NULL,'f12_'||rownum,NULL) "Receipt/ADJ Amount",

APEX_ITEM.TEXT(13,C004,10,100,NULL,'f13_'||rownum,NULL) "Image Number",

APEX_ITEM.HIDDEN(20,C019,NULL,'f20_'||rownum,NULL)||APEX_ITEM.CHECKBOX2(14,rownum,NULL,NULL,':','f14_'||rownum,NULL) "Complete Flag",

APEX_ITEM.CHECKBOX2(15,rownum,'disabled="disabled"',NULL,':','f15_'||rownum,NULL) "Journal Flag",

APEX_ITEM.HIDDEN(22,C017,NULL,'f22_'||rownum,NULL)||APEX_ITEM.CHECKBOX2(16,rownum,NULL,NULL,':','f16_'||rownum,NULL) "Reconcile Flag",

'Change Image' "ADD Image",

CASE WHEN C018 IS NOT NULL THEN

'View'

ELSE

'View'

END "View Image",

c001 as "View Journals"

from apex_collections where collection_name='CASH_VIEW_TABLE'

i didn't how this occupied that much space, or it may be some other error, i didn't get.

please help on this.

thanks in advance.

Regards,

Pavan