hi all,
oracle is my source and vertica is target. my source is having 30 millions of records. here i wrote sql query on 11 table in source qualifier of informatica. when i am loading data into the vertica session got closed by server after loading 370000 records, again i truncated the table and loaded the data into vertica , here also it got closed by the server after loading 370000 records. here session is running above 5 hours of time, some times running 6 hours after that its getting failed because of server closing the session. after that i tried with partition , it loaded 20 lakh records and got failed after 6 hours.( frequently its getting fail after runnig 5-6 hours).
i found that it getting fail because of server closing session. but i dont know why vertica server closing session after 5-6 hours run of session. is there any solution for this problem. can anybody help me why its getting close by server. and also how to improve the session performance when we have vertica as target.
the actual error i am getting in session log is
{server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.}
thanks in advance.
session closing abnormally
Moderator: NorbertKrupa
Re: session closing abnormally
thank you nnani.
-
- Newbie
- Posts: 1
- Joined: Tue Apr 23, 2013 10:59 pm
Re: session closing abnormally
Hi
bhupal and nnani - I am new to vertica. can I contact you thru phone or email please? if so, can you please pass on those to me? Any help on this really helpful.
regards
Ajay
bhupal and nnani - I am new to vertica. can I contact you thru phone or email please? if so, can you please pass on those to me? Any help on this really helpful.
regards
Ajay
Re: session closing abnormally
Hi Ajay,
I am also new to vertica. it is better to together with nnani. still if u want to connect with me,u can reach by mail.
mail id: bhupalreddy200@gmail.com
I am also new to vertica. it is better to together with nnani. still if u want to connect with me,u can reach by mail.
mail id: bhupalreddy200@gmail.com