ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Event ID: 208 - Job Engine

Event ID: 208 - Job Engine

原创 Linux操作系统 作者:tolywang 时间:2009-07-29 18:40:29 0 删除 编辑

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date:  7/31/2009
Time:  4:21:49 AM
User:  N/A
Computer: MXPSV-EFOX-DCDB
Description:
SQL Server Scheduled Job 'MfAssyComponentSaveJob' (0xF132F77A625F064AB4835767670E6CB0) - Status: Failed - Invoked on: 2009-07-31 04:20:07 - Message: The job failed.  The Job was invoked by Schedule 22 (11).  The last step to run was step 1 (eFoxSFCSaveAssyComponentJobs).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

 

查看Job view history log记录 : 

-------------

Executed as user: MXPSV-EFOX-DCDB\it.service.    Violation of PRIMARY KEY constraint 'PK_mfAssyComponent'. Cannot insert duplicate key in object 'mfAssyComponent'. [SQLSTATE 23000] (Error 2627)  Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0. [SQLSTATE 25000] (Error 266)  Insert  into  mfAssyComponent  Error! [SQLSTATE 42000] (Error 99999)  DPDGVH1  Save to table mfAssyComponent Error. [SQLSTATE 42000] (Error 99999)  The statement has been terminated. [SQLSTATE 01000] (Error 3621).  The step failed. 

估计是PK重复值的问题 。


 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-611016/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13240318