User login
Sponsored links
Recent blog posts
- Changing the PeopleSoft Logo
- Temporary Tables
- AJAX XML - The JavaScript code
- AJAX XML - The PHP Page code
- Peoplecode Trace in a File.
- Display pdf file , image, website on peoplesoft page using html area.
- Ren Server -- Over View
- SQR Code
- AP PO Tables - Some imp Query.
- PeopleSoft XML Publisher - Report Development
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 |
|---|---|---|
| Inserting records | PeopleSoft Technical | 07/28/2010 - 11:03am |
| WEBLIB_PT_NAV.ISCRIPT1.FieldFormula.IScript_PT_NAV_PAGELET error... | PeopleSoft Technical | 07/27/2010 - 2:02pm |
| Basic language | PeopleSoft Technical | 07/27/2010 - 7:12am |
| Rowlevel security from app designer | PeopleSoft Technical | 07/27/2010 - 5:15am |
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