Frequent AQS Questions
Installation Logon/Password Screen Functions Loading
Data Reports
Error Messages (Messages from all categories are included in a chart at the bottom of this page.)
Oracle Discoverer
P& A Data
Other
Installation
- What is the AQSProd database?
- Installation/Setup instructions
- Hardware/software requirements
- Version of Oracle used in AQS
Logon/Password Return to Top
- When a password expires, what questions will be asked by the AQS Help Desk (Call Center) to verify the caller's organization and what is the process to get a new password (e.g., will they call back, send an email with a link, etc.)
- Why is my User-ID revoked?
- How many characters are required for my password?
- Logon/password problems
- Synchronizing passwords
Screen or Form Functions Return to Top
- "Function Keys not allowed" message
- Am I missing part of the screen?
- "Field must be entered" -- seem to be caught in a loop
Loading Data Return to Top
- Can data be changed and corrected in AQS once it has been loaded? Are there any negative implications if data are corrected (does it look "bad")? Do states and local agencies change data?
- Is it better to report no data or null value coded data?
- Have questions about PM 2.5 Field Blank reporting? (Links to a list of questions and answers prepared by Lewis Weinstock, 1/9/07)
- What are the most common load errors?
- What is the easiest way to create all of the toxics monitors at a site?
- My Load job failed. How do I find out what went wrong?
- Can I delete all of my unposted records and start over?
- Can I delete some of the raw data records that are in pre-production status?
- Can I input data in the "old" AQS format?
- Why are there differences in some numeric field lengths between the data coding manual and the Input Transaction Format document?
- Why are there so many more records counted on the Edit Load Summary report than in my input transaction file?
- Why doesn't my SCAN report show any values?
- I have data for the Census tract, Block Group, Block Number that I can't add.
- Why is AQS complaining about the format of my sample values?
- My Zip code is missing!
- How does the Load function differ with Precision & Accuracy data?
- If I update a site, do I have to include the new LDP data?
- "Not enough space"? My LOAD job failed.
Reports Return to Top
- What are the standard reports available from AQS?
- Why can't Internet Explorer download my report?
- Why does the Logon window pop up for each report I request?
- Why won't this report run? The first one ran.
- When should duration be specified on an AMP450 Quick Look report?
- When I run a standard report or try to retrieve one from Retrieve Reports, I either get a blank white screen or a window pops up and then quickly disappears. Why doesn’t my report come up?
Error Messages Return to Top
(Messages from all categories are included in a chart at the bottom of this page.)- Why did I get "FRM-40509: ORACLE error: unable to UPDATE record"?
- What does "FRM-40735: ON_ERROR trigger" mean?
- "A batch session exists for this screening group"?
- What does ORA-00942 mean?
- "Not enough space"? My LOAD job failed.
- Chart of other Error Messages not covered in Data Coding Manual
Oracle Discoverer Return to Top
- What is Oracle BI Discoverer?
- What do I need to use BI Discoverer?
- What setup information do I need?
- Where can I get more information on using BI Discoverer?
- What does 'Java.lang.class not found exception: oracle.disco.disco.applet' mean?
Precision and Accuracy (P&A) Data Return to Top
- What is P&A data?
- How do I get Precision and/or Accuracy data into AQS?
- Why does the Accuracy Report (AMP247) show different percent differences for the same values?
- Accuracy has "actual" vs. "indicated", but Precision uses the term "indicated" and "test". The "test" wording is confusing.