|
Logs |
  
|
|
Logs |
|
You have in the Import & Export WIZARD a Trace LOG checkbox which enables you to have a complete LOG file created by DMC for all tasks.
These logs are all in a special directory under 'cgf_import\logs' and you can access then directly from DMC in the Documents Task from the Navigation Panel
These logs can be very helpful for you to understand why a task is not completed
These logs can also be emailed to us to ask our help in a task not completing properly
These logs are also regularly offered to be deleted from your HD : a message will open up when you open DMC the first time on the 1st of each month and offer to delete them
These logs are also - IF they exist - used in our built in emailing feature IF the application crashes in a task when you reopen it
By clicking on the eMail button you will be taken automatically to a module pre filled with all the necessary data (EXCEPT YOUR EMAIL ADDRESS IF UNDER DEMO)
If you are in this situation please fill in your email and send us the email with the log zipped and attached
You just have to check the log file sent - it is displayed for you in Note Pad - check if you want to delete any information's from it before you send it to us for analysis on your problem
Of course you can also chose NOT to send the log by email - this feature will help us (and you at the same time) to better the tool by understanding any eventual problem you encountered
You also have the possibility to ask DMC to generate TRANSFER logs from the MAPPING TAB
Remember that such logs can be VERY important in size if you transfer a large amount of data - we recommend doing a first transfer on say 100 records and to log this one preferable
This is an example PROCESS LOG created (from a Restore Profile on a Transfer from ACCESS to a TPS Table) :
10:34:50 --> Start a New Task
10:34:50 --> Restore a saved Profile
10:34:53 --> GLO:SelectedProfile <> 0
10:34:53 --> Load Profile
10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = - -
10:34:53 --> ?GLO:Driver
10:34:53 --> Load Profile Step 1
10:34:53 --> Select SQL
10:34:53 --> Load Profile Step 2 SQL
10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access - -
10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access - -
10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access - -
10:34:53 --> ?GLO:DriverDest
10:34:53 --> Load Profile Step 1 Destination
10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access - - TOPSPEED
10:34:53 --> Run
10:34:53 --> Init Run
10:34:53 --> Define Type of Transfer
10:34:53 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access - - TOPSPEED
10:34:53 --> SQL Query Source
10:34:53 --> SQL Query Source - Table Name => products
10:34:53 --> SQL Query Source : Start Process
10:34:53 --> SQL Query Source : DO SelectSQL
10:34:53 --> Select SQL
10:34:53 --> SQL Query Source : DO SQLCountRecsS
10:34:53 --> SQL Count Records Source
10:34:53 --> SQL Count Records Source - Connection => dirtbike
10:34:53 --> SQL Count Records Source - Connected
10:34:53 --> SQL Count Records Source - Query => select * from products
10:34:53 --> SQL Count Records Source - Prepared
10:34:53 --> SQL Count Records Source - Create Temp Q
10:34:53 --> SQL Count Records Source - Disconnect
10:34:53 --> Init Class for SQL
10:34:53 --> Init Class for SQL => Access
10:34:53 --> SQL Count Records Source - Get Number of records SQL code on Table => products
10:34:53 --> SQL Count Records Source - Number of records in Table => 577
10:34:53 --> SQL Count Records Source - SQLTableName => products
10:34:53 --> SQL Count Records Source - END
10:34:53 --> SQL Query Source - SQLTableName => products
10:34:53 --> SQL Query Source : Connect => dirtbike
10:34:53 --> SQL Query Source : Connected
10:34:53 --> SQL Query Source : Prepare Query => select * from products
10:34:53 --> SQL Query Source : Prepared
10:34:53 --> SQL Query Source : Access : dFileSource.Clone WITH KEYS => products
10:34:53 --> SQL Query Source : BLOBS => 25
10:34:53 --> SQL Query Source : BLOBS - Create Qs
10:34:53 --> SQL Query Source : DO ReadKeys
10:34:53 --> DMC.Read Keys
10:34:53 --> DMC.Read Keys DLib code : Primary Column ID Name KeyName : (+CATALOGID) (PRIMARYKEY)
10:34:53 --> DMC.Read Keys Primary Column ID Name KeyName : (1) (CATALOGID) (PRIMARYKEY)
10:34:53 --> SQL Query Source : Primary Column ID Name KeyName : (CATALOGID) (PRIMARYKEY)
10:34:53 --> SQL Query Source : dQueSource is Completed
10:34:53 --> SQL Query Source - Reset Table Name and Owner => products - dirtbike
10:34:53 --> SQL Query Source : (Not Generate Data and Not EXCEL) DO FillSQLSourceQ
10:34:53 --> Fill SQL Source Q
10:34:53 --> Fill SQL Source Q (VIEWER) : BLOBS so CREATE DMCBLOB
10:34:53 --> Fill SQL Source Q (VIEWER)
10:34:53 --> Fill SQL Source Q (Clone or Transfer and ReadOnlyFirst 50 Recs)
10:34:53 --> Fill SQL Source Q (Clone or Transfer and ReadOnlyFirst 50 Recs - BLOBS => DO ReadSQLDataWBlob)
10:34:53 --> Read SQL Data With Blob
10:34:53 --> Read SQL Data With Blob => BLOBS = 25
10:34:53 --> Read SQL Data With Blob - Reset Table Name and Owner => products - dirtbike
10:34:54 --> SQL Query Source : dSQLSource.DisConnect
10:34:54 --> SQL Query Source - (Fill DummyQ)
10:34:54 --> SQL Query Source - (GLO:ReadSrcOnly = 0 OR GLO:SQLType = Excel) => DO SQL_StepOne
10:34:54 --> SQL Step One
10:34:54 --> SQL Step One (Generate or Transfer) => DO CreateDFDTable
10:34:54 --> Create Table Main
10:34:54 --> Create Table Main : ID = 1
10:34:54 --> Create Table Main : ID = 1 Goto Creation
10:34:54 --> SQL Step One => DO ModifierStructure
10:34:54 --> SQL Step One => DO DO EcrireStructureStartSource
10:34:54 --> SQL Step One => DO DO EcrireStructureODBC
10:34:55 --> SQL Step One - General => DO BuildNewList
10:34:55 --> Build ListBox Format
10:34:55 --> Build ListBox Format - Decimal Sep. => .
10:34:55 --> Build ListBox Format - Nb. Decimals => 4
10:34:55 --> SQL Step One - General => oQ2SQL.Kill
10:34:55 --> SQL Query Source - END
10:34:55 --> Run : Goto run step one (not MT or MT and restore profile)
10:34:55 --> Run Step One
10:34:55 -->
10:34:55 --> TPS Query Destination
10:34:55 --> TPS Query Destination - Table Name => L:\Data\eBusines\PIECES.TPS
10:34:55 --> TPS Query Destination - TOPSPEED Check if it is a Multi-Table
10:34:55 --> TPS Query Destination - Normal and NOT a Multi-Table or Load Profile
10:34:55 --> TPS Read Destination Table
10:34:55 --> TPS Read Destination Table - Init
10:34:55 --> TPS Read Destination Table - DAT or TOPSPEED
10:34:55 --> TPS Read Destination Table - Restore and Normal Table and NO PWD
10:34:55 --> TPS Read Destination Table - Goto FillTPSDestinationQ
10:34:55 --> Fill TPS Destination Q
10:34:55 --> Fill TPS Destination Q - Init all
10:34:55 --> Fill TPS Destination Q - MEMO or BLOBS or ARRAYS => 0 | 0
10:34:55 --> Fill TPS Destination Q - NO Memos and NO Blobs and NO Arrays - Create Q
10:34:55 --> Fill TPS Destination Q - Create DISPLAY Q
10:34:55 --> Fill TPS Destination Q - End of Q creation
10:34:55 --> Fill TPS Destination Q - Goto FillTPSDestQ
10:34:55 --> Fill TPS Destination Q
10:34:55 --> Fill TPS Destination Q - Reset Table NAME => L:\Data\eBusines\PIECES.TPS
10:34:55 --> Fill TPS Destination Q - OPEN Table
10:34:55 --> Fill TPS Destination Q - SET Table
10:34:55 --> Fill TPS Destination Q - END
10:34:55 --> TPS Read Destination Table - Goto Build ListBox Format
10:34:55 --> Build ListBox Format Destination
10:34:55 --> TPS Read Destination Table - Goto Create Temp TPS Structure Tables
10:34:55 --> Create Table Main
10:34:55 --> Create Table Main : ID = 2
10:34:55 --> Create Table Main - File to Create => L:\CGF\Compta\cgf_import\Dfd_D_Data.tps
10:34:55 --> Create Table Main : ID = 2 Goto Creation
10:34:57 --> TPS Read Destination Table - Reset Browse From File
10:34:57 --> TPS Read Destination Table - CLOSE Table
10:34:57 --> TPS Query Destination - END
10:34:57 --> Run Step One : DO Run Step Next
10:34:57 --> Run Step Next
10:34:57 --> Run Step Next - Continue
10:34:57 --> Run Step Next - General Case
10:34:57 --> Run Step Next - (General Case) Goto FillSLColNameQ
10:34:57 --> Fill Source ColName Q
10:34:57 --> Run Step Next - (General Case NOT Viewer)
10:34:57 --> Run Step Next - Continue Loading = 2 AND Clone2SQL = 0)
10:34:57 --> Load Profile Step 2
10:34:57 --> Load Saved Mappings
10:34:57 --> Define Type of Task => (SQL Type - SQL Type Dest - Driver Dest) = Access - - TOPSPEED
10:34:57 --> Load Profile - END
10:34:57 --> Run Step Next (ReadSrcOnly = 0 OR (ReadSrcOnly = 1 AND GenerateData = 1) OR (ReadSrcOnly = 1 AND Driver = ASCII))
10:34:57 --> Run Step Next - END
10:34:57 --> Run Step One - END
10:34:57 --> Run - Display LOG File
10:34:57 --> Run - END
10:34:57 -->