Layton ServiceDesk - Troubleshooting - PDF Report Not Attached to Scheduled Report Email

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(New section: "Test")
Line 3: Line 3:
 
=Overview=
 
=Overview=
 
When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This results in scheduled-report emails being sent without an attachment.
 
When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This results in scheduled-report emails being sent without an attachment.
 +
 +
=Test=
 +
1.  Copy the following SQL query into a new query window in Management Studio and execute it:
 +
 +
    SELECT  sys_admin_value AS "Server Path"
 +
   
 +
    FROM    [admin]
 +
   
 +
    WHERE  sys_admin_id = 'ap_serverpath'
 +
 +
3. This is your server path. By default, it's ''<nowiki>http://servername/laytonservicedesk</nowiki>''.
  
 
=Repair Procedure=
 
=Repair Procedure=

Revision as of 23:09, 23 January 2018

Btn back up.png Back to Contents

Contents

Overview

When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This results in scheduled-report emails being sent without an attachment.

Test

1. Copy the following SQL query into a new query window in Management Studio and execute it:

   SELECT  sys_admin_value AS "Server Path"
   
   FROM    [admin]
   
   WHERE   sys_admin_id = 'ap_serverpath'

3. This is your server path. By default, it's http://servername/laytonservicedesk.

Repair Procedure

1. Back up your database.

2. Copy the following SQL query into a new query window in Management Studio:

   DECLARE	@Path VARCHAR(255)
   SET		@Path = 'ENTERPATHNAMEHERE'
   
   
   UPDATE	[admin]
   
   SET		sys_admin_value = @Path
   
   WHERE	sys_admin_id = 'ap_serverpath'

3. Look at the URL in your browser's URL field to determine your server path. By default, it's http://servername/laytonservicedesk.

4. Replace the string ENTERPATHNAMEHERE with your path, including the port number (default :80). For example, if your path is

   http://ithelpdeskserver/laytonservicedesk

then the path to enter will be

   http://ithelpdeskserver:80/laytonservicedesk

You must get this right. Note that the query will fail if your path is greater than 255 characters, as that is the length of the column. In this case, use the IP address, e.g.

   http://10.1.1.10:80/laytonservicedesk

5. Execute the query.

6. Go to Reporting > Schedule Reports. Create a new schedule, or modify an existing schedule. Make the trigger Daily > Start time: [2 minutes in future] > Every 1 day(s).

7. Check that the emailed report includes a PDF attachment.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox