I'm attempting to debug why I cannot establish a connection from Microstations to our Oracle database.
In my workspace cfg file, I am setting:
MS_SESSION_DEBUG = 1
I've confirmed thru the show configuration and (File) Settings - Configuration - Configuration Variables that MS_SESSION_DEBUG is set to 1.
I enter my database connection command below (fake id/pw and alias) into the command window:
mdl load dbconmgr;dbconmgr oracle;db=usertwo/pwseven@dbalias
I open the Message Center window and see the following in the top pane:
Unsuccessful CONNECT StatementDatabase NONEDatabaseDBGCONMGR LoadedDatabaseLoading and initializing databaseIf I click on one of these entries in the top pane, I see nothing in the Message Details pane. Shouldn't I be seeing debug information for each entry? I believe I had this working in that I did see something in the detail pane last week for Unsuccessful CONNECT Statement, but don't know what I did that session debug does not appear to be showing anything.
Does anyone have any idea on why I am not seeing any debug information on my failed database connection?
I have confirmed that I am loading the oracle.cfg file with the following values:
_USTN_WORKSETDESCR + (Oracle)
#------ Will the DLM version of the server be used?%if !defined (_msdos) && !defined (_unix) && !defined (_powerc) %if !defined (MS_NODBDLM) MS_DBDLM = 1 %endif%endif
#------ Oracle Home Path ------## MS_ORACLE_HOME is the path to the location of the Oracle client# files used to connect to the database server. If this variable# is not set MicroStation will automatically determine the location# of the client files by looking at the system registry and path.
#%if !defined (MS_ORACLE_HOME)# MS_ORACLE_HOME = d:/oracle/ora81#%endif
#------ Database Files ------#MS_DBASE = $(_USTN_WORKSETSROOT)examples/database/oracle/
#------ Server Loader ------#%if defined (MS_DBDLM)MS_SERVER : oralddlm%elseMS_SERVER : dbload%endif
#------ Database Server ------#%if !defined (MS_DBDLM) %if defined (_WINCONN) MS_DBEXT : orsrvwin.exe %elif defined (_msdos) MS_DBEXT : orserver.pxe %elif defined (_winNT) MS_DBEXT : orserver.exe %else MS_DBEXT : orserver %endif%endif
#------ Database Linkages ------#MS_LINKTYPE = ORACLEMS_LINKTYPE > ODBCMS_LINKTYPE > OLEDBMS_LINKTYPE > DMRSMS_LINKTYPE > XBASEMS_LINKTYPE > IXMS_LINKTYPE > RISMS_LINKTYPE > BUDBC
#------ Don't create MSFORMS tables ------#
MS_NOMSFORMSTABLE = 1
#------ Design File Applications ------#%if !defined (_USTN_DONTSETSERVER) MS_DGNAPPS > server%endif
MS_ORACLE_HOME = C:/app/oracle/product/12c64
I reported issue of using MS_SESSION_DEBUG, and it is identified as a bug.
Bug# 660390 has been filed.