VBA check if a feature is queried from database
Hello all,
I have a features queried from database and another I just placed. Can I check if feature is queried from database in VBA?
Bentley Map V8i - Oracle client compatibility
Hi, I want to use an Oracle connection in Bentley Map V8i (SELECTseries 4) 08.11.09.615. I have an Oracle Client 18.1.0.095 but there is an error message about Oracle client compatibility when settting the connection in Geospatial administrator.
Any…
Posting Error in history enabled layer - Bentley Map
Hello Experts,
I am getting error while posting a feature in Bentley Map using Oracle database.
"Error Inserting Feature (Class : LayerName, id : 1234)
InsertRow:
ORA20012: need to be on latest version to insert
ORA-06512: at WMSYS,WM_ERROR…
Bentley Map Streaming - Very Slow performance - 30 minutes to display 30,000 polygon records.
Bentley Map Streaming of data [Oracle View ]from Oracle database takes so much time.
Around 30 minutes to display 30,000 polygon records.
Made connection through GDI Explorer - Connect to Oracle DB - Streaming Set as TRUE.
Same Oracle View queried…
RE: [BM SS4] What happens to User Data Linkages?
Bruce,
The provided MVBA example code demonstrates how one could read the MSLINK value from the graphical element in the promoted polygon collection feature instances and write the value to a business property, which after posting would appear in a…
RE: [BM SS4] What happens to User Data Linkages?
Bruce,
During the "Promote" process the database linkages should be preserved and remain available on the elements. However database linkage information is not automatically available on the feature instance or inserted into the spatial database during…
RE: DGN to SHP
Use MicroStation Solid Utilities tools to Extract the Smart Solid faces and edges for use in the Export to Shapefile command.
Jan is correct that the Smart Solid MicroStation element types are not suitable (or available) for Export to Shapefile. The…
How to trace SQL between Oracle and Bentley Map ?
Hi there,
Is there any way to trace SQL statements as well as responses between Bentley Map and Oracle?
I noticed there's a log file that you can enable but it doesn't log SQL statements...
Does anyone knows if TOAD allows you to trace an application…
PowerMap and Map (SELECTSeries 1) Problem with Oracle
I have downloaded and install both PowerMap and Bentley Map release candidates and I am trying to connect to my Oracle 11g server.
Whenever I try to connect through the 'Open Oracle Spatial' or 'Import->GIS Data Types', and add a new Oracle connection…
Bentley Map Enterprise (SS2) and Oracle 11g
I have been playing around with Bentley Map Enterprise v8i (SS2) with our Oracle Server. The tables on my Oracle server are built from MapInfo TAB files (using MapInfo EasyLoader Utility), and a script is run to fix the SRID and USER_SDO_GEOM_METADATA…
Re: Bentley Map Annotation (Labeling)
Hi All,
I am still stuck on this problem. I have an Oracle database and the latest Bentley Map V8i and still I can't find an option to automatically label the features from the Oracle Spatial database. Have I missed something?
I also found…
Oracle Based Topographic or Reference Features
Hi All,
I have a Bentley Water GSA project with all the Oracle based features I want to maintain defined and working properly. But I want to add or include several other reference features which are also within the same Oracle schema, but I don't want…
Re: Refreshing Oracle Data
Jon Summers: Ian: Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?
What do you mean by 'refresh the Oracle data'?
I mean that when you open a DGN the data may not…
Refreshing Oracle Data
Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?
Also how can you save the Oracle connection user name and password in a DGN?
Cheers Ian
3D Features in Oracle Locator
This is probably something I am just doing wrong, but I am having trouble loading my 3D features (buildings) into our Oracle Server (11g).
I have created me GSA project and created a couple of features, now I want to load these into Oracle. I used…
BM Oracle Connection
I am having a problem reading data from my Oracle Database. I am getting an error "There is no algorithm for assigning the given source geometry to the given target geometry, they do not match."
What does this error mean and how can I work around…
Re: Oracle Spatial Error
Does it matter if you install the 64 or 32 bit versionof the Oracle Client. In previous versions of Map, it would only work with the 32bit driver.
Cheers Ian
Re: Need help in joining tables
Hi Jun,
Can you said what is origin of your second table (oracle, shp, dgn xfm, etc...) ?
In which do you join table ? I mean here which feature property is on left side and on right side ?
Once joined, are you able to see properties values in analyze…
Bentley Geospatial Administrator + Bentley Map - Importing from Oracle in specific SRID
I have a geographic data stored in Oracle with SRID 2065 (JTSK) and I need to import them into a DGN file, respecting the same projection. I have found some documentation of an older version of Bentley Geospatial Administrator where there was a category…
Need help in joining tables
Hi all,
I was having trouble with joining tables (sometimes working with other table, sometimes not) I hope someone could help me this;
I was joining two feature tables together (Oracle database properties not Oracle spatial) using Bmap join…
Re: Refreshing Oracle Data
Hi Sebastian,
I have saved the .orax file from Bentley Map, but it is not saving the connection password. Can you tell me the XML property that should be set.
Cheers Ian
GSA Performance with Oracle
Hi All,
We are experiencing large dealy when we are creating GSA projects for our Oracle based data. I have found that the GSA executes the following query, which takes a long time (10+ minutes) on our Oracle server. I am keen to know if other people…
(GeoGraphics) HOW DO I : Connect to and Dump elements into an Access Database
Alright,
I've been a GeoGraphics user since about 2006. We have a strict workflow in our department that doesn't encourage familiarity with the database. Use the Spatial Query and Post tools, fill in the attributes in our prepared forms, and that's…
Re: BM Oracle Connection
Thanks Jerry,
I found the problem. The data was uploaded from MapInfo Tables (using EasyLoader), and although the geometeries where polylines, some contained multiple polylines (as a geometry collection or multi section line). This is represented…
Re: GSA Performance with Oracle
Thanks Jerry,
Is there anyway we can speed up the query?
We use a generic login for our users performing edits (a seperate login for each department), and this allows us to see how makes any changes (and what PC they used to make the change) which…