You’re offline. This is a read only version of the page.
Announcements
13
Hi,
I have custom objects in Business central since I want to create an extension in the Business Central cloud I have renamed object names with BGS_ as a suffix in Visual Studio code and Published them online but my SQL server database tables are without Suffix BGS_. So data from these tables are not copied into my online business central.
will you suggest one? Please
Width property is different to length of the field.
We cannot increase the length of the field size in BC.
Standard Description field length is 100 characters so you have to shrink your data in description field 100 in your OnPrem system.
Hi Mohana,
Your advice is working fine.
around 7 important tables are not migrated because of almost one reason the 'Description' field has more than customized standard tables.
example
"Failed to copy the table. Inner error: String or binary data would be truncated in table 'db_bcprodasia_t86224812_20230306_06352608_0756.dbo.BrightGas$Item$437dbf0e-84ff-417a-965d-ed2bb9650972', column 'Description'. Truncated value: 'LPG Flexible Hose With 3/4" CS NPT Male Fitting Other End 3/4" CS NPT Female Fitting Union Type With'.'
where to correct
I have increased the size as shown below
Hi Mohana,
Your advice is working fine.
around 7 important tables are not migrated because of almost one reason the 'Description' field has more than customized standard tables.
example
"Failed to copy the table. Inner error: String or binary data would be truncated in table 'db_bcprodasia_t86224812_20230306_06352608_0756.dbo.BrightGas$Item$437dbf0e-84ff-417a-965d-ed2bb9650972', column 'Description'. Truncated value: 'LPG Flexible Hose With 3/4" CS NPT Male Fitting Other End 3/4" CS NPT Female Fitting Union Type With'.'
where to correct
I have increased the size as shown below
Hi Mohana,
Your advice is working fine.
around 7 important tables are not migrated because of almost one reason the 'Description' field has more than customized standard tables.
example
"Failed to copy the table. Inner error: String or binary data would be truncated in table 'db_bcprodasia_t86224812_20230306_06352608_0756.dbo.BrightGas$Item$437dbf0e-84ff-417a-965d-ed2bb9650972', column 'Description'. Truncated value: 'LPG Flexible Hose With 3/4" CS NPT Male Fitting Other End 3/4" CS NPT Female Fitting Union Type With'.'
where to correct
I have increased the size as shown below
You can define the table mappings in the latest Cloud Migration Tool.
Please try this
Things get more complicated
when I want to deploy an extension on the promise, the allowed object ranges differ. cloud objects ranges I have done are different.
Please install the app with BGS_ in OnPrem database also and try to migrate afterwards.
Yes, Mohana,
I am aware of the issue. Please give me a solution. I
The extension that is installed in OnPrem and Cloud should be the same.
#1
André Arnaud de Cal...
294,190
Super User 2025 Season 1
#2
Martin Dráb
232,968
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
