transaction error

Moderator: NorbertKrupa

Post Reply
lwmonster
Newbie
Newbie
Posts: 3
Joined: Fri Apr 29, 2016 6:58 am

transaction error

Post by lwmonster » Wed Dec 07, 2016 9:58 am

hi, I'm doing SELECT operation with ODBC, before I send SELECT request, I would begin a transaction to SET TIMEZONE, when start the transaction I encountered this error: begin tx failed, SQLSetConnectUIntPtrAttr: {HY000} [DSI] The error message VPropertySetFailed could not be found in the en-US locale. Check that /en-US/VerticaMessages.xml exists

I've googled for a long time and couldn't find the answer, any idea?

lwmonster
Newbie
Newbie
Posts: 3
Joined: Fri Apr 29, 2016 6:58 am

Re: transaction error

Post by lwmonster » Wed Dec 07, 2016 11:09 am

BTW, there are no ERROR logs in vertica.log

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: transaction error

Post by JimKnicely » Wed Dec 07, 2016 4:43 pm

Have you tried using the ConnSettings property of the connect string?

See:
viewtopic.php?f=21&t=98
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Database Administration”