Question

Error While Running Report Definition

Getting below error while running report definition. Please Help!! This issue is happening in Staging environment and working fine in dev

i'm referring a property in the Blob and which is a page group. The same is working for different property but it doesn't work for one property alone which is a decimal.

.pagegroup(A).page.property

Error:

** An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: XX000 Message: ERROR: ReferenceError: value is not defined Where: undefined() LINE 0: (function() { StreamReader=function(){function t(t){this.cachedStream=t,this.createTime=(new Date).getTime()}t.prototype.getCreateTime=function(){return this.createTime},t.prototype.getCachedStream=function(){return this.cachedStream};var e=function(e,n,i){if(!i)return null;var o;if(n){StreamReader.oStreamCache||(StreamReader.oStreamCache=new LRUCache(10));var s=StreamReader.oStreamCache.get(n,!1);s&&(new Date).getTime()-s.getCreateTime()<500?(plv8.elog(DEBUG1,"Using existing stream object::"+n),o=s.getCachedStream()):(plv8.elog(DEBUG1,"Creating a new one::"+n),o=r(i),StreamReader.oStreamCache.put(n,new t(o)))}else o=r(i);return null!==o?o.getFromTopLevelPage(e):null},r=function(t){I(t);for(var e=new Array(t.length-8),r=0;r<t.length-8;r++)e[r]=t[r+8];var n=new pako.Inflate;if(n.push(e,!0),n.err)throw new Error("Error inflating stream::"+n.msg);var i=n.result;return E(i,0,l,0,4)?(plv8.elog(DEBUG1,"Directstream version 7 detected."),DirectStreamV7.newInstance(i)):E(i,0,O,0,4)?(plv8.elog(DEBUG1,"Directstream version 6 detected."),DirectStreamV6.newInstance(i)):null},n=function(t,r,n){var i=e(t,r,n);if(!i||0===i.length)return null;if(f(i))return parseInt(i,10);throw new Error("Invalid integer value: "+value)},i=function(t,r,n){var i=e(t,r,n);if(!i||0===i.length)return null;if(S(i))return parseFloat(i);throw new Error("Invalid decimal value: "+value)},o=function(t,r,n){return e(t,null,n)},s=function(t,e,r){return n(t,null,r)},a=function(t,e,r){return i(t,null,r)},E=function(t,e,r,n,i){for(var o=0;i>o;o++)if(t[e+o]!==r[n+o])return!1;return!0},I=function(t){if(!E(t,0,c,0,4))throw E(t,0,u,0,4)?new Error("Detected InflaterV6. UDF only supports version 7 inflation."):E(t,0,g,0,4)?new Error("BLOB encrypted. UDF cannot read from encrypted BLOBs"):new Error("The contents of the storage stream are corrupt: encountered signature "+t[0]+" "+t[1]+" "+t[2]+" "+t[3])},S=function(t){return t-parseFloat(t)+1>=0},f=function(t){return S(t)&&Math.floor(t)==t},c=[90,108,66,55],u=[90,108,66,54],O=[80,82,54,100],l=[80,82,55,100],g=[123,69,78,125];return{get:e,getInt:n,getDecimal:i,getNoCache:o,getIntNoCache:s,getDecimalNoCache:a}}();}) DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: ReferenceError: value is not defined Where: undefined() LINE 0: (function() { StreamReader=function(){function t(t){this.cachedStream=t,this.createTime=(new Date).getTime()}t.prototype.getCreateTime=function(){return this.createTime},t.prototype.getCachedStream=function(){return this.cachedStream};var e=function(e,n,i){if(!i)return null;var o;if(n){StreamReader.oStreamCache||(StreamReader.oStreamCache=new LRUCache(10));var s=StreamReader.oStreamCache.get(n,!1);s&&(new Date).getTime()-s.getCreateTime()<500?(plv8.elog(DEBUG1,"Using existing stream object::"+n),o=s.getCachedStream()):(plv8.elog(DEBUG1,"Creating a new one::"+n),o=r(i),StreamReader.oStreamCache.put(n,new t(o)))}else o=r(i);return null!==o?o.getFromTopLevelPage(e):null},r=function(t){I(t);for(var e=new Array(t.length-8),r=0;r<t.length-8;r++)e[r]=t[r+8];var n=new pako.Inflate;if(n.push(e,!0),n.err)throw new Error("Error inflating stream::"+n.msg);var i=n.result;return E(i,0,l,0,4)?(plv8.elog(DEBUG1,"Directstream version 7 detected."),DirectStreamV7.newInstance(i)):E(i,0,O,0,4)?(plv8.elog(DEBUG1,"Directstream version 6 detected."),DirectStreamV6.newInstance(i)):null},n=function(t,r,n){var i=e(t,r,n);if(!i||0===i.length)return null;if(f(i))return parseInt(i,10);throw new Error("Invalid integer value: "+value)},i=function(t,r,n){var i=e(t,r,n);if(!i||0===i.length)return null;if(S(i))return parseFloat(i);throw new Error("Invalid decimal value: "+value)},o=function(t,r,n){return e(t,null,n)},s=function(t,e,r){return n(t,null,r)},a=function(t,e,r){return i(t,null,r)},E=function(t,e,r,n,i){for(var o=0;i>o;o++)if(t[e+o]!==r[n+o])return!1;return!0},I=function(t){if(!E(t,0,c,0,4))throw E(t,0,u,0,4)?new Error("Detected InflaterV6. UDF only supports version 7 inflation."):E(t,0,g,0,4)?new Error("BLOB encrypted. UDF cannot read from encrypted BLOBs"):new Error("The contents of the storage stream are corrupt: encountered signature "+t[0]+" "+t[1]+" "+t[2]+" "+t[3])},S=function(t){return t-parseFloat(t)+1>=0},f=function(t){return S(t)&&Math.floor(t)==t},c=[90,108,66,55],u=[90,108,66,54],O=[80,82,54,100],l=[80,82,55,100],g=[123,69,78,125];return{get:e,getInt:n,getDecimal:i,getNoCache:o,getIntNoCache:s,getDecimalNoCache:a}}();}) | SQL Code: 0 | SQL State: XX000

Correct Answer
August 16, 2019 - 12:47am

There is a specific issue with a single case which has caused this issue. we are no longer seeing this issue after correcting the case

Comments

Keep up to date on this post and subscribe to comments

July 31, 2019 - 2:59am

Hello,

Can you add a screen shot of your report definition? Reporting on BLOB properties isn't recommended could you create an index instead maybe.

August 1, 2019 - 9:00pm

Hi

Can you attach the screenshots of RD configuration.

But another thing is you should be using an unexposed property in the RD. You must change this.

Regards

Bhavya

August 2, 2019 - 5:08pm

Is it possible to expose that page group using a declare index instead, to properly retrieve the required data from embedded page group, which will not only improve the performance of the Report def, but also avoid this issue?

August 16, 2019 - 12:47am

There is a specific issue with a single case which has caused this issue. we are no longer seeing this issue after correcting the case