B95krk / MDM

1 stars 0 forks source link

Unable to import the file (successful in transform step, but not in load step). #18

Closed B95krk closed 2 months ago

B95krk commented 2 months ago

https://docs.google.com/spreadsheets/d/1x2b_bQHZRBpHTRdgi3mHUx2MwvkU99JL/edit?gid=1537908390#gid=1537908390

B95krk commented 2 months ago

LW:19/08/2024: (1)This is not a defect. There might be an issue with CSV file's Data.Click On Errors from Load Phase, download CSV file which has the error description to find the error. Also, 1.User only able to do file import for updating an existing record 2.User only able to update the value which are marked as editable.(E.g, Material Group Name was not provided with Editable in DD)

Ging: 20-Aug-24: LW to provide a list of attributes that need to be changed as editable fields. LW:20/08/2024: As per DD's CDE elements column M.Will discuss internally and gt back on this Ging: 20-Aug-24: Sent email rgd this issue. LW:20/08/2024: As per request LW acknowledged and applied the edit access for attributes Note: As we discussed earlier, We are not recommending to do file import for updating particular values of a record. Becasue when user try to update particular values, rest of other values will be deleted. We are recommending users to do update using UI instead of doing it using file import to avoid data lose. Refer sheet 17. LW:21/08/2024: LW working on it to find a solution for Authorization Error.

(2) Ging: 21/08/2024 (added PTG's expectations and request for LW to support) File Import Process for Update Actions Issues: PTG can't and are unable to prepare the file with all fields included.

Supporting Reasons:

  1. Users are unable to prepare files with all attributes when they only need to update specific fields.

  2. A single domain can have multiple records in some attribute groups, making file preparation challenging. For example, if one plant has 20 SLOCs, to update the name of this plant, the user must prepare 20 records with different SLOCs (as per the current data) but with the same new name for all 20 records. This is not best practice and is risky for them. LW:22-08-2024: I understood, but unfortunately it was tool's default funtionality

  3. They need the file import feature to be available because sometimes they want to update information for a large number of PKs. Doing this one by one manually via the MDM UI is not effective.

LW:21/08/2024: For updating large num of PKs, we are having incremental load PTG can utilise this.

LW:21/08/2024: Case raised with informatica . Case num for your reference 04707866. Will update here once received any update from informatica. LW:21/08/2024: (1) File import authorization error was solved now. User Can retest the File import Process.(RCA - While trying to update some values, rest of attributes values are being deleted from UI. So, the user needs to be assigned with delete privilege.After assigning delete access for attribute level, the error was solved) (2) Currenlty the request not possible informatica confirmed the same. Please refer sheet num 17. This feature was under enhancement now.

Ging:22/08/2024 (1) Retested, material file import process was successful. (2) Since this feature (to prepare a file with only CDE attributes and the attributes they want to update) is a high priority for PTG working team, for the reason mentioned above, could we request an ETA for the Informatica enhancement?

LW:22-08-2024: Regarding ETA, There is no ETA for this enhancement. I added the same comment from informatica in sheet 17. Last Screenshot.

Ging: 22/08/2024: Expectedly, Informatica will enhance MDM to support this request. (enhancement no. MDMN-126603) Next Action:

  1. LW to ask Informatica how PTG can track the enhancement progress directly. LW:22-08-2024: Case was created 04708607 and received solution from INFA. Added that in Sheet 17
  2. LW to prepare manual document, how PTG user prepare a file with all attributes of the domain. LW:22-08-2024: https://docs.google.com/presentation/d/1pZpdNi4D5xhdhjyjsLUuPFvDdQkEs7ml/edit#slide=id.p31