After I rename id to shp_id I get the following attribute mapping:

When I run this workbench I get a geopackage with the id attribute and without the shp_id attribute. The id attribute is filled with Null values since no attributes are mapped to it. You can check this by clicking on the attribute dropdown arrow on the writer.

Simplest fix is to go to the "User Attributes" tab on your geopackage writer and to change the mapping to Automatic. It will automatically add the new shp_id attribute with correct values.

However, even though the writer doesn't show an id field anymore, it will still create the id field with simple incrementing integer values, I think it does this because the geopackage format requires a field named "id".

Another fix is to change the attribute type of id from mediumint to int. This is better if you want to keep manual control over the attributes on the writer.

Tested on Workbench version 2022.2.2

Also, in the future it would be better to ask questions like this about file transformations under the topic transformation. Under new to FME you might not get the attention of the right people.

Thanks for your suggestion.

But we are using dynamic mode for conversion. And we are using FME server

You mean version 2022.2.2 can't find the error message.

Let me try 2022.2.2

The attached is log and testing data

Here is the testing dataset