|
== F18 start: 09.04.12 / 15:56:58 ==
|
|
setovanje ekrana: setovan ekran po rezoluciji
|
|
server connection ok: vsasa / cago_2011
|
|
home baze: /Users/bringout/.f18/cago_2011/
|
|
Ne postoji ini fajl /Users/bringout/.f18/cago_2011/.f18_config.ini
|
|
Fajl je prazan: /Users/bringout/.f18/cago_2011/.f18_config.ini
|
|
current dbf version: 0
|
|
F18 dbf version: 406
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/ops.dbf, ID
|
|
index on id / ID / /Users/bringout/.f18/cago_2011/ops / alias=ops / used() = .T.
|
|
BEGIN;
|
|
_sql_query VALTYPE(_ret) = O
|
|
my_use table:banke / rdd: SEMAPHORE alias: BANKE exclusive: .T. new: .F.
|
|
qry: SELECT id,match_code,naz,mjesto,adresa FROM fmk.banke ORDER BY id LIMIT 15000 OFFSET 0
|
|
banke updated from sql server rec_cnt: 7
|
|
banke synchro cache: 0.11
|
|
update_semaphore_version banke ver: -1/ last_ver: 0
|
|
ret[qry]=(array): 1 / ?U? ;
|
|
ret[ids]=(array): 1 / ?U? ;
|
|
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ; ; qry / (array): 1 / ?U? ; ;
|
|
COMMIT;
|
|
_sql_query VALTYPE(_ret) = O
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/banke.dbf, ID
|
|
index on id / ID / /Users/bringout/.f18/cago_2011/banke / alias=banke / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/banke.dbf, NAZ
|
|
index on naz / NAZ / /Users/bringout/.f18/cago_2011/banke / alias=banke / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/rnal.dbf, ID
|
|
index on id / ID / /Users/bringout/.f18/cago_2011/rnal / alias=rnal / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/rnal.dbf, NAZ
|
|
index on naz / NAZ / /Users/bringout/.f18/cago_2011/rnal / alias=rnal / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/refer.dbf, ID
|
|
index on id / ID / /Users/bringout/.f18/cago_2011/refer / alias=refer / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/refer.dbf, NAZ
|
|
index on naz / NAZ / /Users/bringout/.f18/cago_2011/refer / alias=refer / used() = .T.
|
|
BEGIN;
|
|
_sql_query VALTYPE(_ret) = O
|
|
my_use table:vrstep / rdd: SEMAPHORE alias: VRSTEP exclusive: .T. new: .F.
|
|
qry: SELECT id,naz FROM fmk.vrstep ORDER BY id LIMIT 15000 OFFSET 0
|
|
vrstep updated from sql server rec_cnt: 0
|
|
vrstep synchro cache: 0.05
|
|
update_semaphore_version vrstep ver: -1/ last_ver: 0
|
|
ret[qry]=(array): 1 / ?U? ;
|
|
ret[ids]=(array): 1 / ?U? ;
|
|
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ; ; qry / (array): 1 / ?U? ; ;
|
|
COMMIT;
|
|
_sql_query VALTYPE(_ret) = O
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/vrstep.dbf, ID
|
|
index on Id / ID / /Users/bringout/.f18/cago_2011/vrstep / alias=VRSTEP / used() = .T.
|
|
BEGIN;
|
|
_sql_query VALTYPE(_ret) = O
|
|
my_use table:lokal / rdd: SEMAPHORE alias: LOKAL exclusive: .T. new: .F.
|
|
qry: SELECT id,id_str,naz FROM fmk.lokal ORDER BY id LIMIT 15000 OFFSET 0
|
|
lokal updated from sql server rec_cnt: 0
|
|
lokal synchro cache: 0.02
|
|
update_semaphore_version lokal ver: -1/ last_ver: 0
|
|
ret[qry]=(array): 1 / ?U? ;
|
|
ret[ids]=(array): 1 / ?U? ;
|
|
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ; ; qry / (array): 1 / ?U? ; ;
|
|
COMMIT;
|
|
_sql_query VALTYPE(_ret) = O
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, ID
|
|
index on id+STR(id_str,6,0)+naz / ID / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, IDNAZ
|
|
index on id+naz / IDNAZ / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, ID_STR
|
|
index on STR(id_str,6,0)+naz+id / ID_STR / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/lokal.dbf, NAZ
|
|
index on naz+str(id_str,6,0) / NAZ / /Users/bringout/.f18/cago_2011/lokal / alias=LOKAL / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/doksrc.dbf, 1
|
|
index on idfirma+idvd+brdok+DTOS(datdok)+src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 1 / /Users/bringout/.f18/cago_2011/doksrc / alias=DOKSRC / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/doksrc.dbf, 2
|
|
index on src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 2 / /Users/bringout/.f18/cago_2011/doksrc / alias=DOKSRC / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/p_doksrc.dbf, 1
|
|
index on idfirma+idvd+brdok+DTOS(datdok)+src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 1 / /Users/bringout/.f18/cago_2011/p_doksrc / alias=P_DOKSRC / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/p_doksrc.dbf, 2
|
|
index on src_modul+src_idfirm+src_idvd+src_brdok+DTOS(src_datdok) / 2 / /Users/bringout/.f18/cago_2011/p_doksrc / alias=P_DOKSRC / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/p_update.dbf, 1
|
|
index on modul+idkonto+p_updated / 1 / /Users/bringout/.f18/cago_2011/p_update / alias=P_UPDATE / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/relation.dbf, 1
|
|
index on TFROM+TTO+TFROMID / 1 / /Users/bringout/.f18/cago_2011/relation / alias=RELATION / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/relation.dbf, 2
|
|
index on TTO+TFROM+TTOID / 2 / /Users/bringout/.f18/cago_2011/relation / alias=RELATION / used() = .T.
|
|
BEGIN;
|
|
_sql_query VALTYPE(_ret) = O
|
|
my_use table:f18_rules / rdd: SEMAPHORE alias: FMKRULES exclusive: .T. new: .F.
|
|
qry: SELECT rule_id,modul_name,rule_obj,rule_no,rule_name,rule_ermsg,rule_level,rule_c1,rule_c2,rule_c3,rule_c4,rule_c5,rule_c6,rule_c7,rule_n1,rule_n2,rule_n3,rule_d1,rule_d2 FROM fmk.f18_rules ORDER BY rule_id LIMIT 15000 OFFSET 0
|
|
f18_rules updated from sql server rec_cnt: 0
|
|
f18_rules synchro cache: 0.04
|
|
update_semaphore_version f18_rules ver: -1/ last_ver: 0
|
|
ret[qry]=(array): 1 / ?U? ;
|
|
ret[ids]=(array): 1 / ?U? ;
|
|
ids_synchro - ids_queries: (hash): ids / (array): 1 / ?U? ; ; qry / (array): 1 / ?U? ; ;
|
|
COMMIT;
|
|
_sql_query VALTYPE(_ret) = O
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 1
|
|
index on STR(RULE_ID,10) / 1 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 2
|
|
index on MODUL_NAME+RULE_OBJ+STR(RULE_NO,10) / 2 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 3
|
|
index on MODUL_NAME+RULE_OBJ+STR(RULE_LEVEL,2)+STR(RULE_NO,10) / 3 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
|
|
Kreiram indeks za tabelu /Users/bringout/.f18/cago_2011/f18_rules.dbf, 4
|
|
index on MODUL_NAME+RULE_OBJ+RULE_C1+RULE_C2 / 4 / /Users/bringout/.f18/cago_2011/f18_rules / alias=fmkrules / used() = .T.
|
|
modifikacija struktura - start
|
|
ime fajla: /Users/bringout/.f18/cago_2011/roba
|
|
Greska: Polje IDKONTO vec postoji u DBF-u, linija: IDKONTO C 7 0
|
|
modstru problem :roba
|
|
BEGIN;
|
|
_sql_query VALTYPE(_ret) = O
|
|
my_use table:roba / rdd: SEMAPHORE alias: ROBA exclusive: .T. new: .F.
|
|
qry: SELECT id,sifradob,match_code,naz,strings,jmj,idtarifa,nc,vpc,vpc2,plc,mpc,mpc2,mpc3,k1,k2,k7,k8,k9,n1,n2,tip,mink,opis,barkod,fisc_plu,zanivel,zaniv2,trosk1,trosk2,trosk3,trosk4,trosk5,idkonto FROM fmk.roba ORDER BY id LIMIT 15000 OFFSET 0
|
|
roba updated from sql server rec_cnt: 6807
|
|
roba synchro cache: 5.95
|
|
update_semaphore_version roba ver: -1/ last_ver: 1
|
|
ret[qry]=(array): 1 / SELECT id,sifradob,match_code,naz,strings,jmj,idtarifa,nc,vpc,vpc2,plc,mpc,mpc2,mpc3,k1,k2,k7,k8,k9,n1,n2,tip,mink,opis,barkod,fisc_plu,zanivel,zaniv2,trosk1,trosk2,trosk3,trosk4,trosk5,idkonto FROM fmk.roba WHERE (id) IN ('10032 ') ;
|
|
ret[ids]=(array): 1 / (array): 1 / 10032 ; ;
|
|
ids_synchro - ids_queries: (hash): ids / (array): 1 / (array): 1 / 10032 ; ; ; qry / (array): 1 / SELECT id,sifradob,match_code,naz,strings,jmj,idtarifa,nc,vpc,vpc2,plc,mpc,mpc2,mpc3,k1,k2,k7,k8,k9,n1,n2,tip,mink,opis,barkod,fisc_plu,zanivel,zaniv2,trosk1,trosk2,trosk3,trosk4,trosk5,idkonto FROM fmk.roba WHERE (id) IN ('10032 ') ; ;
|