Errors in "Transform data with UiPath Process Mining" Course

Feedback Process Mining
1

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
3

@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

4

Hey @andrew.ryba
is this resolved?

If not, can you share your Cases_input.sql file here?

5

Yes it is! Thanks for following up.

Andrew Ryba
O: 402.240.8314

6

@andrew.ryba Awesome!
May I know what was the issue?

7

I am honestly quite embarrassed to admit it. Just a absent “,”.

Andrew Ryba
O: 402.240.8314

1 Like
9

@andrew.ryba
happy to hear that you figured it out!