|
| | | Junior Member
 
Group: Forum Members
Last Login: 10/26/2006 9:22:01 AM
Posts: 11, Visits: 34 |
| | We have duplicate entries showing up in the PDS server, this just started yesterday, I found the following errors in the event log. Can you help? .Event Type: Error Event Source: CalyxPDSFileSync Event Category: None Event ID: 0 Date: 5/25/2006 Time: 12:24:19 PM User: N/A Computer: CFCSQLSRV Description: The description for Event ID ( 0 ) in Source ( CalyxPDSFileSync ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Calyx PDS Tier 5.1.5.0 Error while attempting to execute SQL in RunActionQuery(): System.Data.SqlClient.SqlException: Invalid column name 'f5027'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PdsTier.DBAccess.DBUtil.RunActionQueryWithResult(String strSQL) in D:\Vss\pds\PdsTier\main\DBUtil.vb:line 66 SQLQuery: INSERT INTO Additional (iFileID , f135, f630, f921, f923, f924, f1466, f5027, f5032, f5034, f5036, f5482 ) VALUES ( 135671 , 'REAL ESTATE INVESTOR' , 37500, '' , '' , 'X' , 'N' , '' , '693' , '734' , '688' , 'X' ) . Event Type: Error Event Source: CalyxPDSFileSync Event Category: None Event ID: 0 Date: 5/25/2006 Time: 12:24:19 PM User: N/A Computer: CFCSQLSRV Description: The description for Event ID ( 0 ) in Source ( CalyxPDSFileSync ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: PDS FileSync 5.1.2013.23296 Could not update additional fields table for file F:\dataserver\filesync\DataFolders\Simi2-Primary-Data-Folder\borrower\sv20604054.brw . |
| |
| | | Junior Member
Group: Forum Members
Last Login: 10/26/2006 9:22:01 AM
Posts: 11, Visits: 34 |
| | No worries, I figured it out for myself, I don't have an explanation of how it happened, this field was generated 3 months ago and the column was deleted yesterday, I checked all the logs and couldn't find any evidence of intrusion and I am the only one capable of deleting a column from sql directly without using the admin program. go figure.... |
| |
|
|