Member since
01-14-2025
2
Posts
1
Kudos Received
0
Solutions
10-31-2025
04:34 AM
Hello! I have a NiFi 1.28 instance running on a Oracle Linux Server 9.6. I'm trying to connect to a Microsoft SQL Server database using a DBCPConnectionPool 1.28.1 controller, with a mssql-jdbc-13.2.1.jre11.jar driver, but I'm getting a very confusing error: Failed to establish Database Connection: java.sql.SQLException: Cannot create PoolableConnectionFactory ("encrypt" property is set to "false" and "trustServerCertificate" property is set to "true" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: Certificates do not conform to algorithm constraints. Here is what I've already tried to fix this error: - Import the self signed certificate (from the database machine) into the $JAVA_HOME truststore - change the default cypto policy with: update-crypto-policies --set DEFAULT:SHA1 - Relax the java security restrictions by going into the java.security file and commenting the jdk.certpath.disabledAlgorithms and jdk.tls.disabledAlgorithms properties - Tried accessing the database itself within the machine's terminal, which works just fine (so it is a NiFi issue) - Tried connecting with the properties encrypt=false;trustServerCertificate=true; on the connection string and all of it's 3 variations (true/true, true/false and false/false) Is this a known issue or am I missing a configuration? Any help is appreciated and I'm down to answering any questions to help solve this issue. Thank you very much.
... View more
Labels:
- Labels:
-
Apache NiFi
01-14-2025
03:12 AM
1 Kudo
Hello! I'm trying to convert float values on my flow files into integers. My Jolt Specification looks like this: [ { "operation": "modify-default-beta", "spec": { "progress": "=toInteger", "setup_value": "=toDouble", "proposed_setup_cost": "=toDouble", "real_setup_cost": "=toDouble", "invoiced_value": "=toDouble", "last_recognized_value": "=toDouble", "starting_date": ["=toDateTime", "yyyy-MM-dd HH:mm:ss", "coerceOrNull"], "last_progress_change": ["=toDateTime", "yyyy-MM-dd HH:mm:ss", "coerceOrNull"], "end_date": ["=toDateTime", "yyyy-MM-dd HH:mm:ss", "coerceOrNull"] } } ] But somehow my "progress" value is still being outputted like a float. If I have the value 100.0, it is not transformed to 100, for example. I also tried using "=toInteger(@(1,value))", but that also didn't worked.
... View more
Labels:
- Labels:
-
Apache NiFi