Member since 
    
	
		
		
		03-29-2023
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                53
            
            
                Posts
            
        
                32
            
            
                Kudos Received
            
        
                3
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 2176 | 04-05-2024 12:26 PM | |
| 3026 | 03-05-2024 10:53 AM | |
| 18292 | 04-03-2023 12:57 AM | 
			
    
	
		
		
		03-02-2024
	
		
		06:44 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Thank you very much @SAMSAL . Do we need to provide the  JsonPath expressions ? I had simplifed data using JOLT Spec so I am getting flat JSON so below has worked.  What about if we have structured data ?   Another Question: what if I wanted to write the calculation on column rather than filed.value ? something like below ?           
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-02-2024
	
		
		04:16 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Hello Team,         I have one column and did some calculation on it and wanted to make another copy of same column to create flag to check whether records are empty or not and retain the same column also.I tired to using pulling another processor and  wrote calculation New_field , Old_column which did not work.      However, this approach did not yield the desired outcome.                      
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache NiFi
 
			
    
	
		
		
		02-29-2024
	
		
		12:58 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Thank you @SAMSAL , I tried using JOLT, but when it didn't work, I resorted to using the UpdateRecords process. However, this is ultimately what I need. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-28-2024
	
		
		09:30 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello Team,  I have JSON like following  [  {  "INTEGRATION_ID": "1",  "ISSUE_STATUS_CAT": "Done",  "SPRINT_LIST": [  "24-w1-2",  "24-w1-3",  "24-w1-4"  ]  },{  "INTEGRATION_ID": "2",  "ISSUE_STATUS_CAT": "Done",  "SPRINT_LIST": "24-w1-2"  }  ]  My requirement is to check whether SPRINT_LIST is array or not. so I am using UpdateRecord processor with following formula   ${field.value:startsWith(" [ ")}  I was getting the correct output earlier, where it returned 'True' when the value was a list and 'False' when it was null or not a list. However, after making some changes and then reverting back to the original settings, I started encountering issues. "Cannot convert value [true] of type class java.lang.String to Object Array for field error" 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache NiFi
 
			
    
	
		
		
		02-04-2024
	
		
		12:01 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Hello Team,  I have created the flow lile below  InnovokeHttp --> JOLTTransformJSON --> Putdatabase record  However While testing this process insert the data in database whenever record count is one. whenever records are more then 1 then its trigger the error. I tried to changes the JOLT spec to accept the multiple values but no luck.  ---------------------------------------------------------------------------  --Sample JSON record extracted from JIRA.  ---------------------------------------------------------------------------  {  "expand": "schema,names",  "startAt": 0,  "maxResults": 50,  "total": 1,  "issues": [  {  "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",  "id": "10000",  "self": "https://your-jira-instance.com/rest/api/2/issue/10000",  "key": "TEST-1",  "fields": {  "summary": "Example issue summary",  "description": "This is a detailed issue description.",  "status": {  "name": "Open"  },  "assignee": {  "name": "John Doe"  },  "reporter": {  "name": "Jane Smith"  },  "created": "2023-11-21T15:22:00.000+0000",  "updated": "2023-11-21T15:45:00.000+0000",  "project": {  "key": "TEST"  }  }  }  ]  }  ---------------------------------------------------------------------------  --JOLT Spec  ---------------------------------------------------------------------------  [  {  "operation": "shift",  "spec": {  "issues": {  "*": {  "id": "id",  "key": "key_id",  "fields": {  "summary": "summary",  "status": {  "name": "status"  },  "assignee": {  "name": "assignee"  },  "reporter": {  "name": "reporter"  },  "created": "created",  "updated": "updated",  "project": {  "key": "project"  }  }  }  }  }  }  ]  Any hint would be appriciated or alternative way to create flow also help.    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache NiFi
 
			
    
	
		
		
		04-04-2023
	
		
		06:32 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello @cotopaul,     I would like to create log of flows into database table. like when flow started, its succeed or failed. If failed then what is error message  example         Thanks,  Shakib    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-03-2023
	
		
		06:37 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hello,  I built a flow to pull data from the source (Oracle) and push it into the data warehouse. (Oracle).     The ETL procedure log must be created in a database, for example.     FLOW_ID, FLOW_NAME, START_TIME, END_TIME, STATUS, and ERROR_MESSAGE     How do I go about doing this?     Flow Example:            Log message into database like below                    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache NiFi
 
			
    
	
		
		
		04-03-2023
	
		
		12:57 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Good day, everyone.      This problem has been resolved. I made a new subfolder called /opt/nifi_server/ and installed the NIFI in it. When I first began, it gave me the error "Unable to bind the IP with port 844." I terminated the PID and launched the Nifi.Everything is back to normal now.    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-02-2023
	
		
		07:07 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Same credentials I am using on both the places  <provider>  <identifier>single-user-provider</identifier>  <class>org.apache.nifi.authentication.single.user.SingleUserLoginIdentityProvider</class>  <property name="Username">15a7a80c-dd66-47ca-8d32-4f0c9d4ee372</property>  <property name="Password">$2b$12$Zy.DA3JNLlgBsnhLTnb41uoTzbAVHTxoRtSaMuY5wUibm6vN7kd6y</property>  </provider>  <!--       Error Log : When login from remote machine.     Caused by: org.apache.nifi.authentication.exception.InvalidLoginCredentialsException: Password verification failed  at org.apache.nifi.authentication.single.user.SingleUserLoginIdentityProvider.authenticate(SingleUserLoginIdentityProvider.java:92)  at org.apache.nifi.web.security.spring.LoginIdentityProviderFactoryBean$1.authenticate(LoginIdentityProviderFactoryBean.java:343)  at org.apache.nifi.web.api.AccessResource.createAccessToken(AccessResource.java:422)     Log: when from localhost  loggin successfully , log message when logged off.     2023-04-03 06:05:30,599 INFO [NiFi Web Server-852] org.apache.nifi.web.api.AccessResource Logout Request [57fddaf8-4a7b-40ce-b63a-23d331cb872f] Identity [15a7a80c-dd66-47ca-8d32-4f0c9d4ee372] started             
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-31-2023
	
		
		11:18 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @MattWho, I have tried this one also, unfortunate did not work. In fact I have deleted the entire nifi and extracted it again with new password. issue still persist. 😞    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		- « Previous
 - Next »