Forum

Welcome Guest! To enable all features please try to register or login.
vladimir
#1 Posted: : 30 July 2018 13:35:11(UTC)
vladimir

Rank: Newbie

You have been a member since:: 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 Posted: : 30 July 2018 14:40:34(UTC)
vladimir

Rank: Newbie

You have been a member since:: 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 Posted: : 30 July 2018 14:48:25(UTC)
vladimir

Rank: Newbie

You have been a member since:: 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 Posted: : 19 October 2018 08:53:34(UTC)
VLADIMIRPA

Rank: Datalab

You have been a member since:: 24/04/2009(UTC)
Objave: 30

Was thanked: 1 time(s) in 1 post(s)
Prebacite računar sa koga procesirate kocke na engleski regional settings
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0,115 seconds.