500 errors logging into JDE and then on databrowser

All difficult things start off being simple…  Or is it that all simple things start off being difficult…  I dunno.

A simple exercise to “skin” the JDE interface on am OAS 10.1.3.4 server sitting on linux…  Very simple.  We have a test server (local OAS same release).  Get all of the jpg’s, gif’s and jsp / css files working locally – perfect.

sftp the files to the web server, easy

backup the existing webstylesheetgui.jsp

move the new one in.

HTTP 500 error?  WTF?

okay, restart web app server

still broken… Hmmm

move old file back, all okay.

in relation to the error:

find a log:  /u01/product/10.1.3.1/OracleAS_1/j2ee/DV812/log/DV812_default_group_1/oc4j called log.xml containing something like:

    <MSG_TEXT>Unable to dispatch JSP Page : Exception:oracle.jsp.parse.JspParseException: /databrowser/ChooseTarget.jsp: Line # 20, &lt;%@taglib prefix="webgui"  uri="http://java.peoplesoft.com/e1/webgui"%>
Error: "http://java.peoplesoft.com/e1/webgui" is not a registered TLD namespace. </MSG_TEXT>

Something chunky to search, find lots of red herrings EVERYWHERE

Eventually cry myself to sleep and reinstall JDE on web server – amazingly then I CAN change the webstylesheetgui.jsp!!!  Changes come in…  Ripper…

THEN client tells me that databroswer has stopped with HTTP 500 error

Find issue:  https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1070574.1

(ironically the shite metalink3 search could not find this two nights ago)

1. Make a copy of web.xml for backup and store it somewhere outside of webclient folder
2. Make a copy of web.xml and rename it to web.xml.bad
3. Edit web.xml and replace the current URL patterns:
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/*.mafService</url-pattern>
   </filter-mapping>
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/*.maf</url-pattern>
   </filter-mapping>
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/js/*</url-pattern>
   </filter-mapping>
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/share/js/*</url-pattern>
   </filter-mapping>
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/css/*</url-pattern>
   </filter-mapping>
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/share/css/*</url-pattern>
   </filter-mapping>
   and replace with the following lines:
   <filter-mapping>
   <filter-name>GZIPFilter</filter-name>
   <url-pattern>/*</url-pattern>
   </filter-mapping>
4. Restart web services
5. Test Databrowser

If Databrowser still does not work after replace the above text then do the following:

• Delete web.xml and rename web.xml.bad back to web.xml
• Restart web services
• Test Databrowser

 

The even more amazing thing about this is that it worked!!!

The initial step did nothing (replacing a section in the web.xml)..

The most amazing thing was that the delete and replace with the existing file DID fix it????  HUH???  Replace with a copy of the broken file fixed it?

Anyway, problem sorted.  I bet this would have even prevented me from reinstalled DV, PY and TR to get the stoopid skinning changes in…  Oh well, live and learn!