Unable to run scripts locally in visual studio


  • I am unable to run usql scripts locally from within visual studio (version 15.7.1). I get the following error:

    Severity Code Description Project File Line Suppression State
    Error E_SMS_SYSTEM_FAILURE: Value cannot be null.
    Parameter name: source
    An exception has been raised from the metadata service client. This could be the result of a user operation or the SMS service being temporarily unavailable.
    Please correct the user operation or contact support if the service outage persists. Thales.USql.Queries D:\Development\eclipsePoc\usql-queries\Thales.USql.Queries\Ldc\LdcScript.usql 1

    Is there a solution for this problem?
    Friday, May 18, 2018 8:15 AM

All replies

  • Robert,

    Could you please try to get the "diagnosticsjson" log file from the  ProjectDirectory \bin\debug\ScriptName\ directory and post the detailed error stack here for us to check ?

    In additon, you may want to try the following steps to see if that helps :

    1.  VS -> Tools -> Data Lake -> Options and Settings -> U-SQL Runtime SDK Directory -> Reset

    If that doesn't work, you may try to recreate the local metadata again.   Please note that this will result in loss of your local tables and registered metadata objects.   

    2. Delete DATAROOT \  localrunmetadata  and _catalog_  and recreate the local environment. 


    Yu Dong

    Monday, May 21, 2018 5:23 AM