KFAA31243-E

There is a problem with the audit trail file path names (that contain special characters) specified as the argument of the ADB_AUDITREAD function.

               aa....aa: Cause of the error

                        no audit trail file path is specified for the input data

                        There is no audit trail file that will be the input data. <SQLSTATE: 427K6>

                        the input data includes more than 65535 audit trail file path names

                        The number of audit trail files that will be the input data exceeds 65,535. <SQLSTATE: 427K7>

               bb....bb: Position number of the query that specified the ADB_AUDITREAD function

                  For details about query position numbers, see 1.5 Query position numbers.

               S:

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

               Action:

                  Take the corrective action for the cause of the error displayed for aa....aa.

                                 Cause of the error displayed for aa....aa

                                 Specification of arguments in the ADB_AUDITREAD function

                                 Corrective action to take

                                 no audit trail file path is specified for the input data

                                 Argument specified

                                 Correct the audit trail file path names containing special characters specified as the argument of the ADB_AUDITREAD function. (Correct the audit trail file path names so that audit trail files that will be the input data of the ADB_AUDITREAD function exist.)

                                 Note that the current audit trail file will not be the input data of the ADB_AUDITREAD function.

                                 If you want to view an audit trail in the current audit trail file, swap the current audit trail file, and then execute the SELECT statement with the ADB_AUDITREAD function specified.

                                 Argument not specified

                                 An audit trail file other than the current one does not exist under the audit trail directory. Therefore, there is no audit trail file that will be the input data of the ADB_AUDITREAD function. If you want to view an audit trail in the current audit trail file, swap the current audit trail file, and then execute the SELECT statement with the ADB_AUDITREAD function specified.

                                 If you want to view an audit trail file stored in a place that is not under the audit trail directory, specify the path name of that audit trail file in the ADB_AUDITREAD function.

                                 the input data includes more than 65535 audit trail file path names

                                 Argument specified

                                 Correct the audit trail file path names containing special characters specified as the argument of the ADB_AUDITREAD function. Make sure that the number of audit trail files that will be the input data of the ADB_AUDITREAD function does not exceed 65,535.^#

                                 Argument not specified

                                 Make sure that the number of audit trail files under the audit trail directory does not exceed 65,535.^# For example, move audit trail files to the audit trail storage directory.

                        #

                           The current audit trail file is not subject to counting.

Note

                           The audit trail directory is the directory specified in the adb_audit_log_path operand in the server definition.

                           For details about how to swap the current audit trail file, see Swapping the current audit trail file in the HADB Setup and Operation Guide.

Cause of the error displayed for `aa....aa`	Specification of arguments in the `ADB_AUDITREAD` function	Corrective action to take
`no audit trail file path is specified for the input data`	Argument specified	Correct the audit trail file path names containing special characters specified as the argument of the `ADB_AUDITREAD` function. (Correct the audit trail file path names so that audit trail files that will be the input data of the `ADB_AUDITREAD` function exist.) Note that the current audit trail file will not be the input data of the `ADB_AUDITREAD` function. If you want to view an audit trail in the current audit trail file, swap the current audit trail file, and then execute the `SELECT` statement with the `ADB_AUDITREAD` function specified.
`no audit trail file path is specified for the input data`	Argument not specified	An audit trail file other than the current one does not exist under the audit trail directory. Therefore, there is no audit trail file that will be the input data of the `ADB_AUDITREAD` function. If you want to view an audit trail in the current audit trail file, swap the current audit trail file, and then execute the `SELECT` statement with the `ADB_AUDITREAD` function specified. If you want to view an audit trail file stored in a place that is not under the audit trail directory, specify the path name of that audit trail file in the `ADB_AUDITREAD` function.
`the input data includes more than 65535 audit trail file path names`	Argument specified	Correct the audit trail file path names containing special characters specified as the argument of the `ADB_AUDITREAD` function. Make sure that the number of audit trail files that will be the input data of the `ADB_AUDITREAD` function does not exceed 65,535.^#
	Argument not specified	Make sure that the number of audit trail files under the audit trail directory does not exceed 65,535.^# For example, move audit trail files to the audit trail storage directory.