Do any of you see a potential solution to my problem?
Can someone point me in the right direction?
I've searched and read for hours on this topic. I've tried to export using 64 bit ODBC to a new database in an existing SQL Server 2016. I've tried to export using 64 bit ODBC to a new database in a new SQL Server 2019. I get the same behavior every single time and there is no explanation as to what is going on.
It logs me in to the SQL Server and creates the tables with headers, but does not populate any rows. The error message is simply:
Please check the Database connection:
DSN=Revit;
Thank you in advance for your time.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Here is the (compacted; no redundant table creation entries) execution log from the journal (full journal attached):
'E 28-Feb-2020 12:03:44.334; 0:<
Jrn.RibbonEvent "TabActivated:Add-Ins"
' 0:< ::59:: Delta VM: Avail -1 -> 134177977 MB, Used +10 -> 847 MB, Peak +9 -> 847 MB; RAM: Avail -13 -> 9923 MB, Used +10 -> 991 MB, Peak +9 -> 991 MB
' 0:< GUI Resource Usage GDI: Avail 9112, Used 888, User: Used 430
Jrn.RibbonEvent "Execute external command:CustomCtrl_%CustomCtrl_%Add-Ins%RevitDBLink%RevitDBLink:Revit.Addon.RevitDBLink.CS.Command"
' 1:< [RDBL] [12:03:47.5539] Start Revit DB Link
' 1:< [RDBL] [12:03:47.5539] AssemblyInfo: RevitDBLink, Version=20.0.0.0, Culture=neutral, PublicKeyToken=null
' 1:< [RDBL] [12:03:47.5539] Set APIObjectList.ActiveDocument
' 1:< [RDBL] [12:03:47.5539] End Set APIObjectList.ActiveDocument
' 1:< [RDBL] [12:03:47.5559] Document title: rst_basic_sample_project
'E 28-Feb-2020 12:03:47.501; 0:<
' 1:< [RDBL] [12:03:47.5569] Document path: C:\Program Files\Autodesk\Revit 2020\Samples\rst_basic_sample_project.rvt
' 1:< [RDBL] [12:03:47.5579] Config file C:\Users\jjjohnson\AppData\Roaming\Autodesk\Revit\Addins\2020\Revit DB Link\ignoretables.xml
' 1:< [RDBL] [12:03:47.5629] Config file not found
' 1:< [RDBL] [12:03:47.5739] Get last DatabaseType: ODBC
' 1:< [RDBL] [12:03:47.6639] Show RDBLink Form
' 1:< [RDBL] [12:03:47.7268] Load ODBC connection history to UI
' 1:< [RDBL] [12:03:47.7278] m_previousHistory Count: 1
' 1:< [RDBL] [12:03:47.7278] DSN=RevitLink;
' 1:< [RDBL] [12:03:47.7278] DatabaseManager.LastDatabaseType = ODBC
' 1:< [RDBL] [12:03:47.7338] odbc tab set is selected
' 1:< ::60:: Delta VM: Avail -2 -> 134177976 MB, Used +1 -> 849 MB, Peak +9 -> 857 MB; RAM: Avail -7 -> 9917 MB, Used +2 -> 994 MB, Peak +10 -> 1002 MB
' 1:< GUI Resource Usage GDI: Avail 9106, Used 894, User: Used 450
' 1:< [RDBL] [12:03:52.3023] Removed history: DSN=RevitLink;
' 1:< ::60:: Delta VM: Avail 134177976 MB, Used 849 MB; RAM: Avail -17 -> 9900 MB, Used 994 MB
' 1:< GUI Resource Usage GDI: Avail 9109, Used 891, User: Used 433
' 1:< [RDBL] [12:03:54.2313] Closed RDBLink Form
' 6.856696!!! 2:!!!BIG_GAP API External Command Time
' 5.035388!!! 2:!!!BIG_GAP API External Command Time
' 1:< ::60:: Delta VM: Avail -14 -> 134177963 MB, Used +1 -> 851 MB; RAM: Avail -7 -> 9894 MB, Used +2 -> 997 MB
' 1:< GUI Resource Usage GDI: Avail 9067, Used 933, User: Used 435
' 1:< [RDBL] [12:04:13.6540] DatabaseName: Microsoft SQL Server
' 1:< [RDBL] [12:04:13.6630] Initialize Tables ...
' 1:< [RDBL] [12:04:13.6630] Initialize TableInfoSet ...
' 1:< ::60:: Delta VM: Avail 134177963 MB, Used 851 MB, Peak +13 -> 871 MB; RAM: Avail -8 -> 9886 MB, Used 997 MB, Peak +14 -> 1016 MB
' 1:< GUI Resource Usage GDI: Avail 9067, Used 933, User: Used 435
' 1:< [RDBL] [12:04:13.7490] OmniClassTaxonomyFile: C:\Users\jjjohnson\AppData\Roaming\Autodesk\Revit\Autodesk Revit 2020\OmniClassTaxonomy.txt
' 1:< [RDBL] [12:04:13.8239] Creating shared or project parameter columns
' 1:< [RDBL] [12:04:13.8889] [Rooms] (TabN_OST_Rooms_INSTANCE)
' 1:< [RDBL] [12:04:13.8899] Add column: Occupant
''''''''''''''REPEAT ADD COLUMN SEVERAL TIMES''''''''''''''
' 1:< [RDBL] [12:04:13.9119] Finished creating shared or project parameter columns
' 1:< [RDBL] [12:04:13.9119] Initialize TableInfoSet finished
' 1:< [RDBL] [12:04:13.9159] Initialize Tables Finished
' 1:< [RDBL] [12:04:13.9468] Create all database tables ...
' 1:< [RDBL] [12:04:13.9518] Create tables ...
' 1:< [RDBL] [12:04:14.9353] TabN_CST_RoomAssociations,RoomAssociations
' 1:< [RDBL] [12:04:14.9353] primaryKey:ColN_CST_Id
' 1:< [RDBL] [12:04:14.9353] primaryKey:ColN_CST_PhaseId
' 1:< [RDBL] [12:04:14.9353] primaryKey:ColN_CST_DesignOptionId
' 1:< [RDBL] [12:04:14.9713] TabN_CST_RoomFromToAssociations,RoomFromToAssociations
' 1:< [RDBL] [12:04:14.9713] primaryKey:ColN_CST_Id
' 1:< [RDBL] [12:04:14.9713] primaryKey:ColN_CST_PhaseId
' 1:< [RDBL] [12:04:14.9713] primaryKey:ColN_CST_DesignOptionId
' 1:< [RDBL] [12:04:14.9763] TabN_CST_MaterialQuantities,MaterialQuantities
' 1:< [RDBL] [12:04:14.9773] primaryKey:ColN_CST_ElementId
' 1:< [RDBL] [12:04:14.9773] primaryKey:ColN_CST_MaterialId
' 1:< [RDBL] [12:04:14.9773] primaryKey:ColN_CST_AsPaint
' 1:< [RDBL] [12:04:15.1542] TabN_CST_SpaceAssociations,SpaceAssociations
' 1:< [RDBL] [12:04:15.1542] primaryKey:ColN_CST_Id
' 1:< [RDBL] [12:04:15.1542] primaryKey:ColN_CST_PhaseId
' 1:< [RDBL] [12:04:15.1542] primaryKey:ColN_CST_DesignOptionId
' 1:< [RDBL] [12:04:15.4710] Create tables Finished
' 1:< [RDBL] [12:04:15.4710] Add foreign keys ...
' 1:< [RDBL] [12:04:16.6863] Add foreign keys Finished
' 1:< [RDBL] [12:04:16.6863] Create all database tables Finished
' 1:< [RDBL] [12:04:16.6873] Categorize Elements ...
' 1:< [RDBL] [12:04:16.6883] Filter elements:[RevitDBLinkInfo] (TabN_CST_RevitDBLinkInfo)
' 1:< [RDBL] [12:04:16.6883] Filter elements:[RevitDBLinkInfo] (TabN_CST_RevitDBLinkInfo) Count:1
' 1:< [RDBL] [12:04:16.6883] Filter elements:[InstanceUsageEnums] (TabN_CST_StructuralUsageEnum)
' 1:< [RDBL] [12:04:16.6883] Filter elements:[InstanceUsageEnums] (TabN_CST_StructuralUsageEnum) Count:13
''''''''''''''REPEAT FILTER ELEMENTS SEVERAL TIMES''''''''''''''
' 1:< [RDBL] [12:04:19.0010] CategorizeElements
' 1:< [RDBL] [12:04:19.0010] Time: [00:00:31.4661011]
' 1:< [RDBL] [12:04:19.0060] ODBCDriver Opened
' 1:< [RDBL] [12:04:19.0060] Conn String = DSN=Revit;
' 1:< TaskDialog "Please check the Database connection: DSN=Revit;"
'CommonButtons : Close
'DefaultButton : Close
' 19.734537!!! 2:!!!BIG_GAP API External Command Time
' 1:< [RDBL] [12:04:26.4221] DatabaseManager dispose
' 1:< [RDBL] [12:04:26.4261] SaveSettings
' 1:< [RDBL] [12:04:26.4261] #Last Database type: ODBC
' 1:< [RDBL] [12:04:26.4271] ODBC,DSN=Revit;
' 1:< [RDBL] [12:04:26.4320] ODBCDriver dispose
' 1:< [RDBL] [12:04:26.4330] DatabaseManager Closed
' 1:< [RDBL] [12:04:26.4360] DatabaseManager.isExcelExport = False
' 1:< [RDBL] [12:04:26.4360] End Revit DB Link
' 39.040105 1:<<API External Command Time
' 0:< ::60:: Delta VM: Avail -5 -> 134177942 MB, Used +5 -> 870 MB, Peak +3 -> 874 MB; RAM: Avail -12 -> 9864 MB, Used +7 -> 1011 MB
' 0:< GUI Resource Usage GDI: Avail 9065, Used 935, User: Used 434
'H 28-Feb-2020 12:04:26.574; 0:<
Jrn.Data "APIStringStringMapJournalData" _
, 3, "ConnectionString", "DSN=Revit;" _
, "DatabaseType", "ODBC", "IsExport" _
, "True"
' 0:< Error posted:
' 0:< Error Connecting
'DSN=Revit;
' 1:< Invoked HandleDocFailure
' 1:< Error dialog has no callback because
'it was not provided in following error in error message
'Error Connecting
'DSN=Revit;
' 1:< Error dialog data for transaction in Host document
' 1:< Error: Error Connecting
'DSN=Revit;
' 1:< Error dialog summary
' 1:< Error: Error Connecting
'DSN=Revit; - 1 times
'H 28-Feb-2020 12:04:26.579; 1:<
Jrn.Data "Error dialog" _
, "0 failures, 1 errors, 0 warnings"
I somehow managed to solve this by switching from SQL-Server-Authentification to Windows-Authentification. So in the end that error is happening when trying to connect to the db even after the tests at connection creation at revit db link dialogs succeeded.
I ended up going in another direction, but I will definitely revisit this now that I've heard of a success story. Thank you for posting.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.