Qlik Talend Data Preparation: Unable to import CSV files into Datasets with wrong client_secret

wei_guo · Aug 19, 2025 10:53:10 PM

You may encounter this error that unable to import csv files into Talend Data Preparation Datasets which gives Import Error and the oauth authenticaiton failed message.

Log

2025-08-13 14:04:21.403 ERROR [user ] 1678370 --- [nio-9999-exec-3] o.t.d.exception.TDPExceptionController : An error occurred. Error : org.talend.dataprep.exception.TDPExceptionFlowControl: Sorry, an unexpected error occurred and we could not complete your last operation. You can continue to use Data Preparation | Context : {}
2025-08-13 14:04:21.416 ERROR [user ] 1678370 --- [nio-9999-exec-5] o.t.d.exception.TDPExceptionController : An error occurred : {cause=null}

org.talend.dataprep.exception.TDPException: 500 Internal Server Error from GET http://1.2.3.4:9999/datasets/9d69c531-b630-4c5e-b2ca-b9cb73f7910d/content
    at org.talend.dataprep.processor.ExceptionsConfiguration$ExceptionsConversions.lambda$doWith$1(ExceptionsConfiguration.java:109)
    at org.talend.dataprep.conversions.BeanConversionService.convert(BeanConversionService.java:189)
    at org.talend.dataprep.command.GenericCommand$ErrorHandler.getTDPExceptionFromDTO(GenericCommand.java:546)
    at org.talend.dataprep.command.GenericCommand$ErrorHandler.apply(GenericCommand.java:519)
    at org.talend.dataprep.command.GenericCommand$ErrorHandler.apply(GenericCommand.java:495)
    at org.talend.dataprep.command.GenericCommand.executeCall(GenericCommand.java:253)
    at org.talend.dataprep.command.GenericCommand.execute(GenericCommand.java:265)
    at org.talend.dataprep.dataset.adapter.DataInventoryClient.getDataSetContent(DataInventoryClient.java:263)
2025-08-13 14:04:38.385 ERROR [user ] 1678370 --- [nio-9999-exec-4] o.t.d.exception.TDPExceptionController : An error occurred. Error : org.talend.dataprep.exception.TDPExceptionFlowControl: ACL_NOT_FOUND.MESSAGE | Context : {entityId=689c39066827013844aa11d1}
2025-08-13 14:04:38.393 WARN [user ] 1678370 --- [or-http-epoll-8] o.t.dataprep.sharing.SharingWebClient : Sharing client error with : 404 Not Found from GET http://1.2.3.4:9999/sharing/v1/sharingset/preparation_folder/689c39066827013844aa11d1
2025-08-13 14:04:38.621 WARN [user ] 1678370 --- [nio-9999-exec-2] o.t.d.cache.MultiTenantKeyGenerator : No Current tenant in the context we can't add the tenantId into the cache key
2025-08-13 14:04:38.991 ERROR [user ] 1678370 --- [io-9999-exec-10] o.t.d.exception.TDPExceptionController : An error occurred. Error : org.talend.dataprep.exception.TDPExceptionFlowControl: ACL_NOT_FOUND.MESSAGE | Context : {entityId=689c39066827013844aa11d1}
2025-08-13 14:04:38.993 WARN [user ] 1678370 --- [or-http-epoll-8] o.t.dataprep.sharing.SharingWebClient : Sharing client error with : 404 Not Found from GET http://1.2.3.4:9999/sharing/v1/sharingset/preparation_folder/689c39066827013844aa11d1
2025-08-13 14:04:39.826 WARN [user ] 1678370 --- [nio-9999-exec-1] o.t.d.cache.MultiTenantKeyGenerator : No Current tenant in the context we can't add the tenantId into the cache key

2025-08-13 14:05:00.316 ERROR [user ] 1678370 --- [nio-9999-exec-4] o.t.d.exception.TDPExceptionController : An error occurred. Error : org.talend.dataprep.exception.TDPExceptionFlowControl: ACL_NOT_FOUND.MESSAGE | Context : {entityId=3168a305-05d1-41ee-9c9e-b43f18c49c96}
2025-08-13 14:05:00.319 WARN [user ] 1678370 --- [or-http-epoll-9] o.t.dataprep.sharing.SharingWebClient : Sharing client error with : 404 Not Found from GET http://1.2.3.4:9999/sharing/v1/sharingset/dataset/3168a305-05d1-41ee-9c9e-b43f18c49c96
2025-08-13 14:05:00.513 ERROR [user ] 1678370 --- [io-9999-exec-10] o.t.d.exception.TDPExceptionController : An error occurred. Error : org.talend.dataprep.exception.TDPExceptionFlowControl: ACL_NOT_FOUND.MESSAGE | Context : {entityId=3168a305-05d1-41ee-9c9e-b43f18c49c96}
2025-08-13 14:05:00.516 WARN [user ] 1678370 --- [or-http-epoll-9] o.t.dataprep.sharing.SharingWebClient : Sharing client error with : 404 Not Found from GET http://1.2.3.4:9999/sharing/v1/sharingset/dataset/3168a305-05d1-41ee-9c9e-b43f18c49c96
2025-08-13 14:05:01.684 ERROR [user ] 1678370 --- [nio-9999-exec-6] o.t.d.d.s.a.synchronous.SchemaAnalysis : Unable to analyse schema for dataset 3168a305-05d1-41ee-9c9e-b43f18c49c96.
org.springframework.web.client.HttpClientErrorException$Unauthorized: 401 on GET request for "http://localhost:8187/artifacts/t_default/lastVersion": "{"status":401,"title":"Unauthorized"}"
    at org.talend.tsd.maven.publisher.controller.ApiClient.invokeAPI(ApiClient.java:579)
    at org.talend.tsd.maven.publisher.controller.api.ArtifactsApi.lastVersionWithHttpInfo(ArtifactsApi.java:95)
    at org.talend.tsd.maven.publisher.controller.api.ArtifactsApi.lastVersion(ArtifactsApi.java:57)
    at org.talend.tsd.dictionary.provider.service.IndexVersionsCache.getLastVersionFromProducer(IndexVersionsCache.java:43)
2025-08-13 14:05:01.701 ERROR [user ] 1678370 --- [nio-9999-exec-6] o.t.d.exception.TDPExceptionController : An error occurred : {}
org.talend.dataprep.exception.TDPException: Sorry, an unexpected error occurred and we could not complete your last operation. You can continue to use Data Preparation
    at org.talend.dataprep.exception.TDPException.rethrowOrWrap(TDPException.java:63)
    at org.talend.dataprep.dataset.service.analysis.synchronous.SchemaAnalysis.analyze(SchemaAnalysis.java:109)
    at org.talend.dataprep.dataset.service.BaseDataSetService.analyzeDataSet(BaseDataSetService.java:112)
    at org.talend.dataprep.dataset.service.DataSetService.create(DataSetService.java:443)
Caused by: org.springframework.web.client.HttpClientErrorException$Unauthorized: 401 on GET request for "http://localhost:8187/artifacts/t_default/lastVersion": "{"status":401,"title":"Unauthorized"}"
    at org.talend.tsd.maven.publisher.controller.ApiClient.invokeAPI(ApiClient.java:579)
    at org.talend.tsd.maven.publisher.controller.api.ArtifactsApi.lastVersionWithHttpInfo(ArtifactsApi.java:95)
    at org.talend.tsd.maven.publisher.controller.api.ArtifactsApi.lastVersion(ArtifactsApi.java:57)
    at org.talend.tsd.dictionary.provider.service.IndexVersionsCache.getLastVersionFromProducer(IndexVersionsCache.java:43)
    at org.talend.tsd.dictionary.provider.service.DictionaryProviderFacade.getBy(DictionaryProviderFacade.java:17)
    at org.talend.dataprep.configuration.ExtendedDictionarySnapshotProviderImpl$ExtendedDictionarySnapshotImpl.<init>(ExtendedDictionarySnapshotProviderImpl.java:58)
    at org.talend.dataprep.configuration.ExtendedDictionarySnapshotProviderImpl.get(ExtendedDictionarySnapshotProviderImpl.java:47)
    at org.talend.dataprep.dataset.service.analysis.synchronous.SchemaAnalysis.analyze(SchemaAnalysis.java:84)
2025-08-13 14:05:01.711 ERROR [user ] 1678370 --- [or-http-epoll-8] o.t.d.d.adapter.DataInventoryClient : Error when create dataSet Purview_ApplicationService-sample from content
org.springframework.web.reactive.function.client.WebClientResponseException$InternalServerError: 500 Internal Server Error from POST http://1.2.3.4:9999/dataset/v1/datasets/
    at org.springframework.web.reactive.function.client.WebClientResponseException.create(WebClientResponseException.java:332)
    Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException:
Error has been observed at the following site(s):
    *__checkpoint ⇢ 500 INTERNAL_SERVER_ERROR from POST http://1.2.3.4:9999/dataset/v1/datasets/ [DefaultWebClient]
Original Stack Trace:
2025-08-13 14:05:01.716 ERROR [user ] 1678370 --- [nio-9999-exec-3] o.t.d.exception.TDPExceptionController : An error occurred : {}
org.talend.dataprep.exception.TDPException: An error has occurred during the import.
    at org.talend.dataprep.dataset.adapter.DataInventoryClient.lambda$createDatasetFromContent$4(DataInventoryClient.java:292)
    Suppressed: [CIRCULAR REFERENCE: org.springframework.web.reactive.function.client.WebClientResponseException$InternalServerError: 500 Internal Server Error from POST http://1.2.3.4:9999/dataset/v1/datasets/]
Caused by: org.springframework.web.reactive.function.client.WebClientResponseException$InternalServerError: 500 Internal Server Error from POST http://1.2.3.4:9999/dataset/v1/datasets/
    at org.springframework.web.reactive.function.client.WebClientResponseException.create(WebClientResponseException.java:332)
    Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException:
Error has been observed at the following site(s):
    *__checkpoint ⇢ 500 INTERNAL_SERVER_ERROR from POST http://1.2.3.4:9999/dataset/v1/datasets/ [DefaultWebClient]

Oauth Authenticaiton Failed

org.springframework.web.client.HttpClientErrorException$Unauthorized: 401 on GET request for "http://localhost:8187/artifacts/t_default/lastVersion": "{"status":401,"title":"Unauthorized"}"

Resolution

Revise the client_secret value in iam/config/clients/dqdict-client.json with the correct value from oidc.semanticservice.secret in dq_dict/config/data-quality.properties
```
oidc.semanticservice.secret=5yjRGCv-f5e15374fae358e1-Lp3Q
```
Restart IAM Server to take affect the change

Cause

Since Talend Data Preparation is connected with dq-dict service per schema analysis module, this issue is caused by DQ-Dictionary-IAM-setting and iam/config/clients/dqdict-client.json is configured improperly with wrong client_secret

{"client_name" : "DQ Dict API Server", "application_type" : "web", "client_id" : "FqtrjyZu7hTsoQ", "client_secret" : "/5TG+15LvXy7DE49z+UdmSPdBhwVBUt8ptVSF2m0Dx5YN4+81PUjfBTv90TG4OSZezR98o5L/byb", "grant_types" : [ "password", "authorization_code" ] }

which is not aligned with the oidc.semanticservice.secret in dq_dict/config/data-quality.properties

oidc.semanticservice.secret=5yjRGCv-f5e15374fae358e1-Lp3Q

Environment

# Qlik Talend Data Preparation
Talend Data Integration

Qlik Talend Data Preparation: Unable to import CSV files into Datasets with wrong client_secret