change data type

Question

When i run the workflow in my local computer, it is suceefully with no bug. But when i use same XML file as input and run same workflow in the server, it has bug and because one of column of output change type to string automatually. So when the output connect to database, it appears bug. Could someone explain to me or face same problem before?

Thank you for your reading.

digitalmemo · Answer

In addition to @ArtApa try using Auto Field tool as well.

ArtApa · Answer

Hi @haoyu1227 - It's difficult to troubleshoot without your data and workflow. However, please try adding a Select tool with the following setting:

It will make sure that your output field is in the right format.