Andrea,
This error page is returned when the database access code (~las/server/xml/perl/TMAP/TMAPDBI.pm)
generates a "No data was returned with the query:" message. There's a
couple of places you can look to see how far LAS is getting in
accessing your data.
- Look in ~las/server/log/mysql_request.txt for a
transcript of the LAS MySQL request. Try issuing this request from the
command line to see if it works for you.
- Review your <database_access> properties to be sure you're
using the correct <lon_domain> for your variables. (From the
request it seems you need to configure your <lon_domain> to
"-360:0"? Remember that your database doesn't understand modulo
longitudes and LAS has to convert user interface input into the proper
<lon_domain> for your database query.)
That's all that comes to mind immediately. Let us know how it goes.
-- Jon
Andrea Fey wrote:
Good afternoon.
I am still having trouble getting insitu data into LAS. I'm currently
attempting to do this from mysql. I've followed the insitu_demo files
carefully, but can't get real data working. I've changed all of my data
types to floats and changed my date to one which can be read by the
TMAP date module (YYYYMMDDHHMMSS). A working version of the insitu demo
is running from the same server, and LAS is able to access the dates
from my database and interpret them correctly (I have the proper date
range on the constraints page.) Yet each time I attempt to get output,
I get the error "The query submitted to the back end database
returned no valid data for this variable."
Here is what my table looks like (levels are press2):
mysql> describe test6;
+---------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default |
Extra |
+---------------+------------+------+-----+---------+-------+
| id | float | YES | | NULL
| |
| geo_hgt_m | float | YES | | NULL |
|
| temp_10C | float | YES | | NULL |
|
| Td_diff_10C | float | YES | | NULL |
|
| wind_dir | float | YES | | NULL
| |
| wind_spd_10ms | float | YES | | NULL |
|
| new_date | bigint(17) | YES | | NULL |
|
| press2 | float | YES | | NULL
| |
| lat | float | YES | | NULL
| |
| lon | float | YES | | NULL
| |
+---------------+------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
I've successfully queried the database from the "test" query in the
documentation:
mysql> SELECT lon,lat,press2,new_date,temp_10C
-> FROM test6
-> WHERE lon>=-195.363327 AND lon<=-60.1234
-> AND lat>=23.783333 AND lat<=83.183333
-> AND new_date>=20050401000000 AND
new_date<=20050420000000
-> limit 100;
+--------+-------+--------+----------------+----------+
| lon | lat | press2 | new_date | temp_10C |
+--------+-------+--------+----------------+----------+
| -80.23 | 40.53 | 965 | 20050404000000 | 80 |
| -80.23 | 40.53 | 925 | 20050404000000 | 54 |
| -80.23 | 40.53 | 850 | 20050404000000 | -11 |
| -80.23 | 40.53 | 700 | 20050404000000 | -85 |
| -80.23 | 40.53 | 500 | 20050404000000 | -219 |
| -80.23 | 40.53 | 400 | 20050404000000 | -323 |
Does anyone have suggestions of what I could try next?
Thanks!
Andrea
--
Andrea Fey
NOMADS Project Intern
Andrea.Fey@noaa.gov
828-271-4474
|