Postgres Database Connection through Abinitio
"Pelluru, Subramanyam" <[email protected]> Tue, 8 Mar 2016 16:12:22 +0000
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <BY1PR0701MB18309202285F70D4CAC7384BC9B20@BY1PR0701MB1830.namprd07.prod.outlook.com> |
--_000_BY1PR0701MB18309202285F70D4CAC7384BC9B20BY1PR0701MB1830_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Team,
We have to setup Postgres Database connection through ETL Abinitio GDE/Co-O=
p system.
We have tried with the following configuration parameters in the .dbc file =
.
dbms: PostgreSQL
db_version: 9.2
db_home: /opt/PostgreSQL/9.2
db_name: @postgres
db_nodes: tparhermsd001
user: postgres
password: postgres
But we are ending up with the below error.
ABINITIO(DB00113): Error remotely executing 'm_db' on node 'tparhermsd001.=
nielsen.com'.
tparhermsd001.nielsen.com: Remote job failed to start up
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Please let us know the files or any other configuraion items we require to =
connect to the Postgres database.
Thanks,
Subramanyam Pelluru
--_000_BY1PR0701MB18309202285F70D4CAC7384BC9B20BY1PR0701MB1830_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;back=
ground-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Team,</p>
<p><br>
</p>
<p>We have to setup Postgres Database connection through ETL Abinitio GDE/C=
o-Op system.</p>
<p>We have tried with the following configuration parameters in the .dbc fi=
le .</p>
<p><br>
</p>
<p><span style=3D"background-color: rgb(255, 255, 0);">dbms: PostgreSQL</sp=
an><br>
<span style=3D"background-color: rgb(255, 255, 0);">db_version: 9.2 </span>=
<br>
<span style=3D"background-color: rgb(255, 255, 0);">db_home: /opt/PostgreSQ=
L/9.2</span><br>
<span style=3D"background-color: rgb(255, 255, 0);">db_name: @postgres </sp=
an><br>
<span style=3D"background-color: rgb(255, 255, 0);">db_nodes: tparhermsd001=
</span>
<br>
<span style=3D"background-color: rgb(255, 255, 0);">user: postgres </span><=
br>
<span style=3D"background-color: rgb(255, 255, 0);">password: postgres</spa=
n></p>
<p><br>
<span style=3D"background-color: rgb(255, 255, 0);"></span></p>
<p><span style=3D"background-color: rgb(255, 255, 255);">But we are ending =
up with the below error.</span></p>
<p><span style=3D"background-color: rgb(255, 255, 255);"><br>
</span></p>
<p><span style=3D"background-color: rgb(255, 255, 0);"><span style=3D"backg=
round-color: rgb(255, 255, 0);">ABINITIO(DB00113): Error remotely exe=
cuting 'm_db' on node 'tparhermsd001.nielsen.com'.</span><br>
<span style=3D"background-color: rgb(255, 255, 0);">tparhermsd001.nielsen.c=
om: Remote job failed to start up</span><br>
<span style=3D"background-color: rgb(255, 255, 0);">=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D</span></span></p>
<p><br>
<span style=3D"background-color: rgb(255, 255, 0);"></span></p>
<p>Please let us know the files or any other configuraion items we req=
uire to connect to the Postgres database.
<br>
</p>
<p><br>
</p>
<div id=3D"Signature">
<div style=3D"font-family:Tahoma; font-size:13px">
<p><font style=3D"background-color:#ffffff" color=3D"#666699">Thanks,</font=
></p>
<p><strong><font style=3D"background-color:#ffffff" color=3D"#666699">Subra=
manyam Pelluru</font></strong></p>
</div>
</div>
</div>
</body>
</html>
--_000_BY1PR0701MB18309202285F70D4CAC7384BC9B20BY1PR0701MB1830_--