LINKS
General
Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script
Troubleshooting Home
Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script
Troubleshooting Home
MOST RECENT
‘End of Stream encountered before parsing was completed’ error appears during database documenting
I want to install the downloaded VSHIK installer but it requires Visual Studio 2003 that I haven't.
The documentation process starts but then "Hangs"
Error encountered at final documenting stage - chm compilation. Chm documentation can be incomplete.
Content of the CHM file generated by ApexSQL Doc is not shown from the shared drive
I am getting a CHM compilation error saying that access is denied to the resulting file
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs 
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.
|
Troubleshooting Troubleshooting and Known issues with Apex SQL Tools ‘End of Stream encountered before parsing was completed’ error appears during database documenting The ‘End of Stream encountered before parsing was completed’ error occurs when database is being documented RESOLUTION Delete the cache files located at the following path: <ApexSQL Doc installation folder>\Data\<server name>\<database name> The cache files are: cache<version>.dat and cache<version>.idx. LAST REVIEW 20 September 2007 Date of Last Review Labels: ApexSQL Doc ...List of Tables is not being generated in Tables.htm of the generated document as usual and other pages also are corrupted List of Tables is not being generated in Tables.htm of the generated document as usual and other pages also seem to be corrupted CAUSE This issue occurs due to corrupting of ApexSQL Doc templates from Templates subfolder of the product directory for unknown reasons RESOLUTION Please reinstall ApexSQL Doc and try to generate the document again. If this won't resolve the problem please send an email to doc_team@apexsql.com and you will be sent the new templates for replacing of the current ones. LAST REVIEW 24 July 2007 Labels: ApexSQL Doc ...ApexSQL appears to run the SQL exec msdb..sp_help_jobhistory @mode=N'FULL' 3 times towards the end of its processing job. ApexSQL executes the SQL exec msdb..sp_help_jobhistory @mode=N'FULL' 3 times towards the end of its processing job, which can take a couple of minutes per stored procedure and is causing the blocking to occur. RESOLUTION Please turn off Alerts, Jobs and Operators options on Server Details step of the ApexSQL Doc Wizard. LAST REVIEW 24 July 2007 Labels: ApexSQL Doc ..."This program cannot display the webpage" message is shown for generated CHM documents copied to network drive New database document file can be opened from local machine, but "This program cannot display the webpage" message appears after it was copied to the network drive.  RESOLUTION Example 1: Use the UrlAllowList entry to enable specific URLs Warning: Include only URLs for sites that you trust. The .reg file in this example re-enables hosting of the HTML Help ActiveX control in the following remote content: Any .chm files that are in the \\productmanuals\helpfiles folder A Web application that located at http://www.wingtiptoys.com/help. Paste the following text in a text editor such as Notepad. Then, save the file by using the .reg file name extension. REGEDIT4 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp] [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\HHRestrictions] "UrlAllowList"="\\\\productmanuals\\helpfiles;http:// www.wingtiptoys.com/help/" You cannot use wildcard characters in the URL string of any site that is added to the UrlAllowList registry key. For example, you cannot use the following URL string: "UrlAllowList"="http://*.wingtiptoys.com" However, you can use the following URL string: "UrlAllowList"="http://help.wingtiptoys.com" This string lets the following sites host the HTML Help ActiveX control: http://help.wingtiptoys.com/research http://help.wingtiptoys.com/sales Example 2: Paste the following text in a text editor such as Notepad. Then, save the file by using the .reg file name extension. REGEDIT4 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp] [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\HHRestrictions] "MaxAllowedZone"=dword:00000003 "UrlAllowList"="" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions] "MaxAllowedZone"=dword:00000003 "UrlAllowList"="" SEE ALSO Detailed information located here: http://support.microsoft.com/kb/892675/ LAST REVIEW 24 July 2007 Labels: ApexSQL Doc ...After compiling the help file the right side of the help shows:"This program cannot display the webpage" "This program cannot display the webpage" is shown on the right pane of the generated CHM document CAUSE This is a windows "security" feature. RESOLUTION You will have to right click on the .chm, click Properties and click Unlock option. This will unblock the help file and will display it as usual. LAST REVIEW 24 July 2007 Labels: ApexSQL Doc ...I want to install the downloaded VSHIK installer but it requires Visual Studio 2003 that I haven't. How to install VSHIK on computer without Visual Studio 2003 installed? RESOLUTION Please follow the instructions for unblocking VSHIK installer. LAST REVIEW 24 July 2007 Labels: ApexSQL Doc ...The documentation process starts but then "Hangs" The documentation process may hang during database objects parsing and documenting. CAUSE Most likely the documentation process is still running, vs hanging or not responding. Documentation can be a lengthy process for large databases. RESOLUTION In such a case, it is recommended that you:
LAST REVIEW 23 July 2007 Labels: ApexSQL Doc ...Error encountered at final documenting stage - chm compilation. Chm documentation can be incomplete. Error encountered at final documenting stage - chm compilation. RESOLUTION Try to run the following from the command line: axDoc_Path\hhc.exe "C:\Program Files\ApexSQL\ApexSQLDoc\Intermediary\Temp####\apexdoc.hhp" and have a look what happens in a console output it might be created log file hhc.log. Example: "C:\Program Files\ApexSQL\ApexSQLDoc\hhc.exe" "C:\Program Files\ApexSQL\ApexSQLDoc\Intermediary\Temp####\apexdoc.hhp" At this step the documentation must be created in the html format in the C:\Program Files\ApexSQL\ApexSQLDoc\Intermediary\Temp#### folder. LAST REVIEW 23 July 2007 Labels: ApexSQL Doc ...Content of the CHM file generated by ApexSQL Doc is not shown from the shared drive Content of the CHM file generated by ApexSQL Doc is not shown from the shared drive. CAUSE This is due to a security patch put in place on most or all Windows operating systems as of May of 2005 and is not a limitation of ApexSQL Doc or its output. A security update released at that time limited a machine's ability to view Active Content (which includes all .chm page content) on a networked or shared drive by default. RESOLUTION This setting replicates common restrictions placed in viewing Active Content over the Web for local networks, and must be overridden on each individual client machine that wishes to view the file's page content. This can be accomplished by applying the following registry setting to the individual machine (this code can be cut and pasted into a .reg file, then applied to the registry by double-clicking the file): REGEDIT4 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp] [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions] "MaxAllowedZone"=dword:00000004 Please note that by opening up a machine to view Active Content on remote machines, there is an inherent security risk associated, since .chm files have been used with some frequency to distribute Trojans or other malware, so a degree of awareness and caution should be exercised. There is nothing that can be done to the file or hosting driver/server itself to work around this issue the viewing machine's security settings must be altered. LAST REVIEW 23 July 2007 Labels: ApexSQL Doc ...It seems that when an error occurs, the ApexSQL programs overwrite Windows clipboard contents. Is this the case? Windows clipboard is overriden when ApexSQL products throw an exception dialog in response to a problem, they also automatically copy the ticket's contents to the clipboard. Hence, any data previously present in the clipboard is overwritten. This is default behaviour which helps us to help you locating and solving the root cause for the exception error. LAST REVIEW 23 July 2007 Labels: ApexSQL Doc ...I am getting a CHM compilation error saying that access is denied to the resulting file Getting a CHM compilation error saying that access is denied to the resulting file. CAUSE Typically this error occurs when you have opened an instance of the output help file. RESOLUTION Close this opened instance and try to compile again. LAST REVIEW 23 July 2007 Labels: ApexSQL Doc ...System.IO.FileNotFoundException exceptions under Vista There appears to be a permission issue under Vista with the Intermediate folder. This folder located in the ApexSQL Doc installation folder and contains temporary information which is collected here during documenting process. To solve it you need to give full control for EVERYONE group to Intermediate folder and read/execute/list on the Template folder, which is located in the ApexSQL Doc installation folder and contains templates which are applied on the generated document. Labels: ApexSQL Doc ...Welcome to the ApexSQL Troubleshooting and Known Issues Welcome to the ApexSQL Troubleshooting and Known Issues. This is an online resource to help you find solutions to known issues with Apex SQL tools. Labels: ApexSQL Audit, ApexSQL Clean, ApexSQL Code, ApexSQL Diff, ApexSQL Diff (Data), ApexSQL Doc, ApexSQL Edit, ApexSQL Enforce, ApexSQL Law, ApexSQL Log, ApexSQL Script, General ... |
© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy