Forum Discussion
ERROR [22003] [Sybase][ODBC Driver][SQL Anywhere]Value 1034 out of range for destination
I get this error when I try to refresh data from a specific table on an ODBC connection. Until last week I didn't have this error, and now I get it when I try to refresh or even Get Data from a blank query from this specific table. Any idea on what's going on?
Falha na última atualização: Wed Jul 26 2017 09:37:30 GMT-0300 (-03)
Houve um erro no data gateway.Ocultar detalhes
| Código de erro subjacente: | -2147467259 |
| Mensagem de erro subjacente: | ERROR [22003] [Sybase][ODBC Driver][SQL Anywhere]Value 1034 out of range for destination |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Cluster URI: | WABI-BRAZIL-SOUTH-redirect.analysis.windows.net |
| ID da atividade: | db73f792-b1f4-4d00-a00e-6baaf5557622 |
| Solicitar ID: | 481c3971-9b06-e20d-32d8-f1866b4d66b2 |
| Hora: | 2017-07-26 12:37:30Z |
1 Reply
bmannato,
Based on my research, the above error occurs when you supplied to or fetched from the database a value that is out of range for the destination column or host variable. For example, the value 10 may have been supplied for a DECIMAL(3,2) field. Please check if the values in your columns are in correct data type and if they exceeds the range of that data type accepts.
There are similar articles for your reference.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/saerrors/errm158.html
https://communities.bmc.com/docs/DOC-47707
Regards,
Lydia
