Whoops!
2 views
Skip to first unread message
Norm
Aug 6, 2009, 8:53:15 PM8/6/09
to Bridge Works .NET Support, carolyn...@clark.wa.gov
For whatever reason, carolyn's BridgeWorks just stopped working. We
uninstalled and reinstalled. The system reported the initial database
was missing, I couldn't find one online, so I found one on another
machine and installed it. Now we get the following error message.
Any ideas?
Error loading Bridge Works application:
Invalid object name 'dbo.viewPermissions'.
Program exiting due to error.
SQL Command:
SELECT PER.* FROM dbo.viewPermissions AS PER WHERE (object_gid =
CONVERT(uniqueidentifier, '99496a87-6b70-49f8-8d3c-986b747ce456'))
Stack Trace:
Stacktrace in BridgeWorks.BWApplicationShell
[BridgeWorks.BWUtilities.BWDB.BWConnection] on PWD33706N:
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError
(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader
(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader
(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader
(CommandBehavior behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at BridgeWorks.BWUtilities.BWDB.SqlHelper.ExecuteDataset
(SqlConnection connection, SqlTransaction transaction, Int32 iTimeout,
CommandType commandType, String commandText, SqlParameter[]
objSQLParameters) in C:\WSDOT\NETProjects_2.0\Common\BWUtilities
\SQLHelper.vb:line 578
at BridgeWorks.BWUtilities.BWDB.BWConnection.ExecuteDataset
(String strSQL, Boolean bErrorCheck) in C:\WSDOT\NETProjects_2.0\Common
\BWUtilities\BWDBBase.vb:line 1214
Rethrown in BridgeWorks.BWApplicationShell
[BridgeWorks.BWUtilities.BWDB.BWConnection] on PWD33706N:
at BridgeWorks.BWUtilities.BWDB.BWConnection.ExecuteDataset(String
strSQL, Boolean bErrorCheck) in C:\WSDOT\NETProjects_2.0\Common
\BWUtilities\BWDBBase.vb:line 1245
at BridgeWorks.BWApplicationShell.AppDB.GetPermissions(BWGuid
objObjectGid) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\AppClasses\AppDB.vb:line 1492
at BridgeWorks.BWUtilities.BWAccountManager.HasPermission(BWGuid
objObjectGid, EOperationTypes eOperation, EPermissionTypes
ePermissionType) in C:\WSDOT\NETProjects_2.0\Common\BWUtilities
\BWAccountManager.vb:line 1298
at BridgeWorks.BWApplicationShell.BWManagedOperation.CheckWriteable
() in C:\WSDOT\NETProjects_2.0\BWApplicationShell\BWApplicationShell
\AppClasses\BWManagedOperation.vb:line 620
at BridgeWorks.BWApplicationShell.BWManagedOperation.lclActivated
(IWin32Window objForm, BWManagedOperation objPreviousMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 1304
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 691
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Rethrown in BridgeWorks.BWApplicationShell
[BridgeWorks.BWUtilities.BWAccountManager] on PWD33706N:
at BridgeWorks.BWUtilities.BWAccountManager.HasPermission(BWGuid
objObjectGid, EOperationTypes eOperation, EPermissionTypes
ePermissionType) in C:\WSDOT\NETProjects_2.0\Common\BWUtilities
\BWAccountManager.vb:line 1352
at BridgeWorks.BWApplicationShell.BWManagedOperation.CheckWriteable
() in C:\WSDOT\NETProjects_2.0\BWApplicationShell\BWApplicationShell
\AppClasses\BWManagedOperation.vb:line 620
at BridgeWorks.BWApplicationShell.BWManagedOperation.lclActivated
(IWin32Window objForm, BWManagedOperation objPreviousMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 1304
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 691
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Rethrown in BridgeWorks.BWApplicationShell
[BridgeWorks.BWApplicationShell.BWManagedOperation] on PWD33706N:
at BridgeWorks.BWApplicationShell.BWManagedOperation.lclActivated
(IWin32Window objForm, BWManagedOperation objPreviousMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 1331
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 691
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Rethrown in BridgeWorks.BWApplicationShell on PWD33706N:
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 696
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
uninstalled and reinstalled. The system reported the initial database
was missing, I couldn't find one online, so I found one on another
machine and installed it. Now we get the following error message.
Any ideas?
Error loading Bridge Works application:
Invalid object name 'dbo.viewPermissions'.
Program exiting due to error.
SQL Command:
SELECT PER.* FROM dbo.viewPermissions AS PER WHERE (object_gid =
CONVERT(uniqueidentifier, '99496a87-6b70-49f8-8d3c-986b747ce456'))
Stack Trace:
Stacktrace in BridgeWorks.BWApplicationShell
[BridgeWorks.BWUtilities.BWDB.BWConnection] on PWD33706N:
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError
(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader
(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader
(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader
(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader
(CommandBehavior behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at BridgeWorks.BWUtilities.BWDB.SqlHelper.ExecuteDataset
(SqlConnection connection, SqlTransaction transaction, Int32 iTimeout,
CommandType commandType, String commandText, SqlParameter[]
objSQLParameters) in C:\WSDOT\NETProjects_2.0\Common\BWUtilities
\SQLHelper.vb:line 578
at BridgeWorks.BWUtilities.BWDB.BWConnection.ExecuteDataset
(String strSQL, Boolean bErrorCheck) in C:\WSDOT\NETProjects_2.0\Common
\BWUtilities\BWDBBase.vb:line 1214
Rethrown in BridgeWorks.BWApplicationShell
[BridgeWorks.BWUtilities.BWDB.BWConnection] on PWD33706N:
at BridgeWorks.BWUtilities.BWDB.BWConnection.ExecuteDataset(String
strSQL, Boolean bErrorCheck) in C:\WSDOT\NETProjects_2.0\Common
\BWUtilities\BWDBBase.vb:line 1245
at BridgeWorks.BWApplicationShell.AppDB.GetPermissions(BWGuid
objObjectGid) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\AppClasses\AppDB.vb:line 1492
at BridgeWorks.BWUtilities.BWAccountManager.HasPermission(BWGuid
objObjectGid, EOperationTypes eOperation, EPermissionTypes
ePermissionType) in C:\WSDOT\NETProjects_2.0\Common\BWUtilities
\BWAccountManager.vb:line 1298
at BridgeWorks.BWApplicationShell.BWManagedOperation.CheckWriteable
() in C:\WSDOT\NETProjects_2.0\BWApplicationShell\BWApplicationShell
\AppClasses\BWManagedOperation.vb:line 620
at BridgeWorks.BWApplicationShell.BWManagedOperation.lclActivated
(IWin32Window objForm, BWManagedOperation objPreviousMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 1304
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 691
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Rethrown in BridgeWorks.BWApplicationShell
[BridgeWorks.BWUtilities.BWAccountManager] on PWD33706N:
at BridgeWorks.BWUtilities.BWAccountManager.HasPermission(BWGuid
objObjectGid, EOperationTypes eOperation, EPermissionTypes
ePermissionType) in C:\WSDOT\NETProjects_2.0\Common\BWUtilities
\BWAccountManager.vb:line 1352
at BridgeWorks.BWApplicationShell.BWManagedOperation.CheckWriteable
() in C:\WSDOT\NETProjects_2.0\BWApplicationShell\BWApplicationShell
\AppClasses\BWManagedOperation.vb:line 620
at BridgeWorks.BWApplicationShell.BWManagedOperation.lclActivated
(IWin32Window objForm, BWManagedOperation objPreviousMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 1304
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 691
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Rethrown in BridgeWorks.BWApplicationShell
[BridgeWorks.BWApplicationShell.BWManagedOperation] on PWD33706N:
at BridgeWorks.BWApplicationShell.BWManagedOperation.lclActivated
(IWin32Window objForm, BWManagedOperation objPreviousMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 1331
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 691
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Rethrown in BridgeWorks.BWApplicationShell on PWD33706N:
at BridgeWorks.BWApplicationShell.BWManagedOperation.SetMO
(IWin32Window objForm, BWManagedOperation objMO) in C:\WSDOT
\NETProjects_2.0\BWApplicationShell\BWApplicationShell\AppClasses
\BWManagedOperation.vb:line 696
at BridgeWorks.BWApplicationShell.frmMain.frmMain_Load(Object
sender, EventArgs e) in C:\WSDOT\NETProjects_2.0\BWApplicationShell
\BWApplicationShell\Forms\frmMain.vb:line 236
Larry Veden
Aug 6, 2009, 10:41:48 PM8/6/09
to bridge-works...@googlegroups.com
Norm:
Let me know when you will be available for a GoToMeeting. I think I know what's going on but would like to check it out first.
Thanks,
Larry
Norm Willinger
Aug 7, 2009, 2:06:11 PM8/7/09
to bridge-works...@googlegroups.com
Larry, can you give me a call? 360.397.6118 x4503
Thanks!
Norm Willinger 
From: Larry Veden <l2v...@gmail.com>
To: bridge-works...@googlegroups.com
Sent: Thursday, August 6, 2009 7:41:48 PM
Subject: {Bridge Works:169} Re: Whoops!
Reply all
Reply to author
Forward
0 new messages