I am VB application developer who writes custom DB applications. We have written an application that is deployed in a Citrix environment at a client's site. The Citrix Environment is a metaframe XP farm that has been upgraded to Win 2K SP3, FR3 SP3.
The application is an App that uses a custom written MTS component (installed on another server) to talk to a MS SQL Server database server (yet another server). This application has been running in this environment for about 1.5 years with no issues before the upgrade to SP3/FR3 SP3. The application was written using VB 6.0 with SP 5.
Since the upgrade, the Citrix server will reboot leaving no errors in the event log other than the computer was unexpectedly shut down (which is logged after the server reboots). The automatic reboot option has been turned off in the system options from the control panel.
We have confirmed that the application runs without this problem on a standalone workstation. The app blows up in a portion of the code where it is reading from or writing to and excel file and reading from or inserting into a recordset. During the section of code where the server is rebooting there is screen output for the row of the excel file being worked on so we are sure where in the code the reboot is occuring. All work during this section is going on locally -- ie no calls to the MTS component / database machine. The processors (2 in the machine) are not going above 60-70% utilization when only 1 load is being done. The memory utilization in the citrix machine is not going above 5% utilization or rising rapid before the blow up occurs. The error is not consistant and can occur at any point during the run with a Excel file of ~2400 rows.
We have made sure that all of the servers(Citrix, MTS, DB) are all running mdac 2.7 sp1 refresh (as is the development environment where the application and MTS component are compiled.) This is happening on multiple citrix servers when the only application published on the server is the custom VB app (other apps may be installed but are not published for testing purposes). We have tried 2 different database servers and 2 different MTS machines to no avail.
Any ideas?
The application is an App that uses a custom written MTS component (installed on another server) to talk to a MS SQL Server database server (yet another server). This application has been running in this environment for about 1.5 years with no issues before the upgrade to SP3/FR3 SP3. The application was written using VB 6.0 with SP 5.
Since the upgrade, the Citrix server will reboot leaving no errors in the event log other than the computer was unexpectedly shut down (which is logged after the server reboots). The automatic reboot option has been turned off in the system options from the control panel.
We have confirmed that the application runs without this problem on a standalone workstation. The app blows up in a portion of the code where it is reading from or writing to and excel file and reading from or inserting into a recordset. During the section of code where the server is rebooting there is screen output for the row of the excel file being worked on so we are sure where in the code the reboot is occuring. All work during this section is going on locally -- ie no calls to the MTS component / database machine. The processors (2 in the machine) are not going above 60-70% utilization when only 1 load is being done. The memory utilization in the citrix machine is not going above 5% utilization or rising rapid before the blow up occurs. The error is not consistant and can occur at any point during the run with a Excel file of ~2400 rows.
We have made sure that all of the servers(Citrix, MTS, DB) are all running mdac 2.7 sp1 refresh (as is the development environment where the application and MTS component are compiled.) This is happening on multiple citrix servers when the only application published on the server is the custom VB app (other apps may be installed but are not published for testing purposes). We have tried 2 different database servers and 2 different MTS machines to no avail.
Any ideas?