The log files written by the scheduling application keep track of all the tasks executed by the user on the Scheduling module. The log files can be found in the local directory of the workstation where the application runs (Ex. C:\Etere\Log\user.001). Every module has its own log file, composed as follows: module.exe.user.pcname.date form.log. In the log, the date and time format is captured as dd/mm/yyyy, hh:mm:ss.ms.
•Sch.eteresch.001.PCNAME.YYYYMMDD.Executive Editor.log: It is the log file containing traces of all operations executed by Executive Editor. SQL queries executed by the application are shown too. Information is ordered by date (dd/mm) and time (HH:mm:ss.ms[frames]) such as, for instance:
31/1/2002 10:57:21.531 67771.09 15DC4 SQL 001 | SELECT DISTINCT COD_TYPE, DESCRIZIO FROM TIPOLOGIE WHERE COD_TYPE_GROUP=' ' ORDER BY DESCRIZIO
•Sch.eteresch.001.PCNAME.YYYYMMDD.Instant Editor.log: It is the log file containing traces of all operations executed by Instant Editor. Information is ordered by date (dd/mm) and time (HH:mm:ss.ms[frames]) such as, for instance:
31/1/2002 11:00:09.842 67939.17 15DC4 Open schedule 31/1/2002 Automation Main - O:\ETERESQLBETA\USER.001\2002\TPAL0131.DBF
•Sch.Asset.001.PCNAME.log: It is the log file containing traces of all commands and operations executed within the Asset Form, such as, for instance:
13/04/2005 11:05:14.482 7408.10 0000 SQL 001 | Update FILMATI with (rowlock) set
13/04/2005 11:05:14.482 7408.10 0000 SQL 002 | COD_PROGRA= N'prova', DESCRIZIO=N'prova', ......
13/04/2005 11:05:14.482 7408.10 0000 SQL 003 | where ID_FILMATI=1
13/04/2005 11:05:14.482 7408.10 0000 SQL ___ |
13/04/2005 11:05:14.482 7408.10 0000 SQL --> | Start Query
13/04/2005 11:05:14.492 7408.11 0000 -------- BEGIN TRANSACTION ---------------
13/04/2005 11:05:14.522 7408.14 0000 -------- COMMIT TRANSACTION --------------
•Sch.TapeManagerOnAsset-001.PCNAME.log: It is the log file of Tape Management and Measurements executed within the Asset Form, such as, for instance:
13/04/2005 11:05:14.642 7408.26 0000 SQL 001 | Update Filmati with (rowlock) set Durata_Pub = 180000
13/04/2005 11:05:14.642 7408.26 0000 SQL 002 | where ID_Filmati=1
13/04/2005 11:05:14.642 7408.26 0000 SQL ___ |
13/04/2005 11:05:14.642 7408.26 0000 SQL --> | Start Query
13/04/2005 11:05:14.642 7408.26 0000 -------- BEGIN TRANSACTION ---------------
13/04/2005 11:05:14.652 7408.27 0000 -------- COMMIT TRANSACTION ---------------
13/04/2005 11:05:14.652 7408.27 0000 *********************************************
13/04/2005 11:05:14.652 7408.27 0000 SQL --> | End Query
13/04/2005 11:05:14.652 7408.27 0000 SQL ___ +------------------------------
13/04/2005 11:05:14.662 7408.28 0000 SQL ___ +------------------------------
13/04/2005 11:05:14.662 7408.28 0000 SQL 001 | Update S Set Durata_Prev = 180000
13/04/2005 11:05:14.662 7408.28 0000 SQL 002 | from FSerie S with (rowlock)
13/04/2005 11:05:14.662 7408.28 0000 SQL 003 | join Filmati F with (nolock) on F.ID_Serie = S.ID_Serie
13/04/2005 11:05:14.662 7408.28 0000 SQL 004 | where F.ID_Filmati = 1
13/04/2005 11:05:14.662 7408.28 0000 SQL ___ |
13/04/2005 11:05:14.662 7408.28 0000 SQL --> | Start Query
13/04/2005 11:05:14.662 7408.28 0000 -------- BEGIN TRANSACTION ---------------
13/04/2005 11:05:14.672 7408.29 0000 -------- COMMIT TRANSACTION --------------
•sch.etfutente.001.PCNAME.futente.log. It is the log file of "etfutente.dll" procedure used at all Etere modules' startup, such as, for instance:
[- ] 11/04 17:39:46.622 | |Log Started
[Std ] 11/04 17:39:46.632 | |Impossibile to connect to the SQL server.
Go to:
1) Etere Scheduling
2) Settings
Check if the following parameters are correct:
1) SQL Server: "eterew0" - (Indicate the name of the server where SQL is installed)
2) Database Name: "etere_maurizio" - (Indicate the name of the database where the archives are stored)
[- ] 11/04 17:39:46.632 | |Log Closed
•sch.etapi.005.PCNAME.Etere Library.log: It is the log file of libraries used by Etere Scheduling module, such as, for instance:
[- ] 11/04 17:42:49.785 | |Log Started
[Std ] 11/04 17:42:49.785 | etApi.dll| 15.01.21.20
[Std ] 11/04 17:42:49.785 |Router Channels| Searching Channels list [Please wait...]
[Std ] 11/04 17:42:49.795 |Router Channels| SQL ___ +------------------------------
[Std ] 11/04 17:42:49.795 |Router Channels| SQL 001 | select main_input_channel, description from RouterLinks001 order by main_input_channel
[Std ] 11/04 17:42:49.795 |Router Channels| SQL ___ |
[Std ] 11/04 17:42:49.795 |Router Channels| SQL --> | Start Query
[Std ] 11/04 17:42:49.815 |Router Channels| SQL +------------------------------
[Std ] 11/04 17:42:49.815 |Router Channels| SQL | Invalid object name 'RouterLinks001' [-2147217865]
[Std ] 11/04 17:42:49.815 |Router Channels| SQL | Unknown Error code: -2147217865
[Std ] 11/04 17:42:49.815 |Router Channels| SQL +------------------------------
[Std ] 11/04 17:42:49.925 |Router Channels| Channels detected: [Count=0, Channels list=]
How to display the archive of all the tasks executed in the Executive Editor
To show the archive of all the tasks executed in the Executive Editor you have to use the function "Save logs" in the workstation where the problem has occurred.
"Save logs" makes a ZIP file containing the archive of all the tasks executed in TXT format, and a INI file (loginname.ini) containing the columns list visualized by the operator in the Executive Editor.
E.g.: Let's suppose one works on a PC where Scheduling is installed in C:\Program Files\Etere and the Wsetup.ini file that is inside the same folder points to the O:\Etere folder. The user logged on this workstation is "Administrator" and at the Etere Start we select USER.001
This means that:
LOCAL = C:\Program Files\Etere
NETWORK = O:\Etere
USER = USER.001
LOGINNAME = NETWORK\USER\Administrator.ini
Log file must be unzipped in this way:
1.All TXT files must be unzipped in LOCAL\Log\USER\schedule.
2.USER's loginname.ini file contained in the ZIP file must be unzipped in NETWORK\USER.
Note: loginname.ini file must be user's and not Etere' s one.
3.Rename loginname.ini file with the pc name where the logs are examined.
4.Open Executive Editor and select the day you want to display the executed tasks.
5.Select the icon that shows the empty playlist, and press CTRL-ALT-SHIFT-A.
6.Select the row to display the playlist from the popup window.