Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
Geospatial Services
  • Product Communities
  • Geospatial
  • Geospatial Services
  • Cancel
Geospatial Services
Geospatial Services - Wiki GWP9001 Troubleshooting Bentley Geo Web Publisher
    • Sign In
    • Geospatial Services - Wiki
    • +ProjectWise Geospatial Management
    • +ProjectWise Spatial

     
     Questions about this article, topic, or product? Click here. 

    GWP9001 Troubleshooting Bentley Geo Web Publisher

    Monitoring server activity (logs)

    The 08.11.09.37 (SS3) release of Geo Web Publisher saw the introduction of the Log Viewer.   The Log Viewer can be accessed via it's program icon within the Geo Web Publisher... program group.  Details and important notes regarding the log viewer output and modification of the logging level via PubLoggingService.exe.config.xml, can be found within the Geo Web Publisher documentation.

    For versions prior to the 08.11.09.37 release, Bentley Geo Web Publisher V8i logs messages and the activity of the main server components in a log file. These logs can be accessed by two means: console mode or dump in a text file.

    •  You can start the console from the following program: C:\Bentley\GeoWebPublisher>PubLogCons.  Server activity will be shown here live
    •  You can generate a text file with the logs with the following command: C:\Bentley\GeoWebPublisher>PubLogDump > filename.txt. You can replace ‘filename' by any file name you wishes to give to the log file.

    There is a separate log file specifically for the DataPreparation service. You'll find that file at C:\Bentley\GeoWebPublisher\Logs\DataPreparationLog.log. This file will contain information about automated IDPR generation, Projectwise file fetching for the connections that use this feature and also print border imports.

    Monitoring Oracle server activity

    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.

    • Since GeoWebPublisher does multiple connections to the database, and does so from more than one process, we choose to activate the Oracle tracing for a specific Oracle user account. This will let you trace all calls on a specific database connection. We will create a database trigger that will activate the tracing for that user account when a connection is made using that account. You must execute the following SQL inside a tool such as SQL*Plus. Connect to the database using a administrative account first. After this is done and committed, every connection to the database using this account will be traced.

    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;
    /

    • Execute the steps in GeoWebPublisher that you want to trace. If you had a problem with Administrative tasks, make sure you start a new Administration.exe session before testing. For publication, start from a fresh web browser.
    • Once that is done, you must log on to the Oracle server machine and look for the .trc files that have been generated for all the connections GeoWebPublisher has made. Refer to your Oracle documentation for help on finding these files. You can look at these files directly but they are tough to read. Alternatively, you can use an Oracle tool called TKPROF. TKPROF is a command-line tool that has the following syntax: TKPROF <trcfile> <outputfile> . This will generate a more readable text file that will list all the SQL statements executed.
    • Once you are done with tracing, make sure that you drop the trigger that you created, otherwise trace will always be generated for that Oracle user. Connect to your database using a tool such as SQL*Plus and execute the following, and commit;

    DROP TRIGGER GEOWEBPUBLISHER_TRACE_TRIGGER;

     

    The version of VPR used with this control is not up to date.

    This message appears when the MapViewer ActiveX control detects an older registered version of the VPR ActiveX control than the one expected. The MapViewer is dependent on VPR and the VPR is also shared by other Bentley applications which sometimes may register an older version.

    To fix this issue:

    1. Close all Internet Explorer sessions to ensure that the MapViewer ActiveX control is not residing in memory.
    2. Open a fresh instance of Internet Explorer 8 or 9.
    3. Select Tools->Manage Add-ons.
    4. Change the drop down to All add-ons since the default only shows ones that are loaded. (optional)
    5. Select the MapViewer Class add-on.
    6. Select the link displayed on the lower left that says More information.
    7. This opens another dialog box that allows you to safely Remove the ActiveX control. Select Remove on the lower left.
    8. Close the dialog boxes and access the desired Bentley Geo Web Publisher Web site again to re-install the MapViewer ActiveX with the expected VPR version.

    *This issue is only applicable to Geo Web Publisher SELECTSeries 4 users.

    • MapViewer
    • GWP
    • VPR
    • ActiveX
    • Oracle Spatial
    • troubleshoot
    • Geo Web Publisher
    • map viewer
    • Share
    • History
    • More
    • Cancel
    • Nicolas Loubier Created by Bentley Colleague Nicolas Loubier
    • When: Fri, Jun 19 2009 11:25 AM
    • Nelson Hobdell Last revision by Bentley Colleague Nelson Hobdell
    • When: Mon, Oct 13 2014 2:27 PM
    • Revisions: 12
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies