none
Azure Data Factory U-SQL Pipeline script - "errorCode": "2703","message": "Error Id: E_CSC_USER_SYNTAXERROR, Error Message: syntax error. ... exceeds the maximum allowed length (512). ",

    Question

  • I created an Azure Data Factory - Data Lake Analytics - U-SQL pipeline and am trying to use the script below.  But I get a strange syntax error when running it - stating that I am ' exceeds the maximum allowed length (512). ".

    {
      "name": "AmazonDailySales-U-SQL",
      "properties": {
        "activities": [
          {
              "name": "U-SQL Script for Amazon Actual Sales Master",
              "type": "DataLakeAnalyticsU-SQL",
              "policy": {
                "timeout": "7.00:00:00",
                "retry": 0,
                "retryIntervalInSeconds": 30,
                "secureOutput": false,
                "secureInput": false
              },
              "typeProperties": {
                "scriptPath": "lfanalytics/Scripts/DailySales_script.usql",
                "scriptLinkedService": {
                  "referenceName": "azureblobstoragelinkedservice1",
                  "type": "LinkedServiceReference"
                },
                "parameters": {
                  "dailysales_file": "'wasb://lfanalytics@lsnasa02.blob.core.windows.net/AmazonUSDailySalesDiagnostic_2018-10-24.csv",
                  "asinmapping_file": "wasb://lfanalytics@lsnasa02.blob.core.windows.net/ASIN mapping.csv",
                  "actualsalesmaster_file": "wasb://lfanalytics@lsnasa02.blob.core.windows.net/output/actualsalesmaster.csv"
                }
              },
              "linkedServiceName": {
                "referenceName": "AzureDataLakeAnalytics_LinkedService",
                "type": "LinkedServiceReference"
              },        
            "inputs": [
              {
                "name": "AmazonDailySales"
              },
              {
                "name": "ASINMapping"
              }
            ],
            "outputs": [
              {
                "name": "AmazonActualSalesMaster"
              }
            ]
    	  }
    	]
      }
    } 

    Error Message:

    Error
    
    
    {
        "errorCode": "2703",
        "message": "Error Id: E_CSC_USER_SYNTAXERROR, Error Message: syntax error. Expected one of: ALTER COMBINE CREATE DECLARE DELETE DEPLOY DROP EXPORT EXTRACT IF IMPORT INSERT PROCESS RAISE REDUCE REFERENCE RENAME SAMPLE SELECT SET TRUNCATE UPDATE USE USING identifier quoted-identifier variable '(' OUTPUT ';' . Error Id: E_CSC_USER_QUOTEDIDENTIFIERTOOLONG, Error Message: Quoted Identifier '\n      {\n          \"name\": \"U-SQL Script for Amazon Actual Sales Master\",\n          \"type\": \"DataLakeAnalyticsU-SQL\",\n          \"policy\": {\n            \"timeout\": \"7.00:00:00\",\n            \"retry\": 0,\n            \"retryIntervalInSeconds\": 30,\n            \"secureOutput\": false,\n            \"secureInput\": false\n          },\n          \"typeProperties\": {\n            \"scriptPath\": \"lfanalytics/Scripts/DailySales_script.usql\",\n            \"scriptLinkedService\": {\n              \"referenceName\": \"azureblobstoragelinkedservice1\",\n              \"type\": \"LinkedServiceReference\"\n            },\n            \"parameters\": {\n              \"dailysales_file\": \"'wasb://lfanalytics@lsnasa02.blob.core.windows.net/AmazonUSDailySalesDiagnostic_2018-10-24.csv\",\n              \"asinmapping_file\": \"wasb://lfanalytics@lsnasa02.blob.core.windows.net/ASIN mapping.csv\",\n              \"actualsalesmaster_file\": \"wasb://lfanalytics@lsnasa02.blob.core.windows.net/output/actualsalesmaster.csv\"\n            }\n          },\n          \"linkedServiceName\": {\n            \"referenceName\": \"AzureDataLakeAnalytics_LinkedService\",\n            \"type\": \"LinkedServiceReference\"\n          },        \n        \"inputs\": [\n          {\n            \"name\": \"AmazonDailySales\"\n          },\n          {\n            \"name\": \"ASINMapping\"\n          }\n        ' exceeds the maximum allowed length (512). ",
        "failureType": "UserError",
        "target": "amazon-daily-sales-U-SQL"
    }

    Thursday, November 8, 2018 10:44 PM

All replies