User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
Query Not running online
Wed, 10/08/2008 - 4:09pm
Hello All,
I am getting the below error when I try to run the *public query SAR_TER_BY_DATE* online using Query Manager.
**[Open Query] [CQryStmt::Prepare] QDM could not load query definition [ PUBLIC.SAR_TER_BY_DATE ]**
I checked the all PSQUERY tables like PSQRYDEFN, PSQRYFIELD, PSQRYEXPR, PSQRYCRITERIA, PSQRYRECORD, PSQRYSELECT etc and this query exist in all the PSQUERY tables. I am able to run in two-tie and in database using query tool.
Please let me know what could be the problem.
Thanks in Advance!
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Has any of the underlying tables behind your SAR_TER_BY_DATE query changed/modified? Try using "save as" and try running the new query online. Let me know how it goes.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Thanks Lepa!!! It worked perfectly. Thanks for helping community.
Your welcome, its a weird issue and sometimes just re-saving the query would do the trick. Glad its working now.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Post new comment