MS SQL Realtime datasource: error in event logs
When any change in table appears, it fires the trigger and we have validate this because of change in “Run Number” field of Map grid.
But as per mapping we are unable to find the updated data. Then we’ll check the Event log and found below error.
Cannot implicitly convert type ‘string’ to ‘bool’
This error is shown then number of Mappings available in map. We have test this by removing map one by one.
For trying to resolve, we have checked the datatype of all fields. But nothing wrong with the data and datatype.
For checking the same,
We have created the duplicate map and change the data source to “ODBC data source” and schedule this map for 1 minute. We found that this map is working as required.
Provide the solution to cross this issue.
Log Map Detail Type: buildassembly
Was Successful: Unchecked
Log Master Errors: eOne.SmartConnect.Engine.LogMaster " Error count : 8
what value are you sending to the destination for the boolean? You don't say what your destination is so it's hard to say if that boolean is supposed to be a 0 or 1 or FALSE/TRUE or which value it is requesting.
More than likely you are sending a string of TRUE/FALSE and it needs 0/1.
I have selected MS Dynamic GP as destination.
I have added one extender object and map that extender node with datasource output fields.
The Extender node having by default Windows ID and I have added Customer number and emailid fields mapping and then save it.
Then update the datasource table, so as per logic, I need this Email ID Updated according to selected customer.
But it gives error in debug log (as mentioned in above discussions).
As per my understanding, this is because of compilation of some assembly. And must be in place where attached document task check applied.
If you would like to submit an answer or comment, please sign in to the eOne portal.