Data Source Error

オフライン

Hello

I changed Part ItemType data type from Item to String for Product Code and I tried to change it back but I got an error stating "Some Part item still use the old data source for the product_code property? Does anyone know how to resolve this issue? Thank you very much in advance for any feedback.

Regards,

Jakk

Parents
  • Hi Jakk

    There should be some part which already has some data for Product code property (when the data type is Item). When it is changed to string, the connection to data source is almost lost but still it is pointing to the ID of the data source.

    If you want to keep the product code data, then you need to store this data somewhere and remediate. If you don't have any issue in losing this data then you can do below steps

    (THIS STEP WILL LOSE THE DATA IN PRODUCT CODE FIELD IN PART)

    Step 1: Check total count

    SELECT COUNT(*) from innovator.PART where PRODUCT_CODE IS NOT NULL 

    Step 1: Empty Product Code Field in Database (Run this SQL in SSMS) - Test in lower environment

    UPDATE innovator.PART
    SET PRODUCT_CODE = NULL
    WHERE PRODUCT_CODE IS NOT NULL

    Step 2: Revert the change in item type. 

    Open Part item type and change the data type and save

    Also ensure that Data type of Product code is changed in Part form from String to Item.

    Thank You

    Gopikrishnan R

  • オフライン in reply to Gopikrishnan

    Hello Gopikrishnan,

    I fixed the issue now. Thank you so much for your help, sir.

    Regards,

    Jakk

Reply Children
No Data