This discussion is archived
0 Replies Latest reply: Nov 6, 2013 8:52 AM by user2300390 RSS

Thothgateway and APEX 4.2.2 on IIS7: APEX is undefined

user2300390 Explorer
Currently Being Moderated

Hi, Mobra or other APEX experts, Tried to use Morten's Thothgateway, and got "APEX" is undefined jscript error and blank screen.

 

OS: Windows server 2008 r2, 64bit., IIS7., Oracle 11.2.0.3.0 database

Thothgateway 1-3-7 source code recompile (OracleObjectInfo is already defined, so changed the class to OracleProcInfo). Followed the installation doc in the unzipped the folder of doc.

 

URL: http:/domain.com/pls/apex/f?p=4550:1:2452451174926

 

errlog:

[Header]\r\n[Footer]\r\n[Header]\r\n2013-11-06 10:45:13,253 [351] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /pls/apex

2013-11-06 10:45:13,269 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Parsed module = pls, dad = apex, proc = apex

2013-11-06 10:45:13,278 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule HTTP Authorization: Negotiate oXcwdaADCgEBoloEWE5UTE1TU1AAAwAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAABXCiOIGAbAdAAAAD7F8M0l2wbad2ZtRc4FzZaejEgQQAQAAAPUXp1AtIpqEAAAAAA==

2013-11-06 10:45:13,278 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Cookies: ORA_WWV_USER_61931653801488=ORA_WWV-IJ7XDuGE/j5v1jkQP0b2FBpO

2013-11-06 10:45:13,280 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Current Windows user name (LOGON_USER) = NTPROD\lanID

2013-11-06 10:45:13,285 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connecting with user apex_public_user to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521))(CONNECT_DATA=(SID=apexprod)))...

2013-11-06 10:45:13,424 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connected to Oracle 11.2.0.3.0

2013-11-06 10:45:13,432 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: alter session set nls_language='AMERICAN' nls_territory='AMERICA'

2013-11-06 10:45:13,449 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin dbms_session.modify_package_state(dbms_session.reinitialize); end;

2013-11-06 10:45:13,454 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin owa.init_cgi_env(:ecount, :namarr, :valarr); htp.init; htp.htbuf_len := 63; end;

2013-11-06 10:45:13,484 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin if wwv_flow_epg_include_modules.authorize (:p_proc_name) then apex; if wpg_docload.is_file_download then :p_is_download := 1; else :p_is_download := 0; end if; else raise_application_error (-20000, 'Procedure call forbidden by request validation function (wwv_flow_epg_include_modules.authorize)'); end if; end;

2013-11-06 10:45:13,553 [351] INFO  PLSQLGatewayModule.PLSQLHttpModule Gateway procedure executed successfully.

2013-11-06 10:45:13,553 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Committing database transaction...

2013-11-06 10:45:13,556 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Commit completed.

2013-11-06 10:45:13,556 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Fetch buffer size = 200

2013-11-06 10:45:13,558 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin owa.get_page(:linearr, :nlines); end;

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header Content-type: text/html; charset=UTF-8

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header cache-control: no-cache, no-store, max-age=0, must-revalidate

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header pragma: no-cache

2013-11-06 10:45:13,564 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header Set-Cookie: ORA_WWV_USER_61931653801488=ORA_WWV-EkSfGOjSOxYoSEiwhQznqg7J; path=/pls/apex; HttpOnly

2013-11-06 10:45:13,565 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header Location: f?p=4550:1:2452451174926

2013-11-06 10:45:13,566 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Closing database connection...

2013-11-06 10:45:13,587 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Database connection closed.

2013-11-06 10:45:13,590 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Compression of dynamic content is enabled, client accepts gzip, deflate

2013-11-06 10:45:13,591 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Converting relative path (f?p=4550:1:2452451174926) to absolute path

2013-11-06 10:45:13,591 [351] DEBUG PLSQLGatewayModule.PLSQLHttpModule Redirecting to /pls/apex/f?p=4550:1:2452451174926

2013-11-06 10:45:13,712 [347] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /pls/apex/f

2013-11-06 10:45:13,713 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Parsed module = pls, dad = apex, proc = f

2013-11-06 10:45:13,713 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Parameter 1: p = 4550:1:2452451174926

2013-11-06 10:45:13,714 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule HTTP Authorization: Negotiate oXcwdaADCgEBoloEWE5UTE1TU1AAAwAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAABXCiOIGAbAdAAAAD7Na3adzpatGRP2g0ZtYVpyjEgQQAQAAAPUXp1AtIpqEAAAAAA==

2013-11-06 10:45:13,714 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Cookies: ORA_WWV_USER_61931653801488=ORA_WWV-EkSfGOjSOxYoSEiwhQznqg7J

2013-11-06 10:45:13,715 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Current Windows user name (LOGON_USER) = NTPROD\lanID

2013-11-06 10:45:13,715 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connecting with user apex_public_user to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521))(CONNECT_DATA=(SID=apexprod)))...

2013-11-06 10:45:13,724 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connected to Oracle 11.2.0.3.0

2013-11-06 10:45:13,725 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: alter session set nls_language='AMERICAN' nls_territory='AMERICA'

2013-11-06 10:45:13,726 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin dbms_session.modify_package_state(dbms_session.reinitialize); end;

2013-11-06 10:45:13,726 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin owa.init_cgi_env(:ecount, :namarr, :valarr); htp.init; htp.htbuf_len := 63; end;

2013-11-06 10:45:13,728 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin if wwv_flow_epg_include_modules.authorize (:p_proc_name) then f (p => :b1); if wpg_docload.is_file_download then :p_is_download := 1; else :p_is_download := 0; end if; else raise_application_error (-20000, 'Procedure call forbidden by request validation function (wwv_flow_epg_include_modules.authorize)'); end if; end;

2013-11-06 10:45:13,827 [347] INFO  PLSQLGatewayModule.PLSQLHttpModule Gateway procedure executed successfully.

2013-11-06 10:45:13,827 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Committing database transaction...

2013-11-06 10:45:13,827 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Commit completed.

2013-11-06 10:45:13,827 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Fetch buffer size = 200

2013-11-06 10:45:13,827 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin owa.get_page(:linearr, :nlines); end;

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header Content-type: text/html; charset=utf-8

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header cache-control: no-cache, no-store, max-age=0, must-revalidate

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header pragma: no-cache

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-Frame-Options: DENY

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-DB-Content-length: 10090

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Closing database connection...

2013-11-06 10:45:13,829 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Database connection closed.

2013-11-06 10:45:13,830 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Compression of dynamic content is enabled, client accepts gzip, deflate

2013-11-06 10:45:13,830 [347] DEBUG PLSQLGatewayModule.PLSQLHttpModule Writing response (10090 bytes) to client...

2013-11-06 10:45:13,830 [347] INFO  PLSQLGatewayModule.PLSQLHttpModule Request completed.

[Footer]\r\n[Header]\r\n[Footer]\r\n[Header]\r\n[Footer]\r\n[Header]\r\n[Footer]\r\n[Header]\r\n2013-11-06 10:45:13,920 [349] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/css/apex.min.css

[Footer]\r\n[Header]\r\n2013-11-06 10:45:13,924 [352] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/css/apex_builder_ie7.min.css

2013-11-06 10:45:13,930 [372] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/libraries/apex/minified/desktop_all.min.js

2013-11-06 10:45:13,931 [348] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/libraries/apex/minified/legacy.min.js

2013-11-06 10:45:13,935 [338] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/libraries/jquery-ui/1.8.22/themes/base/jquery-ui.min.css

2013-11-06 10:45:13,937 [351] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/libraries/apex/minified/widget.textarea.min.js

2013-11-06 10:45:13,941 [347] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/libraries/apex/minified/builder.min.js

2013-11-06 10:45:13,950 [355] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/apex_ui/apexlogo.png

2013-11-06 10:45:13,951 [362] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/f_spacer.gif

2013-11-06 10:45:13,954 [341] INFO  PLSQLGatewayModule.PLSQLHttpModule Request: GET /i/apex/builder/apex-db-apps.png

2013-11-06 10:45:13,954 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Parsed module = i, dad = apex, proc = builder

2013-11-06 10:45:13,955 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule HTTP Authorization: Negotiate oXcwdaADCgEBoloEWE5UTE1TU1AAAwAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAABXCiOIGAbAdAAAAD2WI6+HmBSAvLKE5cjvo6YSjEgQQAQAAAPUXp1AtIpqEAAAAAA==

2013-11-06 10:45:13,955 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Current Windows user name (LOGON_USER) = NTPROD\lanID

2013-11-06 10:45:13,955 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connecting with user apex_public_user to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521))(CONNECT_DATA=(SID=apexprod)))...

2013-11-06 10:45:13,955 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connected to Oracle 11.2.0.3.0

2013-11-06 10:45:13,956 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: alter session set nls_language='AMERICAN' nls_territory='AMERICA'

2013-11-06 10:45:13,956 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin dbms_session.modify_package_state(dbms_session.reinitialize); end;

2013-11-06 10:45:13,957 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin owa.init_cgi_env(:ecount, :namarr, :valarr); htp.init; htp.htbuf_len := 63; end;

2013-11-06 10:45:13,958 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin if wwv_flow_epg_include_modules.authorize (:p_proc_name) then builder; if wpg_docload.is_file_download then :p_is_download := 1; else :p_is_download := 0; end if; else raise_application_error (-20000, 'Procedure call forbidden by request validation function (wwv_flow_epg_include_modules.authorize)'); end if; end;

2013-11-06 10:45:13,972 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Command failed: ORA-06550: line 1, column 69:

PLS-00201: identifier 'BUILDER' must be declared

ORA-06550: line 1, column 69:

PL/SQL: Statement ignored

2013-11-06 10:45:13,972 [341] ERROR PLSQLGatewayModule.PLSQLHttpModule Call failed: ORA-06550: line 1, column 69:

PLS-00201: identifier 'BUILDER' must be declared

ORA-06550: line 1, column 69:

PL/SQL: Statement ignored

2013-11-06 10:45:13,973 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Rolling back database transaction...

2013-11-06 10:45:13,974 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Rollback completed.

2013-11-06 10:45:13,974 [341] ERROR PLSQLGatewayModule.PLSQLHttpModule Request failed, showing debug error page

2013-11-06 10:45:13,977 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Closing database connection...

2013-11-06 10:45:13,977 [341] DEBUG PLSQLGatewayModule.PLSQLHttpModule Database connection closed.

2013-11-06 10:45:13,977 [341] INFO  PLSQLGatewayModule.PLSQLHttpModule Request completed.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points