Skocz do zawartości
Forum użytkowników
PIOTR  JAKIMIEC JAKIMIEC

Problem Sello z wersją 1.32.2 po instalacji

Polecane posty

Napisano (edytowany)

Po aktualizacji w grudniu 2019 Sello z wersji  1.31.3  do wersji 1.32.2  pojawiają się problemy w działaniu.

Pierwszy to  wyskakujące okienko "Wystąpił błąd w skrypcie na tej stronie .... " 

https://connect.facebook.net/en_US/fbevents.js

( w załączeniu zrzut ekranu)

Screenshot_395.thumb.png.520f4692b567ce65e4f214ecb7bbcf53.png

 

Pojawia się to za każdym razem jak uruchamiamy  sello. Potwierdzamy to okno ( nie wiem czy dobrze robimy?)

Po potwierdzeniu lub nie za parę chwil pojawia się iż  mamy problem z bazą danych.

Uszkodzone  tabele w bazie  danych : jb__Job, jb_Message  ( w załączeniu zrzut ekranu)

Oczywiście wykonujemy instrukcję  "Napraw problem" 

Poniżej jest okno  "wynik naprawy" a w nim nic.....

Po odświeżeniu  już nie mamy błędu.

Po chwilowej pracy oraz po  ponownym wyłączeniu i włączeniu  ( obojętnie czy klient/serwer) błąd z bazą danych pojawia się a przed nim  ten błąd  skryptu...

Zrobiłem powrót do  bazy danych z przed  instalacją aktualizacji ( na serwerze)

- odinstalowałem sello z wersją 1.32.2 (restart)

- zainstalowałem sello z wersją 1.31.3 ( restart)

- wczytałem zarchiwizowane dane dla wersji 1.31.3 ( restart)

- wszystko  wróciło  do normy ( brak błędów bazy danych)

- wielkość bazy danych dla wersji 1.31.3 to około 7/8 Gb

Po uruchomieniu starej wersji Sello  dokonałem aktualizację  do wersji 1.32.2, i niestety  wszystkie objawy  ponowiły się...

Pracowaliśmy tak poprzez funkcję napraw to lecz po kilku dniach doszło do uszkodzenia bazy danych w takim stopniu że już  nie mogliśmy tego naprawić poprzez tą funkcje

- nie mogliśmy  wejść w sekcję AUKCJE - Trwające - Zakończone - Wszystkie

Całość była pusta ( biała)

Do tego pojawiły się błędy  z zaciągnięciem  towarów z subiekta " brak towaru lub powiązania...."

Nie ściągały się aukcje i zamówienia "transakcje"

Oprócz tego  z uwagi iż Sello jest na tym samym serwerze co Subiekt  to Subiekt nam zaczął wolno chodzić , więc  przerzuciłem Sello  na inny serwer i od nowa ustawiłem to poczynając od stabilnej wersji 1.31.3 do aktualizacji  wersji 1.32.2

lecz dla Sello to nie pomogło, jedynie Subiekt  chodzi stabilnie.

 

Poniżej klika zrzutów problemu wraz z godzinami jak to  się dzieje, że po chwili pracy mamy znów do czynienia z tym samym....

 

Jedyna zmiana  jaka się pojawiła w korzystaniu z Sello  z wersji 1.31.3 to to iż tu go używaliśmy tylko do odczytywania transakcji i wykonywania dokumentu końcowego czyli Faktury, natomiast  na wersji  1.32.2 zaczęliśmy wykonywać wysyłki Paczki Inpost z Sello ( ale czy to ma znaczenie jakieś?)   

Myślę że nie, gdyż Sello ma jeszcze inne fajne funkcje , których nie używamy a przymierzam się do nich takich jak Wysyłka powiadomień do klientów....

 

Proszę o jakieś wskazówki  dotyczące tego problem 

 

 

 

 

 

 

 

 

 

 

Screenshot_396.png

Screenshot_397.png

Screenshot_398.png

Screenshot_399.png

Screenshot_400.png

Screenshot_401.png

Edytowano przez PIOTR JAKIMIEC JAKIMIEC

Udostępnij ten post


Link to postu
1 godzinę temu, PIOTR JAKIMIEC JAKIMIEC napisał:

Pojawia się to za każdym razem jak uruchamiamy  sello. Potwierdzamy to okno ( nie wiem czy dobrze robimy?)

W zasadzie to jest problem ze skryptami facebooka na naszej stronie z aktualnościami w nowej wersji, która ładowana jest w zakładce NOWOŚCI. Nie jest on w żaden sposób niebezpieczny i nie wpływa na pracę. Aby się nie pojawiał proszę wybrać funkcję po lewej, żeby nie wyświetlała się więcej zakładka NOWOŚCI. W wersji 1.33 problem ze skryptem będzie usunięty.

1 godzinę temu, PIOTR JAKIMIEC JAKIMIEC napisał:

Pracowaliśmy tak poprzez funkcję napraw to lecz po kilku dniach doszło do uszkodzenia bazy danych w takim stopniu że już  nie mogliśmy tego naprawić poprzez tą funkcje

- nie mogliśmy  wejść w sekcję AUKCJE - Trwające - Zakończone - Wszystkie

Sello wykrywa problem z jedną z tabeli, ale jest to problem natury logicznej (niespójne dane). Natomiast obawiam się, że skoro występuje on tak często i dochodzą do tego inne zjawiska to sam plik bazy danych może być uszkodzony co generuje kolejne problemy.

Zacząłbym od przeskanowania dysku twardego, na którym jest baza danych Sello czy nie jest on przypadkiem uszkodzony, bo taki może być jeden z pierwszych objawów.

Następnie, korzystając z programu serwisowego proszę wykonać poniższe polecenie SQL (przycisk zaawansowane)

DBCC CHECKDB(Sello2020)

i sprawdzić czy w wyniku pojawią się jakieś informacje o znalezionych błędach w bazie. To może chwilę potrwać.

Udostępnij ten post


Link to postu
4 minuty temu, Bartosz Rosa napisał:

Zacząłbym od przeskanowania dysku twardego, na którym jest baza danych Sello czy nie jest on przypadkiem uszkodzony, bo taki może być jeden z pierwszych objawów.

Dysk chyba możemy wykluczyć, sello zostało przeniesione na inny komputer wraz z bazą

7 minut temu, Bartosz Rosa napisał:

Sello wykrywa problem z jedną z tabeli, ale jest to problem natury logicznej (niespójne dane). Natomiast obawiam się, że skoro występuje on tak często i dochodzą do tego inne zjawiska to sam plik bazy danych może być uszkodzony co generuje kolejne problemy.

Jeżeli to przyczyna to jakie jest rozwiązanie? Bo przenoszenie  zarchiwizowanych danych nawet z grudnia nic nie da??? 

 

Tak więc zabieram się do sprawdzenia jak mi podałeś i zobaczymy co się  urodzi

Udostępnij ten post


Link to postu

Serwer potrafi naprawić bazę, ale możliwe są wtedy straty w danych (tych uszkodzonych) - niekoniecznie są to istotne dane.

Udostępnij ten post


Link to postu

Nie wiem czy dobrze to zrobiłem ale przesyłam wynik z MSSMS

 

DBCC results for 'Sello2020'.

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.

Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.

DBCC results for 'sys.sysrscols'.

There are 2523 rows in 35 pages for object "sys.sysrscols".

DBCC results for 'sys.sysrowsets'.

There are 360 rows in 8 pages for object "sys.sysrowsets".

DBCC results for 'sys.sysclones'.

There are 0 rows in 0 pages for object "sys.sysclones".

DBCC results for 'sys.sysallocunits'.

There are 418 rows in 10 pages for object "sys.sysallocunits".

DBCC results for 'sys.sysfiles1'.

There are 2 rows in 1 pages for object "sys.sysfiles1".

DBCC results for 'sys.sysseobjvalues'.

There are 0 rows in 0 pages for object "sys.sysseobjvalues".

DBCC results for 'sys.syspriorities'.

There are 0 rows in 0 pages for object "sys.syspriorities".

DBCC results for 'sys.sysdbfrag'.

There are 0 rows in 0 pages for object "sys.sysdbfrag".

DBCC results for 'sys.sysfgfrag'.

There are 0 rows in 0 pages for object "sys.sysfgfrag".

DBCC results for 'sys.sysdbfiles'.

There are 2 rows in 1 pages for object "sys.sysdbfiles".

DBCC results for 'sys.syspru'.

There are 0 rows in 0 pages for object "sys.syspru".

DBCC results for 'sys.sysbrickfiles'.

There are 0 rows in 0 pages for object "sys.sysbrickfiles".

DBCC results for 'sys.sysphfg'.

There are 1 rows in 1 pages for object "sys.sysphfg".

DBCC results for 'sys.sysprufiles'.

There are 2 rows in 1 pages for object "sys.sysprufiles".

DBCC results for 'sys.sysftinds'.

There are 0 rows in 0 pages for object "sys.sysftinds".

DBCC results for 'sys.sysowners'.

There are 15 rows in 1 pages for object "sys.sysowners".

DBCC results for 'sys.sysdbreg'.

There are 0 rows in 0 pages for object "sys.sysdbreg".

DBCC results for 'sys.sysprivs'.

There are 287 rows in 2 pages for object "sys.sysprivs".

DBCC results for 'sys.sysschobjs'.

There are 3197 rows in 73 pages for object "sys.sysschobjs".

DBCC results for 'sys.syscsrowgroups'.

There are 0 rows in 0 pages for object "sys.syscsrowgroups".

DBCC results for 'sys.sysexttables'.

There are 0 rows in 0 pages for object "sys.sysexttables".

DBCC results for 'sys.syscolpars'.

There are 2818 rows in 81 pages for object "sys.syscolpars".

DBCC results for 'sys.sysxlgns'.

There are 0 rows in 0 pages for object "sys.sysxlgns".

DBCC results for 'sys.sysxsrvs'.

There are 0 rows in 0 pages for object "sys.sysxsrvs".

DBCC results for 'sys.sysnsobjs'.

There are 1 rows in 1 pages for object "sys.sysnsobjs".

DBCC results for 'sys.sysusermsgs'.

There are 0 rows in 0 pages for object "sys.sysusermsgs".

DBCC results for 'sys.syscerts'.

There are 0 rows in 0 pages for object "sys.syscerts".

DBCC results for 'sys.sysrmtlgns'.

There are 0 rows in 0 pages for object "sys.sysrmtlgns".

DBCC results for 'sys.syslnklgns'.

There are 0 rows in 0 pages for object "sys.syslnklgns".

DBCC results for 'sys.sysxprops'.

There are 1230 rows in 64 pages for object "sys.sysxprops".

DBCC results for 'sys.sysscalartypes'.

There are 95 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 709 rows in 15 pages for object "sys.sysidxstats".

DBCC results for 'sys.sysiscols'.

There are 911 rows in 5 pages for object "sys.sysiscols".

DBCC results for 'sys.sysendpts'.

There are 0 rows in 0 pages for object "sys.sysendpts".

DBCC results for 'sys.syswebmethods'.

There are 0 rows in 0 pages for object "sys.syswebmethods".

DBCC results for 'sys.sysbinobjs'.

There are 23 rows in 1 pages for object "sys.sysbinobjs".

DBCC results for 'sys.sysaudacts'.

There are 0 rows in 0 pages for object "sys.sysaudacts".

DBCC results for 'sys.sysobjvalues'.

There are 1166 rows in 282 pages for object "sys.sysobjvalues".

DBCC results for 'sys.syscscolsegments'.

There are 0 rows in 0 pages for object "sys.syscscolsegments".

DBCC results for 'sys.syscsdictionaries'.

There are 0 rows in 0 pages for object "sys.syscsdictionaries".

DBCC results for 'sys.sysclsobjs'.

There are 16 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 848 rows in 10 pages for object "sys.syssingleobjrefs".

DBCC results for 'sys.sysmultiobjrefs'.

There are 1294 rows in 17 pages for object "sys.sysmultiobjrefs".

DBCC results for 'sys.sysguidrefs'.

There are 0 rows in 0 pages for object "sys.sysguidrefs".

DBCC results for 'sys.sysfoqueues'.

There are 0 rows in 0 pages for object "sys.sysfoqueues".

DBCC results for 'sys.syschildinsts'.

There are 0 rows in 0 pages for object "sys.syschildinsts".

DBCC results for 'sys.syscompfragments'.

There are 0 rows in 0 pages for object "sys.syscompfragments".

DBCC results for 'sys.sysftsemanticsdb'.

There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".

DBCC results for 'sys.sysftstops'.

There are 0 rows in 0 pages for object "sys.sysftstops".

DBCC results for 'sys.sysftproperties'.

There are 0 rows in 0 pages for object "sys.sysftproperties".

DBCC results for 'sys.sysxmitbody'.

There are 0 rows in 0 pages for object "sys.sysxmitbody".

DBCC results for 'sys.sysfos'.

There are 0 rows in 0 pages for object "sys.sysfos".

DBCC results for 'sys.sysqnames'.

There are 98 rows in 1 pages for object "sys.sysqnames".

DBCC results for 'sys.sysxmlcomponent'.

There are 100 rows in 1 pages for object "sys.sysxmlcomponent".

DBCC results for 'sys.sysxmlfacet'.

There are 112 rows in 1 pages for object "sys.sysxmlfacet".

DBCC results for 'sys.sysxmlplacement'.

There are 19 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 3 rows in 1 pages for object "sys.sysbinsubobjs".

DBCC results for 'sys.syssoftobjrefs'.

There are 142 rows in 4 pages for object "sys.syssoftobjrefs".

DBCC results for 'sys.plan_persist_plan'.

There are 0 rows in 0 pages for object "sys.plan_persist_plan".

DBCC results for 'em_Rule'.

There are 0 rows in 0 pages for object "em_Rule".

DBCC results for 'sys.plan_persist_runtime_stats'.

There are 0 rows in 0 pages for object "sys.plan_persist_runtime_stats".

DBCC results for 'xcs_Ewid'.

There are 308305 rows in 1699 pages for object "xcs_Ewid".

DBCC results for 'sys.plan_persist_runtime_stats_interval'.

There are 0 rows in 0 pages for object "sys.plan_persist_runtime_stats_interval".

DBCC results for 'st__Site'.

There are 1 rows in 1 pages for object "st__Site".

DBCC results for 'pd_AutoSyncTimes'.

There are 1 rows in 1 pages for object "pd_AutoSyncTimes".

DBCC results for 'xcs_Szum'.

There are 48 rows in 1 pages for object "xcs_Szum".

DBCC results for 'sys.plan_persist_context_settings'.

There are 0 rows in 0 pages for object "sys.plan_persist_context_settings".

DBCC results for 'xit_Ewid'.

There are 2324 rows in 19 pages for object "xit_Ewid".

DBCC results for 'xit_Szum'.

There are 48 rows in 1 pages for object "xit_Szum".

DBCC results for 'sys.sqlagent_jobs'.

There are 0 rows in 0 pages for object "sys.sqlagent_jobs".

DBCC results for 'st_AuctionType'.

There are 65 rows in 1 pages for object "st_AuctionType".

DBCC results for 'pd_BankAccounts'.

There are 0 rows in 0 pages for object "pd_BankAccounts".

DBCC results for 'pd_AutoSyncParams'.

There are 1 rows in 1 pages for object "pd_AutoSyncParams".

DBCC results for 'em_RuleWord'.

There are 0 rows in 0 pages for object "em_RuleWord".

DBCC results for 'sys.sqlagent_jobsteps'.

There are 0 rows in 0 pages for object "sys.sqlagent_jobsteps".

DBCC results for 'st_Shipping'.

There are 80 rows in 1 pages for object "st_Shipping".

DBCC results for 'pd_InternetParams'.

There are 1 rows in 1 pages for object "pd_InternetParams".

DBCC results for 'au_CategorySpecific'.

There are 9893 rows in 99 pages for object "au_CategorySpecific".

DBCC results for 'sys.sqlagent_job_history'.

There are 0 rows in 0 pages for object "sys.sqlagent_job_history".

DBCC results for 'em_Signature'.

There are 0 rows in 0 pages for object "em_Signature".

DBCC results for 'sys.sqlagent_jobsteps_logs'.

There are 0 rows in 0 pages for object "sys.sqlagent_jobsteps_logs".

DBCC results for 'pd_Parametr'.

There are 1 rows in 1 pages for object "pd_Parametr".

DBCC results for 'nt_Note'.

There are 6964 rows in 51 pages for object "nt_Note".

DBCC results for 'pd_Permission'.

There are 55 rows in 1 pages for object "pd_Permission".

DBCC results for 'em_Source'.

There are 0 rows in 0 pages for object "em_Source".

DBCC results for 'em_Template'.

There are 9 rows in 1 pages for object "em_Template".

DBCC results for 'au_Error'.

There are 0 rows in 0 pages for object "au_Error".

DBCC results for 'tr__Transaction'.

There are 15985 rows in 701 pages for object "tr__Transaction".

DBCC results for 'pd_Sesja'.

There are 0 rows in 0 pages for object "pd_Sesja".

DBCC results for '__BeforeDropOldTables'.

There are 0 rows in 0 pages for object "__BeforeDropOldTables".

DBCC results for 'ep__Registration'.

There are 3 rows in 1 pages for object "ep__Registration".

DBCC results for '__Modyfikacja'.

There are 0 rows in 0 pages for object "__Modyfikacja".

DBCC results for '__PostUpdate'.

There are 0 rows in 0 pages for object "__PostUpdate".

DBCC results for 'pd_UserPermission'.

There are 240 rows in 1 pages for object "pd_UserPermission".

DBCC results for '__Slowniki'.

There are 0 rows in 0 pages for object "__Slowniki".

DBCC results for 'pb__PostBuyFormData'.

There are 11098 rows in 237 pages for object "pb__PostBuyFormData".

DBCC results for '__Tabele'.

There are 0 rows in 0 pages for object "__Tabele".

DBCC results for 'pf_Delivery'.

There are 59 rows in 1 pages for object "pf_Delivery".

DBCC results for 'ep_ExternalProgram'.

There are 2 rows in 1 pages for object "ep_ExternalProgram".

DBCC results for 'pc__Package'.

There are 8 rows in 1 pages for object "pc__Package".

DBCC results for '__Update'.

There are 0 rows in 0 pages for object "__Update".

DBCC results for 'adr__Address'.

There are 72869 rows in 1785 pages for object "adr__Address".

DBCC results for 'pf_PrintForm'.

There are 32 rows in 1 pages for object "pf_PrintForm".

DBCC results for 'ep_RegData'.

There are 43 rows in 26 pages for object "ep_RegData".

DBCC results for 'ep_UserMapping'.

There are 5 rows in 1 pages for object "ep_UserMapping".

DBCC results for 'st_Country'.

There are 430 rows in 3 pages for object "st_Country".

DBCC results for 'fp__ParamsFTP'.

There are 1 rows in 1 pages for object "fp__ParamsFTP".

DBCC results for 'st_Duration'.

There are 14 rows in 1 pages for object "st_Duration".

DBCC results for 'pl_PricingListData'.

There are 10 rows in 1 pages for object "pl_PricingListData".

DBCC results for 'gr__Konfiguracja'.

There are 0 rows in 0 pages for object "gr__Konfiguracja".

DBCC results for 'gr__KonfiguracjaEx'.

There are 152 rows in 4 pages for object "gr__KonfiguracjaEx".

DBCC results for 'st_Enhancement'.

There are 10 rows in 1 pages for object "st_Enhancement".

DBCC results for 'reg__Registration'.

There are 2 rows in 1 pages for object "reg__Registration".

DBCC results for 'gt__Obiekt'.

There are 11 rows in 1 pages for object "gt__Obiekt".

DBCC results for 'gt_Atrybut'.

There are 0 rows in 0 pages for object "gt_Atrybut".

DBCC results for 'st_Insurance'.

There are 36 rows in 1 pages for object "st_Insurance".

DBCC results for 'gt_Definicja'.

There are 11 rows in 1 pages for object "gt_Definicja".

DBCC results for 'st_Payment'.

There are 0 rows in 0 pages for object "st_Payment".

DBCC results for 'reg_AfterSalesServiceConditions'.

There are 3 rows in 1 pages for object "reg_AfterSalesServiceConditions".

DBCC results for 'gt_Transformacja'.

There are 11 rows in 1 pages for object "gt_Transformacja".

DBCC results for 'reg_Data'.

There are 13 rows in 10 pages for object "reg_Data".

DBCC results for 'gt_TransObiekt'.

There are 0 rows in 0 pages for object "gt_TransObiekt".

DBCC results for 'gt_TransRodzaj'.

There are 2 rows in 1 pages for object "gt_TransRodzaj".

DBCC results for 'st_Region'.

There are 32 rows in 1 pages for object "st_Region".

DBCC results for 'reg_JournalDeals'.

There are 615 rows in 9 pages for object "reg_JournalDeals".

DBCC results for 'im__Image'.

There are 1364 rows in 30 pages for object "im__Image".

DBCC results for 'pc_History'.

There are 24 rows in 1 pages for object "pc_History".

DBCC results for 'au_Allegro'.

There are 2058 rows in 97 pages for object "au_Allegro".

DBCC results for 'reg_Site'.

There are 2 rows in 1 pages for object "reg_Site".

DBCC results for 'pc_Item'.

There are 8 rows in 1 pages for object "pc_Item".

DBCC results for 'tr_Default'.

There are 1 rows in 1 pages for object "tr_Default".

DBCC results for 'rn_ReturnedNumber'.

There are 0 rows in 0 pages for object "rn_ReturnedNumber".

DBCC results for 'ins_blokada'.

There are 368 rows in 12 pages for object "ins_blokada".

DBCC results for 'st_ShippingLocation'.

There are 0 rows in 0 pages for object "st_ShippingLocation".

DBCC results for 'sl_AuctionGroup'.

There are 0 rows in 0 pages for object "sl_AuctionGroup".

DBCC results for 'au_DescriptionImage'.

There are 0 rows in 0 pages for object "au_DescriptionImage".

DBCC results for 'st_SiteData'.

There are 0 rows in 0 pages for object "st_SiteData".

DBCC results for 'sl_AuctionTemplateGroup'.

There are 0 rows in 0 pages for object "sl_AuctionTemplateGroup".

DBCC results for 'pc_SendingList'.

There are 0 rows in 0 pages for object "pc_SendingList".

DBCC results for 'ins_counter'.

There are 2 rows in 1 pages for object "ins_counter".

DBCC results for 'ins_ident'.

There are 117 rows in 1 pages for object "ins_ident".

DBCC results for 'au_Ebay'.

There are 0 rows in 0 pages for object "au_Ebay".

DBCC results for 'tp__HtmlTemplate'.

There are 15 rows in 1 pages for object "tp__HtmlTemplate".

DBCC results for 'sl_CommentTemplate'.

There are 10 rows in 1 pages for object "sl_CommentTemplate".

DBCC results for 'pc_SendingListPackage'.

There are 0 rows in 0 pages for object "pc_SendingListPackage".

DBCC results for 'insx_Parametr'.

There are 1 rows in 1 pages for object "insx_Parametr".

DBCC results for 'sl_Currency'.

There are 16 rows in 1 pages for object "sl_Currency".

DBCC results for 'pd__Podmiot'.

There are 1 rows in 1 pages for object "pd__Podmiot".

DBCC results for 'tp_Image'.

There are 0 rows in 0 pages for object "tp_Image".

DBCC results for 'sl_CurrencyBank'.

There are 1 rows in 1 pages for object "sl_CurrencyBank".

DBCC results for 'au_EbayReturnPolicy'.

There are 0 rows in 0 pages for object "au_EbayReturnPolicy".

DBCC results for 'au_Enhancement'.

There are 8 rows in 1 pages for object "au_Enhancement".

DBCC results for 'sl_CurrencyExchangeRates'.

There are 0 rows in 0 pages for object "sl_CurrencyExchangeRates".

DBCC results for 'au_Features'.

There are 0 rows in 0 pages for object "au_Features".

DBCC results for 'sl_CurrencyExchangeRatesEntry'.

There are 0 rows in 0 pages for object "sl_CurrencyExchangeRatesEntry".

DBCC results for 'au_Note'.

There are 0 rows in 0 pages for object "au_Note".

DBCC results for 'it__Item'.

There are 373 rows in 15 pages for object "it__Item".

DBCC results for 'au_Payment'.

There are 0 rows in 0 pages for object "au_Payment".

DBCC results for 'pb_PostBuyFormTransaction'.

There are 16939 rows in 99 pages for object "pb_PostBuyFormTransaction".

DBCC results for 'sl_CustomAttributes'.

There are 0 rows in 0 pages for object "sl_CustomAttributes".

DBCC results for 'au_PendingChanges'.

There are 0 rows in 0 pages for object "au_PendingChanges".

DBCC results for 'sl_CustomCounter'.

There are 2 rows in 1 pages for object "sl_CustomCounter".

DBCC results for 'au_Picture'.

There are 9281 rows in 34 pages for object "au_Picture".

DBCC results for 'sl_CustomerGroup'.

There are 1 rows in 1 pages for object "sl_CustomerGroup".

DBCC results for 'au_Shipping'.

There are 4366 rows in 25 pages for object "au_Shipping".

DBCC results for 'sl_CustomGlobalAttributes'.

There are 0 rows in 0 pages for object "sl_CustomGlobalAttributes".

DBCC results for 'au_TransactionProperty'.

There are 0 rows in 0 pages for object "au_TransactionProperty".

DBCC results for 'sl_CustProperty'.

There are 0 rows in 0 pages for object "sl_CustProperty".

DBCC results for 'cs__Customer'.

There are 10657 rows in 245 pages for object "cs__Customer".

DBCC results for 'it_AuctionTemplate'.

There are 0 rows in 0 pages for object "it_AuctionTemplate".

DBCC results for 'sl_Deliverer'.

There are 12 rows in 1 pages for object "sl_Deliverer".

DBCC results for 'it_CustomAttributes'.

There are 0 rows in 0 pages for object "it_CustomAttributes".

DBCC results for 'sl_Delivery'.

There are 36 rows in 1 pages for object "sl_Delivery".

DBCC results for 'it_ExternalCustomAttributes'.

There are 0 rows in 0 pages for object "it_ExternalCustomAttributes".

DBCC results for 'it_ExternalCustomAttributesDict'.

There are 0 rows in 0 pages for object "it_ExternalCustomAttributesDict".

DBCC results for 'cs_CustEmail'.

There are 10854 rows in 91 pages for object "cs_CustEmail".

DBCC results for 'jb_Message'.

There are 6294007 rows in 166494 pages for object "jb_Message".

DBCC results for 'md__MetaData'.

There are 1 rows in 1 pages for object "md__MetaData".

DBCC results for 'cs_CustIM'.

There are 0 rows in 0 pages for object "cs_CustIM".

DBCC results for 'nm_Params'.

There are 1 rows in 1 pages for object "nm_Params".

DBCC results for 'it_ItemPictures'.

There are 9 rows in 1 pages for object "it_ItemPictures".

DBCC results for 'cs_CustomerProp'.

There are 0 rows in 0 pages for object "cs_CustomerProp".

DBCC results for 'tr_AutoMsgParams'.

There are 1 rows in 1 pages for object "tr_AutoMsgParams".

DBCC results for 'it_ItemProp'.

There are 1 rows in 1 pages for object "it_ItemProp".

DBCC results for 'cs_CustPhone'.

There are 11928 rows in 77 pages for object "cs_CustPhone".

DBCC results for 'sl_EmailGroup'.

There are 0 rows in 0 pages for object "sl_EmailGroup".

DBCC results for 'tr_Comment'.

There are 0 rows in 0 pages for object "tr_Comment".

DBCC results for 'it_ItemSite'.

There are 0 rows in 0 pages for object "it_ItemSite".

DBCC results for 'sl_ExportType'.

There are 3 rows in 1 pages for object "sl_ExportType".

DBCC results for 'ctx_UserSite'.

There are 4 rows in 1 pages for object "ctx_UserSite".

DBCC results for 'sl_InstantMessenger'.

There are 3 rows in 1 pages for object "sl_InstantMessenger".

DBCC results for 'ds_DeliveryToShippingMap'.

There are 29 rows in 1 pages for object "ds_DeliveryToShippingMap".

DBCC results for 'sl_ItemGroup'.

There are 3 rows in 1 pages for object "sl_ItemGroup".

DBCC results for 'em__Email'.

There are 0 rows in 0 pages for object "em__Email".

DBCC results for 'sl_ItemProperty'.

There are 1 rows in 1 pages for object "sl_ItemProperty".

DBCC results for 'sl_Language'.

There are 4 rows in 1 pages for object "sl_Language".

DBCC results for 'sl_PricingList'.

There are 1 rows in 1 pages for object "sl_PricingList".

DBCC results for 'sl_MsgTemplate'.

There are 0 rows in 0 pages for object "sl_MsgTemplate".

DBCC results for 'em_Account'.

There are 0 rows in 0 pages for object "em_Account".

DBCC results for 'sl_PackageSynchronizationParams'.

There are 135 rows in 74 pages for object "sl_PackageSynchronizationParams".

DBCC results for 'st_Category'.

There are 24472 rows in 247 pages for object "st_Category".

DBCC results for 'tr_Group'.

There are 924 rows in 3 pages for object "tr_Group".

DBCC results for 'sl_SendingNumbersPool'.

There are 0 rows in 0 pages for object "sl_SendingNumbersPool".

DBCC results for 'st_CategorySpecific'.

There are 109 rows in 2 pages for object "st_CategorySpecific".

DBCC results for 'jb__Job'.

There are 3152679 rows in 19112 pages for object "jb__Job".

DBCC results for 'tr_History'.

There are 100255 rows in 1989 pages for object "tr_History".

DBCC results for 'tr_Item'.

There are 16578 rows in 166 pages for object "tr_Item".

DBCC results for 'sys.queue_messages_1977058079'.

There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".

DBCC results for 'au__Auction'.

There are 2058 rows in 121 pages for object "au__Auction".

DBCC results for 'log__Sync'.

There are 3 rows in 1 pages for object "log__Sync".

DBCC results for 'sys.queue_messages_2009058193'.

There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".

DBCC results for 'sl_SendingNumbersPoolType'.

There are 3 rows in 1 pages for object "sl_SendingNumbersPoolType".

DBCC results for 'sys.queue_messages_2041058307'.

There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".

DBCC results for 'sl_ServiceProvider'.

There are 4 rows in 1 pages for object "sl_ServiceProvider".

DBCC results for 'log_Message'.

There are 5557562 rows in 14269 pages for object "log_Message".

DBCC results for 'tr_Property'.

There are 1 rows in 1 pages for object "tr_Property".

DBCC results for 'sys.filestream_tombstone_2073058421'.

There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".

DBCC results for 'nm_IgnoredMessages'.

There are 1 rows in 1 pages for object "nm_IgnoredMessages".

DBCC results for 'pc_Error'.

There are 0 rows in 0 pages for object "pc_Error".

DBCC results for 'em_Archive'.

There are 0 rows in 0 pages for object "em_Archive".

DBCC results for 'sys.syscommittab'.

There are 0 rows in 0 pages for object "sys.syscommittab".

DBCC results for 'sl_TransProperty'.

There are 2 rows in 1 pages for object "sl_TransProperty".

DBCC results for 'up_UserParams'.

There are 34 rows in 17 pages for object "up_UserParams".

DBCC results for 'sys.filetable_updates_2105058535'.

There are 0 rows in 0 pages for object "sys.filetable_updates_2105058535".

DBCC results for 'nm_NotifierMessage'.

There are 5 rows in 1 pages for object "nm_NotifierMessage".

DBCC results for 'sys.plan_persist_query_text'.

There are 0 rows in 0 pages for object "sys.plan_persist_query_text".

DBCC results for 'sl_User'.

There are 4 rows in 1 pages for object "sl_User".

DBCC results for 'em_Attachment'.

There are 0 rows in 0 pages for object "em_Attachment".

DBCC results for 'vw__Konfiguracja'.

There are 90 rows in 1 pages for object "vw__Konfiguracja".

DBCC results for 'sys.plan_persist_query'.

There are 0 rows in 0 pages for object "sys.plan_persist_query".

DBCC results for 'st_CategorySpecificDict'.

There are 627 rows in 6 pages for object "st_CategorySpecificDict".

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Sello2020'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Udostępnij ten post


Link to postu
Napisano (edytowany)

Przed chwilą mam ten sam komunikat iż wystąpił problem z bazą danych.... ( robię  naprawę) 

dodatkowo nie ściąga nowych aukcji wystawionych ponownie z poziomu allegro ( ale tu może jest problem z allegro)

Choć mam nowe powiązania sello -> allegro

 

albo teraz  zrobię zapytanie  do bazy przed naprawą... ?

Edytowano przez PIOTR JAKIMIEC JAKIMIEC

Udostępnij ten post


Link to postu

To wynik po błędzie jaki pokazuje Sello przed naprawą 

 

DBCC results for 'Sello2020'.

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.

Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.

DBCC results for 'sys.sysrscols'.

There are 2523 rows in 35 pages for object "sys.sysrscols".

DBCC results for 'sys.sysrowsets'.

There are 360 rows in 8 pages for object "sys.sysrowsets".

DBCC results for 'sys.sysclones'.

There are 0 rows in 0 pages for object "sys.sysclones".

DBCC results for 'sys.sysallocunits'.

There are 418 rows in 10 pages for object "sys.sysallocunits".

DBCC results for 'sys.sysfiles1'.

There are 2 rows in 1 pages for object "sys.sysfiles1".

DBCC results for 'sys.sysseobjvalues'.

There are 0 rows in 0 pages for object "sys.sysseobjvalues".

DBCC results for 'sys.syspriorities'.

There are 0 rows in 0 pages for object "sys.syspriorities".

DBCC results for 'sys.sysdbfrag'.

There are 0 rows in 0 pages for object "sys.sysdbfrag".

DBCC results for 'sys.sysfgfrag'.

There are 0 rows in 0 pages for object "sys.sysfgfrag".

DBCC results for 'sys.sysdbfiles'.

There are 2 rows in 1 pages for object "sys.sysdbfiles".

DBCC results for 'sys.syspru'.

There are 0 rows in 0 pages for object "sys.syspru".

DBCC results for 'sys.sysbrickfiles'.

There are 0 rows in 0 pages for object "sys.sysbrickfiles".

DBCC results for 'sys.sysphfg'.

There are 1 rows in 1 pages for object "sys.sysphfg".

DBCC results for 'sys.sysprufiles'.

There are 2 rows in 1 pages for object "sys.sysprufiles".

DBCC results for 'sys.sysftinds'.

There are 0 rows in 0 pages for object "sys.sysftinds".

DBCC results for 'sys.sysowners'.

There are 15 rows in 1 pages for object "sys.sysowners".

DBCC results for 'sys.sysdbreg'.

There are 0 rows in 0 pages for object "sys.sysdbreg".

DBCC results for 'sys.sysprivs'.

There are 287 rows in 2 pages for object "sys.sysprivs".

DBCC results for 'sys.sysschobjs'.

There are 3197 rows in 73 pages for object "sys.sysschobjs".

DBCC results for 'sys.syscsrowgroups'.

There are 0 rows in 0 pages for object "sys.syscsrowgroups".

DBCC results for 'sys.sysexttables'.

There are 0 rows in 0 pages for object "sys.sysexttables".

DBCC results for 'sys.syscolpars'.

There are 2818 rows in 81 pages for object "sys.syscolpars".

DBCC results for 'sys.sysxlgns'.

There are 0 rows in 0 pages for object "sys.sysxlgns".

DBCC results for 'sys.sysxsrvs'.

There are 0 rows in 0 pages for object "sys.sysxsrvs".

DBCC results for 'sys.sysnsobjs'.

There are 1 rows in 1 pages for object "sys.sysnsobjs".

DBCC results for 'sys.sysusermsgs'.

There are 0 rows in 0 pages for object "sys.sysusermsgs".

DBCC results for 'sys.syscerts'.

There are 0 rows in 0 pages for object "sys.syscerts".

DBCC results for 'sys.sysrmtlgns'.

There are 0 rows in 0 pages for object "sys.sysrmtlgns".

DBCC results for 'sys.syslnklgns'.

There are 0 rows in 0 pages for object "sys.syslnklgns".

DBCC results for 'sys.sysxprops'.

There are 1230 rows in 64 pages for object "sys.sysxprops".

DBCC results for 'sys.sysscalartypes'.

There are 95 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 710 rows in 15 pages for object "sys.sysidxstats".

DBCC results for 'sys.sysiscols'.

There are 912 rows in 5 pages for object "sys.sysiscols".

DBCC results for 'sys.sysendpts'.

There are 0 rows in 0 pages for object "sys.sysendpts".

DBCC results for 'sys.syswebmethods'.

There are 0 rows in 0 pages for object "sys.syswebmethods".

DBCC results for 'sys.sysbinobjs'.

There are 23 rows in 1 pages for object "sys.sysbinobjs".

DBCC results for 'sys.sysaudacts'.

There are 0 rows in 0 pages for object "sys.sysaudacts".

DBCC results for 'sys.sysobjvalues'.

There are 1167 rows in 282 pages for object "sys.sysobjvalues".

DBCC results for 'sys.syscscolsegments'.

There are 0 rows in 0 pages for object "sys.syscscolsegments".

DBCC results for 'sys.syscsdictionaries'.

There are 0 rows in 0 pages for object "sys.syscsdictionaries".

DBCC results for 'sys.sysclsobjs'.

There are 16 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 848 rows in 10 pages for object "sys.syssingleobjrefs".

DBCC results for 'sys.sysmultiobjrefs'.

There are 1294 rows in 17 pages for object "sys.sysmultiobjrefs".

DBCC results for 'sys.sysguidrefs'.

There are 0 rows in 0 pages for object "sys.sysguidrefs".

DBCC results for 'sys.sysfoqueues'.

There are 0 rows in 0 pages for object "sys.sysfoqueues".

DBCC results for 'sys.syschildinsts'.

There are 0 rows in 0 pages for object "sys.syschildinsts".

DBCC results for 'sys.syscompfragments'.

There are 0 rows in 0 pages for object "sys.syscompfragments".

DBCC results for 'sys.sysftsemanticsdb'.

There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".

DBCC results for 'sys.sysftstops'.

There are 0 rows in 0 pages for object "sys.sysftstops".

DBCC results for 'sys.sysftproperties'.

There are 0 rows in 0 pages for object "sys.sysftproperties".

DBCC results for 'sys.sysxmitbody'.

There are 0 rows in 0 pages for object "sys.sysxmitbody".

DBCC results for 'sys.sysfos'.

There are 0 rows in 0 pages for object "sys.sysfos".

DBCC results for 'sys.sysqnames'.

There are 98 rows in 1 pages for object "sys.sysqnames".

DBCC results for 'sys.sysxmlcomponent'.

There are 100 rows in 1 pages for object "sys.sysxmlcomponent".

DBCC results for 'sys.sysxmlfacet'.

There are 112 rows in 1 pages for object "sys.sysxmlfacet".

DBCC results for 'sys.sysxmlplacement'.

There are 19 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 3 rows in 1 pages for object "sys.sysbinsubobjs".

DBCC results for 'sys.syssoftobjrefs'.

There are 142 rows in 4 pages for object "sys.syssoftobjrefs".

DBCC results for 'sys.plan_persist_plan'.

There are 0 rows in 0 pages for object "sys.plan_persist_plan".

DBCC results for 'em_Rule'.

There are 0 rows in 0 pages for object "em_Rule".

DBCC results for 'sys.plan_persist_runtime_stats'.

There are 0 rows in 0 pages for object "sys.plan_persist_runtime_stats".

DBCC results for 'xcs_Ewid'.

There are 309007 rows in 1707 pages for object "xcs_Ewid".

DBCC results for 'sys.plan_persist_runtime_stats_interval'.

There are 0 rows in 0 pages for object "sys.plan_persist_runtime_stats_interval".

DBCC results for 'st__Site'.

There are 1 rows in 1 pages for object "st__Site".

DBCC results for 'pd_AutoSyncTimes'.

There are 1 rows in 1 pages for object "pd_AutoSyncTimes".

DBCC results for 'xcs_Szum'.

There are 48 rows in 1 pages for object "xcs_Szum".

DBCC results for 'sys.plan_persist_context_settings'.

There are 0 rows in 0 pages for object "sys.plan_persist_context_settings".

DBCC results for 'xit_Ewid'.

There are 2324 rows in 19 pages for object "xit_Ewid".

DBCC results for 'xit_Szum'.

There are 48 rows in 1 pages for object "xit_Szum".

DBCC results for 'sys.sqlagent_jobs'.

There are 0 rows in 0 pages for object "sys.sqlagent_jobs".

DBCC results for 'st_AuctionType'.

There are 65 rows in 1 pages for object "st_AuctionType".

DBCC results for 'pd_BankAccounts'.

There are 0 rows in 0 pages for object "pd_BankAccounts".

DBCC results for 'pd_AutoSyncParams'.

There are 1 rows in 1 pages for object "pd_AutoSyncParams".

DBCC results for 'em_RuleWord'.

There are 0 rows in 0 pages for object "em_RuleWord".

DBCC results for 'sys.sqlagent_jobsteps'.

There are 0 rows in 0 pages for object "sys.sqlagent_jobsteps".

DBCC results for 'st_Shipping'.

There are 80 rows in 1 pages for object "st_Shipping".

DBCC results for 'pd_InternetParams'.

There are 1 rows in 1 pages for object "pd_InternetParams".

DBCC results for 'au_CategorySpecific'.

There are 9893 rows in 99 pages for object "au_CategorySpecific".

DBCC results for 'sys.sqlagent_job_history'.

There are 0 rows in 0 pages for object "sys.sqlagent_job_history".

DBCC results for 'em_Signature'.

There are 0 rows in 0 pages for object "em_Signature".

DBCC results for 'sys.sqlagent_jobsteps_logs'.

There are 0 rows in 0 pages for object "sys.sqlagent_jobsteps_logs".

DBCC results for 'pd_Parametr'.

There are 1 rows in 1 pages for object "pd_Parametr".

DBCC results for 'nt_Note'.

There are 6981 rows in 51 pages for object "nt_Note".

DBCC results for 'pd_Permission'.

There are 55 rows in 1 pages for object "pd_Permission".

DBCC results for 'em_Source'.

There are 0 rows in 0 pages for object "em_Source".

DBCC results for 'em_Template'.

There are 9 rows in 1 pages for object "em_Template".

DBCC results for 'au_Error'.

There are 0 rows in 0 pages for object "au_Error".

DBCC results for 'tr__Transaction'.

There are 16035 rows in 705 pages for object "tr__Transaction".

DBCC results for 'pd_Sesja'.

There are 0 rows in 0 pages for object "pd_Sesja".

DBCC results for '__BeforeDropOldTables'.

There are 0 rows in 0 pages for object "__BeforeDropOldTables".

DBCC results for 'ep__Registration'.

There are 3 rows in 1 pages for object "ep__Registration".

DBCC results for '__Modyfikacja'.

There are 0 rows in 0 pages for object "__Modyfikacja".

DBCC results for '__PostUpdate'.

There are 0 rows in 0 pages for object "__PostUpdate".

DBCC results for 'pd_UserPermission'.

There are 240 rows in 1 pages for object "pd_UserPermission".

DBCC results for '__Slowniki'.

There are 0 rows in 0 pages for object "__Slowniki".

DBCC results for 'pb__PostBuyFormData'.

There are 11129 rows in 238 pages for object "pb__PostBuyFormData".

DBCC results for '__Tabele'.

There are 0 rows in 0 pages for object "__Tabele".

DBCC results for 'pf_Delivery'.

There are 59 rows in 1 pages for object "pf_Delivery".

DBCC results for 'ep_ExternalProgram'.

There are 2 rows in 1 pages for object "ep_ExternalProgram".

DBCC results for 'pc__Package'.

There are 13 rows in 1 pages for object "pc__Package".

DBCC results for '__Update'.

There are 0 rows in 0 pages for object "__Update".

DBCC results for 'adr__Address'.

There are 73071 rows in 1793 pages for object "adr__Address".

DBCC results for 'pf_PrintForm'.

There are 32 rows in 1 pages for object "pf_PrintForm".

DBCC results for 'ep_RegData'.

There are 43 rows in 26 pages for object "ep_RegData".

DBCC results for 'ep_UserMapping'.

There are 5 rows in 1 pages for object "ep_UserMapping".

DBCC results for 'st_Country'.

There are 430 rows in 3 pages for object "st_Country".

DBCC results for 'fp__ParamsFTP'.

There are 1 rows in 1 pages for object "fp__ParamsFTP".

DBCC results for 'st_Duration'.

There are 14 rows in 1 pages for object "st_Duration".

DBCC results for 'pl_PricingListData'.

There are 10 rows in 1 pages for object "pl_PricingListData".

DBCC results for 'gr__Konfiguracja'.

There are 0 rows in 0 pages for object "gr__Konfiguracja".

DBCC results for 'gr__KonfiguracjaEx'.

There are 154 rows in 4 pages for object "gr__KonfiguracjaEx".

DBCC results for 'st_Enhancement'.

There are 10 rows in 1 pages for object "st_Enhancement".

DBCC results for 'reg__Registration'.

There are 2 rows in 1 pages for object "reg__Registration".

DBCC results for 'gt__Obiekt'.

There are 11 rows in 1 pages for object "gt__Obiekt".

DBCC results for 'gt_Atrybut'.

There are 0 rows in 0 pages for object "gt_Atrybut".

DBCC results for 'st_Insurance'.

There are 36 rows in 1 pages for object "st_Insurance".

DBCC results for 'gt_Definicja'.

There are 11 rows in 1 pages for object "gt_Definicja".

DBCC results for 'st_Payment'.

There are 0 rows in 0 pages for object "st_Payment".

DBCC results for 'reg_AfterSalesServiceConditions'.

There are 3 rows in 1 pages for object "reg_AfterSalesServiceConditions".

DBCC results for 'gt_Transformacja'.

There are 11 rows in 1 pages for object "gt_Transformacja".

DBCC results for 'reg_Data'.

There are 13 rows in 10 pages for object "reg_Data".

DBCC results for 'gt_TransObiekt'.

There are 0 rows in 0 pages for object "gt_TransObiekt".

DBCC results for 'gt_TransRodzaj'.

There are 2 rows in 1 pages for object "gt_TransRodzaj".

DBCC results for 'st_Region'.

There are 32 rows in 1 pages for object "st_Region".

DBCC results for 'reg_JournalDeals'.

There are 8262 rows in 79 pages for object "reg_JournalDeals".

DBCC results for 'im__Image'.

There are 1364 rows in 30 pages for object "im__Image".

DBCC results for 'pc_History'.

There are 34 rows in 1 pages for object "pc_History".

DBCC results for 'au_Allegro'.

There are 2058 rows in 97 pages for object "au_Allegro".

DBCC results for 'reg_Site'.

There are 2 rows in 1 pages for object "reg_Site".

DBCC results for 'pc_Item'.

There are 14 rows in 1 pages for object "pc_Item".

DBCC results for 'tr_Default'.

There are 1 rows in 1 pages for object "tr_Default".

DBCC results for 'rn_ReturnedNumber'.

There are 0 rows in 0 pages for object "rn_ReturnedNumber".

DBCC results for 'ins_blokada'.

There are 369 rows in 15 pages for object "ins_blokada".

DBCC results for 'st_ShippingLocation'.

There are 0 rows in 0 pages for object "st_ShippingLocation".

DBCC results for 'sl_AuctionGroup'.

There are 0 rows in 0 pages for object "sl_AuctionGroup".

DBCC results for 'au_DescriptionImage'.

There are 0 rows in 0 pages for object "au_DescriptionImage".

DBCC results for 'st_SiteData'.

There are 0 rows in 0 pages for object "st_SiteData".

DBCC results for 'sl_AuctionTemplateGroup'.

There are 0 rows in 0 pages for object "sl_AuctionTemplateGroup".

DBCC results for 'pc_SendingList'.

There are 0 rows in 0 pages for object "pc_SendingList".

DBCC results for 'ins_counter'.

There are 2 rows in 1 pages for object "ins_counter".

DBCC results for 'ins_ident'.

There are 117 rows in 1 pages for object "ins_ident".

DBCC results for 'au_Ebay'.

There are 0 rows in 0 pages for object "au_Ebay".

DBCC results for 'tp__HtmlTemplate'.

There are 15 rows in 1 pages for object "tp__HtmlTemplate".

DBCC results for 'sl_CommentTemplate'.

There are 10 rows in 1 pages for object "sl_CommentTemplate".

DBCC results for 'pc_SendingListPackage'.

There are 0 rows in 0 pages for object "pc_SendingListPackage".

DBCC results for 'insx_Parametr'.

There are 1 rows in 1 pages for object "insx_Parametr".

DBCC results for 'sl_Currency'.

There are 16 rows in 1 pages for object "sl_Currency".

DBCC results for 'pd__Podmiot'.

There are 1 rows in 1 pages for object "pd__Podmiot".

DBCC results for 'tp_Image'.

There are 0 rows in 0 pages for object "tp_Image".

DBCC results for 'sl_CurrencyBank'.

There are 1 rows in 1 pages for object "sl_CurrencyBank".

DBCC results for 'au_EbayReturnPolicy'.

There are 0 rows in 0 pages for object "au_EbayReturnPolicy".

DBCC results for 'au_Enhancement'.

There are 8 rows in 1 pages for object "au_Enhancement".

DBCC results for 'sl_CurrencyExchangeRates'.

There are 0 rows in 0 pages for object "sl_CurrencyExchangeRates".

DBCC results for 'au_Features'.

There are 0 rows in 0 pages for object "au_Features".

DBCC results for 'sl_CurrencyExchangeRatesEntry'.

There are 0 rows in 0 pages for object "sl_CurrencyExchangeRatesEntry".

DBCC results for 'au_Note'.

There are 0 rows in 0 pages for object "au_Note".

DBCC results for 'it__Item'.

There are 373 rows in 15 pages for object "it__Item".

DBCC results for 'au_Payment'.

There are 0 rows in 0 pages for object "au_Payment".

DBCC results for 'pb_PostBuyFormTransaction'.

There are 16990 rows in 100 pages for object "pb_PostBuyFormTransaction".

DBCC results for 'sl_CustomAttributes'.

There are 0 rows in 0 pages for object "sl_CustomAttributes".

DBCC results for 'au_PendingChanges'.

There are 0 rows in 0 pages for object "au_PendingChanges".

DBCC results for 'sl_CustomCounter'.

There are 2 rows in 1 pages for object "sl_CustomCounter".

DBCC results for 'au_Picture'.

There are 9281 rows in 34 pages for object "au_Picture".

DBCC results for 'sl_CustomerGroup'.

There are 1 rows in 1 pages for object "sl_CustomerGroup".

DBCC results for 'au_Shipping'.

There are 4366 rows in 25 pages for object "au_Shipping".

DBCC results for 'sl_CustomGlobalAttributes'.

There are 0 rows in 0 pages for object "sl_CustomGlobalAttributes".

DBCC results for 'au_TransactionProperty'.

There are 0 rows in 0 pages for object "au_TransactionProperty".

DBCC results for 'sl_CustProperty'.

There are 0 rows in 0 pages for object "sl_CustProperty".

DBCC results for 'cs__Customer'.

There are 10679 rows in 245 pages for object "cs__Customer".

DBCC results for 'it_AuctionTemplate'.

There are 0 rows in 0 pages for object "it_AuctionTemplate".

DBCC results for 'sl_Deliverer'.

There are 12 rows in 1 pages for object "sl_Deliverer".

DBCC results for 'it_CustomAttributes'.

There are 0 rows in 0 pages for object "it_CustomAttributes".

DBCC results for 'sl_Delivery'.

There are 36 rows in 1 pages for object "sl_Delivery".

DBCC results for 'it_ExternalCustomAttributes'.

There are 0 rows in 0 pages for object "it_ExternalCustomAttributes".

DBCC results for 'it_ExternalCustomAttributesDict'.

There are 0 rows in 0 pages for object "it_ExternalCustomAttributesDict".

DBCC results for 'cs_CustEmail'.

There are 10876 rows in 91 pages for object "cs_CustEmail".

DBCC results for 'jb_Message'.

There are 6581479 rows in 174829 pages for object "jb_Message".

DBCC results for 'md__MetaData'.

There are 1 rows in 1 pages for object "md__MetaData".

DBCC results for 'cs_CustIM'.

There are 0 rows in 0 pages for object "cs_CustIM".

DBCC results for 'nm_Params'.

There are 1 rows in 1 pages for object "nm_Params".

DBCC results for 'it_ItemPictures'.

There are 9 rows in 1 pages for object "it_ItemPictures".

DBCC results for 'cs_CustomerProp'.

There are 0 rows in 0 pages for object "cs_CustomerProp".

DBCC results for 'tr_AutoMsgParams'.

There are 1 rows in 1 pages for object "tr_AutoMsgParams".

DBCC results for 'it_ItemProp'.

There are 1 rows in 1 pages for object "it_ItemProp".

DBCC results for 'cs_CustPhone'.

There are 11952 rows in 78 pages for object "cs_CustPhone".

DBCC results for 'sl_EmailGroup'.

There are 0 rows in 0 pages for object "sl_EmailGroup".

DBCC results for 'tr_Comment'.

There are 0 rows in 0 pages for object "tr_Comment".

DBCC results for 'it_ItemSite'.

There are 0 rows in 0 pages for object "it_ItemSite".

DBCC results for 'sl_ExportType'.

There are 3 rows in 1 pages for object "sl_ExportType".

DBCC results for 'ctx_UserSite'.

There are 4 rows in 1 pages for object "ctx_UserSite".

DBCC results for 'sl_InstantMessenger'.

There are 3 rows in 1 pages for object "sl_InstantMessenger".

DBCC results for 'ds_DeliveryToShippingMap'.

There are 29 rows in 1 pages for object "ds_DeliveryToShippingMap".

DBCC results for 'sl_ItemGroup'.

There are 3 rows in 1 pages for object "sl_ItemGroup".

DBCC results for 'em__Email'.

There are 0 rows in 0 pages for object "em__Email".

DBCC results for 'sl_ItemProperty'.

There are 1 rows in 1 pages for object "sl_ItemProperty".

DBCC results for 'sl_Language'.

There are 4 rows in 1 pages for object "sl_Language".

DBCC results for 'sl_PricingList'.

There are 1 rows in 1 pages for object "sl_PricingList".

DBCC results for 'sl_MsgTemplate'.

There are 0 rows in 0 pages for object "sl_MsgTemplate".

DBCC results for 'em_Account'.

There are 0 rows in 0 pages for object "em_Account".

DBCC results for 'sl_PackageSynchronizationParams'.

There are 135 rows in 74 pages for object "sl_PackageSynchronizationParams".

DBCC results for 'st_Category'.

There are 24472 rows in 247 pages for object "st_Category".

DBCC results for 'tr_Group'.

There are 948 rows in 3 pages for object "tr_Group".

DBCC results for 'sl_SendingNumbersPool'.

There are 0 rows in 0 pages for object "sl_SendingNumbersPool".

DBCC results for 'st_CategorySpecific'.

There are 109 rows in 2 pages for object "st_CategorySpecific".

DBCC results for 'jb__Job'.

There are 3297307 rows in 19995 pages for object "jb__Job".

DBCC results for 'tr_History'.

There are 100464 rows in 1993 pages for object "tr_History".

DBCC results for 'tr_Item'.

There are 16642 rows in 166 pages for object "tr_Item".

DBCC results for 'sys.queue_messages_1977058079'.

There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".

DBCC results for 'au__Auction'.

There are 2058 rows in 121 pages for object "au__Auction".

DBCC results for 'log__Sync'.

There are 3 rows in 1 pages for object "log__Sync".

DBCC results for 'sys.queue_messages_2009058193'.

There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".

DBCC results for 'sl_SendingNumbersPoolType'.

There are 3 rows in 1 pages for object "sl_SendingNumbersPoolType".

DBCC results for 'sys.queue_messages_2041058307'.

There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".

DBCC results for 'sl_ServiceProvider'.

There are 4 rows in 1 pages for object "sl_ServiceProvider".

DBCC results for 'log_Message'.

There are 5684210 rows in 14269 pages for object "log_Message".

DBCC results for 'tr_Property'.

There are 1 rows in 1 pages for object "tr_Property".

DBCC results for 'sys.filestream_tombstone_2073058421'.

There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".

DBCC results for 'nm_IgnoredMessages'.

There are 1 rows in 1 pages for object "nm_IgnoredMessages".

DBCC results for 'pc_Error'.

There are 0 rows in 0 pages for object "pc_Error".

DBCC results for 'em_Archive'.

There are 0 rows in 0 pages for object "em_Archive".

DBCC results for 'sys.syscommittab'.

There are 0 rows in 0 pages for object "sys.syscommittab".

DBCC results for 'sl_TransProperty'.

There are 2 rows in 1 pages for object "sl_TransProperty".

DBCC results for 'up_UserParams'.

There are 34 rows in 17 pages for object "up_UserParams".

DBCC results for 'sys.filetable_updates_2105058535'.

There are 0 rows in 0 pages for object "sys.filetable_updates_2105058535".

DBCC results for 'nm_NotifierMessage'.

There are 6 rows in 1 pages for object "nm_NotifierMessage".

DBCC results for 'sys.plan_persist_query_text'.

There are 0 rows in 0 pages for object "sys.plan_persist_query_text".

DBCC results for 'sl_User'.

There are 4 rows in 1 pages for object "sl_User".

DBCC results for 'em_Attachment'.

There are 0 rows in 0 pages for object "em_Attachment".

DBCC results for 'vw__Konfiguracja'.

There are 92 rows in 1 pages for object "vw__Konfiguracja".

DBCC results for 'sys.plan_persist_query'.

There are 0 rows in 0 pages for object "sys.plan_persist_query".

DBCC results for 'st_CategorySpecificDict'.

There are 627 rows in 6 pages for object "st_CategorySpecificDict".

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Sello2020'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Screenshot_406.png

Udostępnij ten post


Link to postu

Obecnie sytuacja wygląda tak iż nie mogę  wejść w te trzy zakładki .... 

Screenshot_407.png.b71720e3cf2639a35b27818ab5d2f381.png

 

Tak więc uzbroję się w cierpliwość do jutra, zainstaluję nową wersję i zaimportuję jedną z ostatnich działających baz danych...

 

Jak nic sie nie zmieni to chyba  zainstaluję świeżą wersję i od podstaw wszystko ułożę bez importu bazy danych ;(

 

Udostępnij ten post


Link to postu
17 godzin temu, PIOTR JAKIMIEC JAKIMIEC napisał:

dodatkowo nie ściąga nowych aukcji wystawionych ponownie z poziomu allegro

To może być problem zdublowanych kategorii:

 

17 godzin temu, PIOTR JAKIMIEC JAKIMIEC napisał:

Po ponownym uruchomieniu Sello chciałem wykonać  procedurę naprawczą ale już nie wykrył błędu

A po odświeżeniu sekcji WAŻNE INFORMACJE za pomocą ikonki po prawej?

15 godzin temu, PIOTR JAKIMIEC JAKIMIEC napisał:

Obecnie sytuacja wygląda tak iż nie mogę  wejść w te trzy zakładki ....

To z kolei może świadczyć o uszkodzeniu konfiguracji listy. Czy innym użytkownikiem Sello (jeśli takiego nie ma to proszę testowo dodać w słowniku użytkowników) da się wejść w te zakładki?

Ustawienia list (kolumny, format kolumn, kolejność) można zresetować poniższym poleceniem SQL:

delete from gr__KonfiguracjaEx where cge_Section like 'Aukcje_%'

Należy je wykonać przy wyłączonym programie. Po włączeniu powinno dać się wejść w zakładki - chyba, że problemem są uszkodzone dane, ale wtedy trzeba by taka bazę podesłać do nas do analizy.

Udostępnij ten post


Link to postu
31 minut temu, Bartosz Rosa napisał:

To może być problem zdublowanych kategorii:

Ten problem dotyczy aukcji wystawionych z poziomu Sello?

My mamy wystawione z poziomu MS.allegro - ale sprawdzę

 

33 minuty temu, Bartosz Rosa napisał:

A po odświeżeniu sekcji WAŻNE INFORMACJE za pomocą ikonki po prawej?

Tak również oraz wchodząc na komputery klienckie  w jednym widniał błąd w drugim nie...

 

42 minuty temu, Bartosz Rosa napisał:

To z kolei może świadczyć o uszkodzeniu konfiguracji listy. Czy innym użytkownikiem Sello (jeśli takiego nie ma to proszę testowo dodać w słowniku użytkowników) da się wejść w te zakładki?

Ustawienia list (kolumny, format kolumn, kolejność) można zresetować poniższym poleceniem SQL:


delete from gr__KonfiguracjaEx where cge_Section like 'Aukcje_%'

Mamy poza Szefem jeszcze trzech użytkowników, wszystko wygląda oki, przeprowadziłem  reset dokonał jakiś zmian ale niestety to nie pomogło nadal brak  możliwości wejścia w te trzy zakładki w sekcji AUKCJE

Udostępnij ten post


Link to postu
2 godziny temu, PIOTR JAKIMIEC JAKIMIEC napisał:

Ten problem dotyczy aukcji wystawionych z poziomu Sello?

My mamy wystawione z poziomu MS.allegro - ale sprawdzę

Nie ma to znaczenia.

2 godziny temu, PIOTR JAKIMIEC JAKIMIEC napisał:

nadal brak  możliwości wejścia w te trzy zakładki w sekcji AUKCJE

To chyba zatem coś grubszego. Trzeba będzie podesłać do nas bazę do sprawdzenia. Proszę w tej sprawie o kontakt mailowy na sello@insert.com.pl

Udostępnij ten post


Link to postu

×