Add Product ; Error: Fail to retrieve record from external db, please check connection string or data [LN Interface_GetPartSql]
Creation date: 5/6/2025 10:42 PM
Updated: 11/27/2025 12:46 AM
1. Error message: Fail to retrieve record from external db, please check connection string or data as figure below
2. If user saw this error message, user had to make sure these information in LN is correct and existed.
- BOM
- Customer Code (can refer to this https://mtrac.jitbit.com/helpdesk/KB/View/70107585-error-customer-code-0-does-not-exist-in-the-database)
- Product Number (Customer)
For Support:
item_master
select * from tcibd150 with(nolock) where item = ' 3061370'
item
select * from tcibd001 with(nolock) where item = ' 3061370'
DataImage61.jpg