Форум

Welcome Guest! To enable all features please try to register or login.
tabela tPA_log
Options Go to last post Go to first unread
Previous Topic Next Topic
mbstaneb
#1 Posted : 17 August 2011 10:42:06(UTC)
mbstaneb

Rank: PA User

Joined: 24/04/2009(UTC)
Posts: 46

Thanks: 1 times
Pozdravljeni!

Čemu služi tabela tPA_log? Od builda 5.5.53.20 dalje mi vsako noč zapiše za 500MB podatkov, ki nimajo nobenega smisla. Vsa polja razen AcName in AcValue imajo vrednost NULL.

Kakšna ideja oz. ima še kdo to težavo?

lp
Rimljan d.o.o.
Vegova ulica 4
2250 Ptuj
www.rimljan.si
JUREBOV
#2 Posted : 17 August 2011 12:56:57(UTC)
JUREBOV

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 204

Was thanked: 2 time(s) in 2 post(s)
Zdravo,
tPa_log - tabela za logiranje vhodnih parametrov procedur.
katere operacije (jobe) izvajate ponoči?
Napisana je opomba 31889 (deadline 11.10.2011), s katero bomo umaknilli logiranje na hermesovih procedurah.
Vsebino tabele pa lahko pobrišete: delete from tPa_log.
lp
mbstaneb
#3 Posted : 17 August 2011 13:15:02(UTC)
mbstaneb

Rank: PA User

Joined: 24/04/2009(UTC)
Posts: 46

Thanks: 1 times
Zdravo!

Hvala za odgovor. Čez noč se izvaja backup, preračun prometov in sinhronizacija s poslovno enoto (nekaj preprostih insert stavkov).

lp
Rimljan d.o.o.
Vegova ulica 4
2250 Ptuj
www.rimljan.si
dejan
#4 Posted : 23 August 2011 09:08:15(UTC)
dejan

Rank: PA User

Joined: 24/04/2009(UTC)
Posts: 576
Man

Was thanked: 9 time(s) in 9 post(s)
Pozdrav

Tudi jaz imam problem s tole tabelo.. Jure torej je vsebina te tabele brezpredmetna in se jo lahko pobriše?? Pri meni je ta tabela velika 2,8gb.
Vobo d.o.o.
Na gorci 66
2000 Maribor
www.vobo.si
JUREBOV
#5 Posted : 23 August 2011 12:22:58(UTC)
JUREBOV

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 204

Was thanked: 2 time(s) in 2 post(s)
Tako je, vsebina se lahko pobriše ker se podatki ne uporabljajo.
dejan
#6 Posted : 24 August 2011 10:52:09(UTC)
dejan

Rank: PA User

Joined: 24/04/2009(UTC)
Posts: 576
Man

Was thanked: 9 time(s) in 9 post(s)
JUREBOV wrote:
Tako je, vsebina se lahko pobriše ker se podatki ne uporabljajo.


Zdravo

Je kakšna možnost, da se "izklopi" kje polnjenje te tabele? ker dnevno zraste za cca 100mb. Vceraj sem jo pobrisal, ker je bila velika 3gb sedaj pa je spet velika 100mb.

lp
dejan
Vobo d.o.o.
Na gorci 66
2000 Maribor
www.vobo.si
JUREBOV
#7 Posted : 24 August 2011 11:40:07(UTC)
JUREBOV

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 204

Was thanked: 2 time(s) in 2 post(s)
Če imate vsaj build 555320 vam lahko posredujem procedure, ki to izklopijo.
dejan
#8 Posted : 24 August 2011 11:47:29(UTC)
dejan

Rank: PA User

Joined: 24/04/2009(UTC)
Posts: 576
Man

Was thanked: 9 time(s) in 9 post(s)
Zdravo Jure.

Mail sem si poslal na PM.

Hvala
Dejan
Vobo d.o.o.
Na gorci 66
2000 Maribor
www.vobo.si
JUREBOV
#9 Posted : 24 August 2011 16:16:13(UTC)
JUREBOV

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 204

Was thanked: 2 time(s) in 2 post(s)
Urejeno
tomazkravcar
#10 Posted : 09 September 2011 20:58:33(UTC)
tomazkravcar

Rank: Member

Joined: 06/07/2011(UTC)
Posts: 9
Živjo Jure,

lahko prosim pošlješ še meni oz. objaviš procedure, ker imam enak problem.

lp, Tomaž
bospec
#11 Posted : 12 September 2011 10:22:59(UTC)
bospec

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 44
Zdravo Tomaz,
Posli mi prosim mail na bostjanp@datalab.si in dobiš takoj 4 popravljene procedure.
LD,Bosjtan
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0,487 seconds.