Forum

Welcome Guest! To enable all features please try to register or login.
greska pri unosu naloga za knjizenje
Options Go to last post Go to first unread
Previous Topic Next Topic
HD_prijavio
#1 Posted : 21 January 2011 17:35:00(UTC)
HD_prijavio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 1

Was thanked: 2 time(s) in 2 post(s)
nakon migracije program javi gresku kod unosa naloga za knjizenje.
ima te li ideja oko rjesenja ?

slika greske u prilogu

( sto je najcudnije neki se nalozi normalno unose pod nekim datumima, a pod drugim datumima je to nemoguce.
javlja gornju gresku )
HD_odgovorio
#2 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)
nije upaalila ova nova nadogradnja.
saljem ti tabelu
HD_odgovorio
#3 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

sve pogledao i nadogradio 2 puta.
kod ove baze pojavila se i prethodna greska sa onom `pvvar` procedurom.
nije rijesilo problem.
pokusat cu jos nesto.

pozz
HD_odgovorio
#4 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

majstore ovo ti je bilo vrhunski !
skidam kapu
HD_odgovorio
#5 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

vrhunski !
HD_odgovorio
#6 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

u okviru koraka 1.

samo jos nedostaje drop CONSTRAINT rthe_accttrans...
HD_odgovorio
#7 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

baza u prilogu...
HD_odgovorio
#8 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

queriraj tabelu the_dailyinformation i vidi ima li zapisa u njoj, trebali bi biti svi datumi (pogledaj prilog).

Inace najlakse da napravis jos jednu nadogradnju na isti taj build sa svim objektima, ako ne rijesis
rjesenje koje uvijek upali je salji meni bazu.

P.S. mozes unositi pod nekim i to onim koji postoje u the_dailyinformation.

Vjerovatno se kroz migraciju nisu prenijeli svi datumi...

LP
HD_odgovorio
#9 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

popravio sam gresku na ovoj bazi, zakacicu ti je ali bolje ovako da ti proslijedim querije za popravak...ako budes imao
ovakav slucaj

1. alter table the_accttrans
drop rtHE_AcctTrans_tHE_DailyInformation_3

2. delete the_dailyinformation

3. INSERT INTO nazivbazekojanerad.dbo.the_dailyinformation (addate, acprimcurrency,accalccurr)
SELECT addate, acprimcurrency, accalccurr FROM nazivbazekojaradi.dbo.the_dailyinformation

4. ponovo nadogradi da se constraint namjesti

na serveru ti treba samo jedna baza u kojoj knjizenje radi normalno, samo ce prepisati iz nje ovu tabelu u problematicnu
bazu.

LP
HD_odgovorio
#10 Posted : 21 January 2011 17:35:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

1.prebaci tu tabelu iz neke druge baze u tu problematicnu.

2.Ako ne sredis posalji mi bazu...

LP
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.462 seconds.