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

Revision as of 04:10, 2 August 2016

Back to Contents

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 breaks the PDF function for scheduled reports.

Look at the URL in your browser's URL field to determine your server path. By default, it's http://servername/laytonservicedesk. Replace ENTERPATHNAMEHERE below 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.

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

Test a scheduled PDF report to ensure that the path is correct.

Note that the query will fail if your path is greater than 50 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.

Back to Contents