Bad request error when selecting table in xmatch service

Question

I get the following error when I select my table for the xmatch service:

BAD REQUEST

Your browser sent a request that this server could not understand.

---

Apache/2.2.15 (CentOS) Server at datalab.noirlab.edu Port 443

I am able to upload my csv with the Table management service just fine, so I don't think that is the issue.  This appears after I pick the first table.  My table name only contains lowercase letters, so I don't believe that is the issue either.  Any advice would be appreciated!

Answer 1

Hi,

Looking at the database logs I see the following error:

2023-04-27 06:46:25.691 MST [2287215] ERROR:  invalid input syntax for type double precision: " –3.87986"

2023-04-27 06:46:25.691 MST [2287215] CONTEXT:  COPY yang2023, line 2, column  dec: " –3.87986"

It looks like the space leading to the minus sign is confusing the parser. Is there a space in your CSV file?

If so, let us know if removing that space improve things.

Thank you,

Igor