Periodically, you'll want to call \\n Marshal.ReleaseComObject(reportdocument);\\n to get the program to release the memory that it's using for the ReportDocument.\\n Also, you can't really change the Print Job limit for the .NET SDK - it's limited to 100 concurrent print jobs by the runtime license. So, if you're multi-threaded and running multiple reports at the same time, you might run into issues. A "print job" is defined as a main report plus each instance of a subreport within that report. For example, if you have a subreport that only runs in the report header, you have 2 print jobs. However, if you have a subreport that runs in a details section and you have 100 records displayed, you have 101 print jobs, which will fail.\\n -Dell\\n \\n\",\"author\":\"username\":\"dell.stinnett-christy\",\"displayName\":\"Dell Stinnett-Christy\",\"groupIcons\":[\"name\":\"champion\",\"title\":\"This user is an SAP Champion\",\"priority\":14,\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"dell.stinnett-christy\",\"displayName\":\"Dell Stinnett-Christy\",\"groupIcons\":[\"name\":\"champion\",\"title\":\"This user is an SAP Champion\",\"priority\":14,\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20],\"suspended\":false,\"isCurrentUser\":false,\"id\":484509,\"creationDate\":1523974742000,\"activeRevisionId\":699759,\"lastActivity\":1523974742000,\"parentId\":479278,\"originalParentId\":479006,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]},\"487875\":\"rootParentId\":487875,\"commentsCount\":1,\"comments\":[\"body\":\"Hi Don \\nI have upgraded to the latest version of Crystal Reports: 13.0.22.2668. \\nI am still getting a crash after running the service for about 2 hours and 46 minutes. In that time frame, it has genereated about 50,000+ PDF documents. \\nreporting-service-crash.png \\nIs there anything else I can do to fix this? \\nThanks\",\"author\":\"username\":\"sooyoong\",\"displayName\":\"Soo Yoong Ng\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":500838,\"creationDate\":1525148510000,\"activeRevisionId\":718816,\"lastActivity\":1525148510000,\"parentId\":487875,\"originalParentId\":479006,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[\"id\":137253,\"fileName\":\"reporting-service-crash.png\",\"size\":\"33.4 kB\",\"url\":\"/storage/attachments/137253-reporting-service-crash.png\",\"isImage\":true],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"486913\":\"rootParentId\":486913,\"commentsCount\":1,\"comments\":[\"body\":\"I'm using CR for VS version 13.0.9.1312. \\nI've also attached screenshots of the font. It does look like it is a True Type Font, doesn't it? \\nsap-crystal-reports-version.png\",\"author\":\"username\":\"sooyoong\",\"displayName\":\"Soo Yoong Ng\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":487077,\"creationDate\":1524110333000,\"activeRevisionId\":700444,\"lastActivity\":1524110333000,\"parentId\":486913,\"originalParentId\":479006,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[\"id\":129406,\"fileName\":\"sap-crystal-reports-version.png\",\"size\":\"80.8 kB\",\"url\":\"/storage/attachments/129406-sap-crystal-reports-version.png\",\"isImage\":true],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 479006, plug: "application-crashing-when-generating-many-pdfs-usi", votes: 0, questionTitle: "Application crashing when generating many PDFs using Crystal Report and Thai language", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: true , childToViewInfo: id: "" , comments: JSON.parse("\"479278\":\"rootParentId\":479278,\"commentsCount\":2,\"comments\":[\"body\":\"\\n \\n \\n Periodically, you'll want to call \\n Marshal.ReleaseComObject(reportdocument);\\n to get the program to release the memory that it's using for the ReportDocument.\\n Also, you can't really change the Print Job limit for the .NET SDK - it's limited to 100 concurrent print jobs by the runtime license. So, if you're multi-threaded and running multiple reports at the same time, you might run into issues. A "print job" is defined as a main report plus each instance of a subreport within that report. For example, if you have a subreport that only runs in the report header, you have 2 print jobs. However, if you have a subreport that runs in a details section and you have 100 records displayed, you have 101 print jobs, which will fail.\\n -Dell\\n \\n\",\"author\":\"username\":\"dell.stinnett-christy\",\"displayName\":\"Dell Stinnett-Christy\",\"groupIcons\":[\"name\":\"champion\",\"title\":\"This user is an SAP Champion\",\"priority\":14,\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"dell.stinnett-christy\",\"displayName\":\"Dell Stinnett-Christy\",\"groupIcons\":[\"name\":\"champion\",\"title\":\"This user is an SAP Champion\",\"priority\":14,\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20],\"suspended\":false,\"isCurrentUser\":false,\"id\":484509,\"creationDate\":1523974742000,\"activeRevisionId\":699759,\"lastActivity\":1523974742000,\"parentId\":479278,\"originalParentId\":479006,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"487875\":\"rootParentId\":487875,\"commentsCount\":1,\"comments\":[\"body\":\"Hi Don \\nI have upgraded to the latest version of Crystal Reports: 13.0.22.2668. \\nI am still getting a crash after running the service for about 2 hours and 46 minutes. In that time frame, it has genereated about 50,000+ PDF documents. \\nreporting-service-crash.png \\nIs there anything else I can do to fix this? \\nThanks\",\"author\":\"username\":\"sooyoong\",\"displayName\":\"Soo Yoong Ng\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":500838,\"creationDate\":1525148510000,\"activeRevisionId\":718816,\"lastActivity\":1525148510000,\"parentId\":487875,\"originalParentId\":479006,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[\"id\":137253,\"fileName\":\"reporting-service-crash.png\",\"size\":\"33.4 kB\",\"url\":\"/storage/attachments/137253-reporting-service-crash.png\",\"isImage\":true],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"486913\":\"rootParentId\":486913,\"commentsCount\":1,\"comments\":[\"body\":\"I'm using CR for VS version 13.0.9.1312. \\nI've also attached screenshots of the font. It does look like it is a True Type Font, doesn't it? \\nsap-crystal-reports-version.png\",\"author\":\"username\":\"sooyoong\",\"displayName\":\"Soo Yoong Ng\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":487077,\"creationDate\":1524110333000,\"activeRevisionId\":700444,\"lastActivity\":1524110333000,\"parentId\":486913,\"originalParentId\":479006,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[\"id\":129406,\"fileName\":\"sap-crystal-reports-version.png\",\"size\":\"80.8 kB\",\"url\":\"/storage/attachments/129406-sap-crystal-reports-version.png\",\"isImage\":true],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 5, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Altering that registry key will not affect the number of reports it can process sequentially, and best to leave it at the default 75. \\nYou are using a Free version of the CR runtime, it's not capable of processing thousands of reports repeatedly, also called report bursting. To move up to the next version get Crystal Server, you can run up to 4 RAS Servers to process reports. \\nYou can get it from here: \\n -server.html \\nDon\",\"author\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":501891,\"posted\":1525182771000,\"votes\":0,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"First off, I would look at a couple of things that are not related to the language and font.... \\nWhat language is the application written in - Java, VB.NET, or C#.NET? \\nIf it's either of the .NET languages, is the code ever explicitly calling .dispose() on the ReportDocument instance or is the instance in a "using" clause? If not, that could be at least part of your problem. The .NET SDK is built on a foundation of COM objects which .NET does not memory manage very well so things need to be explicitly disposed or the application's memory use will just keep increasing until all of the memory on the computer is used up. \\nA couple of other things that negatively affect memory usage are: \\n1. The use of "TotalPages" or "PageNofM". If these aren't used, Crystal will export each page as it is rendered. If they are used, Crystal has to render ALL of the pages before any of the report can be exported. \\n2. The use of subreports, especially if they're in a details section. \\n-Dell\",\"author\":\"username\":\"dell.stinnett-christy\",\"displayName\":\"Dell Stinnett-Christy\",\"groupIcons\":[\"name\":\"champion\",\"title\":\"This user is an SAP Champion\",\"priority\":14,\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20],\"suspended\":false,\"isCurrentUser\":false,\"id\":479278,\"posted\":1523371374000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\" \\n The application is written in C#.NET. \\n Yes, the code does explicitly call .Dispose() on the ReportDocument instance. The instance is not in a "using" clause. \\n We're using a pool of ReportDocument instances that we re-use while creating the PDFs, is this alright in your view? \\n We have not much of a choice when it comes to sub-reports. We have to use them. Does the advise about reversing the order of setting connection info from this forum still valid? \\n I tried increasing the value of the PrintJobLimit in the registry to a higher value (ex. 999) but that doesn't fix my problem. Is there some sort of registry setting that I can tweak? The registry setting is:[HKEY_LOCAL_MACHINE\\\\SOFTWARE\\\\SAP BusinessObjects\\\\Crystal Reports for .NETFramework 4.0\\\\Report Application Server\\\\Server] \\n\",\"author\":\"username\":\"sooyoong\",\"displayName\":\"Soo Yoong Ng\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":483877,\"posted\":1523829801000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"I changed the Tag to CR for VS and then CR Designer. \\nWhat version of CR for VS are you using? Look in Programs and Feature, version should be something like this: 13.0.22.xxxx \\nYou can get the latest from here: \\n +Reports%2C+Developer+for+Visual+Studio+Downloads \\nWhat may help is moving to SP 22, it uses an updated version of usp10.dll which if there are issues in the previous version it may be fixed. \\nWhen updating you must read the SP 21 info to update your project references etc. \\nSecond problem/question is CR only supports TTF type font, if your font is not that then test with a ttf version of that font. \\nOpen the report in CR Designer and click on View, Preferred Viewing Locale, and then More.... Scroll down and you should see Thai. \\n \\n \\nSet that, then right click on one of the fields and select the True Type Font. \\nNow preview the report multiple times and see it it works consistently. \\nI believe it's the font causing the memory issue, try a different font and see if it still has a memory issue in your app. \\nDon\",\"author\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":486913,\"posted\":1524059361000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[\"id\":129377,\"fileName\":\"thai.png\",\"size\":\"42.2 kB\",\"url\":\"/storage/attachments/129377-thai.png\",\"isImage\":true],\"body\":\"\\n \\n \\n All I can suggest now is upgrade to SP 22 and see if the updated usp10.dll helps the issue\\n \\n\",\"author\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":487875,\"posted\":1524145688000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/479006/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/479006/answers.rss', answersAndComments: '/feed/479006/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Soo Yoong Ng Apr 10, 2018 at 02:33 PM Application crashing when generating many PDFs using Crystal Report and Thai language 711 Views Last edit Apr 18, 2018 at 01:30 PM 4 rev Follow RSS Feed We are generating 145,112 PDFs using Crystal Reports in a multi-threaded loop.
TOP Font Psl Kittithada
2ff7e9595c
Comments