0 votes
145 views

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!

by ktkauma (140 points) | 145 views

1 Answer

0 votes
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
by isuarezsola (890 points)

447 questions

463 answers

473 comments

658 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.

Categories