Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Limit on the Number of rows to burst in smart notifications

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
4/8/2011 8:23 PM
    Is there a maximum limit on the number of rows smart notes can burst ? For eg I am trying to write a smart notes that has more than 5500 rows of data and would like smart notes to burst each row. Has anybody experienced this issue? What was your solution ?
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    4/9/2011 6:32 AM
      Ruma,

      Im not aware of a limit but with that many email address theres certainly room for some threshhold violations. First check your server logs. If even one of the email address is malformed it could be bombing on that. There would be a null exception error in the WAS out log file. Have you email server admin check the SMTP logs or Relay settings. Perhaps the SMTP server is blocking. Also, take a look at the Task Manager on the SmartNotes server, perhaps you are triggering a outofmemory error (this would also be in the WAS out log).

      hth
      Matt
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      4/9/2011 2:58 PM
        Thanks Matt. You are such a tremendous source of help and for this discussion also you have given me the maximum pointers to look at.

        I did additional testing on this and what I found out is the way this smart notification is written is there is a single row of data for every employee and this row gets bursted to each employee with additional text on the smart note. The row of data is the default that on step4 of the notification wizard is where I am saying "do not display" but send only the text that was included on the header out. Smart notes was not bursting this information.

        Once I included the table it started bursting the rows. Now this leads me to think that you have to have one row of data atleast for the smart note to burst the rows. Please let me know whether you think differently. You are right there is no known issue about the limit on the number of rows to burst.

        Thanks once again for the great help.