DSS Tutorial Creation Error

Solved!
max1mus
Level 1
Level 1
DSS Tutorial Creation Error

Hi, 

I think this is the place I can look for answer. 

I have been having issue with creating Dataiku DSS (SQL Based tutorial). I thought it was with our PostgreSQL. But we can create connection with no problem and can interact with the DB. 
However, when it comes to downloading Dataiku DSS tutorial courses, it gives the following error. Not only this tutorial, but all SQL based tutorials. 

Has anyone experienced this before? Stuck on the Advanced course because of this. 

Any help is greatly appreciated. 

Best,

Max

 

{
  "usedProjectKey":"DKU_TUT_VIZ102_FORMULA",
  "neededAMigration":false,
  "usedConnections":[
     
  ],
  "messages":[
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_copy (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_copy (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset cardholder_info_copy (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset cardholder_info_copy (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset purchase_amount_ranked (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset purchase_amount_ranked (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_dimensions_filtered (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_dimensions_filtered (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_lag (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_lag (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset income_per_tract_usa_copy (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset income_per_tract_usa_copy (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset merchant_info_copy (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset merchant_info_copy (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_windows (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_windows (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_joined (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_joined (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_known_prepared (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_known_prepared (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset merchants_by_state (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset merchants_by_state (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_analyze_windows (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_analyze_windows (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_joined_prepared (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_joined_prepared (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_cumulative_sums (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_cumulative_sums (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_unknown_scored (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_unknown_scored (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_known (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_known (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_moving_average (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_moving_average (not remapped): postgresql (PostgreSQL)"
     },
     {
        "severity":"ERROR",
        "isFatal":true,
        "code":"ERR_BUNDLE_ACTIVATE_MISSING_CONNECTION",
        "title":"Missing connection",
        "details":"Connection missing for dataset transactions_unknown (not remapped): postgresql (PostgreSQL)",
        "message":"Missing connection: Connection missing for dataset transactions_unknown (not remapped): postgresql (PostgreSQL)"
     }
  ],
  "maxSeverity":"ERROR",
  "anyMessage":true,
  "success":false,
  "\"warni"

 

0 Kudos
1 Solution
SeanA
Dataiker
Dataiker

Hi @max1mus ,

Sorry that we didn't see this message earlier.

To confirm, are the projects failing on import when you go to "+New Project > DSS Tutorials > Advanced Designer > [some SQL-based project]"?

Currently, we have a problem with the remapping dialogue when creating a project this way.

You can download any project from the downloads site: https://cdn.downloads.dataiku.com/public/dss-samples/

Then you should be able to import the zip file normally. During import, you will be asked to remap the SQL connection in the project to your local one.

Another alternative is to use the file-based projects for now. You could even change the connection to SQL once you have the projects created if you wanted to.

Hope this helps!

Dataiku

View solution in original post

0 Kudos
2 Replies
SeanA
Dataiker
Dataiker

Hi @max1mus ,

Sorry that we didn't see this message earlier.

To confirm, are the projects failing on import when you go to "+New Project > DSS Tutorials > Advanced Designer > [some SQL-based project]"?

Currently, we have a problem with the remapping dialogue when creating a project this way.

You can download any project from the downloads site: https://cdn.downloads.dataiku.com/public/dss-samples/

Then you should be able to import the zip file normally. During import, you will be asked to remap the SQL connection in the project to your local one.

Another alternative is to use the file-based projects for now. You could even change the connection to SQL once you have the projects created if you wanted to.

Hope this helps!

Dataiku

View solution in original post

0 Kudos
max1mus
Level 1
Level 1
Author

Hi @SeanA 

Thank you for your reply. 

Yes, it was with "+New Project > DSS Tutorials > Advanced Designer > [some SQL-based project]". 

It seems we can work on it by downloading the project.

Since it doesn't have any issue with connecting to the DB, I don't think it poses significant issue here.

Again, thank you for your reply. 

Best,

Max

0 Kudos