Basically, we have a need to have a Smart Notification execute a stored procedure in addition to sending the email based on a defined query. The stored procedure will be designed to update tables based on the assumtpion that an email was generated and sent. The issue at hand is that we are being told by our technical team that if the notification is executed in a preview mode (i.e., no notifications are actually sent out), that the stored procedure would be executed as well. In effect...

On the template for the Smart Notification, we would like to display a warning message depending on the value of the [hostname] token e.g. printing a warning when it is not a production smart notification. We've tried using Javascript if statements but they do not interpret the value of the [hostname]: if [hostname] == 'some host name' is always false. The value of [hostname] prints at the bottom of the template, it just seems like we can't access its value in a conditiona...

We are scheduling Smart Notification processing every morning to create and distribute the SNs to addressess in the infoset and to a couple of devices. We always get a couple of records in the Activity Report for document type Notification, and under Document will be, for instance, Unavailable [ID:661] and in the Device column, Unavailable [ID:656], these two values always being in Red. All the SNs seem to get delivered ok, but I am suspicious of these messages. Lawson Support has had me chasing...

I believe there is a limit to the number of records that can be processed on a smart notification. Does anybody know what it is I seem to recall seeing somewhere that it was around 1000.

Do all existing smart notes with their infosets migrate in the upgrade From what I read in the docs they do - I just need someone to verify that this is so. Thanks

Hi, I am using SQL query and when I am defining my infoset, where we need to define columns, I hit autocreate (Step 2), it takes a while, where you see blue bar below your screen progressing and then it finally throws an error: ' Max wait time 300 reached for object parent.frames.submit.document. Not calling function' I even previewed my data before moving to next step. It takes a while for SQL to generate the data since I have a lot of joins in my query, but it fina...

I have a question about SN links. I have created a 'Summary' SN, which I have linked to a 'Detail' SN via one of the fields. This works, but the 'Detail' SN opens in a new window. I would like to have it open in a 'Viewer' module on the same dashboard. I understand the 'OnClick' action of the SN's, but there must be another method when trying to open it from another SN. Has anyone been successful in doing this Thanks for any help. Bill

I just started working with SN's last week (please forgive if this question should not be posted). I have a query built in Access 2003 that runs fine, but when I copy the SQL over to the JDBC connection, I keep receiving an error. I believe it's because the SQL syntax is different between the two, but I don't know what those differences are. My main objective is to create a SN that will return all Employees who appear in the GMDISTRIB table but do not appear in the GMEFFORT table. Any ...

Hello - I have a query that creates an Infoset using a JDBC connection successfully. I want to limit the records being returned by the Infoset where the PER_END_DATE is after July 1, 2007. I receive the error “Error: ORA-01843: not a valid month” When I try to add the following criteria to the SQL statement: HAVING ((GMDISTRIB.PER_END_DATE)>'07/01/2007') I’ve tried to play with the formatting of the date but I haven’t found the correct format… Any suggestions/ideas Th...

I have a notification that gets sent to show unmatched items after MA126 is run. It has a link to form MA60.1 on each row. I have added the URL to the tag in the infoset, including the value for [Company] pulled from the row in the notification. Based on information I found by looking through Lawson KB articles, I thought I could string an additional variable to the end to also pull the [Vendor] from the row too. However, it doesn't work. When MA60.1 is displayed, it is only filtering by [Com...

I'm trying to create a Smart Note that will list the accounts that exist in the GMDISTRIB that do not have a Record_Type attribute set up on the GL16.2.  Not all accounts should have their Record_Type attribute value assigned, only the accounts in the GMDISTRIB. I've broken it down into two queries: 1. The first infoset JDBC query pulls a listing of all of the unique accounts that exist in the GMDISTRIB. SELECT GMDISTRIB.ACCOUNT FROM GMDISTRIB GROUP BY GMDISTRIB.ACCOUNT 2. The second infos...

I have developed a simple info set, updated.  Created a smart notification, few simple calculations (count and multiplication).  Hitting the Preview button opens a browser window that returns the standard Page cannot be displayed windows error message.  Save smart notification.  Click on it and the window opens with header and footer info, but no body.  I have tried simplifying the smart notificiation, simplifying the infoset, to no avail.  Any suggestions

We migrated our Smart Notification from our Env 8.03 server to LSF9 but the connection tests for the JDBC data souce fail on the new box (DME connections test ok). We think all the SQL and JDBC settings are correct but the LSN install validator still reports Tomcat for the connection. Aside from moving from LSN 3.X to 9.X the only other fundemental difference is that LSN 9 is being serviced by Websphere while LSN 3 was using Tomcat. Has anyone else run into this or know how to point LSN at Websp...

What is the underlying technology of smart notifications SQL or COBOL or something else