transaction error

Forum to discuss general Vertica database administration topics

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: 1736
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”

Who is online

Users browsing this forum: Google [Bot] and 1 guest