Calyx Software Message Board / Calyx Point / Miscellaneous / Rebuild Additional/Custom Fields Table not populating SQL Database / Latest Posts

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

harrysa — Fri, 22 Feb 2008 15:02:09 GMT

NOPE, no warnings

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

BetaFisch — Fri, 22 Feb 2008 14:22:41 GMT

when you look at your event log, do you see warnings from pds filesync?

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

harrysa — Fri, 22 Feb 2008 13:31:33 GMT

PDS SP1? i haven't heard about that.

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

BetaFisch — Fri, 22 Feb 2008 12:15:34 GMT

did you get PDS 6.0 sp1?

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

harrysa — Fri, 22 Feb 2008 11:40:46 GMT

I am running 64-bit so i downgraded to 32bit because of the 6.0 version.
So i am running PDS 6.0 and Point 6.0b windows server 2003 R2 Enterprise Edition SP2

H

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

BetaFisch — Fri, 22 Feb 2008 06:53:03 GMT

harrysa, what version of PDS are you running and what kind of server is it running on?

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

harrysa — Thu, 21 Feb 2008 23:43:10 GMT

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

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

Emmanuel Huna — Sun, 02 Sep 2007 18:50:26 GMT

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

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

Mark_CPM — Fri, 31 Aug 2007 11:40:48 GMT

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

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

BetaFisch — Fri, 31 Aug 2007 10:51:53 GMT

do you have any errors or warnings in the event log?

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

Mark_CPM — Fri, 31 Aug 2007 10:03:40 GMT

Under Status we see the rebuild of the table first then followed by the resync (forced) of all the datafolders.

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

BetaFisch — Fri, 31 Aug 2007 09:50:27 GMT

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?

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

Mark_CPM — Fri, 31 Aug 2007 09:20:42 GMT

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.

RE: Rebuild Additional/Custom Fields Table not populating SQL Database

BetaFisch — Fri, 31 Aug 2007 09:14:34 GMT

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.

Rebuild Additional/Custom Fields Table not populating SQL Database

Mark_CPM — Fri, 31 Aug 2007 08:42:48 GMT

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