Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Salesforce Spring 19 Field Truncation even after DBAmp upgradation of 3.7.3

Salesforce Spring 19 Field Truncation even after DBAmp upgradation of 3.7.3.

Dear team,

Text formula fields of salesforce, are getting truncated when queried after spring 19 release. We upgraded DBAmp to 3.7.3 by reading the release notes. We still see this issue.

Query: select * into sys_sffields_20180109 from ls_salesforce_projectuat...sys_sffields

select * From sys_sffields_20180109
where
calculated='true'
and type='string'
and objectname='Account'

we see all SQLDefinition is nvarchar(255) null

select id,len(outlet_picture__C) from openquery(ls_salesforce_projectuat,'select id,outlet_picture__C from account where id =''001w000001OqhiiAAB''')

returns
001w000001OqhiiAAB,255

This is on a Sandbox environment. Please let me know to provide further information
1 person has
this problem
+1
Reply