Click here to Skip to main content
15,038,237 members

S Douglas - Professional Profile



Summary

    Blog RSS
2
Author
3,549
Authority
5,054
Debator
12
Enquirer
654
Organiser
2,989
Participant
0
Editor
Just another hack, who manages to take care of issues that would otherwise go unsolved. Smile | :)

 

Reputation

Weekly Data. Recent events may not appear immediately. For information on Reputation please see the FAQ.

Privileges

Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege. The member types column lists member types who gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilver
Bypass spam checks when posting contentsilversilversilversilversilversilvergoldSubEditor, Mentor, Protector, Editor
Store personal files in your account areaplatinumplatinumSubEditor, Editor
Have live hyperlinks in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Have the ability to include a biography in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Edit a Question in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Edit an Answer in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Delete a Question in Q&AYesSubEditor, Protector, Editor
Delete an Answer in Q&AYesSubEditor, Protector, Editor
Report an ArticlesilversilversilversilverSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubEditor, Mentor, Protector, Editor
Edit other members' articlesSubEditor, Protector, Editor
Create an article without requiring moderationplatinumSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending QuestionProtector
Approve/Disapprove a pending AnswerProtector
Report a forum messagesilversilverbronzeProtector, Editor
Approve/Disapprove a pending Forum MessageProtector
Create a new tagsilversilversilversilver
Modify a tagsilversilversilversilver

Actions with a green tick can be performed by this member.


 
GeneralSQL Server Errors Pin
S Douglas27-Oct-10 4:40
professionalS Douglas27-Oct-10 4:40 
GeneralRe: SQL Server Errors Pin
S Douglas6-Jul-11 11:16
professionalS Douglas6-Jul-11 11:16 
GeneralSSAS - Processing Error Pin
S Douglas22-Oct-10 20:58
professionalS Douglas22-Oct-10 20:58 
GeneralRandom bits of SQL Pin
S Douglas24-Sep-10 4:12
professionalS Douglas24-Sep-10 4:12 
GeneralRandom bits of SQL Pin
S Douglas24-Sep-10 4:10
professionalS Douglas24-Sep-10 4:10 
GeneralRandom bits of SQL [modified] Pin
S Douglas23-Sep-10 11:52
professionalS Douglas23-Sep-10 11:52 
GeneralTSQL Case statement Pin
S Douglas23-Sep-10 11:26
professionalS Douglas23-Sep-10 11:26 
General(6 years, 2 months) Pin
S Douglas9-May-10 21:03
professionalS Douglas9-May-10 21:03 
GeneralSSAS Backups Followup Pin
S Douglas1-Jul-09 18:23
professionalS Douglas1-Jul-09 18:23 
GeneralCatch up.... [modified] Pin
S Douglas29-Jun-09 8:26
professionalS Douglas29-Jun-09 8:26 
GeneralSSAS Backups Pin
S Douglas27-Apr-09 4:07
professionalS Douglas27-Apr-09 4:07 
GeneralRandom Junk Pin
S Douglas25-Apr-09 21:17
professionalS Douglas25-Apr-09 21:17 
GeneralSSAS Best practices Pin
S Douglas24-Apr-09 3:57
professionalS Douglas24-Apr-09 3:57 
GeneralSSRS... Pin
S Douglas20-Apr-09 10:44
professionalS Douglas20-Apr-09 10:44 
GeneralSSAS... Pin
S Douglas2-Apr-09 17:59
professionalS Douglas2-Apr-09 17:59 
GeneralSSAS from the trenches Cont... Pin
S Douglas11-Mar-09 18:33
professionalS Douglas11-Mar-09 18:33 
GeneralSSAS from the trenches (Cont...) Pin
S Douglas11-Mar-09 18:07
professionalS Douglas11-Mar-09 18:07 
GeneralSSAS from the trenches Pin
S Douglas11-Mar-09 17:52
professionalS Douglas11-Mar-09 17:52 
SSAS from the trenches

While I'm sitting here watching some data process I figured I would share with the rest of the world some of the umm interesting things that have come up while dealing with SQL Server Analysis Services (SSAS). Actually, something I would like to do it blog more often about the topic, it will be interesting to see if any else reads these entry's. Here we go

Dimension processing...
A hard lesson I learned over the weekend was that any time you fully process a Dimension every fact table that relies on that Dim, needs to be processed. When your CUBES are over 500 Gig that can take some time to do (I am still processing the cubes, and probably will be till this weekend).
Now as it turns out, after investigation, no matter what we would have had to reprocess everything. This weekend was DST for us, and because someone previous to me screwed up the step order in a job. We have two SQL jobs (running ETL refreshes of Dims and Cubes) that refresh our Analysis Server. The first one updates the Dims, the second updates the cubes. The second one does have a couple of waits setup so it doesn't trample on anything else, but its first step is to restart SSAS. When SSAS got restarted, it must have been at a critical point because I couldn't get the Dim that had been processing to process and come up clean. It was erroring out. See ever so enlightening error message below

Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Transaction (Process ID 73) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.; 40001. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Dim Product CUBE', Name of 'Product' was being processed. Errors in the OLAP storage engine: An error occurred while the 'First Sales Actual Date' attribute of the 'Product' dimension from the 'CB Cubes' database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Operation canceled; HY008. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Dim Product CUBE', Name of 'Product' was being processed. [snip four more pages of about the same thing]

This has been one really hard week, myself and a coworker have been manually babysitting the jobs all week. The first thing on the order was to get the cubes back up and at least populated with a month's worth of data. Now I'm following up and processing everything (the users are clamoring for the data). Actually funny story, on Tuesday, the CEO caught me in a meeting, and called me out asking how the cube processing was coming along. Now understand our CEO is a really nice person, I just don't care how nice she is, it's never a good thing in my opinion for someone of her nature to know your name and what your working on. Especially when it's something that's broken. Oh well, at least she took it in stride and was more worried about the hours I'm putting in getting things back (yea she's that nice)

If you like that post, then there is more to come. I would like to keep things kind of on topic, so one issue per post Smile | :) Cry | :((


Common sense is admitting there is cause and effect and that you can exert some control over what you understand.


GeneralCode formatting Pin
S Douglas23-Jan-09 19:18
professionalS Douglas23-Jan-09 19:18 
GeneralRe: Code formatting Pin
S Douglas21-Feb-09 9:16
professionalS Douglas21-Feb-09 9:16 
GeneralRe: Code formatting Pin
S Douglas21-Feb-09 9:20
professionalS Douglas21-Feb-09 9:20 
GeneralWhats happening Pin
S Douglas21-Feb-09 13:13
professionalS Douglas21-Feb-09 13:13 
GeneralHEHE Pin
S Douglas21-Feb-09 13:15
professionalS Douglas21-Feb-09 13:15 
GeneralMap printer, vbscript Pin
S Douglas23-Jan-09 19:11
professionalS Douglas23-Jan-09 19:11 
GeneralDelete files, vbscript Pin
S Douglas23-Jan-09 19:07
professionalS Douglas23-Jan-09 19:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.