I love the new format mechanism for controlling presentation both in the browser and in Excel files! I'm using v9.1p_2014-05-23, but I have a problem. For some of my larger tables, the export takes a while (which is ok). However, after almost exactly 30 seconds (I timed it with a stopwatch) it emits this error in the console:
I get no file, and the browser tab turns white (Google Chrome 35.0.1916.114). I timed this error at in Safari at about 105 seconds (not as exact). Here's the command that was executing:
and the ListGrid was exporting about 1700 rows x (10 float columns + 1 summary column + 2 string columns). If I filter that data down to 800 rows, the procedure completes in about 15 seconds. Anyway... there appears to be come kind of browser specified timeout on long running JavaScript on the client. Do you have a way around this?
If I turn off formatting, the procedure takes 15 seconds, but if I set exportRawValues:true for the fields, Chrome still times out at 30 seconds.
This ListGrid is created from a clientOnly:true DataSource. I tried monitoring with showConsole, but then my machine just ran and ran w/o no failure or success.
I made a standalone test for this, but it includes data, so it's too large for your attachment manager to accept it.
I pasted the server output for the relevant interval below.
Code:
Uncaught TypeError: Cannot read property 'RPCManager' of undefined IDACall?isc_rpc=1&isc_v=v9.1p_2014-05-23&isc_tnum=2:1 (anonymous function) IDACall?isc_rpc=1&isc_v=v9.1p_2014-05-23&isc_tnum=2:1
Code:
grid.exportClientData({ exportAs: "ooxml", exportDisplay: "download", exportFilename: table.filename });
If I turn off formatting, the procedure takes 15 seconds, but if I set exportRawValues:true for the fields, Chrome still times out at 30 seconds.
This ListGrid is created from a clientOnly:true DataSource. I tried monitoring with showConsole, but then my machine just ran and ran w/o no failure or success.
I made a standalone test for this, but it includes data, so it's too large for your attachment manager to accept it.
I pasted the server output for the relevant interval below.
Code:
=== 2014-05-23 17:18:42,163 [c-18] DEBUG IDACall - Header Name:Value pair: host:domain.com:8080 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: connection:keep-alive === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: content-length:3806916 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: cache-control:max-age=0 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: origin:http://domain.com:8080 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: dnt:1 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: referer:http://domain.com:8080/test.html === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip,deflate,sdch === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: accept-language:en-US,en;q=0.8 === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - Header Name:Value pair: cookie:JSESSIONID=9056D17035A3CB37500C632BD719883E; GLog=%7B%0D%20%20%20%20left%3A1040%2C%20%0D%20%20%20%20top%3A131%2C%20%0D%20%20%20%20width%3A888%2C%20%0D%20%20%20%20height%3A1218%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A3%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7D === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - session exists: 9056D17035A3CB37500C632BD719883E === 2014-05-23 17:18:42,164 [c-18] DEBUG IDACall - remote user: null === 2014-05-23 17:18:42,165 [c-18] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36': Safari with Accept-Encoding header === 2014-05-23 17:18:42,165 [c-18] WARN RPCManager - Detected zero-length IDA transaction, asking client to retry. === 2014-05-23 17:18:42,165 [c-18] WARN RPCManager - Outputting extra debug information: === 2014-05-23 17:18:42,165 [c-18] WARN RPCManager - Cookies: Name: 'JSESSIONID', value: '9056D17035A3CB37500C632BD719883E', domain: 'null', path: 'null', maxAge: '-1', isSecure: 'false' Name: 'GLog', value: '%7B%0D%20%20%20%20left%3A1040%2C%20%0D%20%20%20%20top%3A131%2C%20%0D%20%20%20%20width%3A888%2C%20%0D%20%20%20%20height%3A1218%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A3%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7D', domain: 'null', path: 'null', maxAge: '-1', isSecure: 'false' === 2014-05-23 17:18:42,165 [c-18] WARN RPCManager - Client HTTP Headers: host: domain.com:8080 connection: keep-alive content-length: 3806916 cache-control: max-age=0 accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 origin: http://domain.com:8080 user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36 content-type: application/x-www-form-urlencoded dnt: 1 referer: http://domain.com:8080/test.html accept-encoding: gzip,deflate,sdch accept-language: en-US,en;q=0.8 cookie: JSESSIONID=9056D17035A3CB37500C632BD719883E; GLog=%7B%0D%20%20%20%20left%3A1040%2C%20%0D%20%20%20%20top%3A131%2C%20%0D%20%20%20%20width%3A888%2C%20%0D%20%20%20%20height%3A1218%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A3%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7D === 2014-05-23 17:18:42,165 [c-18] WARN RPCManager - HTTP Query params: { isc_rpc:"1", isc_v:"v9.1p_2014-05-23", isc_tnum:"1" }
Comment