Maximum rows in active form?
Posted: Tue Dec 06, 2016 4:54 pm
Is there a limit to how many rows can be returned in an active form? And if so is it a parameter than can be changed?
I have an active form in v10.1.1 that works fine with less than 100 rows but when I try to do say 1000 rows I just keep getting a timeout error. When I've looked at the web log file there is an error on there:
2016-12-06 16:35:51,194 [6] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - Last AR data row object was null, check for off 'used range' reference
2016-12-06 16:49:55,835 [5] ERROR Applix.TM1.Web.WebControls.Websheet.TM1RowData - could not process row exp above override argument as a bool
2016-12-06 16:50:28,570 [7] ERROR Applix.TM1.Web.WebControls.Websheet.TM1RowData - could not process row exp above override argument as a bool
It seems as though there is a restriction on the number of rows that can be returned but I need to present the data in an active form because the form links a number of cubes/attributes/dimension data so can't be done by just a plain simple cube view.
I have an active form in v10.1.1 that works fine with less than 100 rows but when I try to do say 1000 rows I just keep getting a timeout error. When I've looked at the web log file there is an error on there:
2016-12-06 16:35:51,194 [6] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - Last AR data row object was null, check for off 'used range' reference
2016-12-06 16:49:55,835 [5] ERROR Applix.TM1.Web.WebControls.Websheet.TM1RowData - could not process row exp above override argument as a bool
2016-12-06 16:50:28,570 [7] ERROR Applix.TM1.Web.WebControls.Websheet.TM1RowData - could not process row exp above override argument as a bool
It seems as though there is a restriction on the number of rows that can be returned but I need to present the data in an active form because the form links a number of cubes/attributes/dimension data so can't be done by just a plain simple cube view.