0 votes

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


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) | 83 views

1 Answer

0 votes

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,

by isuarezsola (850 points)

421 questions

437 answers


640 users

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