Job failed

  • Executed as user: QA\sqlservice. ...sion 10.50.6000.34 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 22:10:00 Progress: 2015-04-16 22:10:02.16 Source: {2A021D14-C3FD-48BC-8167-1FF4B20E1B07} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2015-04-16 22:10:44.06 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.08 Source: Rebuild Index Executing query "ALTER INDEX [MSmerge_index_715239886] ON [dbo].[ac...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.08 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.08 Source: Rebuild Index Executing query "ALTER INDEX [UK_acl_dashboard_permission] ON [dbo]...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.08 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.08 Source: Rebuild Index Executing query "ALTER INDEX [MSmerge_index_332280689] ON [dbo].[ac...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.08 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.09 Source: Rebuild Index Executing query "ALTER INDEX [PK_acl_form_group_permission] ON [dbo...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.09 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.09 Source: Rebuild Index Executing query "ALTER INDEX [MSmerge_index_441469047] ON [dbo].[ac...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.09 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.11 Source: Rebuild Index Executing query "ALTER INDEX [PK_acl_permission_groups] ON [dbo].[a...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.11 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.11 Source: Rebuild Index Executing query "ALTER INDEX [MSmerge_index_505469275] ON [dbo].[ac...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.11 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.11 Source: Rebuild Index Executing query "ALTER INDEX [PK_acl_permission_type] ON [dbo].[acl...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.11 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 0% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "ALTER INDEX [MSmerge_index_473469161] ON [dbo].[ac...".: 0% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 1% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "ALTER INDEX [PK_acl_permission_types_group_link] O...".: 1% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 1% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "ALTER INDEX [MSmerge_index_409468933] ON [dbo].[ac...".: 1% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "USE [dmsdb_master] ".: 1% complete End Progress Progress: 2015-04-16 22:10:44.13 Source: Rebuild Index Executing query "ALTER INDEX [PK_acl_types] ON [dbo].[acl_types] RE...".: 1% complete End Progress Progress: 2015-04-16 22:10:44.13 ... The package execution fa... The step failed.

  • And the question is?

    -- Gianluca Sartori

  • Further on Gianluca's question, all usable details are missing from the error dump you posted, obvious guess for a question would be why the job failed but then there is nothing that can provide any clue to why in the dump.

    😎

  • I see the problem here. Job's failed

  • For the OP, saikrish.cherukuri, you need to read through the output and limit it to the failed part of the job. I doubt there's much in here, so you need to provide the way you called this and also what happens if you call that part alone as a SQL session.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply