Hi Community,
I have come across a weird issue. I am working on use case to import data from MySQL to ServiceNow using a JDBC data source. I have created 5 data sources (one for each table of MySQL). The next step is to map all the loaded data into one custom table. I have done that and using the data available in custom table I started creating reports. After creating 3 reports, for one of the report, I had an issue with the data present in table. I made a change in type of field from String to reference. And I deleted existing records available in custom table and clicked on reprocess related link below import sets. And tried to re-transform the data. But it got paused on Transform map UI. And then deleted the Import sets and tried to reload the data from data source. Then I got the error like this.
And I had created a fix script for the same use case. Once I clicked on run in background and opened progress checker. It shows error like this.
And I tried to delete existing data sources and transform maps and started created them from scratch. And tried by loading the data from data source and am still facing the same issue.
Is this any kind of performance issue or any transaction issue. If any one of you came across with this kind of issue. Could you please help me resolve this issue?
Thanks,
Mani
