Layton ServiceDesk - Troubleshooting - PDF Report Not Attached to Scheduled Report Email
m (Jpainter moved page Layton ServiceDesk™ - General Troubleshooting - PDF Report Not Attached to Scheduled Report Email to Layton ServiceDesk - General Troubleshooting - PDF Report Not Attached to Scheduled Report Email: Removed the TM symbol f...) |
m (Added section titles, major revision, updated links) |
||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
− | 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 | + | __FORCETOC__ |
+ | =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. | ||
− | + | =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) | DECLARE @Path VARCHAR(255) | ||
Line 14: | Line 19: | ||
WHERE sys_admin_id = 'ap_serverpath' | WHERE sys_admin_id = 'ap_serverpath' | ||
− | Test a scheduled PDF report to ensure that the path is correct. | + | 3. Look at the URL in your browser's URL field to determine your server path. By default, it's ''<nowiki>http://servername/laytonservicedesk</nowiki>''. |
+ | |||
+ | 4. Replace the string ''ENTERPATHNAMEHERE'' with your path, including the port number (default '':80''). For example, if your path is | ||
+ | |||
+ | ''<nowiki>http://ithelpdeskserver/laytonservicedesk</nowiki>'' | ||
+ | |||
+ | then the path to enter will be | ||
+ | |||
+ | ''<nowiki>http://ithelpdeskserver:80/laytonservicedesk</nowiki>'' | ||
+ | |||
+ | You must get this right. 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. | ||
+ | |||
+ | ''<nowiki>http://10.1.1.10:80/laytonservicedesk</nowiki>'' | ||
+ | |||
+ | 5. Execute the query. | ||
+ | |||
+ | 6. Test a scheduled PDF report to ensure that the path is correct. | ||
+ | |||
− | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> | |
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + |
Revision as of 04:21, 2 August 2016
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.
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 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
5. Execute the query.
6. Test a scheduled PDF report to ensure that the path is correct.