|
Home > Archive > SQL Anywhere Mobile > May 2005 > download synchronize problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
download synchronize problem
|
|
| R. van der Wiele 2005-05-20, 11:24 am |
| I have a problem in that the consolidated database doesn't sync a (new) row
from table 'werkopdracht' to the remote database.
(maybe the other tables also have that problem, but there are no new rows at
the consolidated db for those tables)
The consolidated database has 1 row and the remote database has 0 rows for
that table (werkopdracht).
The column PersNrCons holds the userid (537), and this column is part of the
prim. key.
The Column LastModified holds '2005-05-20 14:37:44.344'
There is only 1 script (download_cursor) that 1 created, the rest should be
generated automatically
(dbmlsrv8 -c dsn=gercomobile -o mlserver.mls -v+ -dl -za -zu+)
The script is:
call ml_add_table_script(
'v1','werkopdracht',
'download_cursor', 'select *
from werkopdracht where lastmodified>=? and persnrcons=?')
Does someone knows what is wrong?
PS: I thought if the conditions are met (LastModified and PersNrCons) and
there is no row in the remote table that the row gets synchronised.
Ron van der Wiele
The generated logfile is:
I. 05/20 14:40:27. Synchronization Started
I. 05/20 14:40:28. 1: -c
I. 05/20 14:40:28. 2:
********************
********************
*****************
I. 05/20 14:40:28. 3: -n
I. 05/20 14:40:28. 4: gercomobile
I. 05/20 14:40:28. 5: -u
I. 05/20 14:40:28. 6: 537
I. 05/20 14:40:28. 7: -mp
I. 05/20 14:40:28. 8: ***
I. 05/20 14:40:28. 9: -v+
I. 05/20 14:40:28. 10: -x
I. 05/20 14:40:28. 11: -e
I. 05/20 14:40:28. 12: verbose=ON
I. 05/20 14:40:28. ASA MobiLink Synchronization Version 8.0.3.5002
I. 05/20 14:40:28.
I. 05/20 14:40:28. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 05/20 14:40:28. All rights reserved. All unpublished rights reserved.
I. 05/20 14:40:28.
I. 05/20 14:40:28. This software contains confidential and trade secret
information of
I. 05/20 14:40:28. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 05/20 14:40:28. by the U.S. Government is subject to restrictions set
forth in a license
I. 05/20 14:40:29. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 05/20 14:40:29. other written agreement specifying the Government's
rights to use the
I. 05/20 14:40:29. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 05/20 14:40:29.
I. 05/20 14:40:29. Sybase, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 05/20 14:40:29.
I. 05/20 14:40:29. Connecting to remote database
W. 05/20 14:40:29. Unable to convert the string "537" from the system
collation to the database collation.
I. 05/20 14:40:29. Loading synchronization information
W. 05/20 14:40:34. Unable to convert the string "gercomobile" from the
system collation to the database collation.
I. 05/20 14:40:34. Options in database for publication 'gercomobile':
I. 05/20 14:40:34. mp=sql;scn=ON;
I. 05/20 14:40:34. Options in database for publication 'gercomobile':
I. 05/20 14:40:34. mp=sql;scn=ON;
I. 05/20 14:40:35. Options in database for publication 'gercomobile':
I. 05/20 14:40:35. mp=sql;scn=ON;
I. 05/20 14:40:35. Begin synchronizing 'gercomobile' for MobiLink user '537'
I. 05/20 14:40:35. Options for this synchronization:
I. 05/20 14:40:35. SCN='YES',V='YES',MP
='sql',CTP='TCPIP'
I. 05/20 14:40:36. Log scan starting at offset 0004420639
I. 05/20 14:40:36. Processing transaction logs from directory "\My
Documents\Personal\"
I. 05/20 14:40:36. Processing transactions from active transaction log
I. 05/20 14:40:36. Transaction log renamed to: \My
Documents\Personal\0
50520AA.LOG
I. 05/20 14:40:37. Processing transaction logs from directory "\My
Documents\Personal\"
I. 05/20 14:40:37. Transaction log "\My Documents\Personal\0
50520AA.LOG"
starts at offset 0000361285
I. 05/20 14:40:37. Processing transactions from transaction log "\My
Documents\Personal\0
50520AA.LOG"
I. 05/20 14:40:37. Transaction log ends at offset 0004424727
I. 05/20 14:40:37. Processing transactions from active transaction log
I. 05/20 14:40:37. Connecting to MobiLink server at '' using 'dbsock8.dll'
I. 05/20 14:40:37. Uploading header
I. 05/20 14:40:37. Stream version: 304
I. 05/20 14:40:37. Processor is little-endian
I. 05/20 14:40:37. Character set: cp1252
I. 05/20 14:40:37. MobiLink user name: 537
I. 05/20 14:40:37. Script version: default
I. 05/20 14:40:37. Publication 'gercomobile' - Synchronizing - Log offset
0004424307 - Last download time 2005-05-20 11:03:38.106.
I. 05/20 14:40:37. Publication 'GercoMobile ritregistratie' - Not
Synchronizing - Log offset 0004420639 - Last download time 0000-01-00
00:00:00.0.
I. 05/20 14:40:37. Begin upload
I. 05/20 14:40:37. Uploading publication(s)
I. 05/20 14:40:37. Article table: ritregistratie
I. 05/20 14:40:37. Article column: PersNr
I. 05/20 14:40:37. Article column: Tijd
I. 05/20 14:40:37. Article column: Afgelegd
I. 05/20 14:40:37. Article column: Snelheid
I. 05/20 14:40:37. Article column: Locatie_Plts
I. 05/20 14:40:37. Article column: Locatie_Strt
I. 05/20 14:40:37. Article column: Locatie_Nr
I. 05/20 14:40:37. Article column: PersNrCons
I. 05/20 14:40:37. Article table: pdapincodes
I. 05/20 14:40:37. Article column: medid
I. 05/20 14:40:37. Article column: pincode
I. 05/20 14:40:37. Article column: persnrcons
I. 05/20 14:40:37. Article table: userprops
I. 05/20 14:40:37. Article column: PersNr
I. 05/20 14:40:37. Article column: AutoNr
I. 05/20 14:40:37. Article column: PersNrCons
I. 05/20 14:40:37. Article table: bwf
I. 05/20 14:40:37. Article column: Code_BWF
I. 05/20 14:40:37. Article column: Naam
I. 05/20 14:40:37. Article column: BWF
I. 05/20 14:40:37. Article column: Noteer283
I. 05/20 14:40:37. Article table: prijsdef
I. 05/20 14:40:37. Article column: PrijsCode
I. 05/20 14:40:37. Article column: Omschr
I. 05/20 14:40:37. Article column: FlagLengte
I. 05/20 14:40:37. Article column: FlagBreedt
I. 05/20 14:40:37. Article column: FlagPrijs
I. 05/20 14:40:37. Article column: FormuleCod
I. 05/20 14:40:37. Article column: Noteer291
I. 05/20 14:40:37. Article column: PersNrCons
I. 05/20 14:40:37. Article table: autos
I. 05/20 14:40:37. Article column: AutoDKey
I. 05/20 14:40:37. Article column: AutoNr
I. 05/20 14:40:37. Article column: PersDKey
I. 05/20 14:40:37. Article column: PersNr
I. 05/20 14:40:37. Article column: Kenteken
I. 05/20 14:40:37. Article column: PersNrCons
I. 05/20 14:40:37. Article table: personen
I. 05/20 14:40:37. Article column: PersDKey
I. 05/20 14:40:37. Article column: PersNr
I. 05/20 14:40:37. Article column: Naam
I. 05/20 14:40:37. Article column: Adres
I. 05/20 14:40:37. Article column: PostCode
I. 05/20 14:40:37. Article column: WoonPlaats
I. 05/20 14:40:37. Article column: Telefoon
I. 05/20 14:40:37. Article column: PersNrCons
I. 05/20 14:40:37. Article table: calcregie
I. 05/20 14:40:37. Article column: CalcDKey
I. 05/20 14:40:37. Article column: LocDKey
I. 05/20 14:40:37. Article column: DagsDKey
I. 05/20 14:40:37. Article column: MutStamp
I. 05/20 14:40:37. Article column: RegelNr
I. 05/20 14:40:37. Article column: Code_AE
I. 05/20 14:40:37. Article column: Nummer
I. 05/20 14:40:37. Article column: Locatie
I. 05/20 14:40:37. Article column: Tekst
I. 05/20 14:40:37. Article column: BWF
I. 05/20 14:40:37. Article column: Code_BWF
I. 05/20 14:40:37. Article column: MF
I. 05/20 14:40:37. Article column: WPV
I. 05/20 14:40:37. Article column: Lengte
I. 05/20 14:40:37. Article column: Breedte
I. 05/20 14:40:37. Article column: Prijs
I. 05/20 14:40:38. Article column: Aantal
I. 05/20 14:40:38. Article column: Totaal
I. 05/20 14:40:38. Article column: PrijsRest
I. 05/20 14:40:38. Article column: AantRest
I. 05/20 14:40:38. Article column: PrijsAf
I. 05/20 14:40:38. Article column: AantAf
I. 05/20 14:40:38. Article column: SparingNr
I. 05/20 14:40:38. Article column: SparGereed
I. 05/20 14:40:38. Article column: PersNrCons
I. 05/20 14:40:38. Article table: calcdetail
I. 05/20 14:40:38. Article column: Calc2DKey
I. 05/20 14:40:38. Article column: CalcDKey
I. 05/20 14:40:38. Article column: LocDKey
I. 05/20 14:40:38. Article column: DagsDKey
I. 05/20 14:40:38. Article column: MutStamp
I. 05/20 14:40:38. Article column: PrijsAf
I. 05/20 14:40:38. Article column: AantAf
I. 05/20 14:40:38. Article column: RegelNr
I. 05/20 14:40:38. Article column: AantRest
I. 05/20 14:40:38. Article column: Locatie
I. 05/20 14:40:38. Article column: PersNrCons
I. 05/20 14:40:38. Article table: materiaal
I. 05/20 14:40:38. Article column: ArtDkey
I. 05/20 14:40:38. Article column: MutStamp
I. 05/20 14:40:38. Article column: ArtikelCod
I. 05/20 14:40:38. Article column: Eenheid
I. 05/20 14:40:38. Article column: Verbruik
I. 05/20 14:40:38. Article column: Bedrag
I. 05/20 14:40:38. Article column: Omschrijv
I. 05/20 14:40:38. Article column: VVPrijs
I. 05/20 14:40:38. Article column: PersNrCons
I. 05/20 14:40:38. Article table: dagstaten
I. 05/20 14:40:38. Article column: DagsDKey
I. 05/20 14:40:38. Article column: LocDKey
I. 05/20 14:40:38. Article column: AanvDKey
I. 05/20 14:40:38. Article column: ProjDKey
I. 05/20 14:40:38. Article column: PersDKey
I. 05/20 14:40:38. Article column: AutoDKey
I. 05/20 14:40:38. Article column: MutStamp
I. 05/20 14:40:38. Article column: ProjectNr
I. 05/20 14:40:38. Article column: Discipline
I. 05/20 14:40:38. Article column: LocVolgNr
I. 05/20 14:40:38. Article column: Datum
I. 05/20 14:40:38. Article column: KMS
I. 05/20 14:40:38. Article column: Inzittend
I. 05/20 14:40:38. Article column: Rijdingev
I. 05/20 14:40:38. Article column: Begintijd
I. 05/20 14:40:38. Article column: Invoertijd
I. 05/20 14:40:38. Article column: UrenNetto
I. 05/20 14:40:38. Article column: UrenTot
I. 05/20 14:40:38. Article column: UrenMand
I. 05/20 14:40:38. Article column: ReisUren
I. 05/20 14:40:38. Article column: AfWijk
I. 05/20 14:40:38. Article column: DagOmzet
I. 05/20 14:40:38. Article column: Matverbr
I. 05/20 14:40:38. Article column: LunchUren
I. 05/20 14:40:38. Article column: ByzUren
I. 05/20 14:40:38. Article column: VerrekPkm
I. 05/20 14:40:38. Article column: KstPrsAuto
I. 05/20 14:40:38. Article column: KstReisUur
I. 05/20 14:40:38. Article column: KstWerkUur
I. 05/20 14:40:38. Article column: Reizen
I. 05/20 14:40:38. Article column: DagomzetRG
I. 05/20 14:40:38. Article column: DagomzetDR
I. 05/20 14:40:38. Article column: PersUurSel
I. 05/20 14:40:38. Article column: BoordComp
I. 05/20 14:40:38. Article column: KMSPrive
I. 05/20 14:40:38. Article column: Ingelezen
I. 05/20 14:40:38. Article column: Aangenomen
I. 05/20 14:40:38. Article column: TotUrenBC
I. 05/20 14:40:38. Article column: ReisUrenBC
I. 05/20 14:40:38. Article column: UitBWrk
I. 05/20 14:40:38. Article column: LoginNaam
I. 05/20 14:40:38. Article column: PersNrCons
I. 05/20 14:40:38. Article table: werkopdracht
I. 05/20 14:40:38. Article column: WerkDKey
I. 05/20 14:40:38. Article column: ProjNaam
I. 05/20 14:40:38. Article column: ProjAdres
I. 05/20 14:40:38. Article column: ProjPCode
I. 05/20 14:40:38. Article column: ProjPlaats
I. 05/20 14:40:38. Article column: ProjectNr
I. 05/20 14:40:38. Article column: Discipline
I. 05/20 14:40:38. Article column: VolgNr
I. 05/20 14:40:38. Article column: ContGercNm
I. 05/20 14:40:38. Article column: OpnemerNm
I. 05/20 14:40:38. Article column: Monteur1Nm
I. 05/20 14:40:38. Article column: Monteur2Nm
I. 05/20 14:40:38. Article column: Monteur3Nm
I. 05/20 14:40:38. Article column: MutStamp
I. 05/20 14:40:38. Article column: MutDatum
I. 05/20 14:40:38. Article column: LocDKey
I. 05/20 14:40:38. Article column: DatumBespr
I. 05/20 14:40:38. Article column: ManDagen
I. 05/20 14:40:38. Article column: DatAanvang
I. 05/20 14:40:38. Article column: TydstipUur
I. 05/20 14:40:38. Article column: TydstipMin
I. 05/20 14:40:38. Article column: Contproj
I. 05/20 14:40:38. Article column: Contwerk
I. 05/20 14:40:38. Article column: TelContPrj
I. 05/20 14:40:38. Article column: TelWerkPrj
I. 05/20 14:40:38. Article column: ContGerco
I. 05/20 14:40:38. Article column: Opnemer
I. 05/20 14:40:38. Article column: Monteur1
I. 05/20 14:40:38. Article column: Monteur2
I. 05/20 14:40:38. Article column: Monteur3
I. 05/20 14:40:38. Article column: ChkVeilig
I. 05/20 14:40:38. Article column: ChkAanvul
I. 05/20 14:40:38. Article column: ChkRicht
I. 05/20 14:40:38. Article column: ChkIntro
I. 05/20 14:40:38. Article column: ChkOngeval
I. 05/20 14:40:38. Article column: ChkBescher
I. 05/20 14:40:38. Article column: ChkInstruc
I. 05/20 14:40:38. Article column: ChkAfval
I. 05/20 14:40:38. Article column: ChkCalcMit
I. 05/20 14:40:38. Article column: SpecAfspr
I. 05/20 14:40:38. Article column: SpecAfspr0
I. 05/20 14:40:38. Article column: Omschr0
I. 05/20 14:40:38. Article column: Maatregel0
I. 05/20 14:40:38. Article column: Bijzonder0
I. 05/20 14:40:38. Article column: CheckWerk
I. 05/20 14:40:38. Article column: OpdrGever
I. 05/20 14:40:38. Article column: PersNrCons
I. 05/20 14:40:38. Table Upload Order:
ritregistratie,pdapi
ncodes,userprops,bwf
,prijsdef,autos,pers
onen,calcregie,c
alcdetail,materiaal,
dagstaten,werkopdrac
ht
I. 05/20 14:40:38. Uploading table operations
I. 05/20 14:40:38. Upload operations on table 'ritregistratie'
I. 05/20 14:40:38. # rows inserted in table ritregistratie : 0
I. 05/20 14:40:38. # rows deleted in table ritregistratie : 0
I. 05/20 14:40:38. # rows updated in table ritregistratie : 0
I. 05/20 14:40:38. Upload operations on table 'pdapincodes'
I. 05/20 14:40:38. # rows inserted in table pdapincodes : 0
I. 05/20 14:40:38. # rows deleted in table pdapincodes : 0
I. 05/20 14:40:38. # rows updated in table pdapincodes : 0
I. 05/20 14:40:38. Upload operations on table 'userprops'
I. 05/20 14:40:38. # rows inserted in table userprops : 0
I. 05/20 14:40:38. # rows deleted in table userprops : 0
I. 05/20 14:40:38. # rows updated in table userprops : 0
I. 05/20 14:40:38. Upload operations on table 'bwf'
I. 05/20 14:40:38. # rows inserted in table bwf : 0
I. 05/20 14:40:38. # rows deleted in table bwf : 0
I. 05/20 14:40:38. # rows updated in table bwf : 0
I. 05/20 14:40:38. Upload operations on table 'prijsdef'
I. 05/20 14:40:38. # rows inserted in table prijsdef : 0
I. 05/20 14:40:38. # rows deleted in table prijsdef : 0
I. 05/20 14:40:38. # rows updated in table prijsdef : 0
I. 05/20 14:40:38. Upload operations on table 'autos'
I. 05/20 14:40:38. # rows inserted in table autos : 0
I. 05/20 14:40:38. # rows deleted in table autos : 0
I. 05/20 14:40:38. # rows updated in table autos : 0
I. 05/20 14:40:38. Upload operations on table 'personen'
I. 05/20 14:40:38. # rows inserted in table personen : 0
I. 05/20 14:40:38. # rows deleted in table personen : 0
I. 05/20 14:40:38. # rows updated in table personen : 0
I. 05/20 14:40:38. Upload operations on table 'calcregie'
I. 05/20 14:40:38. # rows inserted in table calcregie : 0
I. 05/20 14:40:38. # rows deleted in table calcregie : 0
I. 05/20 14:40:38. # rows updated in table calcregie : 0
I. 05/20 14:40:38. Upload operations on table 'calcdetail'
I. 05/20 14:40:38. # rows inserted in table calcdetail : 0
I. 05/20 14:40:38. # rows deleted in table calcdetail : 0
I. 05/20 14:40:38. # rows updated in table calcdetail : 0
I. 05/20 14:40:38. Upload operations on table 'materiaal'
I. 05/20 14:40:38. # rows inserted in table materiaal : 0
I. 05/20 14:40:38. # rows deleted in table materiaal : 0
I. 05/20 14:40:38. # rows updated in table materiaal : 0
I. 05/20 14:40:38. Upload operations on table 'dagstaten'
I. 05/20 14:40:38. # rows inserted in table dagstaten : 0
I. 05/20 14:40:38. # rows deleted in table dagstaten : 0
I. 05/20 14:40:38. # rows updated in table dagstaten : 0
I. 05/20 14:40:38. Upload operations on table 'werkopdracht'
I. 05/20 14:40:38. # rows inserted in table werkopdracht : 0
I. 05/20 14:40:38. # rows deleted in table werkopdracht : 0
I. 05/20 14:40:38. # rows updated in table werkopdracht : 0
I. 05/20 14:40:38. Upload ended at offset 0004424469
I. 05/20 14:40:38. Waiting for MobiLink to apply upload
I. 05/20 14:40:40. Download stream: received 30 bytes from MobiLink server.
I. 05/20 14:40:40. The user authentication value is 1000.
I. 05/20 14:40:40. Processing download stream ...
I. 05/20 14:40:40. Downloading into table: ritregistratie
I. 05/20 14:40:41. # rows inserted/updated into table ritregistratie : 0
I. 05/20 14:40:41. # rows deleted in table ritregistratie : 0
I. 05/20 14:40:41. Downloading into table: pdapincodes
I. 05/20 14:40:41. # rows inserted/updated into table pdapincodes : 0
I. 05/20 14:40:41. # rows deleted in table pdapincodes : 0
I. 05/20 14:40:41. Downloading into table: userprops
I. 05/20 14:40:41. # rows inserted/updated into table userprops : 0
I. 05/20 14:40:41. # rows deleted in table userprops : 0
I. 05/20 14:40:41. Downloading into table: bwf
I. 05/20 14:40:41. # rows inserted/updated into table bwf : 0
I. 05/20 14:40:42. # rows deleted in table bwf : 0
I. 05/20 14:40:42. Downloading into table: prijsdef
I. 05/20 14:40:42. # rows inserted/updated into table prijsdef : 0
I. 05/20 14:40:42. # rows deleted in table prijsdef : 0
I. 05/20 14:40:42. Downloading into table: autos
I. 05/20 14:40:42. # rows inserted/updated into table autos : 0
I. 05/20 14:40:42. # rows deleted in table autos : 0
I. 05/20 14:40:42. Downloading into table: personen
I. 05/20 14:40:42. # rows inserted/updated into table personen : 0
I. 05/20 14:40:42. # rows deleted in table personen : 0
I. 05/20 14:40:42. Downloading into table: calcregie
I. 05/20 14:40:43. # rows inserted/updated into table calcregie : 0
I. 05/20 14:40:43. # rows deleted in table calcregie : 0
I. 05/20 14:40:43. Downloading into table: calcdetail
I. 05/20 14:40:43. # rows inserted/updated into table calcdetail : 0
I. 05/20 14:40:43. # rows deleted in table calcdetail : 0
I. 05/20 14:40:43. Downloading into table: materiaal
I. 05/20 14:40:43. # rows inserted/updated into table materiaal : 0
I. 05/20 14:40:43. # rows deleted in table materiaal : 0
I. 05/20 14:40:43. Downloading into table: dagstaten
I. 05/20 14:40:43. # rows inserted/updated into table dagstaten : 0
I. 05/20 14:40:43. # rows deleted in table dagstaten : 0
I. 05/20 14:40:43. Downloading into table: werkopdracht
I. 05/20 14:40:43. # rows inserted/updated into table werkopdracht : 0
I. 05/20 14:40:44. # rows deleted in table werkopdracht : 0
I. 05/20 14:40:44. COMMIT
I. 05/20 14:40:44. Completed processing of download stream
I. 05/20 14:40:44. Sending an acknowledgment to the MobiLink server.
I. 05/20 14:40:44. End synchronizing 'gercomobile' for MobiLink user '537'
I. 05/20 14:40:44. Disconnecting from MobiLink server
I. 05/20 14:40:44. Synchronization completed
I. 05/20 14:40:44. Options in database for publication 'gercomobile':
I. 05/20 14:40:44. mp=sql;scn=ON;
I. 05/20 14:40:44. Disconnecting from remote database
| |
| R. van der Wiele 2005-05-20, 11:24 am |
| Oh sorry, btw: ASA 8.03.5002 (remote and consolidated)
"R. van der Wiele" <r.vd.wiele@aci.nl> wrote in message
news:428e1348@forums
-1-dub...
> I have a problem in that the consolidated database doesn't sync a (new)
row
> from table 'werkopdracht' to the remote database.
| |
| Greg Fenton 2005-05-23, 3:24 am |
| R. van der Wiele wrote:
> The script is:
> call ml_add_table_script(
'v1','werkopdracht',
'download_cursor', 'select *
> from werkopdracht where lastmodified>=? and persnrcons=?')
>
> Does someone knows what is wrong?
I cannot be sure what the problem is based on what you've posted. The
more appropriate log to be posting (in full verbose mode, -v+) is the ML
server log as that's where the download_cursor will be running (what you
have posted here is the client log, so we can only see that the row you
were expecting didn't get downloaded).
However, here are a couple of comments about your script:
- You should complete AVOID using "SELECT * " in source code. Always
specify the exact list of columns that you want. "*" is a short-cut for
when doing quick-and-dirty scripts interactively, but is a REALLY BAD
idea to have in source code for a number of reasons (unless your code is
actually scanning the meta-data of the result set and is set to handle
dynamic numbers and types of columns...)
- You almost certainly do *not* want the "lastmodified" column to be in
your remote database. It sole purpose is to identify when the row was
last updated *in the consolidated*.
Hope this is somewhat useful,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| R. van der Wiele 2005-05-23, 3:24 am |
| Hi Greg, thanks for the reply, the select statement indeed shows all columns
now, but that's going to be less,
at first I want the download to be working :)
The LastModified is only on the consolidated and not on the remote (thus,
thats OK).
I have the logfile from the mlserver at the end of this post, the only thing
that's concerning are 2
warning messages (from 2 other tables) '..has no entry in the ml_table
table'.
Ron van der Wiele
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42914f25@forums
-1-dub...
> R. van der Wiele wrote:
*[color=darkred]
>
> I cannot be sure what the problem is based on what you've posted. The
> more appropriate log to be posting (in full verbose mode, -v+) is the ML
> server log as that's where the download_cursor will be running (what you
> have posted here is the client log, so we can only see that the row you
> were expecting didn't get downloaded).
>
> However, here are a couple of comments about your script:
>
> - You should complete AVOID using "SELECT * " in source code. Always
> specify the exact list of columns that you want. "*" is a short-cut for
> when doing quick-and-dirty scripts interactively, but is a REALLY BAD
> idea to have in source code for a number of reasons (unless your code is
> actually scanning the meta-data of the result set and is set to handle
> dynamic numbers and types of columns...)
>
> - You almost certainly do *not* want the "lastmodified" column to be in
> your remote database. It sole purpose is to identify when the row was
> last updated *in the consolidated*.
>
>
> Hope this is somewhat useful,
> greg.fenton
====================
=====
MLSERVER LOGFILE:
====================
=====
I. 05/20 14:13:41. Adaptive Server Anywhere MobiLink Version 8.0.3.5002
I. 05/20 14:13:41.
I. 05/20 14:13:41. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 05/20 14:13:41. All rights reserved. All unpublished rights reserved.
I. 05/20 14:13:41.
I. 05/20 14:13:41. This software contains confidential and trade secret
information of
I. 05/20 14:13:41. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 05/20 14:13:41. by the U.S. Government is subject to restrictions set
forth in a license
I. 05/20 14:13:41. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 05/20 14:13:41. other written agreement specifying the Government's
rights to use the
I. 05/20 14:13:41. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 05/20 14:13:41.
I. 05/20 14:13:41. Sybase, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 05/20 14:13:41.
I. 05/20 14:13:41. Concurrent Seat model. Access to the server is limited to
1 concurrent seat(s).
This server is licensed to:
I. 05/20 14:13:41. Ron van der Wiele
I. 05/20 14:13:41. ACI
I. 05/20 14:13:41. <Main>: MobiLink server started
I. 05/20 14:13:41. <Main>: Option 1: -c
I. 05/20 14:13:41. <Main>: Option 2: ****************
I. 05/20 14:13:41. <Main>: Option 3: -v+
I. 05/20 14:13:41. <Main>: Option 4: -za
I. 05/20 14:13:41. <Main>: Option 5: -zu+
I. 05/20 14:13:41. <Main>: Verbose logging: show row values
I. 05/20 14:13:41. <Main>: Verbose logging: show script names when invoked
I. 05/20 14:13:41. <Main>: Verbose logging: show script contents when
invoked
I. 05/20 14:13:41. <Main>: Verbose logging: show schema for each table
I. 05/20 14:13:41. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 05/20 14:13:41. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 05/20 14:13:41. <Main>: Verbose logging: show rowcount values
I. 05/20 14:13:41. <Main>: Individual database connections will be closed
after synchronization errors.
I. 05/20 14:13:41. <Main>: BLOB cache size: 524288
I. 05/20 14:13:41. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 05/20 14:13:41. <Main>: Maximum number of database connections: 6
I. 05/20 14:13:41. <Main>: Maximum number of deadlock retries: 10
I. 05/20 14:13:41. <Main>: Timeout for inactive database connections: 60
minutes
I. 05/20 14:13:41. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 05/20 14:13:41. <Main>: Rowset size: 10
I. 05/20 14:13:41. <Main>: Upload cache size: 524288 bytes
I. 05/20 14:13:41. <Main>: Download cache size: 524288 bytes
I. 05/20 14:13:41. <Main>: Number of worker threads: 5
I. 05/20 14:13:41. <Main>: Maximum number of threads uploading concurrently:
5
W. 05/20 14:13:41. <Main>: Warning: Unknown users will be added
automatically (when there is no authenticate_user script).
I. 05/20 14:13:41. <Main>: Pass last download timestamp first.
I. 05/20 14:13:41. <Main>: Warning: Example scripts may be automatically
generated and activated for unknown versions.
I. 05/20 14:13:41. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 05/20 14:13:41. <Main>: Stream specifier 1: TCPIP
I. 05/20 14:13:41. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
I. 05/20 14:13:41. <Main>: ODBC DBMS Version: 08.00.0003
I. 05/20 14:13:41. <Main>: ODBC DBMS Driver Version: 08.00.0003
I. 05/20 14:13:41. <Main>: ODBC Version supported by the driver: 3.52
I. 05/20 14:13:41. <Main>: Collation sequence of the consolidated database
is 'cp1252'
I. 05/20 14:13:41. <Main>: Translated SQL:
set temporary option chained = 'ON'
I. 05/20 14:13:41. <Main>: ODBC isolation set to: Read Committed
I. 05/20 14:13:41. <Main>: Connected
I. 05/20 14:13:41. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 05/20 14:13:41. <thread 1.1>: Ready to handle requests
I. 05/20 14:13:41. <thread 1.2>: Ready to handle requests
I. 05/20 14:13:41. <thread 1.3>: Ready to handle requests
I. 05/20 14:13:41. <thread 1.4>: Ready to handle requests
I. 05/20 14:13:41. <thread 1.5>: Ready to handle requests
I. 05/20 14:43:16. <thread 1.5>: Working on a request
I. 05/20 14:43:17. <thread 1.5>: Translated SQL:
SELECT last_modified FROM ml_scripts_modified
I. 05/20 14:43:17. <thread 1.5>: ml_scripts_modified last modified at:
2005-03-25 10:22:54.000000
I. 05/20 14:43:17. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version WHERE name = ?
I. 05/20 14:43:17. <thread 1.5>: ASA synchronization request from: 537
(version: default)
I. 05/20 14:43:18. <1.5> [537]: Translated SQL:
set temporary option chained = 'ON'
I. 05/20 14:43:18. <1.5> [537]: ODBC isolation set to: Read Committed
I. 05/20 14:43:18. <1.5> [537]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_connection_script
t1, ml_script t2 WHERE t1.version_id = ? AND
t1.script_id = t2.script_id
I. 05/20 14:43:18. <1.5> [537]: begin_connection <connection> (no script)
I. 05/20 14:43:18. <1.5> [537]: COMMIT Transaction: begin_connection
I. 05/20 14:43:18. <1.5> [537]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 05/20 14:43:18. <1.5> [537]: Translated SQL:
SELECT user_id FROM ml_user WHERE name = ?
I. 05/20 14:43:18. <1.5> [537]: Publication #1: gercomobile, subscription
id: 9, last download time: 2005-05-20 11:03:38.106000
I. 05/20 14:43:18. <1.5> [537]: Table #1: ritregistratie, 8 columns
I. 05/20 14:43:18. <1.5> [537]: PersNr decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Tijd timestamp NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Afgelegd decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Snelheid decimal(3,0)
I. 05/20 14:43:18. <1.5> [537]: Locatie_Plts char(30)
I. 05/20 14:43:18. <1.5> [537]: Locatie_Strt char(30)
I. 05/20 14:43:18. <1.5> [537]: Locatie_Nr char(5)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #2: pdapincodes, 3 columns
I. 05/20 14:43:18. <1.5> [537]: medid char(6) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: pincode char(4)
I. 05/20 14:43:18. <1.5> [537]: persnrcons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #3: userprops, 3 columns
I. 05/20 14:43:18. <1.5> [537]: PersNr decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: AutoNr decimal(3,0)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #4: bwf, 4 columns
I. 05/20 14:43:18. <1.5> [537]: Code_BWF char(4) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Naam char(30)
I. 05/20 14:43:18. <1.5> [537]: BWF decimal(4,2)
I. 05/20 14:43:18. <1.5> [537]: Noteer283 decimal(2,0)
I. 05/20 14:43:18. <1.5> [537]: Table #5: prijsdef, 8 columns
I. 05/20 14:43:18. <1.5> [537]: PrijsCode char(5) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Omschr char(30)
I. 05/20 14:43:18. <1.5> [537]: FlagLengte integer
I. 05/20 14:43:18. <1.5> [537]: FlagBreedt integer
I. 05/20 14:43:18. <1.5> [537]: FlagPrijs integer
I. 05/20 14:43:18. <1.5> [537]: FormuleCod char(1)
I. 05/20 14:43:18. <1.5> [537]: Noteer291 decimal(2,0)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #6: autos, 6 columns
I. 05/20 14:43:18. <1.5> [537]: AutoDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: AutoNr decimal(3,0)
I. 05/20 14:43:18. <1.5> [537]: PersDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: PersNr decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Kenteken char(8)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #7: personen, 8 columns
I. 05/20 14:43:18. <1.5> [537]: PersDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: PersNr decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Naam char(30)
I. 05/20 14:43:18. <1.5> [537]: Adres char(30)
I. 05/20 14:43:18. <1.5> [537]: PostCode char(6)
I. 05/20 14:43:18. <1.5> [537]: WoonPlaats char(30)
I. 05/20 14:43:18. <1.5> [537]: Telefoon char(16)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #8: calcregie, 25 columns
I. 05/20 14:43:18. <1.5> [537]: CalcDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: DagsDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: MutStamp char(12)
I. 05/20 14:43:18. <1.5> [537]: RegelNr decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Code_AE char(1)
I. 05/20 14:43:18. <1.5> [537]: Nummer char(6)
I. 05/20 14:43:18. <1.5> [537]: Locatie char(30)
I. 05/20 14:43:18. <1.5> [537]: Tekst char(100)
I. 05/20 14:43:18. <1.5> [537]: BWF decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Code_BWF char(4)
I. 05/20 14:43:18. <1.5> [537]: MF decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: WPV char(1)
I. 05/20 14:43:18. <1.5> [537]: Lengte decimal(5,0)
I. 05/20 14:43:18. <1.5> [537]: Breedte decimal(5,0)
I. 05/20 14:43:18. <1.5> [537]: Prijs decimal(10,0)
I. 05/20 14:43:18. <1.5> [537]: Aantal decimal(7,0)
I. 05/20 14:43:18. <1.5> [537]: Totaal decimal(10,0)
I. 05/20 14:43:18. <1.5> [537]: PrijsRest decimal(10,0)
I. 05/20 14:43:18. <1.5> [537]: AantRest decimal(7,0)
I. 05/20 14:43:18. <1.5> [537]: PrijsAf decimal(10,0)
I. 05/20 14:43:18. <1.5> [537]: AantAf decimal(7,0)
I. 05/20 14:43:18. <1.5> [537]: SparingNr decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: SparGereed integer
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #9: calcdetail, 11 columns
I. 05/20 14:43:18. <1.5> [537]: Calc2DKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: CalcDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: DagsDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: MutStamp char(12)
I. 05/20 14:43:18. <1.5> [537]: PrijsAf decimal(13,5)
I. 05/20 14:43:18. <1.5> [537]: AantAf decimal(7,2)
I. 05/20 14:43:18. <1.5> [537]: RegelNr decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: AantRest decimal(7,2)
I. 05/20 14:43:18. <1.5> [537]: Locatie char(30)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #10: materiaal, 9 columns
I. 05/20 14:43:18. <1.5> [537]: ArtDkey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: MutStamp char(12)
I. 05/20 14:43:18. <1.5> [537]: ArtikelCod char(6)
I. 05/20 14:43:18. <1.5> [537]: Eenheid char(8)
I. 05/20 14:43:18. <1.5> [537]: Verbruik decimal(7,2)
I. 05/20 14:43:18. <1.5> [537]: Bedrag decimal(8,2)
I. 05/20 14:43:18. <1.5> [537]: Omschrijv char(50)
I. 05/20 14:43:18. <1.5> [537]: VVPrijs decimal(8,2)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #11: dagstaten, 42 columns
I. 05/20 14:43:18. <1.5> [537]: DagsDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: AanvDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: ProjDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: PersDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: AutoDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: MutStamp char(12)
I. 05/20 14:43:18. <1.5> [537]: ProjectNr decimal(6,0)
I. 05/20 14:43:18. <1.5> [537]: Discipline char(4)
I. 05/20 14:43:18. <1.5> [537]: LocVolgNr decimal(2,0)
I. 05/20 14:43:18. <1.5> [537]: Datum date
I. 05/20 14:43:18. <1.5> [537]: KMS decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Inzittend decimal(1,0)
I. 05/20 14:43:18. <1.5> [537]: Rijdingev integer
I. 05/20 14:43:18. <1.5> [537]: Begintijd decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: Invoertijd decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: UrenNetto decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: UrenTot decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: UrenMand decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: ReisUren decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: AfWijk integer
I. 05/20 14:43:18. <1.5> [537]: DagOmzet decimal(14,5)
I. 05/20 14:43:18. <1.5> [537]: Matverbr decimal(11,2)
I. 05/20 14:43:18. <1.5> [537]: LunchUren decimal(4,2)
I. 05/20 14:43:18. <1.5> [537]: ByzUren decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: VerrekPkm decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: KstPrsAuto decimal(5,0)
I. 05/20 14:43:18. <1.5> [537]: KstReisUur decimal(6,2)
I. 05/20 14:43:18. <1.5> [537]: KstWerkUur decimal(7,2)
I. 05/20 14:43:18. <1.5> [537]: Reizen integer
I. 05/20 14:43:18. <1.5> [537]: DagomzetRG decimal(11,2)
I. 05/20 14:43:18. <1.5> [537]: DagomzetDR decimal(14,5)
I. 05/20 14:43:18. <1.5> [537]: PersUurSel integer
I. 05/20 14:43:18. <1.5> [537]: BoordComp char(1)
I. 05/20 14:43:18. <1.5> [537]: KMSPrive decimal(4,0)
I. 05/20 14:43:18. <1.5> [537]: Ingelezen integer
I. 05/20 14:43:18. <1.5> [537]: Aangenomen integer
I. 05/20 14:43:18. <1.5> [537]: TotUrenBC decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: ReisUrenBC decimal(5,2)
I. 05/20 14:43:18. <1.5> [537]: UitBWrk decimal(13,2)
I. 05/20 14:43:18. <1.5> [537]: LoginNaam char(10)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Table #12: werkopdracht, 47 columns
I. 05/20 14:43:18. <1.5> [537]: WerkDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: ProjNaam char(30)
I. 05/20 14:43:18. <1.5> [537]: ProjAdres char(30)
I. 05/20 14:43:18. <1.5> [537]: ProjPCode char(30)
I. 05/20 14:43:18. <1.5> [537]: ProjPlaats char(30)
I. 05/20 14:43:18. <1.5> [537]: ProjectNr decimal(6,0)
I. 05/20 14:43:18. <1.5> [537]: Discipline char(4)
I. 05/20 14:43:18. <1.5> [537]: VolgNr decimal(2,0)
I. 05/20 14:43:18. <1.5> [537]: ContGercNm char(30)
I. 05/20 14:43:18. <1.5> [537]: OpnemerNm char(30)
I. 05/20 14:43:18. <1.5> [537]: Monteur1Nm char(30)
I. 05/20 14:43:18. <1.5> [537]: Monteur2Nm char(30)
I. 05/20 14:43:18. <1.5> [537]: Monteur3Nm char(30)
I. 05/20 14:43:18. <1.5> [537]: MutStamp char(11)
I. 05/20 14:43:18. <1.5> [537]: MutDatum date
I. 05/20 14:43:18. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: DatumBespr date
I. 05/20 14:43:18. <1.5> [537]: ManDagen decimal(7,2)
I. 05/20 14:43:18. <1.5> [537]: DatAanvang date
I. 05/20 14:43:18. <1.5> [537]: TydstipUur decimal(2,0)
I. 05/20 14:43:18. <1.5> [537]: TydstipMin decimal(2,0)
I. 05/20 14:43:18. <1.5> [537]: Contproj char(30)
I. 05/20 14:43:18. <1.5> [537]: Contwerk char(30)
I. 05/20 14:43:18. <1.5> [537]: TelContPrj char(15)
I. 05/20 14:43:18. <1.5> [537]: TelWerkPrj char(15)
I. 05/20 14:43:18. <1.5> [537]: ContGerco decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: Opnemer decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: Monteur1 decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: Monteur2 decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: Monteur3 decimal(11,0)
I. 05/20 14:43:18. <1.5> [537]: ChkVeilig integer
I. 05/20 14:43:18. <1.5> [537]: ChkAanvul integer
I. 05/20 14:43:18. <1.5> [537]: ChkRicht integer
I. 05/20 14:43:18. <1.5> [537]: ChkIntro integer
I. 05/20 14:43:18. <1.5> [537]: ChkOngeval integer
I. 05/20 14:43:18. <1.5> [537]: ChkBescher integer
I. 05/20 14:43:18. <1.5> [537]: ChkInstruc integer
I. 05/20 14:43:18. <1.5> [537]: ChkAfval integer
I. 05/20 14:43:18. <1.5> [537]: ChkCalcMit integer
I. 05/20 14:43:18. <1.5> [537]: SpecAfspr integer
I. 05/20 14:43:18. <1.5> [537]: SpecAfspr0 char(300)
I. 05/20 14:43:18. <1.5> [537]: Omschr0 char(300)
I. 05/20 14:43:18. <1.5> [537]: Maatregel0 char(300)
I. 05/20 14:43:18. <1.5> [537]: Bijzonder0 char(300)
I. 05/20 14:43:18. <1.5> [537]: CheckWerk integer
I. 05/20 14:43:18. <1.5> [537]: OpdrGever char(40)
I. 05/20 14:43:18. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 14:43:18. <1.5> [537]: Translated SQL:
SELECT progress FROM ml_subscription WHERE user_id = ?
AND publication_name = ?
I. 05/20 14:43:18. <1.5> [537]: Cached ODBC statement:
SELECT progress FROM ml_subscription WHERE user_id = ?
AND publication_name = ?
I. 05/20 14:43:18. <1.5> [537]: Progress offsets for the publications that
are explicitly involved in the current synchronization
I. 05/20 14:43:18. <1.5> [537]: Subscription id 9: consolidated progress
4424307 and remote progress 4424307
I. 05/20 14:43:18. <1.5> [537]: Progress offsets for the publications that
are not explicitly involved in the current synchronization
I. 05/20 14:43:19. <1.5> [537]: Subscription id 12: consolidated progress 0
and remote progress 4420639
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
SELECT table_id FROM ml_table WHERE name = ?
W. 05/20 14:43:19. <1.5> [537]: Warning: [10024] Table "ritregistratie" has
no entry in the ml_table table
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
W. 05/20 14:43:19. <1.5> [537]: Warning: [10024] Table "userprops" has no
entry in the ml_table table
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n <connection> (no
script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n pdapincodes (no
script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n autos (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n personen (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 14:43:19. <1.5> [537]: begin_synchronizatio
n werkopdracht (no
script)
I. 05/20 14:43:19. <1.5> [537]: COMMIT Transaction: begin_synchronizatio
n
I. 05/20 14:43:19. <1.5> [537]: begin_upload <connection> (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload autos (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload personen (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it0
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it0
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it1
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it1
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it2
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it2
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it3
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it3
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it4
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it4
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows autos (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it5
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it5
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows autos (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows personen (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it6
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it6
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows personen (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it7
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it7
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it8
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it8
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it9
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it9
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it10
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it10
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_upload_rows werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
savepoint it11
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
release savepoint it11
I. 05/20 14:43:19. <1.5> [537]: end_upload_rows werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload autos (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload personen (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: end_upload <connection> (no script)
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table ritregistratie :
0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table ritregistratie :
0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table ritregistratie :
0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table calcregie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table calcregie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table calcregie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table calcregie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table calcregie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table calcregie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table calcdetail : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table calcdetail : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table calcdetail : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table calcdetail : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table calcdetail : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table calcdetail : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table materiaal : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table materiaal : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table materiaal : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table materiaal : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table materiaal : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table materiaal : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table dagstaten : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table dagstaten : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table dagstaten : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table dagstaten : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table dagstaten : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table dagstaten : 0
I. 05/20 14:43:19. <1.5> [537]: # rows uploaded into table werkopdracht : 0
I. 05/20 14:43:19. <1.5> [537]: # rows inserted into table werkopdracht : 0
I. 05/20 14:43:19. <1.5> [537]: # rows deleted in table werkopdracht : 0
I. 05/20 14:43:19. <1.5> [537]: # rows updated into table werkopdracht : 0
I. 05/20 14:43:19. <1.5> [537]: # rows conflicted in table werkopdracht : 0
I. 05/20 14:43:19. <1.5> [537]: # rows ignored in table werkopdracht : 0
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
UPDATE ml_subscription SET progress = ? WHERE user_id = ?
AND publication_name = ?
I. 05/20 14:43:19. <1.5> [537]: COMMIT Transaction: end_upload
I. 05/20 14:43:19. <1.5> [537]: Translated SQL:
SELECT NOW(*)
I. 05/20 14:43:19. <1.5> [537]: begin_download <connection> (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download autos (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download personen (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: Sending the download to the remote database.
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es pdapincodes (no
script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es autos (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
autos (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows autos (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows autos (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es personen (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
personen (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows personen (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows personen (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es calcdetail (no
script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_delet
es werkopdracht (no
script)
I. 05/20 14:43:19. <1.5> [537]: end_download_deletes
werkopdracht (no
script)
I. 05/20 14:43:19. <1.5> [537]: begin_download_rows werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download_rows werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download pdapincodes (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download bwf (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download prijsdef (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download autos (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download personen (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download calcregie (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download calcdetail (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download materiaal (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download dagstaten (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download werkopdracht (no script)
I. 05/20 14:43:19. <1.5> [537]: end_download <connection> (no script)
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table
ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows filtered for download from table
ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded to remote from table
ritregistratie : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table
pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows filtered for download from table
pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded to remote from table
pdapincodes : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table
userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows filtered for download from table
userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded to remote from table
userprops : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table bwf
: 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table bwf : 0
I. 05/20 14:43:19. <1.5> [537]: # rows filtered for download from table bwf
: 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded to remote from table bwf :
0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table
prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows filtered for download from table
prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded to remote from table
prijsdef : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table
autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows filtered for download from table
autos : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded to remote from table autos
: 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for delete from table
personen : 0
I. 05/20 14:43:19. <1.5> [537]: # rows downloaded for insert/update from
table personen : 0
I. 05/20 14:43:20. <1.5> [537]: # rows filtered for download from table
personen : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded to remote from table
personen : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for delete from table
calcregie : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for insert/update from
table calcregie : 0
I. 05/20 14:43:20. <1.5> [537]: # rows filtered for download from table
calcregie : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded to remote from table
calcregie : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for delete from table
calcdetail : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for insert/update from
table calcdetail : 0
I. 05/20 14:43:20. <1.5> [537]: # rows filtered for download from table
calcdetail : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded to remote from table
calcdetail : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for delete from table
materiaal : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for insert/update from
table materiaal : 0
I. 05/20 14:43:20. <1.5> [537]: # rows filtered for download from table
materiaal : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded to remote from table
materiaal : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for delete from table
dagstaten : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for insert/update from
table dagstaten : 0
I. 05/20 14:43:20. <1.5> [537]: # rows filtered for download from table
dagstaten : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded to remote from table
dagstaten : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for delete from table
werkopdracht : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded for insert/update from
table werkopdracht : 0
I. 05/20 14:43:20. <1.5> [537]: # rows filtered for download from table
werkopdracht : 0
I. 05/20 14:43:20. <1.5> [537]: # rows downloaded to remote from table
werkopdracht : 0
I. 05/20 14:43:23. <1.5> [537]: COMMIT Transaction: end_download
I. 05/20 14:43:23. <1.5> [537]: end_synchronization pdapincodes (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization bwf (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization prijsdef (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization autos (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization personen (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization calcregie (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization calcdetail (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization materiaal (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization dagstaten (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization werkopdracht (no script)
I. 05/20 14:43:23. <1.5> [537]: end_synchronization <connection> (no script)
I. 05/20 14:43:23. <1.5> [537]: COMMIT Transaction: end_synchronization
I. 05/20 14:43:23. <1.5> [537]: Synchronization complete
I. 05/20 14:47:50. <Main>: MobiLink server shutting down
I. 05/20 14:47:50. <Main>: MobiLink server undergoing hard shutdown.
I. 05/20 14:47:50. <Main>: All connections and synchronizations being
terminated.
I. 05/20 14:47:52. <thread 1.5>: Shutting down
I. 05/20 14:47:52. <thread 1.4>: Shutting down
I. 05/20 14:47:52. <thread 1.3>: Shutting down
I. 05/20 14:47:52. <thread 1.2>: Shutting down
I. 05/20 14:47:52. <thread 1.1>: Shutting down
I. 05/20 14:47:52. <Main>: end_connection <connection> (no script)
I. 05/20 14:47:52. <Main>: COMMIT Transaction: end_connection
I. 05/20 14:47:52. <Main>: Disconnected from consolidated database
I. 05/20 14:47:52. <Main>: Disconnected
I. 05/20 14:47:52. <Main>: MobiLink server finished
I. 05/20 16:01:02. Adaptive Server Anywhere MobiLink Version 8.0.3.5002
I. 05/20 16:01:02.
I. 05/20 16:01:02. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 05/20 16:01:02. All rights reserved. All unpublished rights reserved.
I. 05/20 16:01:02.
I. 05/20 16:01:02. This software contains confidential and trade secret
information of
I. 05/20 16:01:02. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 05/20 16:01:02. by the U.S. Government is subject to restrictions set
forth in a license
I. 05/20 16:01:02. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 05/20 16:01:02. other written agreement specifying the Government's
rights to use the
I. 05/20 16:01:02. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 05/20 16:01:02.
I. 05/20 16:01:02. Sybase, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 05/20 16:01:02.
I. 05/20 16:01:02. Concurrent Seat model. Access to the server is limited to
1 concurrent seat(s).
This server is licensed to:
I. 05/20 16:01:02. Ron van der Wiele
I. 05/20 16:01:02. ACI
I. 05/20 16:01:02. <Main>: MobiLink server started
I. 05/20 16:01:02. <Main>: Option 1: -c
I. 05/20 16:01:02. <Main>: Option 2: ****************
I. 05/20 16:01:02. <Main>: Option 3: -v+
I. 05/20 16:01:02. <Main>: Option 4: -za
I. 05/20 16:01:02. <Main>: Option 5: -zu+
I. 05/20 16:01:02. <Main>: Verbose logging: show row values
I. 05/20 16:01:02. <Main>: Verbose logging: show script names when invoked
I. 05/20 16:01:02. <Main>: Verbose logging: show script contents when
invoked
I. 05/20 16:01:02. <Main>: Verbose logging: show schema for each table
I. 05/20 16:01:02. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 05/20 16:01:02. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 05/20 16:01:02. <Main>: Verbose logging: show rowcount values
I. 05/20 16:01:02. <Main>: Individual database connections will be closed
after synchronization errors.
I. 05/20 16:01:02. <Main>: BLOB cache size: 524288
I. 05/20 16:01:02. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 05/20 16:01:02. <Main>: Maximum number of database connections: 6
I. 05/20 16:01:02. <Main>: Maximum number of deadlock retries: 10
I. 05/20 16:01:02. <Main>: Timeout for inactive database connections: 60
minutes
I. 05/20 16:01:02. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 05/20 16:01:02. <Main>: Rowset size: 10
I. 05/20 16:01:02. <Main>: Upload cache size: 524288 bytes
I. 05/20 16:01:02. <Main>: Download cache size: 524288 bytes
I. 05/20 16:01:02. <Main>: Number of worker threads: 5
I. 05/20 16:01:02. <Main>: Maximum number of threads uploading concurrently:
5
W. 05/20 16:01:02. <Main>: Warning: Unknown users will be added
automatically (when there is no authenticate_user script).
I. 05/20 16:01:02. <Main>: Pass last download timestamp first.
I. 05/20 16:01:02. <Main>: Warning: Example scripts may be automatically
generated and activated for unknown versions.
I. 05/20 16:01:02. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 05/20 16:01:02. <Main>: Stream specifier 1: TCPIP
I. 05/20 16:01:03. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
I. 05/20 16:01:03. <Main>: ODBC DBMS Version: 08.00.0003
I. 05/20 16:01:03. <Main>: ODBC DBMS Driver Version: 08.00.0003
I. 05/20 16:01:03. <Main>: ODBC Version supported by the driver: 3.52
I. 05/20 16:01:03. <Main>: Collation sequence of the consolidated database
is 'cp1252'
I. 05/20 16:01:03. <Main>: Translated SQL:
set temporary option chained = 'ON'
I. 05/20 16:01:03. <Main>: ODBC isolation set to: Read Committed
I. 05/20 16:01:03. <Main>: Connected
I. 05/20 16:01:03. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 05/20 16:01:03. <thread 1.1>: Ready to handle requests
I. 05/20 16:01:03. <thread 1.2>: Ready to handle requests
I. 05/20 16:01:03. <thread 1.3>: Ready to handle requests
I. 05/20 16:01:03. <thread 1.4>: Ready to handle requests
I. 05/20 16:01:03. <thread 1.5>: Ready to handle requests
I. 05/20 16:01:26. <thread 1.5>: Working on a request
I. 05/20 16:01:26. <thread 1.5>: Translated SQL:
SELECT last_modified FROM ml_scripts_modified
I. 05/20 16:01:26. <thread 1.5>: ml_scripts_modified last modified at:
2005-03-25 10:22:54.000000
I. 05/20 16:01:26. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version WHERE name = ?
I. 05/20 16:01:26. <thread 1.5>: ASA synchronization request from: 537
(version: default)
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
set temporary option chained = 'ON'
I. 05/20 16:01:27. <1.5> [537]: ODBC isolation set to: Read Committed
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_connection_script
t1, ml_script t2 WHERE t1.version_id = ? AND
t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_connection <connection> (no script)
I. 05/20 16:01:27. <1.5> [537]: COMMIT Transaction: begin_connection
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
SELECT user_id FROM ml_user WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Publication #1: gercomobile, subscription
id: 9, last download time: 2005-05-20 14:43:19.606000
I. 05/20 16:01:27. <1.5> [537]: Table #1: ritregistratie, 8 columns
I. 05/20 16:01:27. <1.5> [537]: PersNr decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Tijd timestamp NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Afgelegd decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Snelheid decimal(3,0)
I. 05/20 16:01:27. <1.5> [537]: Locatie_Plts char(30)
I. 05/20 16:01:27. <1.5> [537]: Locatie_Strt char(30)
I. 05/20 16:01:27. <1.5> [537]: Locatie_Nr char(5)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #2: pdapincodes, 3 columns
I. 05/20 16:01:27. <1.5> [537]: medid char(6) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: pincode char(4)
I. 05/20 16:01:27. <1.5> [537]: persnrcons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #3: userprops, 3 columns
I. 05/20 16:01:27. <1.5> [537]: PersNr decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: AutoNr decimal(3,0)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #4: bwf, 4 columns
I. 05/20 16:01:27. <1.5> [537]: Code_BWF char(4) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Naam char(30)
I. 05/20 16:01:27. <1.5> [537]: BWF decimal(4,2)
I. 05/20 16:01:27. <1.5> [537]: Noteer283 decimal(2,0)
I. 05/20 16:01:27. <1.5> [537]: Table #5: prijsdef, 8 columns
I. 05/20 16:01:27. <1.5> [537]: PrijsCode char(5) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Omschr char(30)
I. 05/20 16:01:27. <1.5> [537]: FlagLengte integer
I. 05/20 16:01:27. <1.5> [537]: FlagBreedt integer
I. 05/20 16:01:27. <1.5> [537]: FlagPrijs integer
I. 05/20 16:01:27. <1.5> [537]: FormuleCod char(1)
I. 05/20 16:01:27. <1.5> [537]: Noteer291 decimal(2,0)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #6: autos, 6 columns
I. 05/20 16:01:27. <1.5> [537]: AutoDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: AutoNr decimal(3,0)
I. 05/20 16:01:27. <1.5> [537]: PersDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: PersNr decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Kenteken char(8)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #7: personen, 8 columns
I. 05/20 16:01:27. <1.5> [537]: PersDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: PersNr decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Naam char(30)
I. 05/20 16:01:27. <1.5> [537]: Adres char(30)
I. 05/20 16:01:27. <1.5> [537]: PostCode char(6)
I. 05/20 16:01:27. <1.5> [537]: WoonPlaats char(30)
I. 05/20 16:01:27. <1.5> [537]: Telefoon char(16)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #8: calcregie, 25 columns
I. 05/20 16:01:27. <1.5> [537]: CalcDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: DagsDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: MutStamp char(12)
I. 05/20 16:01:27. <1.5> [537]: RegelNr decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Code_AE char(1)
I. 05/20 16:01:27. <1.5> [537]: Nummer char(6)
I. 05/20 16:01:27. <1.5> [537]: Locatie char(30)
I. 05/20 16:01:27. <1.5> [537]: Tekst char(100)
I. 05/20 16:01:27. <1.5> [537]: BWF decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Code_BWF char(4)
I. 05/20 16:01:27. <1.5> [537]: MF decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: WPV char(1)
I. 05/20 16:01:27. <1.5> [537]: Lengte decimal(5,0)
I. 05/20 16:01:27. <1.5> [537]: Breedte decimal(5,0)
I. 05/20 16:01:27. <1.5> [537]: Prijs decimal(10,0)
I. 05/20 16:01:27. <1.5> [537]: Aantal decimal(7,0)
I. 05/20 16:01:27. <1.5> [537]: Totaal decimal(10,0)
I. 05/20 16:01:27. <1.5> [537]: PrijsRest decimal(10,0)
I. 05/20 16:01:27. <1.5> [537]: AantRest decimal(7,0)
I. 05/20 16:01:27. <1.5> [537]: PrijsAf decimal(10,0)
I. 05/20 16:01:27. <1.5> [537]: AantAf decimal(7,0)
I. 05/20 16:01:27. <1.5> [537]: SparingNr decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: SparGereed integer
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #9: calcdetail, 11 columns
I. 05/20 16:01:27. <1.5> [537]: Calc2DKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: CalcDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: DagsDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: MutStamp char(12)
I. 05/20 16:01:27. <1.5> [537]: PrijsAf decimal(13,5)
I. 05/20 16:01:27. <1.5> [537]: AantAf decimal(7,2)
I. 05/20 16:01:27. <1.5> [537]: RegelNr decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: AantRest decimal(7,2)
I. 05/20 16:01:27. <1.5> [537]: Locatie char(30)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #10: materiaal, 9 columns
I. 05/20 16:01:27. <1.5> [537]: ArtDkey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: MutStamp char(12)
I. 05/20 16:01:27. <1.5> [537]: ArtikelCod char(6)
I. 05/20 16:01:27. <1.5> [537]: Eenheid char(8)
I. 05/20 16:01:27. <1.5> [537]: Verbruik decimal(7,2)
I. 05/20 16:01:27. <1.5> [537]: Bedrag decimal(8,2)
I. 05/20 16:01:27. <1.5> [537]: Omschrijv char(50)
I. 05/20 16:01:27. <1.5> [537]: VVPrijs decimal(8,2)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #11: dagstaten, 42 columns
I. 05/20 16:01:27. <1.5> [537]: DagsDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: AanvDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: ProjDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: PersDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: AutoDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: MutStamp char(12)
I. 05/20 16:01:27. <1.5> [537]: ProjectNr decimal(6,0)
I. 05/20 16:01:27. <1.5> [537]: Discipline char(4)
I. 05/20 16:01:27. <1.5> [537]: LocVolgNr decimal(2,0)
I. 05/20 16:01:27. <1.5> [537]: Datum date
I. 05/20 16:01:27. <1.5> [537]: KMS decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Inzittend decimal(1,0)
I. 05/20 16:01:27. <1.5> [537]: Rijdingev integer
I. 05/20 16:01:27. <1.5> [537]: Begintijd decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: Invoertijd decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: UrenNetto decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: UrenTot decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: UrenMand decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: ReisUren decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: AfWijk integer
I. 05/20 16:01:27. <1.5> [537]: DagOmzet decimal(14,5)
I. 05/20 16:01:27. <1.5> [537]: Matverbr decimal(11,2)
I. 05/20 16:01:27. <1.5> [537]: LunchUren decimal(4,2)
I. 05/20 16:01:27. <1.5> [537]: ByzUren decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: VerrekPkm decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: KstPrsAuto decimal(5,0)
I. 05/20 16:01:27. <1.5> [537]: KstReisUur decimal(6,2)
I. 05/20 16:01:27. <1.5> [537]: KstWerkUur decimal(7,2)
I. 05/20 16:01:27. <1.5> [537]: Reizen integer
I. 05/20 16:01:27. <1.5> [537]: DagomzetRG decimal(11,2)
I. 05/20 16:01:27. <1.5> [537]: DagomzetDR decimal(14,5)
I. 05/20 16:01:27. <1.5> [537]: PersUurSel integer
I. 05/20 16:01:27. <1.5> [537]: BoordComp char(1)
I. 05/20 16:01:27. <1.5> [537]: KMSPrive decimal(4,0)
I. 05/20 16:01:27. <1.5> [537]: Ingelezen integer
I. 05/20 16:01:27. <1.5> [537]: Aangenomen integer
I. 05/20 16:01:27. <1.5> [537]: TotUrenBC decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: ReisUrenBC decimal(5,2)
I. 05/20 16:01:27. <1.5> [537]: UitBWrk decimal(13,2)
I. 05/20 16:01:27. <1.5> [537]: LoginNaam char(10)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Table #12: werkopdracht, 47 columns
I. 05/20 16:01:27. <1.5> [537]: WerkDKey decimal(11,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: ProjNaam char(30)
I. 05/20 16:01:27. <1.5> [537]: ProjAdres char(30)
I. 05/20 16:01:27. <1.5> [537]: ProjPCode char(30)
I. 05/20 16:01:27. <1.5> [537]: ProjPlaats char(30)
I. 05/20 16:01:27. <1.5> [537]: ProjectNr decimal(6,0)
I. 05/20 16:01:27. <1.5> [537]: Discipline char(4)
I. 05/20 16:01:27. <1.5> [537]: VolgNr decimal(2,0)
I. 05/20 16:01:27. <1.5> [537]: ContGercNm char(30)
I. 05/20 16:01:27. <1.5> [537]: OpnemerNm char(30)
I. 05/20 16:01:27. <1.5> [537]: Monteur1Nm char(30)
I. 05/20 16:01:27. <1.5> [537]: Monteur2Nm char(30)
I. 05/20 16:01:27. <1.5> [537]: Monteur3Nm char(30)
I. 05/20 16:01:27. <1.5> [537]: MutStamp char(11)
I. 05/20 16:01:27. <1.5> [537]: MutDatum date
I. 05/20 16:01:27. <1.5> [537]: LocDKey decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: DatumBespr date
I. 05/20 16:01:27. <1.5> [537]: ManDagen decimal(7,2)
I. 05/20 16:01:27. <1.5> [537]: DatAanvang date
I. 05/20 16:01:27. <1.5> [537]: TydstipUur decimal(2,0)
I. 05/20 16:01:27. <1.5> [537]: TydstipMin decimal(2,0)
I. 05/20 16:01:27. <1.5> [537]: Contproj char(30)
I. 05/20 16:01:27. <1.5> [537]: Contwerk char(30)
I. 05/20 16:01:27. <1.5> [537]: TelContPrj char(15)
I. 05/20 16:01:27. <1.5> [537]: TelWerkPrj char(15)
I. 05/20 16:01:27. <1.5> [537]: ContGerco decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: Opnemer decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: Monteur1 decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: Monteur2 decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: Monteur3 decimal(11,0)
I. 05/20 16:01:27. <1.5> [537]: ChkVeilig integer
I. 05/20 16:01:27. <1.5> [537]: ChkAanvul integer
I. 05/20 16:01:27. <1.5> [537]: ChkRicht integer
I. 05/20 16:01:27. <1.5> [537]: ChkIntro integer
I. 05/20 16:01:27. <1.5> [537]: ChkOngeval integer
I. 05/20 16:01:27. <1.5> [537]: ChkBescher integer
I. 05/20 16:01:27. <1.5> [537]: ChkInstruc integer
I. 05/20 16:01:27. <1.5> [537]: ChkAfval integer
I. 05/20 16:01:27. <1.5> [537]: ChkCalcMit integer
I. 05/20 16:01:27. <1.5> [537]: SpecAfspr integer
I. 05/20 16:01:27. <1.5> [537]: SpecAfspr0 char(300)
I. 05/20 16:01:27. <1.5> [537]: Omschr0 char(300)
I. 05/20 16:01:27. <1.5> [537]: Maatregel0 char(300)
I. 05/20 16:01:27. <1.5> [537]: Bijzonder0 char(300)
I. 05/20 16:01:27. <1.5> [537]: CheckWerk integer
I. 05/20 16:01:27. <1.5> [537]: OpdrGever char(40)
I. 05/20 16:01:27. <1.5> [537]: PersNrCons decimal(4,0) NOT NULL PRIMARY KEY
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
SELECT progress FROM ml_subscription WHERE user_id = ?
AND publication_name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT progress FROM ml_subscription WHERE user_id = ?
AND publication_name = ?
I. 05/20 16:01:27. <1.5> [537]: Progress offsets for the publications that
are explicitly involved in the current synchronization
I. 05/20 16:01:27. <1.5> [537]: Subscription id 9: consolidated progress
4424469 and remote progress 4424469
I. 05/20 16:01:27. <1.5> [537]: Progress offsets for the publications that
are not explicitly involved in the current synchronization
I. 05/20 16:01:27. <1.5> [537]: Subscription id 12: consolidated progress 0
and remote progress 4420639
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
SELECT table_id FROM ml_table WHERE name = ?
W. 05/20 16:01:27. <1.5> [537]: Warning: [10024] Table "ritregistratie" has
no entry in the ml_table table
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
W. 05/20 16:01:27. <1.5> [537]: Warning: [10024] Table "userprops" has no
entry in the ml_table table
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n <connection> (no
script)
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n pdapincodes (no
script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n bwf (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n prijsdef (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n autos (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n personen (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n calcregie (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n calcdetail (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n materiaal (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n dagstaten (no script)
I. 05/20 16:01:27. <1.5> [537]: Cached ODBC statement:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND t1.version_id = ?
AND t1.script_id = t2.script_id
I. 05/20 16:01:27. <1.5> [537]: begin_synchronizatio
n werkopdracht (no
script)
I. 05/20 16:01:27. <1.5> [537]: COMMIT Transaction: begin_synchronizatio
n
I. 05/20 16:01:27. <1.5> [537]: begin_upload <connection> (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload pdapincodes (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload bwf (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload prijsdef (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload autos (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload personen (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload calcregie (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload calcdetail (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload materiaal (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload dagstaten (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload werkopdracht (no script)
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
savepoint it0
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
release savepoint it0
I. 05/20 16:01:27. <1.5> [537]: begin_upload_rows pdapincodes (no script)
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
savepoint it1
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
release savepoint it1
I. 05/20 16:01:27. <1.5> [537]: end_upload_rows pdapincodes (no script)
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
savepoint it2
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
release savepoint it2
I. 05/20 16:01:27. <1.5> [537]: begin_upload_rows bwf (no script)
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
savepoint it3
I. 05/20 16:01:27. <1.5> [537]: Translated SQL:
release savepoint it3
I. 05/20 16:01:27. <1.5> [537]: end_upload_rows bwf (no script)
I. 05/20 16:01:27. <1.5> [537]: begin_upload_rows prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it4
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it4
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows autos (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it5
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it5
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows autos (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows personen (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it6
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it6
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows personen (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it7
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it7
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it8
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it8
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it9
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it9
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it10
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it10
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_upload_rows werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
savepoint it11
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
release savepoint it11
I. 05/20 16:01:28. <1.5> [537]: end_upload_rows werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload pdapincodes (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload autos (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload personen (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: end_upload <connection> (no script)
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table ritregistratie :
0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table ritregistratie :
0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table ritregistratie :
0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows uploaded into table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows inserted into table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows deleted in table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows updated into table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows conflicted in table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows ignored in table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
UPDATE ml_subscription SET progress = ? WHERE user_id = ?
AND publication_name = ?
I. 05/20 16:01:28. <1.5> [537]: COMMIT Transaction: end_upload
I. 05/20 16:01:28. <1.5> [537]: Translated SQL:
SELECT NOW(*)
I. 05/20 16:01:28. <1.5> [537]: begin_download <connection> (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download pdapincodes (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download autos (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download personen (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: Sending the download to the remote database.
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es pdapincodes (no
script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
pdapincodes (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows pdapincodes (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows pdapincodes (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es autos (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
autos (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows autos (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows autos (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es personen (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
personen (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows personen (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows personen (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es calcdetail (no
script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_delet
es werkopdracht (no
script)
I. 05/20 16:01:28. <1.5> [537]: end_download_deletes
werkopdracht (no
script)
I. 05/20 16:01:28. <1.5> [537]: begin_download_rows werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download_rows werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download pdapincodes (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download bwf (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download prijsdef (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download autos (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download personen (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download calcregie (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download calcdetail (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download materiaal (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download dagstaten (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download werkopdracht (no script)
I. 05/20 16:01:28. <1.5> [537]: end_download <connection> (no script)
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
ritregistratie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
pdapincodes : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
userprops : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table bwf
: 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table bwf : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table bwf
: 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table bwf :
0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
prijsdef : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
autos : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table autos
: 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
personen : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
calcregie : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
calcdetail : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
materiaal : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
dagstaten : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for delete from table
werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded for insert/update from
table werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows filtered for download from table
werkopdracht : 0
I. 05/20 16:01:28. <1.5> [537]: # rows downloaded to remote from table
werkopdracht : 0
I. 05/20 16:01:32. <1.5> [537]: COMMIT Transaction: end_download
I. 05/20 16:01:32. <1.5> [537]: end_synchronization pdapincodes (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization bwf (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization prijsdef (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization autos (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization personen (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization calcregie (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization calcdetail (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization materiaal (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization dagstaten (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization werkopdracht (no script)
I. 05/20 16:01:32. <1.5> [537]: end_synchronization <connection> (no script)
I. 05/20 16:01:32. <1.5> [537]: COMMIT Transaction: end_synchronization
I. 05/20 16:01:32. <1 | | |