none
Usql - Job failed due to internal system error - NM_CANNOT_LAUNCH_JM

    Question

  • I get the following system error,

    Error in Activity: [{"errorId":"E_SYSTEM_NM_NMCANNOTLAUNCHJM"
    ,"name":"NM_CANNOT_LAUNCH_JM"
    ,"severity":"Error"
    ,"source":"System"
    ,"component":"NM"
    ,"message":"Job failed due to internal system error."
    ,"details":""
    ,"description":"","resolution":"","helpLink":"","innerError":null}].

    This doesn't look intermittent. All it does is copy a file from one location to another. It says internal system error - Any ideas?

    Following is my Usql script,

    DECLARE @in string = "20160229";
    DECLARE @year string = "2016";
    DECLARE @month string = "02";
    DECLARE @day string = "29";
    DECLARE @fileSource string = "/Outputs/folder1/" + @year + @"/" + @month + @"/" + @day + @"/file." + @in;
    
    @rs0 =
        EXTRACT col1 string,
                col2 string,
                col3 string
        FROM @fileSource
        USING Extractors.Csv();
    
    @rs1 =
        SELECT col1,
               col2,
               col3,
               @in AS Date
        FROM @rs0
    
    DECLARE @fileDestination string = "/Outputs/folder2/TEST.csv";
    
    OUTPUT @rs1
    TO @fileDestination
    USING Outputters.Text( quoting : false, delimiter : '|');


    Subash.S

    Thursday, March 17, 2016 10:01 AM

Answers

All replies

  •  It resolved itself after a while. Looks like a service outage.

    Subash.S

    Thursday, March 17, 2016 11:25 AM
  • @Subash,

    I'm sorry for the issues that you encountered here.  Can you please email me (mwinkle at microsoft ) with your subscription id and account name, the team here wants to investigate.

    Thanks!


    Group Program Manager -- Big Data @ Microsoft

    Thursday, March 17, 2016 3:47 PM
  • The issue was resolved by noon on Thursday. Our apologies for the intermittent service disruption.

    Michael Rys

    Friday, March 18, 2016 10:30 PM
    Moderator
  • Hi Michael,

    We encountered same issue .As searching on net seems already you updated this issue resolved could you please suggest on the same,is still any development going on this issue.

    E_SYSTEM_NM_NMCANNOTLAUNCHJM: Job failed due to internal system error.

    Thursday, July 26, 2018 6:23 AM