błąd ? zapis spowodowałby naruszenie integralności danych

[michał michałek 1]

Witam

Mam problem z którym nie za bardzo mogę sobie poradzić, gdy chcę wykonać cokolwiek np odznaczyc paczkę itp wyskakuję mi błąd

 

błąd ? zapis spowodowałby naruszenie integralności danych

 

Wszystko rano działało, wieczorem przestało, baza ma 1gb, zrobiłem arch, wgrałem ją na nowo i dalej ten sam błąd.

 

Wgrałem arch sprzed 1 miesiąca i wszystko działa jak należy, więc wydaje mi się że baza się uszkodziła, proszę o jakieś wskazówki od czego zacząć, ponieważ program potrzebny nam jest do codziennego użytkowania.

 

Jeśli baza jest nie do naprawienia to rozumiem że ręcznie będę musiał nadrabiać miesiąc ? uzupełniając dane  

 

\edit wykonałem DBCC CHECKDB / nic na czerwono nie widze chyba że źle to wykonałem

 

DBCC results for 'huzia'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1774 rows in 20 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 269 rows in 7 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 311 rows in 11 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1774 rows in 21 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 269 rows in 7 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 311 rows in 7 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 180 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 826 rows in 25 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2094 rows in 61 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 454 rows in 25 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 87 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 743 rows in 18 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 854 rows in 6 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 1057 rows in 319 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 14 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 595 rows in 12 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 890 rows in 13 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'pb__PostBuyFormData'.
There are 4131 rows in 80 pages for object "pb__PostBuyFormData".
DBCC results for '__Slowniki'.
There are 0 rows in 0 pages for object "__Slowniki".
DBCC results for 'pb_PostBuyFormTransaction'.
There are 4193 rows in 34 pages for object "pb_PostBuyFormTransaction".
DBCC results for '__Tabele'.
There are 0 rows in 0 pages for object "__Tabele".
DBCC results for 'tr_TransStatus'.
There are 0 rows in 1 pages for object "tr_TransStatus".
DBCC results for 'pc_SendingListPackage'.
There are 217 rows in 1 pages for object "pc_SendingListPackage".
DBCC results for '__Update'.
There are 0 rows in 0 pages for object "__Update".
DBCC results for 'em_Source'.
There are 62025 rows in 286 pages for object "em_Source".
DBCC results for 'pc_Transaction'.
There are 0 rows in 0 pages for object "pc_Transaction".
DBCC results for 'up_UserParams'.
There are 11 rows in 6 pages for object "up_UserParams".
DBCC results for 'em_Template'.
There are 12 rows in 1 pages for object "em_Template".
DBCC results for 'pd__Podmiot'.
There are 1 rows in 1 pages for object "pd__Podmiot".
DBCC results for 'em_Archive'.
There are 250 rows in 2 pages for object "em_Archive".
DBCC results for 'vw__Konfiguracja'.
There are 19 rows in 1 pages for object "vw__Konfiguracja".
DBCC results for 'au__Auction'.
There are 950 rows in 63 pages for object "au__Auction".
DBCC results for 'sl_SendingNumbersPoolType'.
There are 3 rows in 1 pages for object "sl_SendingNumbersPoolType".
DBCC results for 'ep__Registration'.
There are 1 rows in 1 pages for object "ep__Registration".
DBCC results for 'sl_ServiceProvider'.
There are 4 rows in 1 pages for object "sl_ServiceProvider".
DBCC results for 'sl_TransProperty'.
There are 2 rows in 1 pages for object "sl_TransProperty".
DBCC results for 'ep_ExternalProgram'.
There are 1 rows in 1 pages for object "ep_ExternalProgram".
DBCC results for 'sl_User'.
There are 1 rows in 1 pages for object "sl_User".
DBCC results for 'ep_OfflineQueue'.
There are 0 rows in 0 pages for object "ep_OfflineQueue".
DBCC results for 'st__Site'.
There are 1 rows in 1 pages for object "st__Site".
DBCC results for 'ep_OfflineQueueData'.
There are 0 rows in 0 pages for object "ep_OfflineQueueData".
DBCC results for 'pd_BankAccounts'.
There are 1 rows in 1 pages for object "pd_BankAccounts".
DBCC results for 'ep_RegData'.
There are 17 rows in 9 pages for object "ep_RegData".
DBCC results for 'st_AuctionType'.
There are 56 rows in 1 pages for object "st_AuctionType".
DBCC results for 'fp__ParamsFTP'.
There are 1 rows in 1 pages for object "fp__ParamsFTP".
DBCC results for 'adr__Address'.
There are 26128 rows in 500 pages for object "adr__Address".
DBCC results for 'st_Category'.
There are 38245 rows in 303 pages for object "st_Category".
DBCC results for 'gr__Konfiguracja'.
There are 0 rows in 0 pages for object "gr__Konfiguracja".
DBCC results for 'gr__KonfiguracjaEx'.
There are 130 rows in 3 pages for object "gr__KonfiguracjaEx".
DBCC results for 'pd_AutoSyncTimes'.
There are 1 rows in 1 pages for object "pd_AutoSyncTimes".
DBCC results for 'gt__Obiekt'.
There are 9 rows in 1 pages for object "gt__Obiekt".
DBCC results for 'pd_InternetParams'.

[michał michałek 1]

There are 1 rows in 1 pages for object "pd_InternetParams".
DBCC results for 'au_DescriptionImage'.
There are 0 rows in 0 pages for object "au_DescriptionImage".
DBCC results for 'gt_Atrybut'.
There are 0 rows in 0 pages for object "gt_Atrybut".
DBCC results for 'au_Ebay'.
There are 0 rows in 0 pages for object "au_Ebay".
DBCC results for 'gt_Definicja'.
There are 9 rows in 1 pages for object "gt_Definicja".
DBCC results for 'pd_Parametr'.
There are 1 rows in 1 pages for object "pd_Parametr".
DBCC results for 'pd_Permission'.
There are 49 rows in 1 pages for object "pd_Permission".
DBCC results for 'gt_Transformacja'.
There are 9 rows in 1 pages for object "gt_Transformacja".
DBCC results for 'gt_TransObiekt'.
There are 0 rows in 0 pages for object "gt_TransObiekt".
DBCC results for 'pd_Sesja'.
There are 0 rows in 0 pages for object "pd_Sesja".
DBCC results for 'gt_TransRodzaj'.
There are 1 rows in 1 pages for object "gt_TransRodzaj".
DBCC results for 'st_CategorySpecificDict'.
There are 67525 rows in 457 pages for object "st_CategorySpecificDict".
DBCC results for 'igt_UsersMapping'.
There are 0 rows in 0 pages for object "igt_UsersMapping".
DBCC results for 'au_Enhancement'.
There are 1753 rows in 7 pages for object "au_Enhancement".
DBCC results for 'st_Country'.
There are 224 rows in 2 pages for object "st_Country".
DBCC results for 'st_SiteData'.
There are 0 rows in 0 pages for object "st_SiteData".
DBCC results for 'pd_UserPermission'.
There are 49 rows in 1 pages for object "pd_UserPermission".
DBCC results for 'im__Image'.
There are 21 rows in 1 pages for object "im__Image".
DBCC results for 'au_Features'.
There are 0 rows in 1 pages for object "au_Features".
DBCC results for 'st_Duration'.
There are 6 rows in 1 pages for object "st_Duration".
DBCC results for 'pf_Delivery'.
There are 18 rows in 1 pages for object "pf_Delivery".
DBCC results for 'au_EbayReturnPolicy'.
There are 0 rows in 0 pages for object "au_EbayReturnPolicy".
DBCC results for 'au_Note'.
There are 0 rows in 0 pages for object "au_Note".
DBCC results for 'pf_PrintForm'.
There are 28 rows in 1 pages for object "pf_PrintForm".
DBCC results for 'st_Enhancement'.
There are 7 rows in 1 pages for object "st_Enhancement".
DBCC results for 'ins_blokada'.
There are 505 rows in 9 pages for object "ins_blokada".
DBCC results for 'au_Payment'.
There are 1318 rows in 4 pages for object "au_Payment".
DBCC results for 'st_Insurance'.
There are 36 rows in 1 pages for object "st_Insurance".
DBCC results for 'ins_counter'.
There are 4 rows in 1 pages for object "ins_counter".
DBCC results for 'pp_PrintParams'.
There are 0 rows in 0 pages for object "pp_PrintParams".
DBCC results for 'ins_ident'.
There are 110 rows in 1 pages for object "ins_ident".
DBCC results for 'au_Picture'.
There are 949 rows in 4 pages for object "au_Picture".
DBCC results for 'st_Payment'.
There are 3 rows in 1 pages for object "st_Payment".
DBCC results for 'it__Item'.
There are 0 rows in 0 pages for object "it__Item".
DBCC results for 'tr__Transaction'.
There are 4809 rows in 291 pages for object "tr__Transaction".
DBCC results for 'au_Shipping'.
There are 3394 rows in 25 pages for object "au_Shipping".
DBCC results for 'st_Region'.
There are 17 rows in 1 pages for object "st_Region".
DBCC results for 'sl_SendingNumbersPool'.
There are 0 rows in 0 pages for object "sl_SendingNumbersPool".
DBCC results for 'au_SynchParam'.
There are 1 rows in 1 pages for object "au_SynchParam".
DBCC results for 'st_Shipping'.
There are 63 rows in 1 pages for object "st_Shipping".
DBCC results for 'reg__Registration'.
There are 1 rows in 1 pages for object "reg__Registration".
DBCC results for 'st_ShippingLocation'.
There are 0 rows in 0 pages for object "st_ShippingLocation".
DBCC results for 'tp__HtmlTemplate'.
There are 17 rows in 1 pages for object "tp__HtmlTemplate".
DBCC results for 'it_AuctionTemplate'.
There are 0 rows in 0 pages for object "it_AuctionTemplate".
DBCC results for 'reg_Data'.
There are 18 rows in 9 pages for object "reg_Data".
DBCC results for 'ds_DeliveryToShippingMap'.
There are 2 rows in 1 pages for object "ds_DeliveryToShippingMap".
DBCC results for 'tp_Image'.
There are 0 rows in 0 pages for object "tp_Image".
DBCC results for 'it_ItemPictures'.
There are 0 rows in 0 pages for object "it_ItemPictures".
DBCC results for 'cs__Customer'.
There are 4628 rows in 77 pages for object "cs__Customer".
DBCC results for 'nm_IgnoredMessages'.
There are 0 rows in 1 pages for object "nm_IgnoredMessages".
DBCC results for 'reg_Site'.
There are 1 rows in 1 pages for object "reg_Site".
DBCC results for 'nm_NotifierMessage'.
There are 6 rows in 1 pages for object "nm_NotifierMessage".
DBCC results for 'it_ItemProp'.
There are 0 rows in 0 pages for object "it_ItemProp".
DBCC results for 'rn_ReturnedNumber'.
There are 0 rows in 0 pages for object "rn_ReturnedNumber".
DBCC results for 'it_ItemSite'.
There are 0 rows in 0 pages for object "it_ItemSite".
DBCC results for 'sl_AuctionGroup'.
There are 0 rows in 0 pages for object "sl_AuctionGroup".
DBCC results for 'sl_AuctionTemplateGroup'.
There are 0 rows in 0 pages for object "sl_AuctionTemplateGroup".
DBCC results for 'cs_CustEmail'.
There are 4560 rows in 33 pages for object "cs_CustEmail".
DBCC results for 'sl_Categories'.
There are 0 rows in 0 pages for object "sl_Categories".
DBCC results for 'sl_CommentTemplate'.
There are 11 rows in 1 pages for object "sl_CommentTemplate".
DBCC results for 'cs_CustIM'.
There are 0 rows in 0 pages for object "cs_CustIM".
DBCC results for 'sl_Currency'.
There are 8 rows in 1 pages for object "sl_Currency".
DBCC results for 'cs_CustomerProp'.
There are 0 rows in 0 pages for object "cs_CustomerProp".
DBCC results for 'cs_CustPhone'.
There are 5517 rows in 29 pages for object "cs_CustPhone".
DBCC results for 'sl_CurrencyBank'.
There are 1 rows in 1 pages for object "sl_CurrencyBank".
DBCC results for 'au_Allegro'.
There are 950 rows in 10 pages for object "au_Allegro".
DBCC results for 'sl_CurrencyExchangeRates'.
There are 0 rows in 0 pages for object "sl_CurrencyExchangeRates".
DBCC results for 'ctx_UserSite'.
There are 1 rows in 1 pages for object "ctx_UserSite".
DBCC results for 'sl_CurrencyExchangeRatesEntry'.
There are 0 rows in 0 pages for object "sl_CurrencyExchangeRatesEntry".
DBCC results for 'jb__Job'.
There are 232 rows in 3 pages for object "jb__Job".
DBCC results for 'dr__DelivererParams'.
There are 20 rows in 1 pages for object "dr__DelivererParams".
DBCC results for 'jb_Message'.
There are 2243 rows in 422 pages for object "jb_Message".
DBCC results for 'log__Sync'.
There are 32 rows in 1 pages for object "log__Sync".
DBCC results for 'sl_CustomerGroup'.
There are 3 rows in 1 pages for object "sl_CustomerGroup".
DBCC results for 'dr_RegData'.
There are 0 rows in 0 pages for object "dr_RegData".
DBCC results for 'log_Message'.
There are 2 rows in 1 pages for object "log_Message".
DBCC results for 'sl_CustProperty'.
There are 0 rows in 0 pages for object "sl_CustProperty".
DBCC results for 'nt__Note'.
There are 0 rows in 0 pages for object "nt__Note".
DBCC results for 'em__Email'.
There are 62025 rows in 3838 pages for object "em__Email".
DBCC results for 'sl_Deliverer'.
There are 3 rows in 1 pages for object "sl_Deliverer".
DBCC results for 'sl_Delivery'.
There are 7 rows in 1 pages for object "sl_Delivery".
DBCC results for 'tr_AutoMsgParams'.
There are 1 rows in 1 pages for object "tr_AutoMsgParams".
DBCC results for 'em_Account'.
There are 1 rows in 1 pages for object "em_Account".
DBCC results for 'tr_Comment'.
There are 2199 rows in 119 pages for object "tr_Comment".
DBCC results for 'pd_AutoSyncParams'.
There are 1 rows in 1 pages for object "pd_AutoSyncParams".
DBCC results for 'nt_Notes'.
There are 0 rows in 0 pages for object "nt_Notes".
DBCC results for 'tr_Default'.
There are 1 rows in 1 pages for object "tr_Default".
DBCC results for 'sl_EmailGroup'.
There are 2 rows in 1 pages for object "sl_EmailGroup".
DBCC results for 'sl_InstantMessenger'.
There are 3 rows in 1 pages for object "sl_InstantMessenger".
DBCC results for 'au_CategorySpecific'.
There are 881 rows in 6 pages for object "au_CategorySpecific".
DBCC results for 'sl_ItemGroup'.
There are 0 rows in 0 pages for object "sl_ItemGroup".
DBCC results for 'sl_ItemProperty'.
There are 0 rows in 0 pages for object "sl_ItemProperty".
DBCC results for 'st_CategorySpecific'.
There are 18144 rows in 322 pages for object "st_CategorySpecific".
DBCC results for 'em_Attachment'.
There are 98 rows in 3 pages for object "em_Attachment".
DBCC results for 'sl_Language'.
There are 4 rows in 1 pages for object "sl_Language".
DBCC results for 'pc__Package'.
There are 4555 rows in 89 pages for object "pc__Package".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'tr_Group'.
There are 86 rows in 1 pages for object "tr_Group".
DBCC results for 'nm_Params'.
There are 1 rows in 1 pages for object "nm_Params".
DBCC results for 'em_Rule'.
There are 0 rows in 0 pages for object "em_Rule".
DBCC results for 'sl_Link'.
There are 4 rows in 1 pages for object "sl_Link".
DBCC results for 'nt_Note'.
There are 1092 rows in 9 pages for object "nt_Note".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'tr_History'.
There are 30006 rows in 588 pages for object "tr_History".
DBCC results for 'pc_History'.
There are 4856 rows in 40 pages for object "pc_History".
DBCC results for 'tr_Item'.
There are 4884 rows in 85 pages for object "tr_Item".
DBCC results for 'sl_MsgTemplate'.
There are 0 rows in 0 pages for object "sl_MsgTemplate".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'pc_Item'.
There are 4626 rows in 17 pages for object "pc_Item".
DBCC results for 'sl_NoteTemplate'.
There are 0 rows in 0 pages for object "sl_NoteTemplate".
DBCC results for '__BeforeDropOldTables'.
There are 0 rows in 0 pages for object "__BeforeDropOldTables".
DBCC results for 'em_RuleWord'.
There are 0 rows in 0 pages for object "em_RuleWord".
DBCC results for 'tr_Note'.
There are 0 rows in 0 pages for object "tr_Note".
DBCC results for 'sl_NoteType'.
There are 0 rows in 0 pages for object "sl_NoteType".
DBCC results for '__Modyfikacja'.
There are 0 rows in 0 pages for object "__Modyfikacja".
DBCC results for 'pc_SendingList'.
There are 41 rows in 1 pages for object "pc_SendingList".
DBCC results for 'em_Signature'.
There are 0 rows in 0 pages for object "em_Signature".
DBCC results for '__PostUpdate'.
There are 0 rows in 0 pages for object "__PostUpdate".
DBCC results for 'tr_Property'.
There are 1 rows in 1 pages for object "tr_Property".
DBCC results for 'sl_Payment'.
There are 4 rows in 1 pages for object "sl_Payment".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'huzia'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

[Bartosz Rosa 1 775]

Fizycznie baza nie wygląda na uszkodzoną, ale może być w niej uszkodzenie logiczne. Reset serwera SQL rozumiem, że również nie pomaga?

[michał michałek 1]

Reset tzn ? właczenie wyłaczenie serwera ?

 

edit

Mogę zaksiegować wpłatę a jak chcę odznaczyć paczki do wysyłki jako wysłane lub utworzyć nową paczkę to wywala błąd "błąd ? zapis itd"

To samo z wystawianiem aukcji oraz sciaganiem wiadomości

Mam sello (1.8.4.1465)

 

[Bartosz Rosa 1 775]

Proszę za pomocą programu serwisowego (admin.exe) lub management studio wykonać poniższe polecenie na bazie do której łączy się Sello.

 

DECLARE @all_tables TABLE (tableName nvarchar(250), PK nvarchar(50), ido_wartosc INT, max_id int, error nvarchar(20), processed int )
INSERT INTO @all_tables(tableName, PK, ido_wartosc, max_id, error, processed ) 
SELECT tabs.TABLE_NAME as tableName, col.Column_Name PK, insIdent.ido_wartosc, 0, '',0 from 
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab, 
    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col,
    information_schema.tables tabs,
    ins_ident insIdent
WHERE 
    Col.Constraint_Name = Tab.Constraint_Name
    AND Col.Table_Name = Tab.Table_Name
    AND Constraint_Type = 'PRIMARY KEY '
    AND Col.Table_Name = tabs.TABLE_NAME 
    and insIdent.ido_nazwa = tabs.TABLE_NAME
   group by tabs.TABLE_NAME, col.COLUMN_NAME, insIdent.ido_wartosc

Declare @tableName nvarchar(250)
Declare @pk nvarchar(50)
declare @table_id table( id1 int )

While (exists(Select * From @all_tables Where Processed = 0) )
Begin
	Select Top 1 @tableName = tableName, @pk = PK From @all_tables Where Processed = 0
	Declare @max_id int

delete from @table_id
insert into @table_id exec('SELECT max(' + @pk + ') FROM ' + @tableName ) 
select top 1 @max_id = id1 from @table_id

Update @all_tables Set Processed = 1, max_id = @max_id Where tableName = @tableName 
Update @all_tables Set error = 'X' where tableName = @tableName and ido_wartosc <= max_id
End

select tableName, ido_wartosc, max_id, error from @all_tables

 

 

I podać listę tabel dla których w kolumnie error będzie znak X.

 

 

[michał michałek 1]

Gdzie X to error

 

Zbliżone wartości do maksymalnych przy X tak na pierwszy rzut oka ?

 

 

adr__Address 27146 27246         X

au__Auction 2081 2082         X

au_Allegro 2081 2082         X

au_CategorySpecific 1949 1950 X

au_DescriptionImage 1 NULL

au_Ebay 1000 NULL

au_Enhancement 721959 721956

au_Features 1004 NULL

au_Note 1000 NULL

au_Payment 4764 4763

au_Picture 1669 1670         X

au_Shipping 6978 6985         X

cs__Customer 5621 5635         X

cs_CustEmail 5554 5568         X

cs_CustIM 1000 NULL

cs_CustomerProp 5 NULL

cs_CustPhone 6500 6517         X

dr__DelivererParams 1024 1023

dr_RegData 1113 NULL

ds_DeliveryToShippingMap 1002 1001

em__Email 64280 64310         X

em_Account 1005 1004

em_Attachment 1122 1123         X

em_Rule 1000 NULL

em_RuleWord 1000 NULL

em_Source 63330 63360         X

em_Template 1011 1010

ep__Registration 2 1

ep_ExternalProgram 1 1 X

ep_OfflineQueue 1 NULL

igt_UsersMapping 1007 NULL

im__Image 1092 1091

it__Item 1000 NULL

it_AuctionTemplate 1000 NULL

it_ItemPictures 1025 NULL

it_ItemProp 34 NULL

it_ItemSite 1005 NULL

jb__Job 76857 76864                 X

jb_Message 429865 430584         X

nm_IgnoredMessages 1018 NULL

nm_NotifierMessage 1104 1103

nt__Note 1005 NULL

nt_Note 2145 2144

nt_Notes 1000 NULL

pb__PostBuyFormData 5107 5130 X

pb_PostBuyFormTransaction 24674 24701 X

pc__Package 5628 5635         X

pc_History 6063 6035

pc_Item 5722 5729                 X

pc_SendingList 1050 1049

pc_SendingListPackage 1261 1260

pc_Transaction 1038 NULL

pd_UserPermission 1005 1004

pf_Delivery 1005 1004

pf_PrintForm 1000 28

reg__Registration 1003 1002

reg_Data 1041 1040

reg_Site 1017 1016

rn_ReturnedNumber 1000 NULL

sl_AuctionGroup 8 NULL

sl_AuctionTemplateGroup 2 NULL

sl_CommentTemplate 1012 1011

sl_Currency 10 8

sl_CurrencyBank 1 1          X

sl_CurrencyExchangeRates 1003 NULL

sl_CurrencyExchangeRatesEntry 1004 NULL

sl_CustomerGroup 1003 1002

sl_CustProperty 22 NULL

sl_Deliverer 1029 1028

sl_Delivery 1058 1057

sl_EmailGroup 1002 1001

sl_InstantMessenger 1000 3

sl_ItemGroup 9 NULL

sl_ItemProperty 10 NULL

sl_Language 6 4

sl_MsgTemplate 9 NULL

sl_NoteTemplate 1 NULL

sl_NoteType 7 NULL

sl_Payment 12 4

sl_SendingNumbersPool 1000 NULL

sl_SendingNumbersPoolType 1000 3

sl_TransProperty 1002 1001

sl_User 1001 1

st__Site 1001 1000

st_Category 121548 121547

st_CategorySpecific 32044 32043

st_SiteData 1000 NULL

tp__HtmlTemplate 1129 1128

tp_Image 2843 NULL

tr__Transaction 5949 5967       X

tr_Comment 3219 3223       X

tr_Group 1131 1130

tr_Item 6040 6058               X

tr_Note 1004 NULL

tr_Property 1002 1001

tr_TransStatus 1003 NULL

up_UserParams 1011 1010

 

 

 

[Bartosz Rosa 1 775]

Sporo tego. Czy w czasie gdy problem się pojawił wystąpiły jakieś szczególne zdarzenia, jak zanik prądu, zawieszenie się komputera itp?

 

Poniżej skrypty naprawiające problem.

update ins_ident set ido_wartosc = (select max(adr__Address.adr_Id)+1 from adr__Address) where ido_nazwa like 'adr__Address'
update ins_ident set ido_wartosc = (select max(au__Auction.au_Id)+1 from au__Auction) where ido_nazwa like 'au__Auction'
update ins_ident set ido_wartosc = (select max(au_CategorySpecific.as_Id)+1 from au_CategorySpecific) where ido_nazwa like 'au_CategorySpecific'
update ins_ident set ido_wartosc = (select max(au_Picture.ap_Id)+1 from au_Picture) where ido_nazwa like 'au_Picture'
update ins_ident set ido_wartosc = (select max(au_Shipping.as_Id)+1 from au_Shipping) where ido_nazwa like 'au_Shipping'
update ins_ident set ido_wartosc = (select max(cs__Customer.cs_Id)+1 from cs__Customer) where ido_nazwa like 'cs__Customer'
update ins_ident set ido_wartosc = (select max(cs_CustEmail.ce_Id)+1 from cs_CustEmail) where ido_nazwa like 'cs_CustEmail'
update ins_ident set ido_wartosc = (select max(cs_CustPhone.cp_Id)+1 from cs_CustPhone) where ido_nazwa like 'cs_CustPhone'
update ins_ident set ido_wartosc = (select max(em__Email.em_Id)+1 from em__Email) where ido_nazwa like 'em__Email'
update ins_ident set ido_wartosc = (select max(em_Attachment.et_Id)+1 from em_Attachment) where ido_nazwa like 'em_Attachment'
update ins_ident set ido_wartosc = (select max(em_Source.es_Id)+1 from em_Source) where ido_nazwa like 'em_Source'
update ins_ident set ido_wartosc = (select max(jb__Job.lg_Id)+1 from jb__Job) where ido_nazwa like 'jb__Job'
update ins_ident set ido_wartosc = (select max(jb_Message.jm_Id)+1 from jb_Message) where ido_nazwa like 'jb_Message'
update ins_ident set ido_wartosc = (select max(pb__PostBuyFormData.pb_Id)+1 from pb__PostBuyFormData) where ido_nazwa like 'pb__PostBuyFormData'
update ins_ident set ido_wartosc = (select max(pb_PostBuyFormTransaction.pt_Id)+1 from pb_PostBuyFormTransaction) where ido_nazwa like 'pb_PostBuyFormTransaction'
update ins_ident set ido_wartosc = (select max(pc__Package.pc_Id)+1 from pc__Package) where ido_nazwa like 'pc__Package'
update ins_ident set ido_wartosc = (select max(pc_Item.pt_Id)+1 from pc_Item) where ido_nazwa like 'pc_Item'
update ins_ident set ido_wartosc = (select max(tr__Transaction.tr_Id)+1 from tr__Transaction) where ido_nazwa like 'tr__Transaction'
update ins_ident set ido_wartosc = (select max(tr_Comment.tc_Id)+1 from tr_Comment) where ido_nazwa like 'tr_Comment'
update ins_ident set ido_wartosc = (select max(tr_Item.tt_Id)+1 from tr_Item) where ido_nazwa like 'tr_Item'

[michał michałek 1]

Wszystko na razie działa, dziękuje

Prawdopodobną przyczyną było włączenie hibernacji bez uprzedniego wyłączenia programu, być może w tym czasie pobierał jakieś dane.

Możesz wytłumaczyć łopatologicznie co sie stało z bazą ?

 

 

 

[Bartosz Rosa 1 775]

Do nadawania identyfikatorów liczbowych dla nowo tworzonych obiektów w bazie Sello używa osobnej tabeli (nie wbudowanego w SQL Server mechanizmu). Zdarza się czasami, że identyfikatory tam się znajdujące zamiast kolejnego numeru zawierają taki, który jest już użyty. Nie wiemy dlaczego tak się dzieje, więc dlatego pytałem o sytuację, w której problem wystąpił.

 

Sprawdzimy tą hibernację.

[Marcin Leplawy 6]

W wyniku odpalenia skryptu mam błeyw tabelech poniżej:

tableName ido_wartosc max_id error

ep__Registration 2 3 X

ep_ExternalProgram 1 2 X

it_ExternalCustomAttributesDict 1 18 X

sl_CurrencyBank 1 1 X

 

[Bartosz Rosa 1 775]

W tych tabelach może być X i jest to "normalne" zachowanie.

[Marcin Leplawy 6]

Nadal mam błąd przy zapisie jakiejś aukcji "Błąd zapisy do bazy danych"

[Alwin Kolano 143]

Nadal mam błąd przy zapisie jakiejś aukcji "Błąd zapisy do bazy danych"

Zakładałeś wątek tutaj https://forum.sello.pl/index.php?topic=9239.0 zainteresuj się odpowiedzią o Zdublowane kategorie i Błąd zapisu do bazy danych

[Ks. Robak 314]

Można spróbować naprawić bazę danych

 

https://forum.sello.pl/index.php?topic=10505.msg73644#msg73644

[Roman Domański 0]

W dniu 7.08.2013 o 14:05, Bartosz Rosa napisał:

Proszę za pomocą programu serwisowego (admin.exe) lub management studio wykonać poniższe polecenie na bazie do której łączy się Sello.

 

DECLARE @all_tables TABLE (tableName nvarchar(250), PK nvarchar(50), ido_wartosc INT, max_id int, error nvarchar(20), processed int )
INSERT INTO @all_tables(tableName, PK, ido_wartosc, max_id, error, processed ) 
SELECT tabs.TABLE_NAME as tableName, col.Column_Name PK, insIdent.ido_wartosc, 0, '',0 from 
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab, 
    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col,
    information_schema.tables tabs,
    ins_ident insIdent
WHERE 
    Col.Constraint_Name = Tab.Constraint_Name
    AND Col.Table_Name = Tab.Table_Name
    AND Constraint_Type = 'PRIMARY KEY '
    AND Col.Table_Name = tabs.TABLE_NAME 
    and insIdent.ido_nazwa = tabs.TABLE_NAME
   group by tabs.TABLE_NAME, col.COLUMN_NAME, insIdent.ido_wartosc

Declare @tableName nvarchar(250)
Declare @pk nvarchar(50)
declare @table_id table( id1 int )

While (exists(Select * From @all_tables Where Processed = 0) )
Begin
	Select Top 1 @tableName = tableName, @pk = PK From @all_tables Where Processed = 0
	Declare @max_id int

delete from @table_id
insert into @table_id exec('SELECT max(' + @pk + ') FROM ' + @tableName ) 
select top 1 @max_id = id1 from @table_id

Update @all_tables Set Processed = 1, max_id = @max_id Where tableName = @tableName 
Update @all_tables Set error = 'X' where tableName = @tableName and ido_wartosc <= max_id
End

select tableName, ido_wartosc, max_id, error from @all_tables

 

 

I podać listę tabel dla których w kolumnie error będzie znak X.

 

 

Witam,

Czy jest szansa na zbudowanie takiego zapytania, które można uruchomić na bazie danych Subiekt GT?

Mam problem przy tworzeniu formatowania warunkowego - jak próbuję zapisać takowe dostaje powiadomienie "dymek" z informacją Błąd - Błąd zapisu do bazy danych

[Andrzej Kubik 1 098]

Witam,
Czy jest szansa na zbudowanie takiego zapytania, które można uruchomić na bazie danych Subiekt GT?
Mam problem przy tworzeniu formatowania warunkowego - jak próbuję zapisać takowe dostaje powiadomienie "dymek" z informacją Błąd - Błąd zapisu do bazy danych

Ale przecież to zupełnie innego rodzaju błąd

[Bartosz Rosa 1 775]

21 godzin temu, Roman Domański napisał:

zy jest szansa na zbudowanie takiego zapytania, które można uruchomić na bazie danych Subiekt GT?

Powinno ono zadziałać też na bazie Subiekta.