Reply
Frequent Visitor
Posts: 12
Registered: ‎12-09-2016
Accepted Solution

August 2018 Release: Unexpected error importing json file from Data Lake

Hi,

in the August release I'm trying to import a Json file from Data Lake and performing the conversion step below:

= Json.Document(#"CustUserList json")

I receive the following error (same error also converting other files. All of them are perfectly valid Json files).

 

Unexpected error: Adding the specified count to the semaphore would cause it to exceed its maximum count.
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> System.Threading.SemaphoreFullException: Adding the specified count to the semaphore would cause it to exceed its maximum count. ---> System.Threading.SemaphoreFullException: Adding the specified count to the semaphore would cause it to exceed its maximum count.
at System.Threading.Semaphore.Release(Int32 releaseCount)
at System.Threading.Semaphore.Release()
at Microsoft.Internal.EngineContext.Leave()
at Microsoft.Mashup.Engine1.Library.Web.WebContentsBinaryValue.get_AsBytes()
at Microsoft.Mashup.Engine1.Runtime.Library.Binary.BufferFunctionValue.TypedInvoke(Value value)

This is an issue of the August Release. Previous release worked fine.

 


Accepted Solutions
Frequent Visitor
Posts: 12
Registered: ‎12-09-2016

Re: August 2018 Release: Unexpected error importing json file from Data Lake

[ Edited ]

Found a way to revert back to July PBI release here and now everything is working fine.

 

@v-shex-msft: Please file it as a bug to the product team.

 

There is also another bug in the August release with ADLS connector. PBI asks for an optional parameter in the ADLS connection window but if you leave it blank the PBI retruns an error and you cannot go further.

 

Moreover if you do not delete the null or [] parameters that PBI automatically adds in the M language in the ADLS connectionstring when you publish the pbix to the PBI service you receive an error when ADLS dataset refreshes.

 

 

View solution in original post

Advisor
Posts: 17
Registered: ‎07-10-2015

Re: August 2018 Release: Unexpected error importing json file from Data Lake

Hi,

 

Got the exact same problem on the August build.

 

A workaround that worked for me is to execute a Text.FromBinary before the Json.Document:

 

2018-08-17_11-52-35.png

 

Hope it helps...

View solution in original post


All Replies
Community Support Team
Posts: 7,441
Registered: ‎08-14-2016

Re: August 2018 Release: Unexpected error importing json file from Data Lake

Hi @sgiovinetti,

 

I think this issue is more related to azure data lake json data amount limitation.

 

For this scenario, I'd like to suggest you to write a custom extractor instead to load data with original json array schema, it should more suitable with huge amount of data.

How do I load Large JSON Array files into Azure Data Lake Analytics (ADLA)

Extract JSON lines in U-SQL

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
Frequent Visitor
Posts: 12
Registered: ‎12-09-2016

Re: August 2018 Release: Unexpected error importing json file from Data Lake

Hi @v-shex-msft,

this is not the case. The file is only 2.8KB.

 

Consider the following 2 things:

 

1 if I open with PBI from local file system it works correctly

2 everything was functioning right in the July version of PBI, looks like an issue introduced with August version.

 

Is there a way to rollback the installation of PBI to July version?

 

Regards

Stefano

Frequent Visitor
Posts: 12
Registered: ‎12-09-2016

Re: August 2018 Release: Unexpected error importing json file from Data Lake

[ Edited ]

Found a way to revert back to July PBI release here and now everything is working fine.

 

@v-shex-msft: Please file it as a bug to the product team.

 

There is also another bug in the August release with ADLS connector. PBI asks for an optional parameter in the ADLS connection window but if you leave it blank the PBI retruns an error and you cannot go further.

 

Moreover if you do not delete the null or [] parameters that PBI automatically adds in the M language in the ADLS connectionstring when you publish the pbix to the PBI service you receive an error when ADLS dataset refreshes.

 

 

Advisor
Posts: 17
Registered: ‎07-10-2015

Re: August 2018 Release: Unexpected error importing json file from Data Lake

Hi,

 

Got the exact same problem on the August build.

 

A workaround that worked for me is to execute a Text.FromBinary before the Json.Document:

 

2018-08-17_11-52-35.png

 

Hope it helps...