Error when I try to preview external call transformation

Diyaa, Shridi 25 Reputation points
2023-10-05T11:41:12.0233333+00:00

When I try to preview data of an external call transformation, I get the following error:

Spark job failed: { "text/plain": "{"runId":"a07da92a-34f0-4ede-bdbe-8ce326b612c8","sessionId":"6d629a83-5f12-4905-bf18-50443171fc3a","status":"Failed","payload":{"statusCode":400,"shortMessage":"DF-DSL-001 DSL stream has parsing errors\nLine 103 Position 20: extraneous input ''' expecting {DECIMAL_LITERAL, HEX_LITERAL, OCT_LITERAL, BINARY_LITERAL, MAX_INT, MIN_INT, MAX_LONG, MIN_LONG, POSITIVE_INF, NEGATIVE_INF, '-', '!', '$', '~', ':', '(', '#', '[', '@(', '[]', FLOAT_LITERAL, HEX_FLOAT_LITERAL, STRING_LITERAL, REGEX_LITERAL, 'parameters', 'functions', 'stores', 'as', 'input', 'output', 'constant', 'expression', 'integer', 'short', 'long', 'double', 'float', 'decimal', 'boolean', 'timestamp', 'date', 'byte', 'binary', 'integral', 'number', 'fractional', 'any', IDENTIFIER, ANY_IDENTIFIER, META_MATCH, '$$', '$$$', '$#', OPEN_INTERPOLATE}","detailedMessage":"Failure 2023-10-05 11:32:40.388 failed DebugManager.processJob, run=a07da92a-34f0-4ede-bdbe-8ce326b612c8, errorMessage=DF-DSL-001 DSL stream has parsing errors\nLine 103 Position 20: extraneous input ''' expecting {DECIMAL_LITERAL, HEX_LITERAL, OCT_LITERAL, BINARY_LITERAL, MAX_INT, MIN_INT, MAX_LONG, MIN_LONG, POSITIVE_INF, NEGATIVE_INF, '-', '!', '$', '~', ':', '(', '#', '[', '@(', '[]', FLOAT_LITERAL, HEX_FLOAT_LITERAL, STRING_LITERAL, REGEX_LITERAL, 'parameters', 'functions', 'stores', 'as', 'input', 'output', 'constant', 'expression', 'integer', 'short', 'long', 'double', 'float', 'decimal', 'boolean', 'timestamp', 'date', 'byte', 'binary', 'integral', 'number', 'fractional', 'any', IDENTIFIER, ANY_IDENTIFIER, META_MATCH, '$$', '$$$', '$#', OPEN_INTERPOLATE}"}}\n" } - RunId: a07da92a-34f0-4ede-bdbe-8ce326b612c8

I tried navigating to line 103 position 20 but didn't find out what's wrong. Appreciate any help.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,793 questions
{count} votes

Accepted answer
  1. QuantumCache 20,106 Reputation points
    2023-10-05T23:20:15.2033333+00:00

    Hello @Diyaa, Shridi Welcome to QnA forum!

    It is possible that there is a syntax error or a missing parameter in the DSL stream.

    I would suggest reviewing the DSL stream carefully and checking for any syntax errors or missing parameters. You may also want to try removing the extraneous input ''' at line 103 position 20 and see if that resolves the issue.

    You can review the input and output of the external call transformation to ensure that they are correctly defined and match the expected keywords.

    10262023 Offline Support Summary: by Original Poster (Diyaa, Shridi )

    I received and tested the following solution from Microsoft support and found it to resolve the issue.

    preview request checkbox in the debug settings panel should be unchecked and the preview should start working.

    User's image

    Please let us know if this issue is still persistent? comment in the below section!


1 additional answer

Sort by: Most helpful
  1. Diyaa, Shridi 25 Reputation points
    2023-10-26T10:33:02.7766667+00:00

    I received and tested the following solution from Microsoft support and found it to resolve the issue.

    preview request checkbox in the debug settings panel should be unchecked and the preview should start working.

    User's image

    1 person found this answer helpful.
    0 comments No comments