Форум

Welcome Guest! To enable all features please try to register or login.
HD_prijavil
#1 Posted: : 29 March 2013 08:59:00(UTC)
HD_prijavil

Rank: Newbie

You have been a member since:: 20/07/2012(UTC)
Posts: 0
Location: N/A

Pozdravljeni,

pri nadgradnji na Pantheona na verzijo 5930 ali 6000 sem naletel na težavo
pri nadgradnji.
Po meni dostopnih podatkin nadgradnja ne deluje na SQL 2005 na SQL 2008
deluje.
Kako je s podporo SQL 2005 na vaši spletni strani,
http://www.datalab.si/po...rti-operacijski-sistemi-
in-podatkovne-baze/ je strežnik SQL Server 9.0.4035 podprt.


Lep pozdrav

Napaka: `The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name `dbo.tPA_ReportMailLog` and the index name `IX_tPA_ReportMailLog_Id`. The duplicate key value is (2700).`
SQL: ` create unique nonclustered index IX_tPA_ReportMailLog_Id on tPA_ReportMailLog(anId);`
*
Odpravim z najbolj učinkovito komado: delete from tPA_ReportMailLog
HD_odgovoril
#2 Posted: : 29 March 2013 08:59:00(UTC)
HD_odgovoril

Rank: Newbie

You have been a member since:: 24/09/2013(UTC)
Posts: 0

Zdravo,

Prosim nadgradite na zadnjo verzijo 556010. SQL Server 2005 je podprt. Mankajoč unikatni indeks se ne po kreiral ker so podvojeni podatki v tabeli in je stanje potrebno popraviti ročno. Ostalih napak pa ne bi smelo biti.

In ja, lahko uporabite delete in to bi moralo biti vse

lp,
(odgovor stranke še - patch deluje - log nadgradnje brez napak)
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,509 seconds.