Forum

Dobrodošli na forum PANTHEON uporabniških strani.
vladimir
#1 Objavljeno : 30 July 2018 13:35:11(UTC)
vladimir

Stopnja: Newbie

Pridružen(a): 22/06/2017(UTC)
Objave: 5

Probao sam da kreiram OLAP kocke. Verzija servera je 13.0.4474.0 dakle MS SQL server 2016 SP1.
Povezao se i kreirao kocke i procesirao i sve to je trajalo bar pola sata da bi na kraju izbacio sledecu poruku:


Procesiranje OLAP kocki, molimo sačekajte...

牅潲⁲畦汬瀠潲散獳湩⁧湡污獹獩搠瑡扡獡㩥匊牥敶㩲吠敨挠牵敲瑮漠数慲楴湯眠獡挠湡散汬摥戠捥畡敳愠潮桴牥漠数慲楴湯椠桴⁥牴湡慳瑣潩慦汩摥മ䔊牲牯⁳湩琠敨传䅌⁐瑳牯条⁥湥楧敮›湁攠牲牯漠捣牵敲⁤桷汩⁥桴⁥楤敭獮潩Ɱ眠瑩⁨桴⁥䑉漠⁦䄧捣❴‬慎敭漠⁦䄧捣❴眠獡戠楥杮瀠潲散獳摥മ䔊牲牯⁳湩琠敨栠杩⵨敬敶敲慬楴湯污攠杮湩⹥䄠挠湯敮瑣潩潣汵⁤潮⁴敢洠摡⁥潴琠敨搠瑡⁡潳牵散眠瑩⁨桴⁥慄慴潓牵散䑉漠⁦䈧䅉䝌呏䍅❈‬慎敭漠⁦䈧䅉䝌呏䍅❈മ伊䕌䐠⁂牥潲㩲传䕌䐠⁂牯传䉄⁃牥潲㩲䰠杯湩映楡敬⁤潦⁲獵牥✠䱁佇䕔䡃乜协剔䵏㉏✤㬮㈠〸〰.

-
Osvežavanje vremenskih intervala...
-
******************************************
Procesiranje kocki uspešno je završeno.
******************************************


Problem je sto nista zapravo nije uradio. Analize ne rade a na SSMS kocke stoje u statusu Unprocessed.
Jedino sto sam pronasao je da je i kolega iz Slovenije imao isti problem:
https://usersite.datalab.eu/Forum/tabid/125/language/it-IT/g/posts/t/306052/ZEUS-in-SQL-2016-ter-PA-10-40-20.aspx

Da li neko zna kako se ovo resava?
vladimir
#2 Objavljeno : 30 July 2018 14:40:34(UTC)
vladimir

Stopnja: Newbie

Pridružen(a): 22/06/2017(UTC)
Objave: 5

Hm...sa promenom sa windows autentifikacije na sql autentifikaciju dobio sam drugaciji error:

Procesiranje OLAP kocki, molimo sačekajte...

Error full processing analysis database:
Server: The current operation was cancelled because another operation in the transaction failed.
Errors in the OLAP storage engine: An error occurred while the 'ackAcct1 attribute 1' attribute of the 'Acct 1' dimension from the 'ALBI' database was being processed.
Errors in the back-end database access module. The read operation was cancelled due to an earlier error.
Errors in the OLAP storage engine: An error occurred while the 'ackAcct3 attribute 1' attribute of the 'Acct 1' dimension from the 'ALBI' database was being processed.
Errors in the back-end database access module. The read operation was cancelled due to an earlier error.
Errors in the OLAP storage engine: An error occurred while the 'ackAcct2 attribute 1' attribute of the 'Acct 1' dimension from the 'ALBI' database was being processed.
Errors in the back-end database access module. The read operation was cancelled due to an earlier error.
Errors in the OLAP storage engine: An error occurred while the 'ackAcct3 attribute 1' attribute of the 'Acct 1' dimension from the 'ALBI' database was being processed.

-

Sta nije u redu sa ovim atributima Acct 1 dimenzije?
vladimir
#3 Objavljeno : 30 July 2018 14:48:25(UTC)
vladimir

Stopnja: Newbie

Pridružen(a): 22/06/2017(UTC)
Objave: 5

Evo sta jos kaze kada se proba procesiranje preko SSMS:
Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated.
VLADIMIRPA
#4 Objavljeno : 19 October 2018 08:53:34(UTC)
VLADIMIRPA

Stopnja: Datalab

Pridružen(a): 24/04/2009(UTC)
Objave: 30

Prejete zahvale: 1 krat v 1 objavah
Prebacite računar sa koga procesirate kocke na engleski regional settings
RSS vir  Atom Feed
Uporabniki v tej temi
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.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Poganja {0}, verzija {1} YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
Ta stran se je naložila v 0,122 sekunde.