n3r1x
2
#1260844 2015-02-09 18:34 n3r1x

rutyte11 rašė:



Niemand rašė:



rutyte11 rašė:


Sveiki man su kontrahentu automatisku ikelimu meta klaida, nors tokios imones tikrai yra



www.registrucentras.lt/jar/p/index.php
Dėl techninės profilaktikos darbų galimi informacinių sistemų sutrikimai nuo 2015-02-07 23:00 iki 2015-02-08 12:00 val.
Atsiprašome už laikinus nepatogumus.

VMI irgi kažką daro su savo sistemomis, žodžiu kol pas juos situacija nesistabilizuos, neveiks ir programos atitinkama funkcija.


supratau aciu :)


O kodel kontrahentu istraukimas veikia ant senos versijos, o ant naujos meta klaida. Apsisarvuoti kantrybe ir laukti? smile

aaastuteee
56
#1260845 2015-02-09 18:43 aaastuteee

n3r1x rašė:



rutyte11 rašė:



Niemand rašė:



rutyte11 rašė:


Sveiki man su kontrahentu automatisku ikelimu meta klaida, nors tokios imones tikrai yra



www.registrucentras.lt/jar/p/index.php
Dėl techninės profilaktikos darbų galimi informacinių sistemų sutrikimai nuo 2015-02-07 23:00 iki 2015-02-08 12:00 val.
Atsiprašome už laikinus nepatogumus.

VMI irgi kažką daro su savo sistemomis, žodžiu kol pas juos situacija nesistabilizuos, neveiks ir programos atitinkama funkcija.


supratau aciu :)


O kodel kontrahentu istraukimas veikia ant senos versijos, o ant naujos meta klaida. Apsisarvuoti kantrybe ir laukti? smile



Manau, kad kontrahentus galite ir rankiniu būdu susivesti, ne taip jau sudėtinga.

Niemand
4886
#1260849 2015-02-09 19:02 Niemand

n3r1x rašė:

O kodel kontrahentu istraukimas veikia ant senos versijos, o ant naujos meta klaida. Apsisarvuoti kantrybe ir laukti? smile



Neveikia nei ant kurios versijos. VMI su Registrų centru kažką su savo sistemomis daro, VMI senos versijos PVM mokėtojų paieška (kur be captcha) guli nuo vakar.

aaastuteee
56
#1260850 2015-02-09 19:07 aaastuteee
Labas vakaras,

atnaujinimo šiandien nepadarėte ar ne? Nes 5/6 uždarymas man vis dar apvalinasi. O atnaujinimo neranda.

Tik pasitikslinu.


Niemand
4886
#1260851 2015-02-09 19:13 Niemand

Dianaval rašė:

Įvedus kasos išlaidų orderį Kasos Piniginių lėšų apyvartos žiniaraštyje viską gerai rodo, bet pasirinkus banką ta pati suma su minuso ženklu ir likutį jos visai neprideda.



Nes programa įnešimą iš kasos į banką ir priešingai palaiko tik per atskaitingą asmenį, o ne tiesiogiai.

kristiol
58
#1260852 2015-02-09 19:25 kristiol

Niemand rašė:



kristol rašė:


Sveiki, Nerandu naujoj versijoj darbo užmokesčio išmokėjimo žiniaraščio, ar jo nebeliko ar tiesiog nerandu. Per printeriuką yra tik priskaitymo žiniaraštis ir lapeliai.
Ačiū



Bandyk spausti ne ant dropdown'o pasirinkimų, o ant pačio preview mygtuko.




Ačiū veikia :)

Niemand
4886
#1260854 2015-02-09 19:33 Niemand

aaastuteee rašė:

atnaujinimo šiandien nepadarėte ar ne? Nes 5/6 uždarymas man vis dar apvalinasi. O atnaujinimo neranda.



Jau.

topus
4
#1260857 2015-02-09 19:50 topus
Sveiki, gal galite padėti. perkeliant duomenis is senos i nauja versija, užstringu ties 4 punktu atliekant šį veiksmą Bendras\DB struktūra -> Tikrinti -> Taisyti; išmeta tokią klaida Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.

topus
4
#1260858 2015-02-09 19:50 topus
Sveiki, gal galite padėti. perkeliant duomenis is senos i nauja versija, užstringu ties 4 punktu atliekant šį veiksmą Bendras\DB struktūra -> Tikrinti -> Taisyti; išmeta tokią klaida Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.

topus
4
#1260859 2015-02-09 19:51 topus
paspaudus detaliau

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''. ---> MySql.Data.MySqlClient.MySqlException: Unknown column 'k.CashAccountID' in 'where clause'
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessListBase`2.Save()
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.Save()
at ApskaitaWUI.F_DatabaseStructureError.RepairErrorsButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Unknown column 'k.CashAccountID' in 'where clause'
Klaidos šaltinis(Ex.Source):
MySql.Data
Klaidos metodas (Ex.TargetSite):
OpenPacket
Klaidos stekas:
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)

Dianaval
667
#1260861 2015-02-09 20:29 Dianaval

Niemand rašė:



Dianaval rašė:

Įvedus kasos išlaidų orderį Kasos Piniginių lėšų apyvartos žiniaraštyje viską gerai rodo, bet pasirinkus banką ta pati suma su minuso ženklu ir likutį jos visai neprideda.



Nes programa įnešimą iš kasos į banką ir priešingai palaiko tik per atskaitingą asmenį, o ne tiesiogiai.



Dėkui
O kaip pavedimą tarp savo sąskaitų padaryti?
Atskaitingas gi čia nefiguruoja.

Niemand
4886
#1260862 2015-02-09 20:31 Niemand

topus rašė:

paspaudus detaliau
Klaidos tekstas:
Unknown column 'k.CashAccountID' in 'where clause'



Panašu, kad ši klaida yra iš antro bandymo ir beprasmė. Po nepavykusio upgrade'o kaip taisyklė yra sugadinama duombazė. Vėlesnės bandymų klaidos neturi prasmės, tik pirma. Reikia ištrinti duombazę, importuoti, bandyti upgrade'inti ir žiūrėti tik pačią pirmą klaidą.

Niemand
4886
#1260863 2015-02-09 20:33 Niemand

Dianaval rašė:

O kaip pavedimą tarp savo sąskaitų padaryti?
Atskaitingas gi čia nefiguruoja.



Tokia galimybė yra banko operacijos formoje. (bet į kasos sąskaitą neleis, ordnung ist ordnung smile )

topus
4
#1260868 2015-02-09 21:10 topus
dar kartą pamėginau ir išmeta klaidą

Klaida. Nepavyko konvertuoti duomenų į naują versiją: LostAssets


Paspaudus detaliau

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida. Nepavyko konvertuoti duomenų į naują versiją: LostAssets
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessListBase`2.Save()
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.Save()
at ApskaitaWUI.F_DatabaseStructureError.RepairErrorsButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida. Nepavyko konvertuoti duomenų į naują versiją: LostAssets
Klaidos šaltinis(Ex.Source):
ApskaitaObjects
Klaidos metodas (Ex.TargetSite):
RepairCustomError
Klaidos stekas:
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()

Niemand
4886
#1260871 2015-02-09 21:24 Niemand
Kažkokia klaida IT duomenyse. Rytoj parašysiu į asmeninę žinutę kaip paieškoti.

Dianaval
667
#1260875 2015-02-09 21:42 Dianaval

Niemand rašė:



Dianaval rašė:

O kaip pavedimą tarp savo sąskaitų padaryti?
Atskaitingas gi čia nefiguruoja.



Tokia galimybė yra banko operacijos formoje. (bet į kasos sąskaitą neleis, ordnung ist ordnung smile )



Tai importą banko išrašo padariau, bet piniginių lėšų apyvartos žiniaraštyje taip pat kaip kasoje susidėlioja.
Kasą aš negerai suvedžiau o tai kaip banką įvesti?

Niemand
4886
#1260877 2015-02-09 21:55 Niemand

Dianaval rašė:


Tai importą banko išrašo padariau, bet piniginių lėšų apyvartos žiniaraštyje taip pat kaip kasoje susidėlioja.
Kasą aš negerai suvedžiau o tai kaip banką įvesti?



Importo lentoje nėra tokio pasirinkimo, ji ir taip didelė. Jei matai, kad tam tikra operacija yra tarp savų banko sąskaitų, paclickini ir užpildai visą banko operacijos formą.

Marcelo
2
#1260883 2015-02-09 23:19 Marcelo
sveiki,
atliekant duomenu perkelima is senos versijos i nauja, iškilo problema. Suinstaliuotoje naujoje versijoje tikrinant ir taisant duomenų bazės struktūros klaidas išmeta tokia klaida

There is no row at position 10000.

Detaliau:
Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.IndexOutOfRangeException: There is no row at position 10000.
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree`1.get_Item(Int32 index)
at System.Data.DataRowCollection.get_Item(Int32 index)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem..ctor(DataTable myData, Int32& index, FinancialStatementItemType nType)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem.FetchStructure()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.UpgradeOldVersionBalanceStructure(DatabaseStructureErrorList& StructureErrorList)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree`1.get_Item(Int32 index)
at System.Data.DataRowCollection.get_Item(Int32 index)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem..ctor(DataTable myData, Int32& index, FinancialStatementItemType nType)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem.FetchStructure()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.UpgradeOldVersionBalanceStructure(DatabaseStructureErrorList& StructureErrorList)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessListBase`2.Save()
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.Save()
at ApskaitaWUI.F_DatabaseStructureError.RepairErrorsButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree`1.get_Item(Int32 index)
at System.Data.DataRowCollection.get_Item(Int32 index)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem..ctor(DataTable myData, Int32& index, FinancialStatementItemType nType)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem.FetchStructure()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.UpgradeOldVersionBalanceStructure(DatabaseStructureErrorList& StructureErrorList)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
There is no row at position 10000.
Klaidos šaltinis(Ex.Source):
System.Data
Klaidos metodas (Ex.TargetSite):
GetNodeByIndex
Klaidos stekas:
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree`1.get_Item(Int32 index)
at System.Data.DataRowCollection.get_Item(Int32 index)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem..ctor(DataTable myData, Int32& index, FinancialStatementItemType nType)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.OldBalanceItem.FetchStructure()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.UpgradeOldVersionBalanceStructure(DatabaseStructureErrorList& StructureErrorList)
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()

Savamoksle
40
#1260885 2015-02-09 23:47 Savamoksle
Sveiki, dovanokit jei jau tokia klaida kam buvo nutikusi ir as neradau to forume, bet pavargau tiesa sakant ieskoti... Man keliant atsargine kopija is senos versijos i nauja meta klaida:
Klaida atkuriant atsarginę kopiją: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Klaidos duomenys:
Klaidos tekstas:
Klaida atkuriant atsarginę kopiją: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1

Klaidos šaltinis(Ex.Source):
Apskaita5
Klaidos metodas (Ex.TargetSite):
MySqlRestoreDatabase
Klaidos stekas:
at ApskaitaWUI.F_BackUp.MySqlRestoreDatabase(String ModifiedBackupFilePath, String& DbNameToRestore)
at ApskaitaWUI.F_BackUp.RecoverFromFile_Click(Object sender, EventArgs e)


Galit padeti suprasti kame beda?
Aciu

neringaliub
66
#1260893 2015-02-10 08:45 neringaliub
Sveiki, gal galit kas paprotinti mane, kaip įsivesti IT likučius (tęsiamas naudojimas anksčiau įsigytų). Skaičiau ankstesnius komentarus, bet vistiek kažko iki galo nepadarau:(
Einu į turto apskaita->IT įsigijimas-> atsiradusioje lentelėje datą nurodau 20141231, įsivedu pavadinimą, turto grupę, sąskaitas nurodau, viskas ok. Už dedu varnelę "tęsiamas naudojimas".
laukelyje -" amortizac. apskaičiav už mėn (aš palieku tuščią)
laukelis "Amort laik. "- nurodau 4m, nesvarbu kad likę nudėti 2 m 5 mėn, ar gerai darau?
laukelis įsig BŽ operac. ID : -1,
laukeliuose: dok Nr., turinys, nieko neleidžia įrašyti, eilutėje rinktis irgi neduoda nieko (tuščią išmeta), mygtukas "projungti BŽ" ir gi nieko nedaro.
Tai kurioje vietoje reikia pasirinkti "operacijos bž įrašą" (ankstesniuose komentaruose skaičiau, kad reikia jį rinktis). Kitaip neduoda išsaugoti, rašo "nėra susieto bendrojo žurnalo įrašo, kuris būtų įsigijimo pagrindu".
IT likučių sumas (pinigines ) suvedžiau kai vedžiau kitų sąskaitų likučių sumas per duomenys->bendras-> likučių perk, datą rinkausi 20141231
Kur klaid, ką darua ne taip? Ačiū padėjusiems



Diskusijos

Kas prisijungęs?

Tu esi neprisijungęs vartotojas
Prisijungti arba registruotis

Atmintinė

Atmintinė buhalteriui
Delspinigiai už ne laiku sumokėtus mokesčius ir baudas 2021 m. I ketv. 0.03 proc
Palūkanos už naudojimąsi mokestine paskola 2021 m. I ketv. 0.01 proc
Valstybinio socialinio draudimo bazinė pensija
nuo 2021-01-01
198.29 EUR
Minimalus valandinis atlygis ir minimali mėnesinė alga (MMA)
nuo 2021-01-01
3.93 EUR ir 642 EUR