Rightfax Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Rightfax Database

Author

Topic

kopzen
Starting Member

34 Posts

Posted - 2009-08-26 : 13:36:11

Hello Good People

I am running Right fax 9.3 and it stores all its data inside SQL Server 2005, A remote Right fax Board Server is connecting to the database for sending and receiving faxes. I have lost the connection between the two Servers. In the Board Server logs I got the following error:

Event Type: Error
Event Source: RightFax DocTransport Module
Event Category: None
Event ID: 3322
Date: 2009/08/26
Time: 07:28:54 PM
User: N/A
Computer: Server1
Description:
SQL ERROR in <<Executing INSERT INTO DTActivities (ServerGUID, Filename, SendFlags, ActID, Destination, UserID, MinSendChannel, MaxSendChannel, ToContactNum, ToName, ToCompany, BillInfo1, BillInfo2, SecureCSID, AuditFlags, SubscriberID, UniqueID, FromName, SourceServerName, Pages, GoodPages, TimeScheduled, SenderID, QuickHeaderFormat, TTIHeaderID, ForeignLoginID, ForeignLoginPassword, Priority, ExpirationTime, RemoteServerName, GroupID, RemoteProtocol, DocumentFlags, QueueName, Progress, Marked, DTDialingRuleUsed) VALUES ('{1564B11F-B4A2-42C9-AEEC-8C8313429A92}', 'D:\PROGRA~1\RIGHTFAX\DOCTRA~1\FA087A4E.IPK', 0, 38907, '8666', 'ROUTER', 0, 0, '', '8666', '', '', '', '', 0, 0, 'ROU4A9282AAA396', '0114523845', 'Server1', 1, 0, CONVERT(DATETIME, '08/26/2009 17:28:54', 101), '', '', '', '', '', 1, CONVERT(DATETIME, '01/18/2038 01:14:07', 101), '*Server1', 'RFAX_ADMIN', 0, 2048, 'RightFax', 2, 0, 93) >>
szSqlState = 42S22
pfNativeError = 207
szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DTDialingRuleUsed'.
pcbErrorMsg = 87

ODBCRowNumber = 1
SSrvrLine = 1
SSrvrMsgState = 1
SSrvrSeverity = 16
SSrvrProcname =
SSrvrSrvname =

And on The Rightfax server that contains database I get:
Event Type: Error
Event Source: RightFax Server Module
Event Category: None
Event ID: 3312
Date: 8/26/2009
Time: 7:24:41 PM
User: N/A
Computer: Server2
Description:
do_checkxmit:: 19:24:41 ID not found.

.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-26 : 13:47:50

does the column DTDialingRuleUsed exist in the table DTActivities?

does table get rebuilt nightly perhaps and it's a timing issue?

if answers are yes to the 1st and no to the 2nd, i'll run a checkdb.

kopzen
Starting Member

34 Posts

Posted - 2009-08-26 : 14:02:09

I ran a checkdb and got the following:

DBCC results for 'RightFax'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1574 rows in 17 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 206 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 218 rows in 3 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1574 rows in 16 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 206 rows in 2 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 218 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 121 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 536 rows in 12 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2098 rows in 40 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 199 rows in 9 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 345 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 499 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 647 rows in 144 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 14 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 259 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1262 rows in 14 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'DTActivityState'.
There are 2 rows in 1 pages for object "DTActivityState".
DBCC results for 'DTConfigurations'.
There are 2 rows in 1 pages for object "DTConfigurations".
DBCC results for 'DTConfigurationsDialingRules'.
There are 27 rows in 1 pages for object "DTConfigurationsDialingRules".
DBCC results for 'DTDestinationGroups'.
There are 0 rows in 1 pages for object "DTDestinationGroups".
DBCC results for 'DTDestinations'.
There are 0 rows in 0 pages for object "DTDestinations".
DBCC results for 'DTDialingRules'.
There are 27 rows in 1 pages for object "DTDialingRules".
DBCC results for 'DTRxDocs'.
There are 0 rows in 1 pages for object "DTRxDocs".
DBCC results for 'Delegates'.
There are 282 rows in 4 pages for object "Delegates".
DBCC results for 'DistributionLists'.
There are 182 rows in 1 pages for object "DistributionLists".
DBCC results for 'DocFiles'.
There are 54186 rows in 1437 pages for object "DocFiles".
DBCC results for 'Documents'.
There are 59683 rows in 5180 pages for object "Documents".
DBCC results for 'EnumEventsType'.
There are 21 rows in 1 pages for object "EnumEventsType".
DBCC results for 'ErrorLog'.
There are 0 rows in 0 pages for object "ErrorLog".
DBCC results for 'Events'.
There are 616 rows in 13 pages for object "Events".
DBCC results for 'ExtensionJoin'.
There are 518 rows in 2 pages for object "ExtensionJoin".
DBCC results for 'Forms'.
There are 13 rows in 1 pages for object "Forms".
DBCC results for 'GlobalConfiguration'.
There are 1 rows in 1 pages for object "GlobalConfiguration".
DBCC results for 'Globalization'.
There are 10590 rows in 203 pages for object "Globalization".
DBCC results for 'Groups'.
There are 91 rows in 3 pages for object "Groups".
DBCC results for 'HangupStatusToStatusCode'.
There are 89 rows in 1 pages for object "HangupStatusToStatusCode".
DBCC results for 'History'.
There are 164712 rows in 2342 pages for object "History".
DBCC results for 'HistoryApproved'.
There are 0 rows in 0 pages for object "HistoryApproved".
DBCC results for 'HistoryConversionError'.
There are 0 rows in 0 pages for object "HistoryConversionError".
DBCC results for 'HistoryDisapproved'.
There are 0 rows in 0 pages for object "HistoryDisapproved".
DBCC results for 'HistoryFileRouted'.
There are 50742 rows in 1277 pages for object "HistoryFileRouted".
DBCC results for 'HistoryGeneric'.
There are 34024 rows in 667 pages for object "HistoryGeneric".
DBCC results for 'HistoryInterConnect'.
There are 3214 rows in 29 pages for object "HistoryInterConnect".
DBCC results for 'HistoryLoc'.
There are 0 rows in 0 pages for object "HistoryLoc".
DBCC results for 'HistoryNetForward'.
There are 10702 rows in 168 pages for object "HistoryNetForward".
DBCC results for 'HistoryOCR'.
There are 0 rows in 0 pages for object "HistoryOCR".
DBCC results for 'HistoryPrint'.
There are 2598 rows in 38 pages for object "HistoryPrint".
DBCC results for 'HistoryRoute'.
There are 3416 rows in 14 pages for object "HistoryRoute".
DBCC results for 'HistorySecureDocs'.
There are 147 rows in 3 pages for object "HistorySecureDocs".
DBCC results for 'HistoryTRX'.
There are 59869 rows in 2194 pages for object "HistoryTRX".
DBCC results for 'LibraryDocuments'.
There are 121 rows in 4 pages for object "LibraryDocuments".
DBCC results for 'Locks'.
There are 0 rows in 0 pages for object "Locks".
DBCC results for 'NewDocAttachments'.
There are 0 rows in 0 pages for object "NewDocAttachments".
DBCC results for 'NewDocRecipients'.
There are 0 rows in 0 pages for object "NewDocRecipients".
DBCC results for 'NewDocs'.
There are 0 rows in 0 pages for object "NewDocs".
DBCC results for 'Notes'.
There are 4478 rows in 61 pages for object "Notes".
DBCC results for 'Printers'.
There are 327 rows in 5 pages for object "Printers".
DBCC results for 'RequestStatus'.
There are 0 rows in 1 pages for object "RequestStatus".
DBCC results for 'SecureDocsContacts'.
There are 0 rows in 0 pages for object "SecureDocsContacts".
DBCC results for 'SecureDocsRecipients'.
There are 0 rows in 0 pages for object "SecureDocsRecipients".
DBCC results for 'Signatures'.
There are 0 rows in 0 pages for object "Signatures".
DBCC results for 'StatDescs'.
There are 17 rows in 1 pages for object "StatDescs".
DBCC results for 'StatLives'.
There are 2 rows in 1 pages for object "StatLives".
DBCC results for 'StatRangeValues'.
There are 0 rows in 0 pages for object "StatRangeValues".
DBCC results for 'StatValues'.
There are 36 rows in 1 pages for object "StatValues".
DBCC results for 'SystemMessages'.
There are 0 rows in 1 pages for object "SystemMessages".
DBCC results for 'TimeEvents'.
There are 0 rows in 1 pages for object "TimeEvents".
DBCC results for 'UserFolders'.
There are 590 rows in 9 pages for object "UserFolders".
DBCC results for 'UserPagerNotify'.
There are 0 rows in 0 pages for object "UserPagerNotify".
DBCC results for 'Users'.
There are 2827 rows in 306 pages for object "Users".
DBCC results for 'WorkRequests'.
There are 595 rows in 109 pages for object "WorkRequests".
DBCC results for 'TermStatToStatusCode'.
There are 36 rows in 1 pages for object "TermStatToStatusCode".
DBCC results for 'UserRouteType'.
There are 31 rows in 1 pages for object "UserRouteType".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'AdminPagerNotify'.
There are 0 rows in 0 pages for object "AdminPagerNotify".
DBCC results for 'BillingCodes'.
There are 0 rows in 0 pages for object "BillingCodes".
DBCC results for 'Configuration'.
There are 1 rows in 1 pages for object "Configuration".
DBCC results for 'Contacts'.
There are 771 rows in 12 pages for object "Contacts".
DBCC results for 'DTActivities'.
There are 465 rows in 36 pages for object "DTActivities".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'RightFax'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-26 : 14:37:52

it was some sort of network error. db is good. nothing in the event logs?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources