Assertion failure outputting in CHM format

Category: Troubleshooting & error messages
Date: 03 Dec 2008
Product: SQL Doc
Versions: 1.x, 2.0

When creating database documentation in Compiled HTML Help (CHM) format, the following error may occur:
Assertion failure: (pszTmp == m_pCompiler->m_pHtmlMem->psz).

There appears to be a limitation on the index size acceptable by Microsoft HTML Help Studio, which SQL Doc uses to create the CHM file. Once the index grows past 3300 entries, HTML Help Studio crashes with this error. Since this software has been supplied by Microsoft, it is impossible for us to resolve the issue.

One possible workaround is to include fewer databases or fewer database objects in the database documentation desired from SQL Doc.

The other possibility is to manually trim the index. SQL Doc should leave all of the CHM source files in the same folder that you have chosen as the output location, in a subfolder whose name contains "_src_".
Open the SQLDoc.hhk file and trim it by removing all text between <LI><OBJECT> and </OBJECT> for each node that you want to exclude from the index.

After you have trimmed the index, you may attempt to compile the project manually using Microsoft HTML Workshop.

Document ID: KB200804000244 Keywords: SQL,Doc,assertion,failure

Was this article helpful?

Search support