{"action":"opened","issue":{"url":"https://api.github.com/repos/vertica/Vertica-Extension-Packages/issues/40","labels_url":"https://api.github.com/repos/vertica/Vertica-Extension-Packages/issues/40/labels{/name}","comments_url":"https://api.github.com/repos/vertica/Vertica-Extension-Packages/issues/40/comments","events_url":"https://api.github.com/repos/vertica/Vertica-Extension-Packages/issues/40/events","html_url":"https://github.com/vertica/Vertica-Extension-Packages/issues/40","id":77938280,"number":40,"title":"ERROR 0:  Error calling process() in User Function UDParser at [ODBCLoader.cpp:376], error code: 0, message: Error parsing Numeric: '15600249032015053115' (unrecognized syntax from remote database)","user":{"login":"mayankgupta18","id":5162772,"avatar_url":"https://avatars.githubusercontent.com/u/5162772?v=3","gravatar_id":"","url":"https://api.github.com/users/mayankgupta18","html_url":"https://github.com/mayankgupta18","followers_url":"https://api.github.com/users/mayankgupta18/followers","following_url":"https://api.github.com/users/mayankgupta18/following{/other_user}","gists_url":"https://api.github.com/users/mayankgupta18/gists{/gist_id}","starred_url":"https://api.github.com/users/mayankgupta18/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mayankgupta18/subscriptions","organizations_url":"https://api.github.com/users/mayankgupta18/orgs","repos_url":"https://api.github.com/users/mayankgupta18/repos","events_url":"https://api.github.com/users/mayankgupta18/events{/privacy}","received_events_url":"https://api.github.com/users/mayankgupta18/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-05-19T05:17:14Z","updated_at":"2015-05-19T05:17:14Z","closed_at":null,"body":"Hello \r\n\r\nWe are getting error while using ODBCLoader , specially in case if the length of data in source reached to its maximum based on datatype defined for that column\r\n\r\ndbadmin=> \\d t_d1\r\n\r\n                                    List of Fields by Tables\r\n Schema | Table | Column |     Type      | Size | Default | Not Null | Primary Key | Foreign Key\r\n--------+-------+--------+---------------+------+---------+----------+-------------+-------------\r\n public | t_d1  | a      | numeric(20,0) |   16 |         | f        | f           |\r\n(1 row)\r\n\r\nSample data: \r\n15600249032015053115\r\n\r\nCOPY t_d1 WITH SOURCE ODBCSource() PARSER ODBCLoader(CONNECT = 'DSN=DEVVertica;UID=dbadmin;PWD=password;', QUERY = 'SELECT * from t_d1;');\r\n\r\nERROR 0:  Error calling process() in User Function UDParser at [ODBCLoader.cpp:376], error code: 0, message: Error parsing Numeric: '15600249032015053115' (unrecognized syntax from remote database)"}}