Troubleshooting
Here are the most frequent issues our users encounter when installing and using AceProject. These procedures will help you solve these issues and benefit from AceProject's functionalities at full potential.
Installing Internet Information Services (IIS)
Start IIS Installation through "Server Management - Add Role".
To install IIS 6 on Windows Server 2003, set configurations as illustrated in the screenshots below. Scroll further down for instructions on an IIS 7/7.5 on Windows Server 2008/2008R2 install.
To install IIS7/7.5 on Windows Server 2008/2008R2, set configurations as illustrated in the screenshots below.
When you select the ASP.NET and ASP items, most other role services are automatically selected.


You installed .NET Framework 3.5 before installing IIS
Execute the appropriate command below to integrate the Framework with IIS. Framework 3.5 is an update of Framework 2.0; thus the reference to version 2.0 you see in the folder name.
32 bits: C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
64 bits: C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
Installing SQL Server 2008 R2 Express Edition
Download "Microsoft SQL Server 2008 R2 Express with Management Tools", 32 or 64 bits, through the following link:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=967225eb-207b-4950-91df-eeb5f35a80ee
Note:
Installing SQL Server on Windows Server 2003 requires you install both Windows Installer 4.5 (which you
may download here), and PowerShell
(available through Windows Update).
1. Run the SQLEXPRWT_x[86-64]_ENU.EXE (32 or 64 bits) setup file.
2. Select "New installation or add features to an existing installation".
3. On the "Feature Selection" page, select only "Database Engine Services" and "Management Tools - Basic". Then, click "Next".
4. On the "Instance Configuration" page, select "Default instance", and then click "Next".
5. On the "Server Configuration" page, click on the "Collation" tab and on the "Customize" button. In the "Windows collation designator and sort order" area, choose "Latin1_General" and do not check any of the boxes. Click "OK". You should see "Latin1_Genral_CI_AI". If so, click "Next". With Windows Server 2003, you might get an error on the service account tab. If so, select "NT AUTHORITY\NETWORKSERVICE" as the account name for the "SQL Server Database Engine" service and then click "Next".
6. On the "Database Engine Configuration" page, select "Mixed Mode" and enter your password. Click "Add Current User". You can also add other users if you want. Click "Next".
7. Complete the installation.
Installing SQL Server Native Client
If SQL Server is not installed on the same machine as your web server, odds are the "SQL Server Native Client" component is not installed on the web server machine.
Another possible issue lies in the fact the SQL Server 2005 "SQLNCLI" is not identical to the one associated with SQL Server 2008 or 2008 R2. Since AceProject uses the latest SQLNCLI, you must install the appropriate "SQL Native Client" component.
A "Provider cannot be found. It may not be properly installed." error typically occurs if the proper SQLNCLI component is not installed.
You will then need to install SQLNCLI on the web server, using the appropriate link from the two below, so that the AceProject application may connect to SQL Server.
Windows Server 32-bit system:
Windows Server 64-bit system
Launch and perform a default installation.
Disabling the UAC (User Account Control)
If you are installing AceProject on a Windows 2008 or 2008 R2 system, you will need to disable the UAC if you are not logged in under the "Administrator" account. Having administrator rights on an account other than the "Administrator" account is not sufficient.
1. Launch msconfig (Start - Run - type msconfig). Select "Tools" tab.
2a. Windows 2008: Select "Disable UAC". Click "Launch". Reboot.
2b. Windows 2008 R2: Select "Change UAC Settings". Click "Launch". Set it to minimum value. Click OK. Reboot.
Help menu not displayed (page cannot be found)
If the Help Section is not working, this means that IIS is not configured properly. Here is how this issue can be fixed:
1. Open IIS and right-click the corresponding web site, usually aceproject.
2. Select "Properties -> Home Directory".
3. Click the "Configuration" button.
4. Click the "Options" tab and check the "Enable Parent Paths" box.
Activate JavaScript in Internet Explorer (for users)
If you find that AceProject's left menus are displayed poorly or do not work at all, it is likely that your web browser has disabled JavaScript. In order to display AceProject's menus properly, JavaScript must be enabled.
1. Go to "Tools -> Internet Options".
2. Click the Security tab.
3. Click Internet in the Web content zone
4. Set the sliding bar to Medium.
5. Click the "Custom Level…" button.
6. In the new window, scroll down to Scripting
7. In the sub-section Active scripting, click enable.
8. Click the OK button.
9. Click OK to close the options window.
If you only want to activate JavaScript for certain sites, choose Trusted sites instead of Internet in the web content zone, then activate JavaScript as described above. All you have to do is click on the Sites… button to add trusted websites.
Browser Refresh Problem
AceProject being a dynamic site, your Internet browser needs to be set to automatically download every page, instead of using the one stored in your browser cache. If you notice strange behaviour in AceProject (for example tabs that do no refresh or recent changes that are not displayed), you may need to set your refresh settings correctly.
How to set automatic refresh in Internet Explorer:
1. Go to "Tools -> Internet options".
2. Click the General tab.
3. In the middle of the window, click the "Settings…" button.
4. Click "Automatically" in the "Check for newer versions" of stored pages section.
5. Click OK to close the window.
6. Click OK to close the Internet Options window.
Windows 2003 File Upload Size Problem
When users upload file attachments to AceProject tasks, they may encounter problems with larger files. If you use Windows Server 2003, IIS 6.0 prevents the upload of files more than 200 Kb. You need to change this parameter to a higher value to allow larger files.
For IIS 6.0 users, the AspMaxRequestEntityAllowed property specifies the maximum number of bytes allowed in the entity body of an ASP request. If a Content-Length header is present and specifies an amount of data greater than the value of AspMaxRequestEntityAllowed, IIS returns a 403 error response.
This property is related in function to MaxRequestEntityAllowed, but is specific to ASP request. Whereas you might set the MaxRequestEntity Allowed property to 1 MB at the general World Wide Web Publishing Service (WWW Service) level, you may choose to set AspMaxRequest EntityAllowed to a lower value, if you know that your specific ASP applications handle a smaller amount of data.
How to set the maximum file size allowed for upload in IIS 6.0
1. Stop the IIS service before making changes.
2. Open your metabase.XML which is located in c:\Windows\System32\Inetsrv
3. Find the line AspMaxRequestEntityAllowed and change it to 1073741824. This is 1GB - of course you can enter another value to suit your needs.
NOTE: Before you edit the file, be sure to stop the IIS service first or else you
won't be able to save the file.
Date Issue with Non-English Servers
You may have a date issue if you install AceProject on a non-English Windows Web server, or when using a non-English SQL Server. Since AceProject saves dates in US format, default non-English server installation may not save dates in US format. This issue only occurs with SQL databases. It can be fixed with minor modifications.
The user specified in the connection string of the "configuration.asp" file must be set as an English user. For example, if the user is named "aceproject", you should run the following SQL query to fix the issue:
EXEC sp_defaultlanguage 'aceproject', 'english'
DBCC useroptions
PS: We recommend that you do not use the 'sa' user. We recommend you create another user to connect to the database.
Issue with "Plain Text" mode
You might encounter errors when switching to "Plain Text" mode in fields where this option is supported (Details and Comment fields at the task level and Message field in the Discussion forum). You will need to enable CLR integration in SQL Server for this function to operate correctly. Here's how:
SQL server 2008:
1. Start "SQL Server Management Studio" and connect to your SQL server.
2. Right click on your server and select "Facets".
3. Select the "Surface Area Configuration" facet.
4. Set "ClrIntegrationEnabled" to "True" and click on OK.
"Page Cannot be Displayed" Error
If the Intranet package installation is not installed properly on a first try, your Web browser may not be able to tell you what the problem is exactly. In such a case, you would get a "Page Cannot be Displayed" error message.
However, in order to fix the issue, you need to know what the issue is exactly. Your browser can be set to display "HTTP Non-Friendly Error Messages" in which you can see all details related to the error. Here's how you can activate this option:
1. Open Internet Explorer
2. Tools -> Internet Options
3. Advanced tab
4. Uncheck Show friendly HTTP error messages
5. Apply.
6. Try to generate your error again and you should get a more detailed error message.
Session Timeout Issue
The "Timeout" value is set in file "configuration.asp". Even If the value is set in accordance with your needs, it may not work properly. You may have to set the timeout value elsewhere on your web server if you think it doesn't work. There are several places where you can set the timeout value, here are a few of them:
at the IIS level;
at the Application Pool level;
at the Virtual Directory level;
You may have to change the timeout value at all above-mentioned levels.
NOTE: According to our tests, the "session.timeout" value prevails over all above-mentioned
parameters. The value of session.timeout is in minutes.
Example (recommended):
session.timeout = 480
Active Server Pages Not Allowed (Windows Server 2003)
This issue occurs when .asp pages cannot be displayed in Windows Server 2003. By default, Windows Server 2003 doesn't allow .asp pages to be executed. As a result, the "login.html" page will be working but "login.asp" won't.
Here's the procedure to fix this issue (see screenshot):
- 1. Open IIS and locate "Web Service Extensions" on the left tree.
- 2. Click "Active Server Pages" on the right list.
- 3. Click the "Allow" button to allow ASP pages to be executed.
Number of Task Details kept in the History Table (in file configuration.asp)
This is the number of task detail changes kept in the history table in the database. Increasing this number will increase the task history table size. Accepted values are integers equal or above zero (0) Set this value to zero (0) to keep no task detail change in the history table.
Example:
Const constTaskDetailsMaxHistory = 3
Configuration Procedure for Files Hosted on Server Other than the IIS Server
To be able to locate files on a Server different than the IIS Server, a shared folder setup on the file Server is necessary. A UNC path to the shared folder must be used rather than a drive letter mapping because there is no guarantee that the drive letter would be available to the user under which the Aceproject web site would be executed at runtime.
You should therefore create a network domain user specifically for AceProject and assign this user to all applications and application pools used by AceProject. Define a shared folder on the file server and setup Read/Write access on it for the new domain user. Finally, adjust the "PathToFiles" entry in \api\web.config file to make it point to the shared folder using a UNC path syntax, along the following lines…
<add key="PathToFiles" value="\\YourFileServer\files" />
Here is a step-by-step:
- 1. Create a user specifically for AceProject on your network domain.
- 2. Assign the user created in step 1 to the website application pool.
The application pool may be found as illustrated below.
- Please note that if the application pool is different for the AceProject and AceProject-Api websites, changes should be applied on each application pool.
- 3. Assign the user created in step 1 to the AceProject and AceProject-Api websites.