PowerBI, PowerOn error: Save Failed: License error


PowerBI, PowerOn error: Save Failed: License error

Error:

Save Failed: License error

RESPONSE:
No valid license. Stack Trace: Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at LicenseCentralServiceReference.ILicenseCentralService.CheckLicense(String token) at PPWebService.PPWebService.CheckLicense(String version, String user, String customer, String licenseServer, String op, String driver) in
REQUEST:
{“conn”:”SQLConnection”,”connType”:”SQL Datasource”,”customer”:””,”deletedRows”:[],”domain”:””,”insertedRows”:[],”sourceColumns”:[“PCODetailWBKey”,”Pending Change

Solution: PowerOn Licenses are locked or expired. Work with the PowerOn team to increase or refresh the licenses.

How to use Windows Authentication in Database Connector with Microsoft SQL Server in Mule4


How to use Windows Authentication in Database Connector with Microsoft SQL Server in Mule4

Very simple solution:

Add DB connection property after creating a generic MS SQL connection.

Just add listed DB connection property XML tag(s) in the DB config tag.

<db:config name=”Database_Config” doc:name=”Database Config” doc:id=”068171dd-d96f-4eeb-8376-0326746ae25d” >
<db:mssql-connection host=”HOST_IP_NAME” user=”USER_NAME” password=”PASSWORD” databaseName=”DATABASE_NAME“>
<db:connection-properties>
<db:connection-property
key=”authenticationScheme” value=”NTLM” />
<db:connection-property key=”domain” value=”DOMAIN_NAME” />
<db:connection-property
key=”integratedSecurity” value=”true” />
</db:connection-properties>
</db:mssql-connection>
</db:config>