Skip to content
+1-888-319-3663

COMMUNITY FORUM

MS SQL Realtime datasource: error in event logs

Syed asked 7 years ago
We have “MS SQL Realtime data source” as data source in map and mapped three nodes with this map.
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.
Syed replied 7 years ago
I have checked the Debug window and found below details:
 
Message Log: Assembly compilation failed
Map Detail Id: 40b8ec66-d8bb-4b5f-9f12-a427006b66a2
Log Map Detail Type: buildassembly
Sequence: 14
Tenant:
Was Successful: Unchecked
Log Master Errors: eOne.SmartConnect.Engine.LogMaster " Error count : 8
                                   Cannot implicitly convert type 'string' to 'bool'
                                   Cannot implicitly convert type 'string' to 'bool'
                                   Unreachable code detected
                                   Cannot implicitly convert type 'string' to 'bool'
                                   Cannot implicitly convert type 'string' to 'bool'
                                   Unreachable code detected
                                   Cannot implicitly convert type 'string' to 'bool'
                                   Cannot implicitly convert type 'string' to 'bool'
Answers
Best Answer
lorren answered 7 years ago
Syed,

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.
Syed replied 7 years ago

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.