cancel
Showing results for 
Search instead for 
Did you mean: 

Db consistency check failed

Former Member
0 Kudos

Hi Experts,

i am having a error while Check db consistency in db13.

here is the detailed logs

exec msdb..sp_add_job @originating_server = '(local)',@job_name = "SAP CCMS Check Database

PRD [20111220181015-2-181015]",@enabled = 1,@description = "SAP CCMS JOB",@start_step_id = 1,

@category_name = NULL,@category_id = NULL

exec msdb..sp_add_jobstep @job_id = null,@job_name = 'SAP CCMS Check Database PRD

[20111220181015-2-181015]',@step_id = 1,@step_name = 'CCMS-Step1 ',@subsystem = 'TSQL',

@command = 'declare @exeStmt nvarchar(2000) exec prd.sap_new_dbcheck

@dbName="PRD",@outputfile="$(ESCAPE_NONE(SQLDIR))\CCMS_CHECK_DB_HIST_2011.txt",@bkupSim =

"Y",@exeStmt = @exeStmt OUTPUT',@database_name = 'PRD',@output_file_name =

'$(ESCAPE_NONE(SQLDIR))\CCMS_CHECK_DB_HIST_2011.txt',@flags = 2

dbcc checkdb( PRD ) with no_infomsgs

exec msdb..sp_add_jobschedule @job_id = null,@job_name = 'SAP CCMS Check Database PRD

[20111220181015-2-181015]',@name = 'CCMS-sche1',@enabled = 1,@freq_type =1,@freq_interval = 1,

@freq_subday_type = 0,@freq_subday_interval = 0,@active_start_date = 20111220,

@active_start_time = 181015,@freq_recurrence_factor = 0

exec msdb..sp_add_jobserver @job_name = 'SAP CCMS Check Database PRD

[20111220181015-2-181015]',@server_name = '(local)'

.

please help me out of this problem.

thanks in advance

Akshit sharma

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

See if another discussion thread helps you -

http://forums.sdn.sap.com/thread.jspa?threadID=2101833&messageID=10919860#10919860

Thanks

Former Member
0 Kudos

Hi,

I Opened this query to SAP and they helped me to resolve the issue.

Thanks to all

Regards

Akshit Sharma

mohitsahu
Participant
0 Kudos

Hi Akshit,

I am also facing the same issue. I would appreciate if you can help me by sharing the resolution recommended by SAP.

Regards,

Mohit

mohitsahu
Participant
0 Kudos

Hi Akshit,

can you please provide the resolution. I am still looking for the solution.

Regards,

Mohit

Former Member
0 Kudos

Hi Mohit,

I have faced this issue long time ago. so can you please send me the logs with detailed error.

Thanks & Regards

Akshit

mohitsahu
Participant
0 Kudos

Hi Akshit,

I have checked the logs and it explains that

Could not allocate space for object 'dbo.SORT temporary run storage: 

And after that i have increased the size of temp db.. The size of database if 3 TB and i found a blog explaining that the temp db size should be 1.5-2% of database size. So i increased the drive size to 60 GB. But still job is failing. Can you help with other alternative.

Regards,

Mohit

Matt_Fraser
Active Contributor
0 Kudos

Mohit,

I strongly recommend that you open this as a new question, as you will get far more responses that way.

Regards,

Matt