KFAA31742-E


      
         An error was detected when accessing the foreign data file.

         
            
               aa....aa:

               
                  Cause of the error

               

            
            
               bb....bb:

               
                  Detailed error information

               

            
            
               S:

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

               

            
            
               Action:

               
                  Take the following action depending on the cause of error output to aa....aa.

                  

                        
                        
                        
                        
                        
                           
                              
                                 Value of aa....aa

                              

                              
                                 Cause of the error

                              

                              
                                 Corrective action to take

                              

                              
                                 SQLSTATE

                              

                           

                        

                        
                           
                              
                                 Field not found

                              

                              
                                 No field corresponding to the column to be searched was found.

                              

                              
                                 The column name to be searched does not match the field name of the foreign data. The field name of the foreign data will be output to bb....bb. Based on this, change the column name in the foreign table.

                                 The column and field names should match, down to the uppercase and lowercase letters.

                              

                              
                                 2252D

                              

                           

                           
                              
                                 Data type incompatibility

                              

                              
                                 Data type is incompatible.

                              

                              
                                 Data cannot be retrieved because the data type of the columns in the foreign table and the field in the foreign data are incompatible. The data type code of the column and the data type name of the field will be output to bb....bb. Based on this, change the data type of the column in the foreign table to a compatible data type.

                                 Note that if the data type of a column in an foreign table is an array-type column, no data type code is output to bb....bb. It is output as ARRAY.

                                 For details about data type codes, see Types of data types in the HADB SQL Reference manual.

                                 See the Apache Arrow documentation for the data type names of the fields.

                                 For details about data type compatibility, see CREATE FOREIGN TABLE (defining a foreign table) in the HADB SQL Reference manual.

                              

                              
                                 2252E

                              

                           

                           
                              
                                 Outside the range of the numeric data type

                              

                              
                                 There are values in the foreign data that exceed the range that can be handled as numeric data.

                              

                              
                                 Change the data type of the columns in the foreign table to numeric data that can handle a wider range. For example, if a SMALLINT column type caused the error, change it to an INTEGER column type.

                                 Note that values exceeding the maximum range of data types supported by HADB cannot be retrieved. Please take the following actions to avoid errors.

                                 
                                    
                                       Specify values within the range of the column data type for the search condition.

                                    

                                    
                                       Exclude the column that caused the error from the projection column.

                                    

                                 

                                 The column names and data type codes of the foreign table will be output to bb....bb. In the case of DECIMAL column type, precision is also output.

                                 For details about data type codes, see Types of data types in the HADB SQL Reference manual.

                              

                           

                           
                              
                                 Defined column length exceeded

                              

                              
                                 There is data in the foreign data that exceeds the defined length of the columns in the foreign table.

                              

                              
                                 There is foreign data that is greater than the defined length of the columns in the foreign table. The length of the column definitions in the foreign table and the data length of the foreign data will be output to bb....bb. Based on this, increase the length of the column definitions in the foreign table.

                              

                           

                           
                              
                                 The number of array elements exceeded the maximum number of elements

                              

                              
                                 There is array type data in the foreign data in which the number of array elements exceeds the maximum number of elements.

                              

                              
                                 The maximum number of elements specified in the column definition and the number of elements in the foreign data will be output to bb....bb. Based on this, increase the maximum number of elements in the array-type column.

                              

                           

                           
                              
                                 Unsupported data

                              

                              
                                 There is data in the foreign data that is not supported by
                                    HADB.

                              

                              
                                 In bb....bb, there is data in the foreign
                                    data that is not supported by HADB. Based on this, delete the
                                    relevant foreign data.

                              

                           

                           
                              
                                 DECIMAL scale mismatch

                              

                              
                                 The column of the foreign table and the field of the foreign data do not match the scale of the DECIMAL type.

                              

                              
                                 The column and field scale will be output to bb....bb. Based on this, match the scale.

Value of aa....aa	Cause of the error	Corrective action to take	SQLSTATE
Field not found	No field corresponding to the column to be searched was found.	The column name to be searched does not match the field name of the foreign data. The field name of the foreign data will be output to `bb....bb`. Based on this, change the column name in the foreign table. The column and field names should match, down to the uppercase and lowercase letters.	2252D
Data type incompatibility	Data type is incompatible.	Data cannot be retrieved because the data type of the columns in the foreign table and the field in the foreign data are incompatible. The data type code of the column and the data type name of the field will be output to `bb....bb`. Based on this, change the data type of the column in the foreign table to a compatible data type. Note that if the data type of a column in an foreign table is an array-type column, no data type code is output to `bb....bb`. It is output as ARRAY. For details about data type codes, see Types of data types in the HADB SQL Reference manual. See the Apache Arrow documentation for the data type names of the fields. For details about data type compatibility, see CREATE FOREIGN TABLE (defining a foreign table) in the HADB SQL Reference manual.	2252E
Outside the range of the numeric data type	There are values in the foreign data that exceed the range that can be handled as numeric data.	Change the data type of the columns in the foreign table to numeric data that can handle a wider range. For example, if a SMALLINT column type caused the error, change it to an INTEGER column type. Note that values exceeding the maximum range of data types supported by HADB cannot be retrieved. Please take the following actions to avoid errors. Specify values within the range of the column data type for the search condition. Exclude the column that caused the error from the projection column. The column names and data type codes of the foreign table will be output to `bb....bb`. In the case of DECIMAL column type, precision is also output. For details about data type codes, see Types of data types in the HADB SQL Reference manual.
Defined column length exceeded	There is data in the foreign data that exceeds the defined length of the columns in the foreign table.	There is foreign data that is greater than the defined length of the columns in the foreign table. The length of the column definitions in the foreign table and the data length of the foreign data will be output to `bb....bb`. Based on this, increase the length of the column definitions in the foreign table.
The number of array elements exceeded the maximum number of elements	There is array type data in the foreign data in which the number of array elements exceeds the maximum number of elements.	The maximum number of elements specified in the column definition and the number of elements in the foreign data will be output to `bb....bb`. Based on this, increase the maximum number of elements in the array-type column.
Unsupported data	There is data in the foreign data that is not supported by HADB.	In `bb....bb`, there is data in the foreign data that is not supported by HADB. Based on this, delete the relevant foreign data.
DECIMAL scale mismatch	The column of the foreign table and the field of the foreign data do not match the scale of the DECIMAL type.	The column and field scale will be output to `bb....bb`. Based on this, match the scale.