"Import Set not Created, invalid target table" with CSV File

Brizky · ‎08-21-2023

Hello, folks.

I'm wondering if anyone can explain to me why I'm getting this error. I've created a data source for an import. I've also created a transform map. When I try to execute the import, I get an error that my target table is invalid. But what's confusing is that the "target" table specified in the error is actually the SOURCE table that I assumed would be the STAGING TABLE. And my target table is actually the User table in ServiceNow.

The CSV file I'm using for this import is stored on a share.

Now, I thought that ServiceNow was supposed to create the staging table itself and you just tell it what the name of the table should be. So the fact that the staging table is 1.) invalid and 2.) listed as the target table makes no sense to me.

Initially, I thought that the staging table WAS the target at some point, with the CSV file being the source. And maybe ServiceNow couldn't get to the share to populate the staging table so that IT would then be the source. but if that were the case, shouldn't ServiceNow say something like "couldn't access the file" or something?

Harsh Vardhan · ‎08-21-2023

Field mapping will work once the column would get created in staging table else you wont find.

Add attachment on data source
Load 20 records so you can validate those data is coming into staging table or not.
Start field mapping because you have data in staging table with attributes which you wanna map with user table.
after mapping load all records to test if it does any magic on user record .

Hope it will help you.

Thanks,

Harsh

View solution in original post

Brizky · ‎08-21-2023

Looks like that didn't work. And now I'm a bit more confused. Not sure what the attachment is for is ServiceNow doesn't use it to learn about the field names in the file.

Still seems like the staging table that should be created has no fields.

So, I guess that's enough ServiceNow for today. 😅 I'll try to come back at it strong tomorrow. Eight hours is enough. Thank you for that suggestion.

SwarnadeepNandy · ‎08-21-2023

Hello @Brizky,

Is it possible there are multiple transform maps, which got associated with the same data source?

Maybe You can check in the transform map table with target table = u_enchilada_allactivepois. It could be possible that another transform map is interfering.

Kind Regards,

Swarnadeep Nandy

Brizky · ‎08-21-2023

Thanks for your response. So I checked that at your suggestion. And there are no target tables in the transform map table that points to u_enchilada_allactivepois. Just the User table, as I would expect. That's part of the reason why I think the error I'm getting is misleading.

fayza Atibi · ‎08-31-2023

Hi , did you get the solution to this issue ?