{"id":7317,"date":"2014-06-07T02:24:44","date_gmt":"2014-06-07T02:24:44","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/reporting-services-2008r2-throws-native-compiler-error-bc30494-line-is-too-long-collection-of-common-programming-errors\/"},"modified":"2014-06-07T02:24:44","modified_gmt":"2014-06-07T02:24:44","slug":"reporting-services-2008r2-throws-native-compiler-error-bc30494-line-is-too-long-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/reporting-services-2008r2-throws-native-compiler-error-bc30494-line-is-too-long-collection-of-common-programming-errors\/","title":{"rendered":"Reporting Services 2008R2 throws &ldquo;native compiler error [BC30494] Line is too long.&rdquo;-Collection of common programming errors"},"content":{"rendered":"<pre><code>An unexpected error occurred while compiling expressions. Native compiler return value: '[BC30494] Line is too long.'.\n<\/code><\/pre>\n<p>When RS throws this error, the typical scenario appears to be that there are too many text boxes on a specific data region; and the only known measure seems to be to &#8216;minify&#8217; text box names (ie. rename TextBox345 to T345).<\/p>\n<p>My report is not <em>that<\/em> large (2500 Lookup() calls).<\/p>\n<p>So my guess is that the VB code-behind that gets generated for the Lookup() function is quite verbose and therefore breaks the 64K limit for a generated VB code block per data region.<\/p>\n<ol>\n<li>\n<p>Can I test my hypothesis? Ie. is there a way I can inspect the generated VB code?<\/p>\n<\/li>\n<li>\n<p>Any suggestions as to how to fix\/dodge this problem? <em>Needless to say that using abbreviated names in my case didn&#8217;t cut it.<\/em><\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>An unexpected error occurred while compiling expressions. Native compiler return value: &#8216;[BC30494] Line is too long.&#8217;. When RS throws this error, the typical scenario appears to be that there are too many text boxes on a specific data region; and the only known measure seems to be to &#8216;minify&#8217; text box names (ie. rename TextBox345 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7317","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=7317"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7317\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=7317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=7317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=7317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}