Joe,
Sorry
for the delay in getting back to you. I was seeing something
similar. The pre_extract and the rim_extract steps were failing and when I
tried to update the access via Warehouse Sources -> AMX_ITM_RIM_Source ->
properties and the data source tab this was where I was getting the
error. I have changed the DSN to Oracle ODBC Driver and am not getting the
error anymore but the connection seems to be hanging - since 12:45 (it is
now 16:00 here). In fact the whole server seems a little unhappy with
me.
I've
rebooted and everything seems fine so far - I ran the pre_extract and it was
successful I am now running the rim_extract which is taking its time - but there
is probably alot of data.
It
appeared to be the ODBC driver - Thanks Stuart
Regards
Colin Mulkerrins
Enterprise Systems Management
An Post
Ph. +353 (0)1
7057375
FAX
+353 (0)1 8090711
E-Mail colin.mulkerrins@xxxxxxxxx
I'm having a
similar problem, except with SQL Server. I can successfully test the
connection but when I try to test the AMX_c05_s005_Pre_Extract step (the first
step in the extract job) it fails with a similar message. The lines that
follow the message appear to indicate that some of the parameters in the ODBC
call are either in the wrong place or missing; looks like it's missing the
userid and password to connect to the remote data source, although I believe
that I've got it defined everywhere. Are you seeing something
similar?
#######################
Joe Howell
Shelter Insurance
Companies
(573)-214-6534
jhowell@xxxxxxxxxxxxxxxxxxxx
"Colin Mulkerrins"
<Colin.Mulkerrins@xxxxxxxxx>
Sent by: owner-tme10@xxxxxxxxxxxxxxxx
01/28/2005 06:19 AM
|
Please respond
to
tme10@xxxxxxxxxxxxxxxx |
|
|
To
| <tme10@xxxxxxxxxxxxxxxx>
|
|
cc
|
|
|
Subject
| [tme10] [tedw]AMX
connection to RIM Source |
|
Hi,
I have just installed Data Warehouse 1.2 on W2k
and want to collect ITM data. I have ITM (Ver 5.1.2) datacollection
running and loading TEDW data into an Oracle 8.1.5 database on AIX.
I have
installed the AMX onto the TEDW server and have created the ODBC connection to
the ITM Database (I can connect to the database through sqlplus on the TEDW
server), but it will not connect to the Oracle database when testing the AMX
process - it gives the following error message
DWC07356E An agents's
processing of a command of type "connectToSource" failed for edition "0" of
step "?".
Specified driver could not be
loaded due to system error 126 (DataWHSE 3.60 32-bit Oracle8).
RC = 7356 RC2 = 8515
Has anybody come
accross this before?
I sense a PMR coming on but I said that I would
ask here first in case anybody has a quick fix
Thanks
Regards
Colin Mulkerrins
Enterprise Systems
Management
An Post
***********************************************************************************
This
e-mail and its attachments, is confidential and is intended for the
addressee(s) only. If you are not the intended recipient, disclosure,
distribution or any action taken in reliance on it is prohibited and may be
unlawful. Please note that any information expressed in this message or its
attachments is not given or endorsed by An Post unless otherwise indicated by
an authorised representative independently of this message. An Post does not
accept responsibility for the contents of this message and although it has
been scanned for viruses An Post will not accept responsibility for any damage
caused as a result of a virus being passed
on.
***********************************************************************************
