Adobe GoLive (ASP) Troubleshooting Report

This report contains information about the status of your ASP server software and the Adobe GoLive files installed on the server. Below you will find the results of various tests performed by this troubleshooting script.

Please refer to the GoLive User Guide and 'readme' file for more information about installing and configuring your ASP server to work with Adobe GoLive.

Click here for some additional troubleshooting tools. These tools scan your entire site for dynamic content specific errors in pages.

Click here to run test queries directly to databases.


Test Summary

18 tests performed.

TestDescriptionResultsSummary
1Check ASP softwarePassedASP software is present.
2Check Web server versionPassedASP enabled web server "Microsoft-IIS/6.0" was found.
3Check script engine versionPassedBoth server script versions are 5.0 or later.
4Check MSXML versionPassedRequired MSXML version is installed.
5Check XML DOM supportPassedXML DOM is supported on this server.
6Check virtual path settingVerifyYou should verify that your virtual path settings are correct.
7Check session state settingVerifyReload this page once. If this test still does not pass, ASP Session State is disabled. Database Update and CustomMerchant pages require it to be enabled.
8Check password setting of web serverPassedAccess is anonymous, requiring no password security.
9Check server config filesPassedAll server configuration files are present.
10Check config file's line endingsPassedThe file was uploaded correctly.
11Check config/include/friends.asp filePassedServer configuration is done.
12Check config/include folder write permissionFailedFile writing test failed.
13Check XML filesPassedAll XML files appear to be fine.
14Check database datasource filesFailedProblem(s) were found with one or more datasource file(s), or OpenSchema() is not supported.
15Check CustomMerchant datasource filesVerifyNo CustomMerchant datasource (*.ecp) files found in datasources folder.
16Check XML datasource filesVerifyNo XML datasource file (*.xds) found in datasources folder.
17Check server variablesPassedASP server variables.
18Check other issuesVerifyCheck these issues manually.

How to read the test results

Passed: The test was successful, no further action required.
Failed: Problem(s) were found. Refer to the test report details for more information.
Verify: This may or may not be a problem depending on your environment, your should manually verify this information. Read the report details for instructions.

Test 1: Check ASP software

Passed: ASP software is present.

Description: This test checks to see whether your web server is enabled for Active Server Pages. Note that IIS 2.0 requires an additional ASP pack. IIS 3 or later includes ASP support by default. The IIS configuration (Site Management Console or other application) should have "Script Enabled" for the web site folder.

Back to Top


Test 2: Check Web server version

Passed: ASP enabled web server "Microsoft-IIS/6.0" was found.

Description: This test checks to make sure your Microsoft IIS software version is 4.0 or later.

Server variableValue
SERVER_SOFTWAREMicrosoft-IIS/6.0

Back to Top


Test 3: Check script engine version

Passed: Both server script versions are 5.0 or later.

Description: This test checks to make sure your server script engine versions are 5.0 or later. The script versions are depend on installed IIS or IE on the server. If you install IIS 4.0, then you have version 3.0 script engine. After that, if you install IE 5.0, then you will have version 5.0 script engine. Windows 2000 comes with IIS 5, which has version 5.1 script engine.

Script languageVersion
JScript5.6.8831
VBScript5.6.8827

Back to Top


Test 4: Check MSXML version

Passed: Required MSXML version is installed.

Description: This test checks to make sure your server MSXML versions are 3.0 or later. You can get updater from Microsoft website (http://www.microsoft.com/xml/).

VersionCheck
MSXML2Installed
MSXML2 ver 2.6
MSXML2 ver 3.0Installed
MSXML2 ver 4.0Installed

Back to Top


Test 5: Check XML DOM support

Passed: XML DOM is supported on this server.

Description: This test checks to make sure your server support XML DOM.If it is not supported, XML source contents feature and some troubleshooting test won't work.In case of then, you can update IIS with installing IE 5 or later.

Creating XML DOM on this server was successful..

Back to Top


Test 6: Check virtual path setting

Verify: You should verify that your virtual path settings are correct.

Description: This test checks that the virtual path to your web site folder for your URL points to the correct place. APPL_PHYSICAL_PATH is your virtual root setting. PATH_TRANSLATED is the physical path setting for this page. PATH_INFO, SCRIPT_NAME & URL contains the URL to this page without the hostname.

Server variableValue
APPL_PHYSICAL_PATH g:\activewebroot\Active24\w11182390\web\content\
PATH_INFO /config/info/troubleshooting.asp
PATH_TRANSLATED g:\activewebroot\Active24\w11182390\web\content\config\info\troubleshooting.asp
SCRIPT_NAME /config/info/troubleshooting.asp
URL /config/info/troubleshooting.asp

Back to Top


Test 7: Check session state setting

Verify: Reload this page once. If this test still does not pass, ASP Session State is disabled. Database Update and CustomMerchant pages require it to be enabled.

Description: This test checks the virtual root's session state. CustomMerchant requires this setting to be enabled. This setting can be set in Internet Service Manager or GLOBAL.ASA. But if you don't want to enable the option (default is enabled) for the whole site or virtual folder, you can set it on each required page by using the <%@ ENABLESESSIONSTATE=True|False%> setting.

Server variableValue
HTTP_COOKIEundefined

Back to Top


Test 8: Check password setting of web server

Passed: Access is anonymous, requiring no password security.

Description: This test checks whether the web server is set to require user names and passwords. If so, only basic authentication is supported by GoLive. If any of the following server variables have a value, there is a password required to access the server. In case of basic authentication, server variable HTTP_AUTHORIZATION's value will start "Basic ". Other http authentication methods are not supported.

Server variableValue
AUTH_USER
REMOTE_USER
LOGON_USER
HTTP_AUTHORIZATION undefined

Back to Top


Test 9: Check server config files

Passed: All server configuration files are present.

Description: This test checks to see whether the ASP and XML files for GoLive have been properly installed on the server. It also produces a directory tree list of all files in the config folder. The following files are required.

Config Path = [G:\activewebroot\Active24\w11182390\web\content\config]

FileExistNote
actions/ado.actions6.aspFound for updating
actions/glerror.aspFound error page for failed actions
actions/custommerchant.actions6.aspFound for CustomMerchant
include/ado.runtime6.aspFound required
include/friends.aspFound required
include/custommerchant.runtime6.aspFound required
include/utils.runtime6.aspFound required
include/xml.runtime6.aspFound required
info/ADODataSourceEditor/Main.htmlFound for ASP authoring
info/CMDataSourceEditor/Main.htmlFound for CustomMerchant authoring
info/XMLDataSourceEditor/Main.htmlFound for XML authoring
info/ado.info6.aspFound for ASP authoring
info/ado.ui6.xmlFound for ASP authoring
info/general.ui6.xmlFound for authoring
info/custommerchant.cart.info6.aspFound for CustomMerchant
info/custommerchant.order.info6.aspFound for CustomMerchant
info/custommerchant.ui6.xmlFound for CustomMerchant
info/custommerchant.xform.info6.xslFound for CustomMerchant
info/parseasp.aspFound for ASP authoring
info/reservedwords.ui6.xmlFound for ASP authoring
info/test.aspFound for ASP authoring
info/test.htmlFound for ASP authoring
info/testsql.aspFound for ASP authoring
info/troubleshooting.aspFound this page
info/ui6.aspFound for ASP authoring
info/vbscript.ui6.xmlFound for ASP authoring
info/xml.info6.aspFound for XML authoring
info/xml.ui6.xmlFound for XML authoring

Config files:

    Temp$$$11395326.asp
+---actions
|       ado.actions6.asp
|       custommerchant.actions6.asp
|       glerror.asp
+---datasources
|       inc.mdb
|       README_asp.txt
|       UdlConnectionTest.udl
+---include
|       ado.runtime6.asp
|       blockview.runtime6.asp
|       custommerchant.runtime6.asp
|       extrafilters.runtime6.asp
|       friends.asp
|       utils.runtime6.asp
|       xml.runtime6.asp
+---info
|       ado.info6.asp
|       ado.ui6.xml
|       blockview.info6.asp
|       blockview.ui6.xml
|       custommerchant.cart.info6.asp
|       custommerchant.jxform.info6.xsl
|       custommerchant.order.info6.asp
|       custommerchant.ui6.xml
|       custommerchant.xform.info6.xsl
|       extrafilters.ui6.xml
|       general.ui6.xml
|       gl.css
|       parseasp.asp
|       reservedwords.ui6.xml
|       test.asp
|       test.html
|       testsql.asp
|       troubleshooting.asp
|       troubleshooting2.asp
|       troubleshootinginclude.asp
|       ui6.asp
|       vbscript.ui6.xml
|       xml.info6.asp
|       xml.ui6.xml
+---+---ADODataSourceEditor
|   |       Main.html
+---+---CMDataSourceEditor
|   |       Main.html
+---+---XMLDataSourceEditor
|   |       check.gif
|   |       Main.html
|   |       rowset.gif
|   |       structure.gif
|   |       x.gif

Back to Top


Test 10: Check config file's line endings

Passed: The file was uploaded correctly.

Description: This test checks whether the GoLive text files have proper line endings. If you upload the config files or other ASP files from a Macintosh using binary upload, ASP may not work properly. You must upload ASP files as text. Also if the file's line ending is not set to Windows, ASP pages may not work. This is set in GoLive under Edit>Web Settings, Global tab, select Windows (CR/LF) from the popup menu.

Checking file = [G:\activewebroot\Active24\w11182390\web\content\config/include/friends.asp]

53 line(s)

Back to Top


Test 11: Check config/include/friends.asp file

Passed: Server configuration is done.

Description: This test checks the friends.asp file, which is used to provide IP based security. By default, access to the GoLive Dynamic Content authoring features is only allowed from the machine on which the server is running ('localhost'). To allow access from machines you need must edit the config/include/friends.asp file to include the IP address of that machine or use the Dynamic Content setup wizard from the Site>Settings>Dynamic Content dialog.

Checking file = [G:\activewebroot\Active24\w11182390\web\content\config/include/friends.asp]

IP addressMaskNote
62.59.38.242255.255.255.255 Other settings
e>.undefined.undefined.undefined255.255.255.255 Other settings

Back to Top


Test 12: Check config/include folder write permission

Failed: File writing test failed.

Description: This test checks the write permission of config/include folder, which is used by GoLive's Preview function. To preview a dynamic page, GoLive uploads a temporary file to config/include folder so that the web server can process it. If the folder does not have write permission, the preview will not work. Note that you may want to disable write permission on your production servers. In that case, you will not be able to use the GoLive preview with the public server as your site URL. Other features will not be effected.

If error 'ASP 0177 : 800a0046' is returned when previewing a page in GoLive, the folder does not have write permission set.

Test file = [writingtest.txt]

File operation failed to create, write, close, or delete.

Back to Top


Test 13: Check XML files

Passed: All XML files appear to be fine.

Description: This test performs a basic syntax check on the XML files in config/info folder.

XML FilePackage VersionCheck
ado.ui6.xml6 OK
blockview.ui6.xml6 OK
custommerchant.ui6.xml6 OK
extrafilters.ui6.xml6 OK
general.ui6.xml6 OK
reservedwords.ui6.xml6 OK
vbscript.ui6.xml6 OK
xml.ui6.xml6 OK

Back to Top


Test 14: Check database datasource files

Failed: Problem(s) were found with one or more datasource file(s), or OpenSchema() is not supported.

Description: This test examines all the database datasource files found in the datasources folder and produces detailed information about each one. MS-Access (*.mdb) files should not be read-only. If they are read-only any update or other datasource modification action will fail. If MDB files failed to open a connection, the server may have old MDAC version. MDAC 1.5 is installed by default with IIS 4.0, but GoLive requires MDAC 2.1 or later. You can get updater from Microsoft website (http://www.microsoft.com/data/). If UDL, DSN or XDB files failed to open a connection, these files have incorrect settings or the datasource is unavailable. If OpenSchema fails and the other tests are OK, the local server's ASP engine may not support the OpenSchema() call. In this case, the server will not work as a development server with GoLive.

FileAttributes / PermissionConnectionOpenSchemaTables/Fields
inc.mdb Archive
ASP has write permission.
MDB
Success
Success
Companies
Address1
Address2
Address3
Business Phone Warning: Name should not contain spaces!
City
Company_ID (primary key)
CompanyName
Contact_Person
Country_ID
Email
Fax
Mobile Phone Warning: Name should not contain spaces!
MoreInfo
ParentCompanyID
Postcode
Published
StateID
WebAddress
CompaniesServices
CompanyID (primary key)
CountryID (primary key)
ServiceID (primary key)
Countries
CountryCode
CountryID (primary key)
CountryName
Sector
SectorID (primary key)
SectorName
Services
SectorID
ServiceID (primary key)
ServiceName
States
CountryID
StateID (primary key)
StateName
README_asp.txt Archive
unsupported
UdlConnectionTest.udl Archive
ASP has read permission.
UDL
File Name=G:\activewebroot\Active24\w11182390\web\content\config\datasources\UdlConnectionTest.udl
Failed
ADO.Error 1 error(s)
error[0]Number-2147467259
error[0]SourceMicrosoft OLE DB Provider for ODBC Drivers
error[0]Description[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
error[0]HelpFile
error[0]HelpContext0
error[0]SQLStateIM002
error[0]NativeError0

Back to Top


Test 15: Check CustomMerchant datasource files

Verify: No CustomMerchant datasource (*.ecp) files found in datasources folder.

Description: This test examines CustomMerchant datasource files (*.ecp) found in the datasources folder and produces detailed information about each one.

FileAttributesSetting
inc.mdbArchive
Database datasource file.
README_asp.txtArchive
UdlConnectionTest.udlArchive
Database datasource file.

Back to Top


Test 16: Check XML datasource files

Verify: No XML datasource file (*.xds) found in datasources folder.

Description: This test examines XML datasource files (*.xds) found in the datasources folder and produces detailed information about each one.

FileAttributesSetting
inc.mdbArchive
Database datasource file.
README_asp.txtArchive
UdlConnectionTest.udlArchive
Database datasource file.

Back to Top


Test 17: Check server variables

Passed: ASP server variables.

Description: This test generates a table of server variables so that you can review and verify their status.

VariableValues
ALL_HTTP HTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:close HTTP_PRAGMA:no-cache HTTP_ACCEPT:Accept: application/xhtml+xml,text/html;q=0.9,text/plain; HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_ENCODING:gzip HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5 HTTP_HOST:www.incountrysolutions.com HTTP_USER_AGENT:CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
ALL_RAW Cache-Control: no-cache Connection: close Pragma: no-cache Accept: Accept: application/xhtml+xml,text/html;q=0.9,text/plain; Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Encoding: gzip Accept-Language: en-us,en;q=0.5 Host: www.incountrysolutions.com User-Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
APPL_MD_PATH /LM/W3SVC/11182390/Root
APPL_PHYSICAL_PATH g:\activewebroot\Active24\w11182390\web\content\
AUTH_PASSWORD
AUTH_TYPE
AUTH_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH 0
CONTENT_TYPE
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID 11182390
INSTANCE_META_PATH /LM/W3SVC/11182390
LOCAL_ADDR 213.188.134.205
LOGON_USER
PATH_INFO /config/info/troubleshooting.asp
PATH_TRANSLATED g:\activewebroot\Active24\w11182390\web\content\config\info\troubleshooting.asp
QUERY_STRING
REMOTE_ADDR 38.103.63.61
REMOTE_HOST 38.103.63.61
REMOTE_USER
REQUEST_METHOD GET
SCRIPT_NAME /config/info/troubleshooting.asp
SERVER_NAME www.incountrysolutions.com
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/6.0
URL /config/info/troubleshooting.asp
HTTP_CACHE_CONTROL no-cache
HTTP_CONNECTION close
HTTP_PRAGMA no-cache
HTTP_ACCEPT Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_HOST www.incountrysolutions.com
HTTP_USER_AGENT CCBot/1.0 (+http://www.commoncrawl.org/bot.html)

Back to Top


Test 18: Check other issues

Verify: Check these issues manually.

Description: If you are still having problems, here's a listing of known issues you can check manually. Some problems may be dependent on web server versions, datasource server, datasource driver.

MDAC (Microsoft Data Access) version

Symptom: MDAC version 1.5 will fail to connect with Access 2000 datasources. (MDAC 1.5 is part of the Option Pack for IIS, and is not updated by Windows NT service packs.)

Prescription: MDAC 2.1 or later is required for GoLive. MDAC is installed in [system drive]:\Program Files\Common Files\System\ado\ folder. If you have the file ADO210.CHM, the server has MDAC 2.1 installed.

Windows 2000 installs MDAC version 2.5, which is compatible with GoLive.

To update MDAC, go to Microsoft web site http://www.microsoft.com/data/ or do a search for "MDAC".

Microsoft also offers an MDAC version checker, called "Component Checker".

Primary Key Field

Symptom: When the runtime debug switch is on (you can set the RuntimeDebug flag in config/inlude/utils.runtime6.asp), you may receive an error message "Runtime Error: No primary key is specified" when you preview an ASP document.You may also experience significant performance degradation without a primary key.

Prescription: This may be caused by using an ODBC driver, which does not support automatic detection of primary keys. This may cause incorrect results or behavior when displaying multiple records in a table, or when updating or deleting records using a form.

You can manually specify the primary key field by editing the ADORecordSet() function call in the document's <head> section. For example, change:

set Photos = ADORecordSet("album" , "select * from Photos", "block=0", "", "Photos")
to:
set Photos = ADORecordSet("album" , "select * from Photos", "block=0", "ID", "Photos")
or, if more than one field comprises the primary key, enter each separated by commas:
set Photos = ADORecordSet("album" , "select * from Photos", "block=0", "ID,SKU", "Photos")
If you are using the OLE DB driver for your datasource (which is recommended), you do not have to edit this function call: GoLive will automatically add the correct primary key field(s).
POST versus GET

Symptom: You get unexpected results or errors when you update records or link to detail pages.

Prescription: If you have a form in an ASP document, you should use POST rather than GET to avoid problems with the limits inherent to the GET method. GoLive should automatically set the form method to POST. Check in the inspector palette with the form selected.

HTML Tags in DataSources Records

Symptom: <TEXTAREA> tag breaks layout

Prescription: If records in your datasource include strings that might be interpreted as HTML tags (for example, "</textarea>") HTML rendering may fail. To avoid this problem, set the field's filter to "Encode String as HTML" in the Binding Details section of the Dynamic Content palette.

ODBC driver from Oracle or Microsoft

Symptom: Dynamic page with Oracle datasource shows unexpected data.

Prescription: If you need to use an ODBC driver with Oracle (OLE DB is preferred, for reasons described earlier), you should use the Microsoft ODBC driver (named "Microsoft ODBC for Oracle") rather than the Oracle ODBC driver ("Oracle ODBC Driver").

FileMaker Pro 5 for ODBC

Symptom:
* Table and field names do not appear in the Dynamic Content palette.
* Previewing or running ASP pages results in runtime errors.

Prescription: To configure FileMaker Pro 5 for use with GoLive, make sure that:
* FileMaker Pro 5 is running with your datasource open,
* the datasource is set as shared,
* the "Remote Data Access Companion" option (File > Sharing > Remote Data Access Companion) is enabled,
* the "Use Remote Connection" option in the ODBC data source control panel is enabled,
* the "Server Address" field of the ODBC control panel contains the IP address of the machine running FileMaker Pro.

Virtual root setting.

Symptom:
* Browser shows 404 error.
* Updating record goes to the wrong URL.

Prescription: You should use the same path name on both your staging server and production server. For example, if you develop ASP pages on your computer using a content source of http://localhost/golive_vbs/, your production server virtual root path should be /golive_vbs/ also.The host name may be (and generally, will be) different; this will not affect your ASP documents.

config/info folder

Symptom: Potential security hole

Prescription: The files in the "info" folder (config/info/*.*) are used by GoLive to create ASP documents, but are not needed when you deploy your finished pages. You should not install the config/info files on your production server because of the potential for security problems.

You may wish to install these files temporarily to verify your production server's environment using this troubleshooting.asp document, but should remove them after completing the tests. Check the GoLive User Guide for more information on site security.

config/datasources folder

Symptom: Potential security hole

Prescription: The config/datasources folder contains datasource files, or UDL files contains datasource information, possibly including ID/password information.

To prevent unauthorized access to your datasource files, you should disallow "Read", "Write" and "Directory browsing" permissions under IIS to the config/datasources folder.

For increased security, you can move the config/datasources folder out of the virtual root. In this case, you will need to edit GetDataSourcePath() function in config/include/utils.runtime6.asp file.

FTP file setting

Symptom: Possible GoLive misconfiguration

Prescription: ASP files need to be transferred using FTP/WebDAV as text files. If it is not set properly, it will likely cause server error messages.Check GoLive Edit->Web Settings->File Mappings for ASP file setting.

Back to Top