HTTP code: 500, Code: ERR_SQL_DB_UNREACHABLE, type: com.dataiku.dip.exceptions.CodedSQLException

cindy2000_sh
cindy2000_sh Registered Posts: 3 ✭✭✭✭

Got this error when importing data after three days of use.

How I get this error: Import your first dataset-->import existing-->choose connection to import from-->choose a connection to browse

Screen Shot 2020-06-22 at 10.07.28 AM.png

It worked in my first project three days ago. Can I fix this from my side?

Answers

  • Andrey
    Andrey Dataiker Alumni Posts: 119 ✭✭✭✭✭✭✭

    Hi @cindy2000_sh
    ,

    Can you test if your database server is running? You may also test the DB connection from the admin page, by opening Administration -> Connections -> your connection and then clicking on "Test" on the bottom of the page.

  • cindy2000_sh
    cindy2000_sh Registered Posts: 3 ✭✭✭✭

    Hi Andrey,

    In the admin page, I can only see License/Clusters/Code Envs. Is that the correct page?

  • Andrey
    Andrey Dataiker Alumni Posts: 119 ✭✭✭✭✭✭✭

    yes, it's this screen, however, you need to be logged in as admin in order to see the list of connections.

  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭

    Hi Cindy,

    Are you by any chance logged in as the admin user on your DSS instance? You seem to be logged in as a non-admin user, which explains why you are only able to see this particular pages/tabs.

    Thanks,

    Andrew

  • cindy2000_sh
    cindy2000_sh Registered Posts: 3 ✭✭✭✭

    Hi,

    I think I have found my data, thank you so much!

  • ttoropov
    ttoropov Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 8

    Good day!

    I got a similar error but in recipes module. It occurs each time I try to run a recipe.

    Unable to create directory /opt/dataiku/data/jobs/BPPROJECTTIM/Build_data_final_prepared__NP__2023-07-25T10-42-06.561

    Please see our options for getting help

    HTTP code: 500, type: java.io.IOException

    What would you recommend to do?

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,722 Neuron

    Hi. Please start a new thread. You error is different.

Setup Info
    Tags
      Help me…