KFAA31744-E


      
         A connection could not be established to the foreign server. <SQLSTATE:5100S>

         
            
               aa....aa:

               
                  Detailed error information

               

            
            
               S:

               
                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               

            
            
               Action:

               
                  Review the various settings by referring to the detailed error information output to aa....aa.

                  Detailed error information will be output in the error messages generated by Apache Arrow. Detailed error information may include error messages from AWS and other sources.

                  The following describes the cause of the error and the corrective action to take.

                  

                        
                        
                        
                           
                              
                                 Cause of the error

                              

                              
                                 Corrective action

                              

                           

                        

                        
                           
                              
                                 Authentication information to access foreign servers are invalid

                              

                              
                                 Set the correct authentication information. Authentication information can be configured for the foreign servers in the following ways.

                                 
                                    
                                       Set an access key and secret key for each foreign server.

                                    

                                    
                                       Set IAM roles for each instance.

                                    

                                    
                                       Set up an authentication information file for each instance.

                                    

                                 

                                 For details, see the following section.

                                 
                                    
                                       How to define a foreign server in
                                          the manual HADB Setup and Operation
                                          Guide.

                                    

                                    
                                       CREATE SERVER (defining a foreign server) in the manual HADB SQL Reference

                                    

                                 

                              

                           

                           
                              
                                 Privileges required to operate foreign servers are insufficient

                              

                              
                                 Bind the appropriate IAM policy with the authentication
                                    information you are using. For details, see How
                                    to define a foreign server in the manual HADB Setup
                                    and Operation Guide.

                              

                           

                           
                              
                                 Endpoint on foreign servers is invalid

                              

                              
                                 Set the correct endpoints. For details, see CREATE SERVER (defining a foreign server) in the manual HADB SQL Reference.

                              

                           

                           
                              
                                 Communication to the foreign servers is blocked

                              

                              
                                 Check the network settings.

Cause of the error	Corrective action
Authentication information to access foreign servers are invalid	Set the correct authentication information. Authentication information can be configured for the foreign servers in the following ways. Set an access key and secret key for each foreign server. Set IAM roles for each instance. Set up an authentication information file for each instance. For details, see the following section. How to define a foreign server in the manual HADB Setup and Operation Guide. CREATE SERVER (defining a foreign server) in the manual HADB SQL Reference
Privileges required to operate foreign servers are insufficient	Bind the appropriate IAM policy with the authentication information you are using. For details, see How to define a foreign server in the manual HADB Setup and Operation Guide.
Endpoint on foreign servers is invalid	Set the correct endpoints. For details, see CREATE SERVER (defining a foreign server) in the manual HADB SQL Reference.
Communication to the foreign servers is blocked	Check the network settings.