|
| | | Forum Newbie
Group: Forum Members
Last Login: 8/31/2007 1:28:54 PM
Posts: 4, Visits: 11 |
| We currently use the SQL DB from PDS to create our own custom reports using Crystal reports. We send out reports to different branches of our company and have to customize them accordingly. The issue we are having is that when we rebuild the Additional or Custom Fields Tables it seems to remove the data from the SQL DB for those fields. The only way we have found to repopulate the data into the SQL DB is to go into each loan thru Point and save each file. We are wondering if there is a work around or some way to force all the data for those fields to populate inside the SQL DB without having to save each file thru Point individually. Has anyone else seen this behavior and can anyone provide some direction on how we might fix this issue? Thanks, Mark |
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| under the rebuild custom/additional table button there is a check box to for a resync of all data folder check that then click the rebuild button.
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: 8/31/2007 1:28:54 PM
Posts: 4, Visits: 11 |
| | We have been using the check mark, Full Synchronize (Forced) of all data folders. We also wait until the sync has completed, Synchronize Folder (Forced), for all the data folders. The issue is not resolved after all the data folders have been synced. Any other thoughts would be appriciated. |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| when you watch the order of events on the status page what do you see first the rebuild of the table or the re-sync of all the data folders?
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: 8/31/2007 1:28:54 PM
Posts: 4, Visits: 11 |
| | Under Status we see the rebuild of the table first then followed by the resync (forced) of all the datafolders. |
| |
| | |
Sepal
Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| do you have any errors or warnings in the event log?
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: 8/31/2007 1:28:54 PM
Posts: 4, Visits: 11 |
| | Looks like we did have some errors and warnings for the Application Event Viewer. Here is a pattern I have noticed when we attempt to rebuild the fields (please start at the bottom at work your way up): 8/29/2007 4:24:44 PM SceCli Information None 1704 N/A CORPCPM1 Security policy in the Group policy objects has been applied successfully.
8/29/2007 4:12:25 PM Perflib Error None 1023 N/A CORPCPM1 Windows cannot load extensible counter DLL MSSQL$BKUPEXEC, the first DWORD in data section is the Windows error code.
8/29/2007 4:12:25 PM Perflib Error None 1023 N/A CORPCPM1 Windows cannot load extensible counter DLL MSSQL$BKUPEXEC, the first DWORD in data section is the Windows error code.
8/29/2007 4:12:24 PM Perflib Error None 1023 N/A CORPCPM1 Windows cannot load extensible counter DLL MSSQL$BKUPEXEC, the first DWORD in data section is the Windows error code.
8/29/2007 4:12:24 PM Perflib Warning None 2003 N/A CORPCPM1 "The configuration information of the performance library ""C:\WINDOWS\system32\infoctrs.dll"" for the ""InetInfo"" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted."
8/29/2007 4:12:24 PM Perflib Warning None 2003 N/A CORPCPM1 "The configuration information of the performance library ""C:\WINDOWS\system32\aspperf.dll"" for the ""ASP"" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted."
8/29/2007 4:12:24 PM Perflib Error None 1008 N/A CORPCPM1 "The Open Procedure for service "".NETFramework"" in DLL ""C:\WINDOWS\system32\mscoree.dll"" failed. Performance data for this service will not be available. The Status code returned is the first DWORD in the attached data."
8/29/2007 4:12:24 PM CalyxPdsService Information None 0 N/A CORPCPM1 Calyx PDS Service 5.3.2336.18295 Properly retrieved parameters. Support for PdsService methods now available. 8/29/2007 4:11:50 PM CalyxPDSFileSync Information None 0 N/A CORPCPM1 PDS FileSync 5.3.2336.18296 Parameters properly retrieved. 8/29/2007 3:54:48 PM Perflib Error None 1023 N/A CORPCPM1 Windows cannot load extensible counter DLL MSSQL$BKUPEXEC, the first DWORD in data section is the Windows error code.
8/29/2007 3:54:47 PM Perflib Error None 1023 N/A CORPCPM1 Windows cannot load extensible counter DLL MSSQL$BKUPEXEC, the first DWORD in data section is the Windows error code.
8/29/2007 3:54:47 PM Perflib Error None 1023 N/A CORPCPM1 Windows cannot load extensible counter DLL MSSQL$BKUPEXEC, the first DWORD in data section is the Windows error code.
8/29/2007 3:54:47 PM Perflib Warning None 2003 N/A CORPCPM1 "The configuration information of the performance library ""C:\WINDOWS\system32\infoctrs.dll"" for the ""InetInfo"" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted."
8/29/2007 3:54:47 PM Perflib Warning None 2003 N/A CORPCPM1 "The configuration information of the performance library ""C:\WINDOWS\system32\aspperf.dll"" for the ""ASP"" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted."
8/29/2007 3:54:47 PM Perflib Error None 1008 N/A CORPCPM1 "The Open Procedure for service "".NETFramework"" in DLL ""C:\WINDOWS\system32\mscoree.dll"" failed. Performance data for this service will not be available. The Status code returned is the first DWORD in the attached data."
8/29/2007 3:54:46 PM CalyxPdsService Information None 0 N/A CORPCPM1 Calyx PDS Service 5.3.2336.18295 Properly retrieved parameters. Support for PdsService methods now available. 8/29/2007 3:54:33 PM CalyxPDSFileSync Information None 0 N/A CORPCPM1 PDS FileSync 5.3.2336.18296 Parameters properly retrieved. Please let me know if this might be related or what I can do to fix these issues at hand. Thanks,
Mark |
| |
| | | 
www.ehuna.org
Group: Administrators
Last Login: 12/17/2008 10:36:11 PM
Posts: 258, Visits: 13,336 |
| | Can you look again in the event log and look only for error events for the windows service "CalyxPDSFileSync"? You want to do this after stopping and restarting the windows service "CalyxPDSFileSync" and trying to force a synch on your data folders again. For more information on the windows event log and error messages, see this article I wrote: Q11670 - INFO: (v6.0) Appendix L - Event Log
http://pdskb.calyxsoftware.com/article.aspx?id=11670
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: 5/2/2008 12:18:00 PM
Posts: 7, Visits: 21 |
| | I have been having the same kind of problems. But i got no error. The only thing is happening is the CalyxPdsFileSyn service is stopping by itself, so i am restarted again and again. It keeps stopping. I checked the status in the admin area it still says In Progress. I left it the way it is for few hours and all of a sudden the admin area got locked up and people were having problems saving the files, saying that it was already Reserved for someone (the same user) and can't get it, so i had to manually remove the reservations. That happened a lot today. So what you think the problem is Harry |
| |
|
|
|