|
| | | Forum Newbie
Group: Forum Members
Last Login: 9/16/2008 7:13:54 AM
Posts: 2, Visits: 4 |
| | Over the weekend we upgraded to PDS v6.1sp1 and Client v 6.2. I started the forced rebuild of the additional fields. I noticed that the sync was taking way too long. I went and checked the event log and I noticed that I was getting the same error over and over again. Event Type: Warning
Event Source: PDSFileSync
Event Category: None
Event ID: 0
Date: 9/16/2008
Time: 8:42:22 AM
User: N/A
Computer: USAIIS
Description:
PDSFileSync 6.1.13.414 Could not update custom fields table for file: d:\DataFolders\Archive-2008\borrower\001093241.brw\rSystem.Data.SqlClient.SqlException: Error converting data type varchar to float.
at CalyxPDSTier.Entities.DynamicEntityBase.Insert() in d:\Vss\pds\PdsTier\main\Entities\DynamicEntityBase.cs:line 61
at CalyxTier.CalyxBridge.FillAndInsertCustom(TransactionManager mgr, PDS_POINT objPdsPoint, Int32 iFileID) in d:\Vss\pds\PdsTier\main\Bridge\CalyxBridge.cs:line 42
at CalyxTier.CalyxBridge.PointFileToDb(Int32 iFolderID, String sFolderName, Int32 iBorrowerProspect, Int32 iEventID, String sShortName, String sLongName, Int32 iCoBorrowerNumber, DateTime datNewUpdateDate, Int32 iFileSize, String sFullFileName, Int32 PDSPointFileID, PDS_POINT objPdsPoint) in d:\Vss\pds\PdsTier\main\Bridge\CalyxBridge.generated.cs:line 723 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Then the pdsfilesync.exe crashes
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: 9/16/2008
Time: 8:45:39 AM
User: N/A
Computer: USAIIS
Description:
Faulting application PDSFileSync.exe, version 6.1.13.414, faulting module mscorwks.dll, version 2.0.50727.1433, fault address 0x002b832f. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 50 44 53 ure PDS
0018: 46 69 6c 65 53 79 6e 63 FileSync
0020: 2e 65 78 65 20 36 2e 31 .exe 6.1
0028: 2e 31 33 2e 34 31 34 20 .13.414
0030: 69 6e 20 6d 73 63 6f 72 in mscor
0038: 77 6b 73 2e 64 6c 6c 20 wks.dll
0040: 32 2e 30 2e 35 30 37 32 2.0.5072
0048: 37 2e 31 34 33 33 20 61 7.1433 a
0050: 74 20 6f 66 66 73 65 74 t offset
0058: 20 30 30 32 62 38 33 32 002b832
0060: 66 f
I was on the phone with the support guys and they told me I have to let the sync "run it's course" but it has been running for 2 days. I can't run reports and files are disappearing.
Can anyone help?
Jamie Mantegna |
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 6:00:14 AM
Posts: 1,178, Visits: 9,170 |
| The resync will need to finish but you can correct this error for the remaining files. Stop the pdsfilesync service. Then go to the pds admin custom fields page. remove and readd your custom fields. Then restart pds filesync.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 9/16/2008 7:13:54 AM
Posts: 2, Visits: 4 |
| I don't understand what you mean by "remove and read". When I go to the custom fields page there is no option to remove or read.
Jamie Mantegna |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 6:00:14 AM
Posts: 1,178, Visits: 9,170 |
| sorry not enough coffee this morning. that should have read "remove the custom fields and readd the custom fields back." This is the only current way to update the fields type in the database.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| |
|
|