Import set: ISET0010557 transform stopped due to error: Illegal pattern character 'Y'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-02-2016 08:00 AM
Receiving this error after manual importing of Excel file and running transformation. I researched, but have not found a clear enough answer to understand the error to debug. Please help if you can.
Thanks, Norm
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-02-2016 08:22 AM
My initial guess is that you are importing a column that has Y/N in the Excel file, but ServiceNow is expecting True/False. It is hard to say much else without being able to see the actual data being imported. Something in the Excel file can't be translated into the proper data format in ServiceNow, so you might just look through the file and see if there are any "Y"s in fields that are expecting True/False values or number values.
-Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-02-2016 10:23 AM
Hi Norm,
illegal pattern 'Y' is java error and is related to date formats. "Y" represents Year. Make sure the date preference system properties in ServiceNow match your file and match the transform. System Properties > System > Date.
Best,
Tone
