externdata throwing errors

%3CLINGO-SUB%20id%3D%22lingo-sub-1491971%22%20slang%3D%22en-US%22%3Eexterndata%20throwing%20errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491971%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20anyone%20been%20able%20to%20use%20externdata%20today%3F%26nbsp%3B%20I%20just%20tried%20and%20I%20keep%20getting%20an%20error.%26nbsp%3B%20I%20had%20to%20create%20a%20new%20SAS%20but%20used%20Microsoft%20Azure%20Storage%20Explorer%20like%20I%20have%20before%20with%20any%20issues.%26nbsp%3B%20The%20error%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ehe%20query%20was%20aborted%20by%20the%20server.%20Details%3A%20Partial%20query%20failure%3A%20Invalid%20pointer%20(message%3A%20'Argument%20'name'%20is%20null%3A%20at%20.ctor%20in%20c%3A%5Csource%5CSrc%5CCommon%5CKusto.Cloud.Platform.Azure%5CStorage%5CPersistentStorage%5CBlobPersistentStorageFile.cs%3A%20line%2056%20Parameter%20name%3A%20name%3A%20'%2C%20details%3A%20'Source%3A%20Kusto.Cloud.Platform%20System.ArgumentNullException%3A%20Argument%20'name'%20is%20null%3A%20at%20.ctor%20in%20c%3A%5Csource%5CSrc%5CCommon%5CKusto.Cloud.Platform.Azure%5CStorage%5CPersistentStorage%5CBlobPersistentStorageFile.cs%3A%20line%2056%20Parameter%20name%3A%20name%20at%20Kusto.Cloud.Platform.Utils.Ensure.ArgIsNotNullOrWhiteSpace(String%20value%2C%20String%20argName%2C%20String%20callerMemberName%2C%20String%20callerFilePath%2C%20Int32%20callerLineNumber)%20in%20c%3A%5Csource%5CSrc%5CCommon%5CKusto.Cloud.Platform%5CDiagnostics%5CEnsure.cs%3Aline%20166%20at%20Kusto.Cloud.Platform.Azure.Storage.PersistentStorage.BlobPersistentStorageFile..ctor(CloudBlobContainer%20blobContainer%2C%20String%20name%2C%20IPersistentStorageFileCompressor%20persistentStorageFileCompressor%2C%20IPersistentStorageUri%20persistentStorageUri%2C%20TriState%20validBlobStorage%2C%20Nullable%601%20length%2C%20Nullable%601%20lastModified)%20in%20c%3A%5Csource%5CSrc%5CCommon%5CKusto.Cloud.Platform.Azure%5CStorage%5CPersistentStorage%5CBlobPersistentStorageFile.cs%3Aline%2057%20at%20Kusto.Cloud.Platform.Azure.Storage.PersistentStorage.BlobPersistentStorageFactory.CreateFileRef(String%20uri%2C%20ICredentialsProvider%20credentialsProvider%2C%20String%20compressionType%2C%20IPersistentStorageFileCompressorFactory%20persistentStorageFileCompressorFactory%2C%20StorageItemLocationMode%20locationMode)%20in%20c%3A%5Csource%5CSrc%5CCommon%5CKusto.Cloud.Platform.Azure%5CStorage%5CPersistentStorage%5CBlobPersistentStorageFactory.cs%3Aline%20210%20at%20Kusto.Cloud.Platform.Storage.PersistentStorage.PersistentStorageFactoryFactory.CreateFileRef(String%20uri%2C%20ICredentialsProvider%20credentialsProvider%2C%20String%20compressionType%2C%20IPersistentStorageFileCompressorFactory%20persistentStorageFileCompressorFactory%2C%20StorageItemLocationMode%20locationMode)%20in%20c%3A%5Csource%5CSrc%5CCommon%5CKusto.Cloud.Platform%5CStorage%5CPersistentStorage%5CPersistentStorageFactoryFactory.cs%3Aline%20152%20at%20Kusto.DataNode.DataEngineQueryPlan.ExternalDataQueryUtils.ReadExternalDataAsCsv(ArtifactEntry%20artifactEntry%2C%20String%20authorizationScheme%2C%20String%20securityToken%2C%20DataSourceStreamFormat%20format%2C%20String%20serializedColumnMapping%2C%20String%20serializedProjectedColumnNames%2C%20Int64%20recordCountLimit)%20in%20c%3A%5Csource%5CSrc%5CEngine%5CDataNode%5CQueryService%5CDataEngineQueryPlan%5CExternalDataQueryUtils.cs%3Aline%2095%20at%20Kusto.DataNode.DataEngineQueryPlan.DataEngineQueryProcessor.DataEngineQueryCallback.GetExternalData(String%20externalDataUri%2C%20String%20authorizationScheme%2C%20String%20securityToken%2C%20DataSourceStreamFormat%20format%2C%20String%20serializedColumnMapping%2C%20String%20serializedProjectedColumnNames%2C%20Int64%20recordCountLimit)%20in%20c%3A%5Csource%5CSrc%5CEngine%5CDataNode%5CQueryService%5CDataEngineQueryPlan%5CDataEngineQueryProcessor.cs%3Aline%20360')%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super Contributor

Has anyone been able to use externdata today?  I just tried and I keep getting an error.  I had to create a new SAS but used Microsoft Azure Storage Explorer like I have before with any issues.  The error is: 

 

he query was aborted by the server. Details: Partial query failure: Invalid pointer (message: 'Argument 'name' is null: at .ctor in c:\source\Src\Common\Kusto.Cloud.Platform.Azure\Storage\PersistentStorage\BlobPersistentStorageFile.cs: line 56 Parameter name: name: ', details: 'Source: Kusto.Cloud.Platform System.ArgumentNullException: Argument 'name' is null: at .ctor in c:\source\Src\Common\Kusto.Cloud.Platform.Azure\Storage\PersistentStorage\BlobPersistentStorageFile.cs: line 56 Parameter name: name at Kusto.Cloud.Platform.Utils.Ensure.ArgIsNotNullOrWhiteSpace(String value, String argName, String callerMemberName, String callerFilePath, Int32 callerLineNumber) in c:\source\Src\Common\Kusto.Cloud.Platform\Diagnostics\Ensure.cs:line 166 at Kusto.Cloud.Platform.Azure.Storage.PersistentStorage.BlobPersistentStorageFile..ctor(CloudBlobContainer blobContainer, String name, IPersistentStorageFileCompressor persistentStorageFileCompressor, IPersistentStorageUri persistentStorageUri, TriState validBlobStorage, Nullable`1 length, Nullable`1 lastModified) in c:\source\Src\Common\Kusto.Cloud.Platform.Azure\Storage\PersistentStorage\BlobPersistentStorageFile.cs:line 57 at Kusto.Cloud.Platform.Azure.Storage.PersistentStorage.BlobPersistentStorageFactory.CreateFileRef(String uri, ICredentialsProvider credentialsProvider, String compressionType, IPersistentStorageFileCompressorFactory persistentStorageFileCompressorFactory, StorageItemLocationMode locationMode) in c:\source\Src\Common\Kusto.Cloud.Platform.Azure\Storage\PersistentStorage\BlobPersistentStorageFactory.cs:line 210 at Kusto.Cloud.Platform.Storage.PersistentStorage.PersistentStorageFactoryFactory.CreateFileRef(String uri, ICredentialsProvider credentialsProvider, String compressionType, IPersistentStorageFileCompressorFactory persistentStorageFileCompressorFactory, StorageItemLocationMode locationMode) in c:\source\Src\Common\Kusto.Cloud.Platform\Storage\PersistentStorage\PersistentStorageFactoryFactory.cs:line 152 at Kusto.DataNode.DataEngineQueryPlan.ExternalDataQueryUtils.ReadExternalDataAsCsv(ArtifactEntry artifactEntry, String authorizationScheme, String securityToken, DataSourceStreamFormat format, String serializedColumnMapping, String serializedProjectedColumnNames, Int64 recordCountLimit) in c:\source\Src\Engine\DataNode\QueryService\DataEngineQueryPlan\ExternalDataQueryUtils.cs:line 95 at Kusto.DataNode.DataEngineQueryPlan.DataEngineQueryProcessor.DataEngineQueryCallback.GetExternalData(String externalDataUri, String authorizationScheme, String securityToken, DataSourceStreamFormat format, String serializedColumnMapping, String serializedProjectedColumnNames, Int64 recordCountLimit) in c:\source\Src\Engine\DataNode\QueryService\DataEngineQueryPlan\DataEngineQueryProcessor.cs:line 360')

1 Reply

@Gary Bushey ID-10-T error.  Had the container selected rather than the file when creating the SAS.  DOH!