TIMEZONE mismatch between ERP and IDM

[former_member431321]

Hi IDM Exports,

The Standard Timezone format between ERP and IDM is mismatching.

I got Timezone error when initial load job / WriteABAPUsers pass as follows.

The ERP uses UTP+9 format as follows

but IDM uses UTC9 format as follows.

So IDM can not create a user with UTC+9 value.

How should I fix this issue?

Thanks in Advance.

dongsu

[former_member85790 · Accepted solution]

Hi Dongsu,

Have you executed the Read Help Values jobs for your ABAP repositories? In recent versions this job has a pass to read the TimeZone values from table TTZZT.

I can't say exactly when this was introduced, but it would have been in between SP03 and SP06 (IDM8).

Kind regards,
Adam

[former_member431321 · Accepted solution]

Hi Adam,

I run Read Help Values job and there was no error at all.

I am in SP4 currently. We will go to SP6 for production.

If it is solved in SP6, we will be happy.

I will check release notes of SP5 and SP6.

Bytheway, is there any work around?

Thank you very much.

Dongsu

[former_member201064]

The value you want to set is UTC+9 but the key in your table is UTC9. You probably need to switch the description and key. I'd do it with a DB update query I guess.

[former_member431321]

Hi Dominik,

For temporary fix, I added a entry in mxi_AttrValueHelp table in MXMC_db as follow;

After this action, there is no error in InitialLoad job.

regards,

dongsu