What is sql.log file linked to the gateway and Microsoft Mashup Evaluation Container ?

[Anonymous]

Hi all,

I have a problem with a sql.log file which is linked to the gateway and Microsoft Mashup Evaluation Container.

This file is feeded by several Microsoft Mashup Evaluation Container exe, wich are themselves linked to a personal gateway.

The gateway is used for hyperfile files and a sharepoint document.

I can't find anything on the forum, does anyone know what this sql.log file is about ? 

In my case its size was huge (30 go) before I emptied it :

 

Below is an exemple of what is written inside :

Microsoft.Power 4044-2324 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x0000000000000000
SQLHANDLE * 0x0000025387B0CE28

Microsoft.Power 4044-2324 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x0000000000000000
SQLHANDLE * 0x0000025387B0CE28 ( 0x00000253F788BE70)

Microsoft.Power 4044-2324 ENTER SQLSetEnvAttr
SQLHENV 0x00000253F788BE70
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER -6

Microsoft.Power 4044-2324 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x00000253F788BE70
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER -6

Thank you in advance for your help.

Regards,

Alice

[Anonymous · Accepted solution]

Hi @v-chenwuz-msft,

Sorry for the delay, I finnaly found how to resolve my problem.

In fact, the sql.log file was linked to the tracing enabled in the ODBC data source administrator, my personal gateway was using an ODBC connection.

[v-chenwuz-msft]

Hi @Anonymous 

I found some imfo about the Microsoft mashup evaluation contaniner.

What is Microsoft mashup evaluation container?

This is the Power Query Editor Engine that completes all the steps that were done in the Power Query Editor.

https://community.powerbi.com/t5/Service/What-is-Microsoft-mashup-evaluation-container-How-it-impacts-the/m-p/439288#M46668

Did you fail to refresh?

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.