Re: Getting a CPF4269 - 'Not authorized to object QADBERAP in QRECOVERY type *FILE.'

The file QADBERAP is Q=System, A=Database File, DB=Database component, E=Edit, R=Rebuild, A=Access, P=Path. The file QADBERAP is the implementation object for the graphical OpsNav interface to the "Edit Rebuild Access Paths"; i.e. effectively, EDTRBDAP command.

I infer from the errors that either of the following:

- The program SA010R attempts to perform some update activity on a file which apparently effected an error [e.g. CPF5090] that suggested there was an invalid access path of the data being accessed. The response to the error included the "verify file" routine of the query engine attempting to delete the record which recorded\represented the invalid access path, presumably because the access path had since been rebuilt; i.e. CPF3145 or similar was logged. If that is the case, then likely the code has a defect for failing to adopt the necessary authority to effect the DELETE FROM QRECOVERY/QADBERAP WHERE.

- The program SA010R attempts delete activity on a file, the CPF5090 prevents opening the file, some query component activity attempts to access the QADBERAP file in QRECOVERY with regard to the restriction\error, that code does not properly adopt authority to do so, and the default error handling for "not authorized" is manifest; that the origin for the condition was not directly related to the SQL request, but is reported as the object named in the -550 SQL code details is merely a side effect of the defect... and the SQL DELETE may or may not have completed without error without said defect [e.g. perhaps cpf5090 is manifest as sql0901 or similar].

Regards, Chuck

Charles Wilt wrote:

Our box went down hard last night due to a failed power supply.

We noticed this morning during our End of Day process, the following
messages in the job log..

*NONE Command 12/16/09 06:24:21.051840
QCLCLCPR QSYS 04CB FS001C HLTHPRDPGM 037D
Message: 48400 - CALL PGM(SA010R) /* parameters */
CPF4269 Escape 40 12/16/09 06:24:21.227928
QQQSRVV1 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . : QQQVFILE
From procedure . . : QQQSNDPMSG
Statement . . . . . : 6291
To module . . . . . : QSQOPEN
To procedure . . . : FULL_OPEN
Statement . . . . . : 23166
Message: Not authorized to object QADBERAP in QRECOVERY type *FILE.
Cause . : You do not have the necessary authority to perform the
function that you requested. If you are not authorized to a logical file, you may need authority to the based-on files of the
logical file. Recovery . . . : Get the necessary authority from
either your security officer or from the owner of the object. Then try your request again.
SQL0551 Diagnostic 30 12/16/09 06:24:21.228648
QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . : QSQDELET
From procedure . . : CLEANUP
Statement . . . . . : 13437
To module . . . . . : QSQDELET
To procedure . . . : CLEANUP
Statement . . . . . : 13437
Message: Not authorized to object QADBERAP in QRECOVERY type *FILE.
Cause . : An operation was attempted on object QADBERAP in
QRECOVERY type *FILE. This operation cannot be performed without
the required authority. Recovery . . . : Obtain the required authority from either the security officer or the object owner. If you are not authorized to a logical file, obtain the authority
to the based-on files of the logical file. Try the operation
again.

I've googled the file, but don't see anything telling me what it is.

Does anywhere here know anything about it, or should we call IBM?