Transform Map\Import Set Issue - Istanbul

[jonathan_77]

We are currently in the process of upgrading from Fuji to Istanbul and we are having some trouble with some Transform Maps.   We currently have a set of remote file imports\transform maps that run at different times throughout the day.   For some reason, in Istanbul, I cannot get the Transform Maps to work correctly.   When you open one of the Transform Maps in question and click Transform, under related links, you get the following message: "No import set available.   Create and load an import set first."   We do have an import set available so I've tried completing this step, filling in the information to add/create an existing import set table, uploading the file manually and it works as it should.   However it only works for that one time and will not retain the Import Set information.   This process has been working fine for around two years in Fuji.   Has anyone else ran into any similar issues?

[Sashi K1 · Accepted solution]

Hi

I would recommend to clean import sets prior using in upgraded instances.

Under Import Set Module, use Clean up to select import sets (or all) to remove all data. Don't remove transform maps

Once done, use your background scripts to clear system cache

gs.invalidateCache();

run above from your background scripts. Still not solved, for upgrade issues always best bet is Hi ticket.

[vinothkumar]

Hi Sashi,

We recently upgraded to Jakarta and I have been facing the same issue in one of our instance [ Though our DEV and TEST are in the same version, I am facing this issue only in our TEST instance] and did the steps that you have provided and still showing the message as follows. You have any idea, what went wrong?

Even I created a new data source and transform map field, there also am facing the same issue. Could you please help me on this?

[Sashi K1]

Hi Vinoth

Import Sets are volatile. If you have executed all clean up steps prior using them, then continue with following steps.

1. Don't run Transform map or schedule to run first.

2. Open one of Data Source that has above problem.

3. See the Import Set name from Data Source. You would find Import Set Label and Import Set Name.

4. Copy Import Set name, open a separate tab, paste <copied value.list> in left navigator and enter. Eg: imp_load_data.list

5. You must see a table structure with or without data. If you don't see any list view then go back to your previous tab as explained in Step 2.

6. Now click 'Test Load 20 Records' under Related Link

7. This should make a Test call to create Import Set Structure first and then load 20 records.

8. Run Transform after this.

If per step 5, you see import set table list view with or without data, then I would create a Hi ticket as upgrade issue.

Remember, clean up to be done after post upgrade. This should mostly resolves the problem

[vinothkumar]

Thank you very much Sashikanth for you reply. However still not working, we are planning to clone our instance and I will check after clone, if still not raise an Hi Ticket.