Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
How to fix error "A severe error occurred on the current command. The results, if any, should be discarded." on SQL server 2008 R2 Enterprise Edition (64-bit) service pack2

Unanswered How to fix error "A severe error occurred on the current command. The results, if any, should be discarded." on SQL server 2008 R2 Enterprise Edition (64-bit) service pack2

  • Montag, 11. Februar 2013 14:02
     
     
    Anmelden
    0

    When i have execute the ssis Package and check the audit tables then i got the below message:Same query which showing the error in the new server but working properly in another server.

    Msg 0, Level 11, State 0, Line 0

    A severe error occurred on the current command.  The results, if any, should be discarded.

    Msg 0, Level 20, State 0, Line 0

    A severe error occurred on the current command.  The results, if any, should be discarded.

    I have checked the log viewer and found the below messages :

    Error: 17310, Severity: 20, State: 1.

    Message
    External dump process return code 0x20000001.
    External dump process returned no errors.

    Message
    A user request from the session with SPID 53 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

    Please provide me the solution.

     

Alle Antworten

  • Mittwoch, 13. Februar 2013 09:35
    Moderator
     
     
    Anmelden
    1

    Hi Ramesh0103,

    This is a general error message, it maybe a known bug that can happen when the dbo account becomes orphaned and is no longer associated with a valid windows login - usually because the database has been detached and reattached on another server. Please refer to Steven's reply: http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/f9200000-851e-48d2-bb10-aeed5e9b1e1b/

    Thanks,
    Eileen

     

    Eileen Zhao
    TechNet Community Support

     
  • Mittwoch, 13. Februar 2013 12:08
     
      Enthält Code
    Anmelden
    0

    Hi ,

    Thanks for your reply.

    In my case i have not attaching  the database into my new server.

    I have investigated this issue and found that when one open query exeucted then it fetch tha data but it disconnect the query analyser with the following meassge:

    Same query is executed to my another server.

    WITH SourceCTE AS (SELECT *, CHECKSUM(BEHCOD, FTINUM, FTRNUM, WORNUM, WOVNUM, RGLNUM, FTNBDR, AUDDTC, AUDDTU, AUDTMC, AUDTMU, AUDFNC, AUDFNU, AUDUSC, AUDUSU) [biSysColSourceCheckSum] FROM OPENQUERY(N99SYS00MSES, 'SELECT BEHCOD, FTINUM, FTRNUM, WORNUM, WOVNUM, RGLNUM, FTNBDR, AUDDTC, AUDDTU, AUDTMC, AUDTMU, AUDFNC, AUDFNU, AUDUSC, AUDUSU FROM N99SYS00.ES017PD.VRIW')) 
SELECT [biSysColUDI] = 'I', [biSysColCountry] = 'ES', [biSysColSourceSk] = 9, [biSysColSourcePreSufix] = 'ES017PD', [biSysColInsertLogId] = 9999, [biSysColUpdateLogId] = 9999, [biSysColSourceCheckSum] = src.[biSysColSourceCheckSum], [biSysColDeletedFlag] = 0, src.BEHCOD, src.FTINUM, src.FTRNUM, src.WORNUM, src.WOVNUM, src.RGLNUM, src.FTNBDR, src.AUDDTC, src.AUDDTU, src.AUDTMC, src.AUDTMU, src.AUDFNC, src.AUDFNU, src.AUDUSC, src.AUDUSU FROM SourceCTE  AS src;

    A severe error occurred on the current command.  The results, if any, should be discarded.

    Msg 0, Level 20, State 0, Line 0

    A severe error occurred on the current command.  The results, if any, should be discarded.

    But if we execute the the below simple query then it executed sucessfully.

    select * from N99SYS00MSES.N99SYS00.ES017PD.VRIW
    Pleas advice me.