Fiber & Oracle

Hi to Everyone reading this, I'm new to the Bentley product range, so please bare with me.
I hope I've posted this in the right forum.
We have the following installed on a workstation.
Bentley Geospatial Administrator 08.11.07.90
Bentley Fiber V8i SS1 08.11.07.90
Microstation V8i SS1 08.11.07.90
Oracle Client 11g
The Following is installed on a Server
Windows 2003 STD Edition R2
Oracle 10g Release 2
The following is known.
A successful connection from Oracle SQL Developer to The oracle DB can be established.
I'm not 100% sure how Bentley Software interacts with the Oracle DB and what is stores?
Currently we have a empty DB, we also have a temp or example project in the default workspace called CommsTownSpatial
Can someone point me to some documentation or "how to" get an example up and running.

Question 1: What data is stored in Oracle?
Question 2: What Oracle table structure is required for Fiber?
Question 3: What is Bentley Geospatial Administrator 08.11.07.90 used for?
Any assistance would be greatly appreciated.

 

 

  • Vanwykm,

    Please check the readme file that was installed to the \communications folder.

     Answer 1: if persistence mode is DGN, than basically the same information as before. if persistance mode is spatial, then EVERERYTHING is stored in Oracle.

    Answer 2: all products require the same table structure, however they are different between persistance modes, please refer to the readme for steps to create.

    Answer 3: the GSA will configure and maintain your schema required for proper element display from oracle spatial.

    R.L.

  • Good afternoon to everyone reading this post.
    I'm still trying to get Bentley Fibre V8i Select series 1 working with oracle.
    I've followed readme_BentleyCommunications.pdf
    found in the \communications folder to the letter.
    1st issue i found was with importing the commstownspatial.dmp in C:\Program Files\Bentley\MicroStation V8i (SELECTseries 1)\WorkSpace\Projects\CommunicationsSpatial\CommsTownSpatial (header is corrupt)
    I then tried the next option on page 27 in the readme_BentleyCommunications.pdf
    I have done the following.
    1. Create an Oracle user. (Username = CTS)
    2. Run the SQL scripted named BentleyComm-OracleSpatial2tierCreate.SQL located in the \DATABASE\Spatial folder. This SQL script will 3. Create all the Comms Oracle tables.
    Run the SQL scripted named BentleyComm-OracleSpatial2tierVersioning.SQL located in the \DATABASE\Spatial folder. This SQL script will version all of the Comms Oracle tables.
    4. Locate the CommsTownSpatial.xml file under the Workspace folder. Make a copy of CommsTownSpatial. xml and rename it to your user name. (I renamed it to CTS) and kept the file in the same dir.
    5. Open the new xml file with WordPad. Run the find and replace all command to replace the word COMMSTOWNSPATIAL_ and COMMSTOWNSPATIAL. with your user name.
    Example: COMMSTOWNSPATIAL_ replaced with NEWUSER_ and COMMSTOWNSPATIAL. replaced with NEWUSER. (Always use upper case)
    6. From Bentley Geospatial Administrator, click on File > Open and select CTS.xml.
    7. If needed, change the Project information. (Project Name = BentleyFiberDemo)
    Workspace root dir = C:\Program Files\Bentley\MicroStation V8i (SELECTseries 1)\WorkSpace
    Project Parent dir = Projects
    8. Workspace name = CTS
    Base source dir = C:\Program Files\Bentley\MicroStation V8i (SELECTseries 1)\WorkSpace\Projects\CommunicationsSpatial\CommsTownSpatial
    9. (Macros)
    FOCUS = C:/Program Files/Bentley/MicroStation V8i (SELECTseries 1)/Communications/
    FOCUSCFG = C:/Program Files/Bentley/MicroStation V8i (SELECTseries 1)/Communications/
    FOCUSNET = C:/Program Files/Bentley/MicroStation V8i (SELECTseries 1)/WorkSpace/Projects/BentleyFiberDemo/
    FOCUSPROJ = $(FOCUSNET)CTS/
    10. I have saved and exported the schema
    11. I have completed step 19. + 20 + 21 + 22 in the readme_BentleyCommunications.pdf
    The Minute i open the shortcut or click on run, Microstation opens up and then prompts me to open a file.
    if i select work.dgn note that my User: is set to "BentleyFibreDemo_CTS" Project is set to "No Project" and Interface is set to CommsImpExp. the minute it loads Bentley MAP start and then it errors out with the following message "The Database: comms user: CTS cannot be connected."

    I have test this user and it connects with no issue using Oracle SQL Developer.

    Can someone please assist?