SQ01 SAP adhoc query error

[Former Member]

Hi,

We face a very peculiar problem. A particular user is not able to

execute the SQ01 queries for some reasons. All the other users are able

to execute the queries correctly.

When this particular user is trying to execute the query, he gets an

error message that says

"No archive information found for object type and document type"

The details of this error message is as follows:

No archive information found for object type and document type

Message no. PT019

Diagnosis

No information was found about optical archiving. This may be due to

either of the following reasons:

1. No valid archiving parameters were passed

2. Your system is not configured for optical archiving

System response

Processing is cancelled.

Procedure

Specify valid archiving parameters or check whether your system is

configured for optical archiving.

Please let us know why this error is coming and that too for this user

only. We've checked the other settings like Infoset - user-group

assignments etc which are perfectly fine.

Can anyone figure what could be the issue?

Thanks & regards,

Sam

[Former Member]

Hello,

This message is raised in FM GET_ARCHIVE_PARAMETERS when there is no entry in table TOAOM and also in FM GET_ARCHIVE_PARAMS_NODIALOG.

So I guess that there is a userparameter that's not filled for that particular user.

Maybe you could check that out ?

Best regards,

Dirk.

[Former Member]

Hello Dirk,

Thanks for your response. You're right. I already debugged SQ01 and found out that GET_PRINT_PARAMETERS calls GET_ARCHIEVE_PARAMETERS which creates the dump. But when I tried the same with some other users, the 2nd FM is never getting called since some variables is set as 1 (print) in the code. But for this user alone, the value for the variable is set as 2(archive) or 3 (print & archieve) for some reasons due to which the 2nd FM is being called and since no archieval settings has been done in the system, it dumps out.

What I'm trying to find is now, which parameter causes this variable to get a value <> 1. I feel that the table tpri_def has some entries for this user that causes this but no idea how that entry got created in the first place...:)

Still investigating it. Will update u if any new findings.

Thanks for your help.

Cheers,

Sam

[Former Member]

may be authorization problem ? Have u added this user in that User Group ?

after running the query call /NSU53 and see if any probs with authorizations .

Regards

Peram

[Former Member]

Hi Peram,

There is no problem with the authorization at all since I've checked the same by replicating the same user profiles to another dummy user and it works fine in the other id.

Cheers,

Sam

[Former Member]

Hey Mandrake,

Please check your printer settings, I know this sounds wierd but I entountered the same problem and it was because my printer settings in SAP were set to Archive only OR Printer and archive. Please change it back to Print Only. Once you log on to BW through the Gui, press Ctrl + P. If a dialog does not pop up, click Ctrl + P again. After the print dialog comes on type in LP01 on the Output Device so it looks at your local printer. Then make sure the Storage Mode says "Print Only". Now click on Properties, then go to Settings. In the field name box select Output Device, and leave the default value alone whatever value it is. Then click on Copy Settings. Then Click the green check mark 3 times for each window. Log off, try to execute a query, and see if that message disappears for you now.

[Former Member]

Hi Angela,

Thanks a lot for your valid answer. I guess the proble might be that.

But actually I sovled this long back by deleting a table entry for that employee based on a SAP note. I dont remember the table name or the note no at the moment. But I guess the issue is something similar to what you've quoted. I appreciate your help.

Thanks a ton!

Cheers,

Sam

[Former Member]

Hi to all,

I have the same problem as you. I have an user that cannot execute any query. When this particular user is trying to execute the query, he gets an

error message that says

"No archive information found for object type and document type"

The details of this error message is as follows:

No archive information found for object type and document type

Message no. PT019

Diagnosis

No information was found about optical archiving. This may be due to

either of the following reasons:

1. No valid archiving parameters were passed

2. Your system is not configured for optical archiving

System response

Processing is cancelled.

Procedure

Specify valid archiving parameters or check whether your system is

configured for optical archiving.

Please let us know why this error is coming and that too for this user

only. We've checked the other settings like Infoset - user-group

assignments etc which are perfectly fine.

IT IS THE SAME ISSUE.... PLEASE CAN ANYONE TELL ME THE SAP NOTE ... OR HOW TO FIND IT... HOW TO FIND THE TABLE ENTRY AND DELETE IT

Moderator message - Welcome to SCN.

Moderator message - But please do not use all caps or use words like ASAP - everyone's problem is important

Edited by: Rob Burbank on Sep 23, 2009 5:03 PM