Stopnja: Datalab
Pridružen(a): 14/08/2009(UTC) Objave: 1
Prejete zahvale: 2 krat v 2 objavah
|
Testiram na svojoj bazi ( TEST ) nadogradnju sa 4630 BA, na 4701 i pojavilo se hrapa grešaka, a kad se podigne pantheon, traži ponovo nadogradnju, i nisu uspostavljene sve veze .txt
|
|
|
|
|
|
Stopnja: Datalab
Pridružen(a): 14/08/2009(UTC) Objave: 0
Prejete zahvale: 1 krat v 1 objavah
|
Poslije ponovne nadogradnje, nije javljao greške
|
|
|
|
|
|
Stopnja: Datalab
Pridružen(a): 14/08/2009(UTC) Objave: 0
Prejete zahvale: 1 krat v 1 objavah
|
I meni se slično desilo:
Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_LinkMoveRMAOrder`.` SQL: `ALTER TABLE [dbo].[tHE_LinkMoveRMAOrder] ADD CONSTRAINT kHE_LinkMoveRMAOrder_0 PRIMARY KEY NONCLUSTERED (acKey,acLnkKey,acType) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_LinkMoveRMATrvl`.` SQL: `ALTER TABLE [dbo].[tHE_LinkMoveRMATrvl] ADD CONSTRAINT kHE_LinkMoveRMATrvl_0 PRIMARY KEY NONCLUSTERED (acKey,acLnkKey,acType) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_MoveRMAChronology`.` SQL: `ALTER TABLE [dbo].[tHE_MoveRMAChronology] ADD CONSTRAINT kHE_MoveRMAChronology_0 PRIMARY KEY NONCLUSTERED (acKey,anNo) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_MoveRMADetail`.` SQL: `ALTER TABLE [dbo].[tHE_MoveRMADetail] ADD CONSTRAINT kHE_MoveRMADetail_0 PRIMARY KEY NONCLUSTERED (acKey) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_MoveRMAWorkSpec`.` SQL: `ALTER TABLE [dbo].[tHE_MoveRMAWorkSpec] ADD CONSTRAINT kHE_MoveRMAWorkSpec_0 PRIMARY KEY NONCLUSTERED (acKey,anNo) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_PayOrderSig`.` SQL: `ALTER TABLE [dbo].[tHE_PayOrderSig] ADD CONSTRAINT kHE_PayOrderSig PRIMARY KEY NONCLUSTERED (acKey) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHE_SetTransItemStatus`.` SQL: `ALTER TABLE [dbo].[tHE_SetTransItemStatus] ADD CONSTRAINT kHE_SetTransItemStatus PRIMARY KEY NONCLUSTERED (anStatus) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHR_JobDangerMean`.` SQL: `ALTER TABLE [dbo].[tHR_JobDangerMean] ADD CONSTRAINT kHR_JobDangerMean_0 PRIMARY KEY NONCLUSTERED (acJob,anId) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tHR_SetDangerMean`.` SQL: `ALTER TABLE [dbo].[tHR_SetDangerMean] ADD CONSTRAINT kHR_SetDangerMean_0 PRIMARY KEY NONCLUSTERED (acCode) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tPA_TouchProfileGroupItems`.` SQL: `ALTER TABLE [dbo].[tPA_TouchProfileGroupItems] ADD CONSTRAINT tPA_TouchProfileGroupItems_0 PRIMARY KEY NONCLUSTERED (anID) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tPA_TouchProfileGroups`.` SQL: `ALTER TABLE [dbo].[tPA_TouchProfileGroups] ADD CONSTRAINT tPA_TouchProfileGroups_0 PRIMARY KEY NONCLUSTERED (anID) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tPA_TouchProfiles`.` SQL: `ALTER TABLE [dbo].[tPA_TouchProfiles] ADD CONSTRAINT tPA_TouchProfiles_0 PRIMARY KEY NONCLUSTERED (acProfile) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tZE_AdminOlap`.` SQL: `ALTER TABLE [dbo].[tZE_AdminOlap] ADD CONSTRAINT kZE_AdminOlap_0 PRIMARY KEY NONCLUSTERED (acDataBaseName) ` Greška: `Could not create constraint. See previous errors. Cannot define PRIMARY KEY constraint on nullable column in table `tZE_DocTypePurchase`.` SQL: `ALTER TABLE [dbo].[tZE_DocTypePurchase] ADD CONSTRAINT kZE_DocTypePurchase_0 PRIMARY KEY NONCLUSTERED (acDocType)
Kada sam ponovo ušao dobio sam poruku da referencijalni integritet nije uspostavljen. Idem popraviti, pa ti javim šta se desilo.
|
|
|
|
|
|
Stopnja: Datalab
Pridružen(a): 14/08/2009(UTC) Objave: 0
Prejete zahvale: 1 krat v 1 objavah
|
Onako prema tabelama, mislim da se radi o ubacivanju veza za novi servis. Pa možda je bilo problema sa psoatavljanjem konstrainta na novo krerane tabele. Nakon drugog puta i meni je sve ok.
|
|
|
|
|
|
Hitra navigacija
Ne smete dodajati novih tem.
Ne smete odgovarjati na teme.
Ne smete brisati svojih objav.
Ne smete urejati svojih objav.
Ne smete ustvarjati anket.
Ne smete glasovati v anketah.