# Errors in "Transform data with UiPath Process Mining" Course **URL:** \ **Category:** Process Mining\ **Tags:** training, process-mining, academy\ **Created:** [October 3, 2024, 6:46pm UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321 "2024-10-03T18:46:43Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![andrew.ryba](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/andrew.ryba/32/496797_2.png) [@andrew.ryba](https://forum.uipath.com/u/andrew.ryba)\ **Post date:** [October 3, 2024, 6:46pm UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/1 "2024-10-03T18:46:43Z")
I am going through the training via UiPath Academy and I am working on the “Transform data with UiPath Process Mining” course. I follow the instructions, using the provided input files, however I am running into failures during the compile. I have triple checked my code to ensure it matches the instructions. Is anyone else running into this issue? 1. 01:29:44 PMRunning with dbt=1.7.17 2. 01:29:45 PMRegistered adapter: snowflake=1.7.5 3. 01:29:45 PMUnable to do partial parsing because saved manifest not found. Starting full parse. 4. 01:29:47 PM[WARNING]: Configuration paths exist in your dbt\_project.yml file which do not apply to any resources. There are 1 unused configuration paths: - tests 5. 01:29:47 PMFound 12 models, 3 seeds, 4 sources, 0 exposures, 0 metrics, 461 macros, 0 groups, 0 semantic models 6. 01:29:47 PM 7. 01:29:48 PMConcurrency: 1 threads (target=‘cloud’) 8. 01:29:48 PM 9. 01:29:48 PM1 of 6 START sql table model 5a9ddf77\_c93c\_20241003152642\_dev.Cases\_input … [RUN] 10. 01:29:49 PMFailed to convert ‘Opportunity\_raw.“Opportunity\_value”’ to a double for 4540 records. Their values are set to NULL. 11. 01:29:49 PM1 of 6 ERROR creating sql table model 5a9ddf77\_c93c\_20241003152642\_dev.Cases\_input [ERROR in 0.59s] 12. 01:29:49 PM2 of 6 SKIP relation 5a9ddf77\_c93c\_20241003152642\_dev.Cases … [SKIP] 13. 01:29:49 PM3 of 6 SKIP relation 5a9ddf77\_c93c\_20241003152642\_dev.Event\_log … [SKIP] 14. 01:29:49 PM4 of 6 SKIP relation 5a9ddf77\_c93c\_20241003152642\_dev.Due\_dates … [SKIP] 15. 01:29:49 PM5 of 6 SKIP relation 5a9ddf77\_c93c\_20241003152642\_dev.Metadata\_PrecomputedValues [SKIP] 16. 01:29:49 PM6 of 6 SKIP relation 5a9ddf77\_c93c\_20241003152642\_dev.Tags … [SKIP] 17. 01:29:49 PM 18. 01:29:49 PMFinished running 6 table models in 0 hours 0 minutes and 2.30 seconds (2.30s). 19. 01:29:49 PM 20. 01:29:49 PMCompleted with 1 error and 0 warnings: 21. 01:29:49 PM 22. 01:29:49 PM Database Error in model Cases\_input (models/1\_input/Cases\_input.sql) 001003 (42000): SQL compilation error: syntax error line 51 at position 0 unexpected ‘try\_to\_double’. syntax error line 51 at position 14 unexpected ‘to\_varchar’. syntax error line 65 at position 1 unexpected ‘as’. compiled Code at /tmp/xepggo/target/run/UiPathTemplateOne/models/1\_input/Cases\_input.sql 23. 01:29:49 PM 24. 01:29:49 PMDone. PASS=0 WARN=0 ERROR=1 SKIP=5 TOTAL=6 ---
**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\ **Post date:** [October 4, 2024, 2:33am UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/3 "2024-10-04T02:33:32Z")
@andrew.ryba As per error in the input data oppurtunity value is not double or is blank so that it is not converted…try to validate the data once Cheers ---
**Author:** ![Jyoti\_Raghav](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jyoti_raghav/32/63830_2.png) [@Jyoti\_Raghav](https://forum.uipath.com/u/Jyoti_Raghav)\ **Post date:** [October 10, 2024, 9:23am UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/4 "2024-10-10T09:23:43Z")
Hey @andrew.ryba is this resolved? If not, can you share your Cases\_input.sql file here? ---
**Author:** ![andrew.ryba](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/andrew.ryba/32/496797_2.png) [@andrew.ryba](https://forum.uipath.com/u/andrew.ryba)\ **Post date:** [October 10, 2024, 1:24pm UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/5 "2024-10-10T13:24:23Z")
Yes it is! Thanks for following up. **Andrew Ryba** O: 402.240.8314 ---
**Author:** ![Jyoti\_Raghav](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jyoti_raghav/32/63830_2.png) [@Jyoti\_Raghav](https://forum.uipath.com/u/Jyoti_Raghav)\ **Post date:** [October 10, 2024, 1:31pm UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/6 "2024-10-10T13:31:27Z")
@andrew.ryba Awesome! May I know what was the issue? ---
**Author:** ![andrew.ryba](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/andrew.ryba/32/496797_2.png) [@andrew.ryba](https://forum.uipath.com/u/andrew.ryba)\ **Post date:** [October 10, 2024, 1:55pm UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/7 "2024-10-10T13:55:48Z")
I am honestly quite embarrassed to admit it. Just a absent “,”. **Andrew Ryba** O: 402.240.8314 ---
**Author:** ![Jyoti\_Raghav](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jyoti_raghav/32/63830_2.png) [@Jyoti\_Raghav](https://forum.uipath.com/u/Jyoti_Raghav)\ **Post date:** [October 10, 2024, 3:20pm UTC](https://forum.uipath.com/t/errors-in-transform-data-with-uipath-process-mining-course/771321/9 "2024-10-10T15:20:01Z")
@andrew.ryba happy to hear that you figured it out!