Skyline Installation

Clear the Database

Clear the Database

Previous topic Next topic  

Clear the Database

Previous topic Next topic JavaScript is required for the print function  

You will need to use a program called “Microsoft SQL Management Studio” to view that database. This is a free program that can be downloaded from Microsoft.

By default, the database used by the converter services is on the Skyline server. If you are using the default settings, the database is called “Skyline” and the table is called “SkylineConverter”.

To clear the database:

1.Log in to the web server with an account that has local administrator rights.
2.Check the database connection settings used by the converter. Browse to the directory where the converter service is installed. This should be C:\Program Files (x86)\Skyline\PDF Scheduler by default.
3.Open the file MasterService.exe.config with Notepad. The location of the database the Converter Service uses is specified in the section that starts with <connectionStrings>. Note the values for the following SQL settings.
data source.
initial catalog.
user id.
password.
4.Connect to the database used by the Skyline PDF Scheduler with Microsoft SQL Server Management Studio using the values specified in the MasterService.exe.config file.
5.Open the SkylineConverter.SkylineInstance table. The Skyline PDF Scheduler service can monitor several Skyline website. If you only have one Skyline Website, then you will only see one entry in the table.
SkylineInstance table
Check that the values for the following fields are set correctly:
SkylineInstanceId: The value of field should never be changed. It’s an automatically generated ID number.
SkylineName: A unique name for each Skyline website. This can be set to any value describing the website, NOT the portals. All the portals in the same website use the same PDF Scheduler. The value for this field is not important as long as it is unique.
SkylineURL: The URL of any portal on the website. This is usually set to the portal used to log in with host admin rights, but any portal URL can be used. Check that the URL is valid by opening it in a browser on the server.
UploadFolder: This must be set to the same path defined in Skyline Admin / Default Configuration / Upload - Directory. Check that the path is correct and that the user account that runs the Skyline PDF Scheduler service has full read / write access to that path.
DocumentFolder: This must be set to the same path defined in Skyline Admin / Default Configuration /Document Directory.
ErrorsFolder: This must be set to the same path defined in Skyline Admin / Default Configuration /Document Error Folder.
SkylineInstanceId: This must be set to the same path defined in Skyline Admin / Default Configuration / Driver Directory.
Online: Should be set to True. The “Skyline PDF Scheduler” service” will attempt to set this value to True when it starts up.
6.Open the SkylineConverter.PdfConverter table. If you only have one PDF Converter, then you will only see one entry in this table
PDFConverter table
Check the values of the following fields:
PdfConveterId: The value of field should never be changed. It’s an automatically generated ID number.
Name: This should be the name of the PC where the PDF Converter service is running. If the PC name has changed then the PDF Converter service will not run.
Path: This should be the local path when the “PDF Converter service” converts documents to PDF. This working directory needs to be on the same PC as the “Skyline PDF Converter” service. By default this path is C:\Skyline\ConverterIN. Check that the path is correct and that the user account that runs the “Skyline PDF Converter” service has full read / write access to that path.
Priority: This should be a value between 1 and 100. If Skyline is set up to use several PDF converters then the one with the highest priority will be used first.
Busy: This will be False by the “PDF Converter service” when it is idle. The Skyline PDF Converter service will change this field to True to signal to the PDF Scheduler service that has started converting a document.
StatusId: This field is changed by the PDF Converter to show the progress of the PDF conversion process. The StatusId will be 1 when it’s idle.
Online: This should be set to True. If it is set to False, then the Skyline PDF Scheduler will ignore this PDF Converter. The Skyline PDF Converter service will set this value to True when it starts up.
ServiceStartCount: This field is not used at present, but will indicate the number of times the Skyline PDF Converter has stalled and was restarted by the Skyline PDF Scheduler service.
7.Open the SkylineConverter.Job table. This lists all the documents being converted to PDF and should be empty when no document is being converted. Restarting the PDF Scheduler should clear this table but if it does not then delete all entries from this table.
8.Open the SkylineConverter.Error table. The Error field contains the errors recorded by the PDF Scheduler and the PDF Converter services. This table can be cleared once the PDF Converter is working again.
9.The SkylineConverter.ConversionHistory table lists the time taken to convert past documents and the ID of these documents. This table can be cleared if this information is not required.
10.When the databases are correct, stop the Services listed below in the order that they are shown.
Skyline PDF Scheduler.
Skyline PDF Converter.
DCStart.
11.Start the Services listed below in the order that they are shown.
DCStart.
Skyline PDF Converter.
Skyline PDF Scheduler.
12.Upload a document and check that the PDF Converter is now running.

If uploaded documents are still stuck at the status “Queued” them we need to look deeper still. The user account that runs the website needs to have full read / write access to the directories where documents are stored. Follow the instructions on how to check access rights.