trying to use Secrets in Knime Hub. The workflow is running when run in local but when called from other system via API, I keep getting this:

{
“id”: “7a53c364-8054-43f6-be5a-626393df6857”,
“createdAt”: “2025-04-02T20:53:03.778Z[GMT]”,
“name”: “Export2dApi_v1.1 2025-04-02 20.53.03”,
“creator”: “account:user:8934e524-249a-4bb4-a8db-6ecb1882d80e”,
“state”: “EXECUTION_FAILED”,
“jobState”: “LOADED”,
“workflowState”: “EXECUTION_FAILED”,
“startedExecutionAt”: “2025-04-02T20:53:36.836436Z[Etc/UTC]”,
“finishedExecutionAt”: “2025-04-02T20:53:38.854926Z[Etc/UTC]”,
“deploymentId”: “rest:51b718d2-87ce-4599-9408-b7a52a97fd80”,
“nodeMessages”: [
{
“node”: “KNIME Hub Authenticator 3:40”,
“messageType”: “WARNING”,
“message”: “KNIME Hub connection no longer available. Please re-execute the node.”,
“jobId”: null
},
{
“node”: “Secrets Retriever 3:38”,
“messageType”: “WARNING”,
“message”: “Secrets no longer available. Please re-execute the node.”,
“jobId”: null
},
{
“node”: “DB Connector 3:9”,
“messageType”: “ERROR”,
“message”: “Execute failed: ORA-01005: null password given; logon denied\n”,
“jobId”: null
},
{
“node”: “DB Connector 3:15”,
“messageType”: “ERROR”,
“message”: “Execute failed: ORA-01005: null password given; logon denied\n”,
“jobId”: null
}
],
“scope”: “account:team:b76cb10c-2693-49e8-8843-ea706dc57233”,
“creatorName”: “rsen-c”,
“isSwapped”: false,
“hasReport”: false,
“workflow”: “/Users/SONAR - Development/dev/Export2dApi”,
“workflowId”: “*X6ithu9j0cmy0FKQ”,
“spaceVersion”: “13”,
“itemVersion”: “13”,
“createdVia”: “generic client”,
“executorID”: “bd330a7f-f56b-425d-a9cd-30ea9c9594ec@executor-11def822-6d02-4dea-9e7a-18e0b70fb7db-bd330a7f-f56b-425”,
“executorName”: “executor-11def822-6d02-4dea-9e7a-18e0b70fb7db-bd330a7f-f56b-425”,
“executionContext”: “11def822-6d02-4dea-9e7a-18e0b70fb7db”,
“discardAfterSuccessfulExec”: false,
“discardAfterFailedExec”: false,
“errors”: ,
“configuration”: {},
“actions”: ,
“inputParameters”: {
“json-input”: {
“config”: “EXPORT_CONFIG_2D”,
“environment”: “tst”,
“experimentId”: 188477,
“protocolName”: “Hybridization ELISA Detection”,
“experimentUsername”: “rsen”
}
},
“outputValues”: {
“json-output”: {
“status”: “success”,
“response_code”: 200,
“message”: “Successfully exported 2D plate format for protocol Hybridization ELISA Detection”,
“dotmatics_file_location”: {
“Uploaded files”: [
“C:/Program Files/Apache Software Foundation/Tomcat 8.5/webapps/browser/tempfiles\multipart-5AD4ZPNU\0\output_188176_Hybridization_ELISA_Detection_20250306T094406.xlsx”
]
},
“download_url”: “https://dotmatics-dev.wavelifesciences.com/browser/tempfiles//multipart-5AD4ZPNU/0/output_188176_Hybridization_ELISA_Detection_20250306T094406.xlsx”,
“experiment_id”: 188176,
“protocol_name”: “Hybridization ELISA Detection”,
“table_name”: “ELISA_METADATA”,
“config_name”: “EXPORT_CONFIG_2D”,
“timestamp”: “2025-03-06T09:44:07.229464”,
“plate_dimensions”: “12x8”,
“value_columns_processed”: [
“ANIMAL_NAME”,
“ANIMAL_SAMPLE_ID”,
“ASSOCIATED_STANDARD”,
“CAPTURE_PROBE”,
“CHOOSE”,
“COHORT”,
“COMPLEX_SAMPLE_ID”,
“DETECTION_PROBE”,
“DOSE”,
“DOSE_VOLUME”,
“DOSING_REGIMEN”,
“LINE”,
“PLATE_NAME”,
“STUDY_ID”,
“TEST_ARTICLE”,
“TISSUE_SUBTYPE”,
“TISSUE_TYPE”,
“WELL_TYPE”,
“CONCENTRATION”,
“LYSATE_CONCENTRATION”,
“PLATE_ID”,
“SAMPLE_HARVEST_TIME_POINT”,
“WELL_NUMBER”
],
“plate_ids_processed”: [
“1.0”,
“2.0”
]
}
}
}

Hmm. Not a lot to go by (at least for me just looking at the dump is difficult).

Maybe you can share some more insights on:

  • Are you accessing a Personal or a Team Secret?
  • If you ad-hoc execute on Hub, does it work?
  • When uploading to Hub, did you check “Reset Workflow before Upload”?
1 Like

Let me answer it one by one:

  • It is a Team Secret
  • Yes, when I execute it ad-hoc, it works most times unless the Platform has lost connectivity to Hub. In the scenario when the platform does not have connection to the required Knime Hub then I just need to use the Space Explorer and connect to the Knime Hub, then it all works again.
  • Yes, I did check the “Reset Workflow before Upload”

Kindly let me know if you have any more questions.

So this sounds like you are running it from your Desktop when connected to the Hub.

What happens if you upload your workflow to the Hub and then Execute it from the Web User Interface - e.g. when clicking this button: