Crash Visual Query Builder 10.00.00.25

Workflow:

  • Attach
  • Connect
  • Connect to database: oracle
  • Visual Query Builder
  • Tables: select mscatalog
  • Table Mscatalog: select entyitynum
  • SQL select statement is now: SELECT ENTITYNUM FROM MSCATALOG
  • Execute and MicroStation crashes

Any suggestions?

Parents Reply Children
  • I would add:

    - explicit version and connection details, e.g.
    --OS (+bit depth)
    --MS version
    --connection type (ODBC, Oracle, Xbase…)
    -- Oracle server details (e.g. Oracle Enterprise 08.09.10.11) (+bit depth)
    -- Oracle client/connection details (Oracle RSF version, ODBC version,...) (+bit depth)

    The quick cursory test: does executing the same SQL from the SQL window cause a crash or error?
    What toggles are engaged within the VSQL builder at the time of submission?

    Depending on the crash event (or during testing using SQL window), a second look might be obtained by using the session debug option to record the event:

    MicroStation Keyins:

    DMSG OPENMSGFILE c:\yourfile.txt
    SESSION DEBUG ON
    -- (perform action) --
    SESSION DEBUG OFF
    DMSG CLOSEMSGFILE

    ...review yourfile.txt

    Ultimately, this could be data based (SQL reserved words or characters, duplicate mslink), so details regarding the MSCATALOG table structure may be necessary.

    As it is Oracle, do note case sensitivity verbatim.

  • Hello Kees,

    Since MicroStation CONNECT Edtion is a 64-bit application, did you install the Oracle Client 64-bit on your Workstation ?

    Regards

    Sebastien Cote

    Regards

  • Hello Dan, Nelson and Sebastien,

    ExceptionHistory-1.zip

    MicroStation Connect 10.00.00.25 and MicroStation V8i 08.11.09.357 are installed on the same PC.

     

    10.00.00.25 uses an Oracle11GClient64

    08.11.09.357 uses an 32-bits-client

     

    The Oracle-server is: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – Production

     

    Connecting to the database and querying both using mdlDB-functions is no problem in Connect and V8i

     

    Only using SQL and VSQL is no problem in V8i

     

    Using SQL “select * from mscatalog” is a problem in Connect (see also dmsg_sql.txt):

    • only the first 3 columns are visible: the scrollbar doesn’t work.

    • the records are dimmed.

       

      Using VSQL “select * from mscatalog” is a problem in Connect (see also dmsg_vsql.txt + exception.log + minidump.dmp).

       

      The describe and data of the mscatalog-table:

       

      SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 15 11:52:26 2015

       

      Copyright (c) 1982, 2011, Oracle. All rights reserved.

       

       

      Connected to:

      Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

      Name                                                    Null?   Type

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

      TABLENAME                                           NOT NULL CHAR(32)

      ENTITYNUM                                           NOT NULL NUMBER

      SCREENFORM                                                     CHAR(64)

      REPORTTABLE                                                   CHAR(32)

      DASTABLE                                                         CHAR(32)

      SQLREVIEW                                                       CHAR(240)

      FENCEFILTER                                                     CHAR(240)

      FORMTABLE                                                       CHAR(64)

       

       

      TABLENAME                              ENTITYNUM

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

      nag_panden                                     2001

      nag_vw_panden_gisnr                      2002

      nag_verblijfsobjecten                       2003

      nag_vw_verblijfsobjecten_gisnr         2004

      nag_ligplaatsen                                2005

      nag_vw_ligplaatsen_gisnr                 2006

      nag_standplaatsen                           2007

      nag_vw_standplaatsen_gisnr             2008

      nag_woonplaatsen                           2009

      nag_vw_woonplaatsen_gisnr             2010