toString does not accept array types

%3CLINGO-SUB%20id%3D%22lingo-sub-1432678%22%20slang%3D%22en-US%22%3EtoString%20does%20not%20accept%20array%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432678%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20of%20today%20i%20started%20getting%20a%20new%20error%20message%20in%20my%20pipelines%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(DF-FN-006%20-%20toString%20does%20not%20accept%20array%20types)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20seems%20to%20be%20a%20recent%20change%20and%20I%20have%20quite%20a%20lot%20Mapping%20Dataflows%20which%20rely%20on%20these%20conversions.%20e.g%20toString(columnname)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20of%20a%20solution%20or%20workaround%20i%20can%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1432678%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433635%22%20slang%3D%22en-US%22%3ERe%3A%20toString%20does%20not%20accept%20array%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433635%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20problem%20as%20of%20today%3B%3C%2FP%3E%3CP%3Edata%20flows%20which%20have%20been%20working%20in%20production%20environment%20are%20now%20failing%20with%20this%20error.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GeoRos_0-1591110338591.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195923i73EB08470F1360C0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22GeoRos_0-1591110338591.png%22%20alt%3D%22GeoRos_0-1591110338591.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434889%22%20slang%3D%22en-US%22%3ERe%3A%20toString%20does%20not%20accept%20array%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686093%22%20target%3D%22_blank%22%3E%40rajneelsharma%3C%2FA%3E%26nbsp%3B%20Can%20you%20please%20open%20an%20Azure%20ticket%20on%20it%20from%20the%20Azure%20Portal%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438731%22%20slang%3D%22en-US%22%3ERe%3A%20toString%20does%20not%20accept%20array%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686730%22%20target%3D%22_blank%22%3E%40GeoRos%3C%2FA%3EMy%20errors%20have%20disappeared%20the%20next%20day%20and%20my%20pipelines%20as%20working%20again.%20Are%20you%20still%20having%20problems%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438734%22%20slang%3D%22en-US%22%3ERe%3A%20toString%20does%20not%20accept%20array%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F175989%22%20target%3D%22_blank%22%3E%40Mark%20Kromer%3C%2FA%3E%20the%20issue%20appears%20to%20have%20resolved%20it%20self%20the%20next%20day.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442990%22%20slang%3D%22en-US%22%3ERe%3A%20toString%20does%20not%20accept%20array%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686093%22%20target%3D%22_blank%22%3E%40rajneelsharma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20specific%20toString%20error%20disappeared%3B%20however%20same%20DataFlow%20fails%20with%20another%20error%20(below)%20past%20two%20days.%20Will%20contact%20Azure%20Support%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%7B%20%22errorCode%22%3A%20%224501%22%2C%20%22message%22%3A%20%22Failed%20to%20fetch%20execution%20state%3A%20''%2C%20please%20retry.%20If%20the%20problem%20persists%2C%20please%20contact%20Azure%20Support%22%2C%20%22failureType%22%3A%20%22UserError%22%2C%20%22target%22%3A%20%22meta_Heap_json%22%2C%20%22details%22%3A%20%5B%5D%20%7D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20914px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196732i90C5C2545409CC9F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

As of today i started getting a new error message in my pipelines -

 

(DF-FN-006 - toString does not accept array types)

 

This seems to be a recent change and I have quite a lot Mapping Dataflows which rely on these conversions. e.g toString(columnname)

 

Anyone know of a solution or workaround i can use?

 

Thanks

5 Replies

Same problem as of today;

data flows which have been working in production environment are now failing with this error.

GeoRos_0-1591110338591.png

 

@rajneelsharma  Can you please open an Azure ticket on it from the Azure Portal?

@GeoRosMy errors have disappeared the next day and my pipelines as working again. Are you still having problems?

Hi@Mark Kromer the issue appears to have resolved it self the next day. Thanks

@rajneelsharma 

That specific toString error disappeared; however same DataFlow fails with another error (below) past two days. Will contact Azure Support

 

{ "errorCode": "4501", "message": "Failed to fetch execution state: '', please retry. If the problem persists, please contact Azure Support", "failureType": "UserError", "target": "meta_Heap_json", "details": [] }

 

 
 

Capture.PNG