0 Replies Latest reply on Jul 19, 2005 9:26 AM by 110272

    Report on Linux

    110272
      I've just installed Oracle Oracle Developer Suite 10g (9.0.4) over RedHat and i'm doing this,

      1) i run the script,

      $ORACLE_HOME/j2ee/DevSuit/startinst.sh

      2) i created a report through the report builder wizard, when i use "run paper layout" the report looks ok but when i try to use "run web layout" i get this error,

      ------------------------------------------------
      Tue Jul 19 18:58:04 EST 2005
      javax.servlet.jsp.JspException

      javax.servlet.jsp.JspException
           at oracle.reports.jsp.ReportTag.doStartTag(ReportTag.java:439)
           at MODULE202805126.jspService(_MODULE202805126.java:50)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
           at oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:567)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:302)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
           at java.lang.Thread.run(Thread.java:534)
      -----------------------------------------------------

      and the trace file has this,

      -----------------------------------------------------
      [2005/7/19 7:30:23:265] Debug 50103 (InProcessServer:Init): Server Config and Trace objects available
      [2005/7/19 7:30:23:266] Debug 50103 (WebServerDriver:start): Server Trace Object available
      [2005/7/19 7:30:23:267] Info 56025 (RWServer:startServer): Reports Server is starting up
      [2005/7/19 7:30:23:314] Debug 50103 (OC4JWebServer:start): webserver_srcroot=/opt/app/oracle/OraHome_2/reports/docroot WEBSERVER_DOCROOT=/tmp/docroot
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): RW=/opt/app/oracle/OraHome_2/reports
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): SSH_AGENT_PID=4122
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): HOSTNAME=localhost.localdomain
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): TERM=xterm
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): SHELL=/bin/bash
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): HISTSIZE=1000
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): LD_PRELOAD=/usr/local/error_oracle/libcwait.so
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
      [2005/7/19 7:30:23:665] Debug 50103 (Environment:getEnvironmentStrings): WINDOWID=35666755
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): QTDIR=/usr/lib/qt-3.3
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): REPORTS_NO_DUMMY_PRINTER=TRUE
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): USER=oracle
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): LD_LIBRARY_PATH=/opt/app/oracle/OraHome_2/jdk/jre/lib/i386/server:/opt/app/oracle/OraHome_2/jdk/jre/lib/i386/native_threads:/opt/app/oracle/OraHome_2/jdk/jre/lib/i386:/opt/app/oracle/OraHome_2/lib:
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): ORACLE_SID=orcl1
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): SSH_AUTH_SOCK=/tmp/ssh-zTptff4121/agent.4121
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): ORACLE_BASE=/opt/app/oracle
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): GNOME_KEYRING_SOCKET=/tmp/keyring-Dzz7aj/socket
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): KDEDIR=/usr
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/4094
      [2005/7/19 7:30:23:666] Debug 50103 (Environment:getEnvironmentStrings): REPORTS_PATH=/opt/app/oracle/OraHome_2/reports/templates:/opt/app/oracle/OraHome_2/reports/samples/demo:/opt/app/oracle/OraHome_2/reports/integ:/opt/app/oracle/OraHome_2/reports/printers
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): TK90_ICON=/opt/app/oracle/OraHome_2/reports/plugins/resource
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): PATH=/opt/app/oracle/OraHome_2/jdk/bin:/opt/app/oracle/OraHome_2/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): DESKTOP_SESSION=default
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): MAIL=/var/spool/mail/oracle
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): TNS_ADMIN=/opt/app/oracle/OraHome_2/network/admin
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): REPORTS_CLASSPATH=/opt/app/oracle/OraHome_2/reports/jlib/rwbuilder.jar:/opt/app/oracle/OraHome_2/reports/jlib/rwrun.jar:/opt/app/oracle/OraHome_2/jlib/zrclient.jar:/opt/app/oracle/OraHome_2/j2ee/home/oc4j.jar:/opt/app/oracle/OraHome_2/j2ee/home/lib/ojsp.jar
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): PWD=/opt/app/oracle/OraHome_2/bin
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): INPUTRC=/etc/inputrc
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): LANG=en_US
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): GDMSESSION=default
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
      [2005/7/19 7:30:23:667] Debug 50103 (Environment:getEnvironmentStrings): SHLVL=2
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): HOME=/home/oracle
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): LD_ASSUME_KERNEL=2.4.1
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): GNOME_DESKTOP_SESSION_ID=Default
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): LOGNAME=oracle
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-7YL1vQQ8ct
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): LESSOPEN=|/usr/bin/lesspipe.sh %s
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): REPORTS_TAGLIB_URI=/WEB-INF/lib/reports_tld.jar
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): DISPLAY=:0.0
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): ORACLE_HOME=/opt/app/oracle/OraHome_2
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): G_BROKEN_FILENAMES=1
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): REPORTS_TMP=/tmp
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): XAUTHORITY=/home/oracle/.Xauthority
      [2005/7/19 7:30:23:668] Debug 50103 (Environment:getEnvironmentStrings): COLORTERM=gnome-terminal
      [2005/7/19 7:30:23:669] Debug 50103 (Environment:getEnvironmentStrings): PLSQL_COMPILER_FLAGS=INTERPRETED,DEBUG
      [2005/7/19 7:30:23:669] Debug 50103 (Environment:getEnvironmentStrings): NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat
      [2005/7/19 7:30:23:669] Debug 50103 (Environment:getEnvironmentStrings): XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt
      [2005/7/19 7:30:23:669] Debug 50103 (Environment:getEnvironmentStrings): NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
      [2005/7/19 7:30:25:236] Debug 50103 (RWReport:getCurrentReport): Inprocess Server Trace Object available
      [2005/7/19 7:30:25:246] Debug 50103 (Report:(Proxy, Trace):1): Got an engine
      [2005/7/19 7:30:25:248] Debug 50103 (Report:(Proxy, Trace):2): Report created:147752400
      [2005/7/19 7:30:25:254] Debug 50103 (XMLPDS): setHelpSetID: 1
      [2005/7/19 7:30:25:255] Debug 50103 (XMLPDS): needSignOnParameter: True.
      [2005/7/19 7:30:25:258] Debug 50103 (JDBCPDS): setHelpSetID: 2
      [2005/7/19 7:30:25:258] Debug 50103 (JDBCPDS): needSignOnParameter: TRUE.
      [2005/7/19 7:30:25:260] Debug 50103 (textpds): TextDataSourceFactory: setReportContext
      [2005/7/19 7:30:25:260] Debug 50103 (textpds): setHelpSetID: null
      [2005/7/19 7:30:25:260] Debug 50103 (textpds): needSignOnParameter: true
      [2005/7/19 7:30:26:153] Info 56023 (ServerImpl:ServerImpl): Idle thread has been started
      [2005/7/19 7:30:26:211] Info 56020 (EngineManager:spawnEngine): Launching engine rwEng-0
      [2005/7/19 7:30:26:212] Debug 50103 (EngineManager:spawnEngine): Start engine command line = /opt/app/oracle/OraHome_2/bin/rwengine.sh -server -cp /opt/app/oracle/OraHome_2/j2ee/home/lib/ojsp.jar:/opt/app/oracle/OraHome_2/reports/jlib/rwrun.jar:/opt/app/oracle/OraHome_2/jlib/zrclient.jar -Xbootclasspath/p:/opt/app/oracle/OraHome_2/vbroker4/lib/vbjboot.jar -Xmx256M oracle.reports.engine.RWEngine name=rwEng-0 server=rep_localhost-rwbuilder ORACLE_HOME=/opt/app/oracle/OraHome_2 engineimplclass=oracle.reports.engine.EngineImpl traceopts=trace_all tracefile=/opt/app/oracle/OraHome_2/reports/logs/rep_localhost-rwbuilder/rwEng-0.trc tracemode=trace_replace cacheDir=/opt/app/oracle/OraHome_2/reports/cache
      [2005/7/19 7:30:26:218] Info 56021 (EngineManager:spawnEngine): Engine rwEng-0 has been launched
      [2005/7/19 7:30:26:218] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Initial
      [2005/7/19 7:30:26:236] Debug 50103 (RWEngine:init): args[0]=ORACLE_HOME=/opt/app/oracle/OraHome_2
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[1]=frombuilder=yes
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[2]=name=rwEng-0
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[3]=server=rep_localhost-rwbuilder
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[4]=cachedir=/opt/app/oracle/OraHome_2/reports/cache
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[5]=traceopts=trace_all
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[6]=tracefile=
      [2005/7/19 7:30:26:237] Debug 50103 (RWEngine:init): args[7]=tracemode=trace_replace
      [2005/7/19 7:30:26:356] Info 55007 (EngineImpl:loadLibrary): Load librw90.so succeeded
      [2005/7/19 7:31:26:240] Exception 50125 (java.lang.NullPointerException
           at oracle.reports.server.EngineManager.manage(EngineManager.java:256)
           at oracle.reports.server.IdleThread.run(IdleThread.java:87)
      ): Internal error java.lang.NullPointerException
      [2005/7/19 7:31:26:243] Info 50002 (RWServer:shutdown): Server is shutting down
      [2005/7/19 7:31:26:244] Info 50103 (RWServer:startServer): Notify thread to exit
      [2005/7/19 7:31:26:244] Info 50103 (RWServer:startServer): RWServer thread exits
      [2005/7/19 7:31:26:249] Exception 50125 (): Caught exception: java.lang.NullPointerException
      exception oracle.reports.RWException {
      oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
      int errorCode=50125,
      java.lang.String errorString="Caught exception: java.lang.NullPointerException",
      java.lang.String moduleName="REP"
      }}
      }
           at oracle.reports.utility.Utility.newRWException(Utility.java:604)
           at oracle.reports.utility.Utility.newRWException(Utility.java:614)
           at oracle.reports.server.IdleThread.run(IdleThread.java:171)


      -----------------------------------------------------




      any idea guys ????