You are currently reviewing an older revision of this page.
Bentley Geo Web Publisher V8i logs messages and the activity of the different server components in a log file. These logs can be accessed by two means: console mode or dump in a text file.
If you are having trouble with Oracle Spatial, either in the table discovery phase (inside Administration.exe) or in the publication phase, you can get Oracle to generate tracing. This way you'll be able to see all the SQL statements that get executed on the Oracle server on behalf of the GeoWebPublisher server. This sequence of steps will require administrative rights on the database.
grant ALTER SESSION to system; CREATE OR REPLACE TRIGGER GEOWEBPUBLISHER_TRACE_TRIGGER After logon on database Begin if ( user='GWPUSER') then execute immediate 'alter session set sql_trace=true'; execute immediate 'alter session set events ''10046 trace name context forever, level 12'''; End if; END; /
grant ALTER SESSION to system;
CREATE OR REPLACE TRIGGER GEOWEBPUBLISHER_TRACE_TRIGGER After logon on database Begin if ( user='GWPUSER') then execute immediate 'alter session set sql_trace=true'; execute immediate 'alter session set events ''10046 trace name context forever, level 12'''; End if; END; /
DROP TRIGGER GEOWEBPUBLISHER_TRACE_TRIGGER;