on 06-18-2015 1:30 PM
Hi.. i have come across this problem SQL server can not optimize the database..
What could be the problem? On side of that the hard drive is just full of out of no where. (3gb)
Did this happen after dimensions were processed?
If yes, incorrect data format might be the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Peter,
can you please share the message of the optimize error? Search also in tbllogs for a detailed error and share it.
Regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Peter,
Which optimization you are doing Full, Incremental, Lite?
Have you compressed your database using Compress Database while optimization.?
Most probably, your issue must be related to space.
Also, check for or dirty records in the fact tables. these records may be developed due script logic or any other reasons. You have data on parents member in data base.
Hi,
why you continue to try to give solutions if you don't know the error?
you're right probably it's a problem related with space but we don't know the error message, so why you ask to check records in fact tables?
why you give this old link? even if it's "assumed answered" the user solved applying an old sap note of 7.0 version and sp 7 (old support package for this old version), I doubt this is the case.
Regards
Roberto
HI Robert,
Yes you are correct that we don't know the error but topic author also not facing any error or it is not displayed so i though it was memory issue so i have given that link if he found relevant to him.
Also suggested that try to find out the issues related to fact table.Some times system gives wired message even error might be different and i have faced such kind error that why i have suggested to check if there are any dirty records.
Hi,
for all we know the reason could also be a db log issue, a COM+ issue, maybe Send Governor or, a conflict with other packages and the link you give it's related whit a very particular case, so better wait for the error message.
Maybe when Peter found it on the log doesn't need more our help.
Regards
Roberto
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.