[ https://issues.apache.org/jira/browse/NIFI-11519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Emilio Setiadarma reassigned NIFI-11519: ---------------------------------------- Assignee: Emilio Setiadarma > Sensitive Dynamic Properties do not work with Sensitive Parameter Values in > DBCP > -------------------------------------------------------------------------------- > > Key: NIFI-11519 > URL: https://issues.apache.org/jira/browse/NIFI-11519 > Project: Apache NiFi > Issue Type: Bug > Components: Core Framework > Affects Versions: 1.21.0 > Reporter: Andrew M. Lim > Assignee: Emilio Setiadarma > Priority: Major > > When configuring a DBCPConnectionPool controller service, I created a dynamic > property {{PWD}} and selected "Sensitive". The value from this dynamic > property should be used in the PWD connection property in the Database > Connection URL, but it causes an error in the processor that uses the > controller service (see below). > WORKAROUND: If I create a dynamic property {{SENSITIVE.PWD}} (doesn't matter > if I select "Sensitive" setting), then the error does not occur. > Error (from ExecuteSQL processor using the DBCP Connection Pool): > 16:04:12 UTCERRORef0a84d5-26f6-377a-af2c-bd9ddb098ea0 > All NodesExecuteSQL[id=ef0a84d5-26f6-377a-af2c-bd9ddb098ea0] Unable to > execute SQL select query [CREATE EXTERNAL TABLE orders25 LIKE PARQUET > 's3a://XXXXX/destination/parquet/XXXXX.parquet' > STORED AS PARQUET > LOCATION 's3a://XXXXX/destination/parquet/';] for > FlowFile[filename=XXXXX.parquet] routing to failure: > org.apache.nifi.processor.exception.ProcessException: Privileged action > failed due to: Cannot create PoolableConnectionFactory ( [JDBC](10100) > Connection Refused: [JDBC](11640) Required Connection Key(s): PWD; > [JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, > AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, > CatalogSchemaSwitch, DefaultStringColumnLength, DelegationToken, > DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, > LowerCaseResultSetColumnName, NonSSPs, OptimizedInsert, > PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, > ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, > SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, > StripCatalogName, SupportTimeOnlyTimestamp, UseCustomTypeCoercionMap, > UseNativeQuery, UseSasl) > - Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory ( > [JDBC](10100) Connection Refused: [JDBC](11640) Required Connection Key(s): > PWD; [JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, > AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, > CatalogSchemaSwitch, DefaultStringColumnLength, DelegationToken, > DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, > LowerCaseResultSetColumnName, NonSSPs, OptimizedInsert, > PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, > ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, > SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, > StripCatalogName, SupportTimeOnlyTimestamp, UseCustomTypeCoercionMap, > UseNativeQuery, UseSasl) > - Caused by: java.sql.SQLNonTransientConnectionException: [JDBC](10100) > Connection Refused: [JDBC](11640) Required Connection Key(s): PWD; > [JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, > AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, > CatalogSchemaSwitch, DefaultStringColumnLength, DelegationToken, > DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, > LowerCaseResultSetColumnName, NonSSPs, OptimizedInsert, > PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, > ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, > SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, > StripCatalogName, SupportTimeOnlyTimestamp, UseCustomTypeCoercionMap, > UseNativeQuery, UseSasl -- This message was sent by Atlassian Jira (v8.20.10#820010)