IxpTransfer error (Doc ID 2638601.1)

Last updated on AUGUST 15, 2023

Applies to:

Symptoms

We are seeing multiple alerts in system alarms related to ixp server. In all the IXP subsystem servers we see the processes dataexport and IxpTransfer getting restarted frequently.
IxpTransfer log shows the following error,
[cfguser@ixp ~]$ tt IxpTransfer
+ cf.follow -10 -u /var/TKLC/ixp/run/proc/IxpTransfer/trace.dat

  ***** cf.follow Adjusting Time from UTC by 01:00 *****

1108:083304.038 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32798) [32798/ProcUtil.cxx:443]
1108:083304.040 MNG2 Read role, GetServer failed hostname=ixp [32798/IxsDatabase.cpp:110]
1108:083304.143 TR-V PROGRAM TERMINATED -- IxpTransfer code=0 [32798/ProcUtil.cxx:515]
1108:083309.041 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32807) [32807/ProcUtil.cxx:443]
1108:083309.045 MNG2 Read role, GetServer failed hostname=ixp0010-1a [32807/IxsDatabase.cpp:110]
1108:083309.147 TR-V PROGRAM TERMINATED -- IxpTransfer code=0 [32807/ProcUtil.cxx:515]
1108:083314.035 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32823) [32823/ProcUtil.cxx:443]
1108:083314.038 MNG2 Read role, GetServer failed hostname=ixp0010-1a [32823/IxsDatabase.cpp:110]
1108:083314.140 TR-V PROGRAM TERMINATED -- IxpTransfer code=0 [32823/ProcUtil.cxx:515]
1108:083319.043 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32841) [32841/ProcUtil.cxx:443]

System alarms shows the following critical error,

 ixp : Creating connection to oracles failed: Problem: Table XXXXXXXXX3 does not exists.; Session: xxxxxxxxx3; Failed DatawareHouses: XXXXXXXa (XXX.XXX.XXX.XXX) : Exporting period starting o

On :

Problem Details:
--------------------
We are seeing multiple alerts in system alarms related to ixp server. In all the IXP subsystem servers we see the processes dataexport and IxpTransfer getting restarted frequently.
IxpTransfer log shows the following error,
[cfguser@ixp0010-1a ~]$ tt IxpTransfer
+ cf.follow -10 -u /var/TKLC/ixp/run/proc/IxpTransfer/trace.dat

  ***** cf.follow Adjusting Time from UTC by 01:00 *****

1108:083304.038 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32798) [32798/ProcUtil.cxx:443]
1108:083304.040 MNG2 Read role, GetServer failed hostname=ixp [32798/IxsDatabase.cpp:110]
1108:083304.143 TR-V PROGRAM TERMINATED -- IxpTransfer code=0 [32798/ProcUtil.cxx:515]
1108:083309.041 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32807) [32807/ProcUtil.cxx:443]
1108:083309.045 MNG2 Read role, GetServer failed hostname=ixp [32807/IxsDatabase.cpp:110]
1108:083309.147 TR-V PROGRAM TERMINATED -- IxpTransfer code=0 [32807/ProcUtil.cxx:515]
1108:083314.035 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32823) [32823/ProcUtil.cxx:443]
1108:083314.038 MNG2 Read role, GetServer failed hostname=ixp [32823/IxsDatabase.cpp:110]
1108:083314.140 TR-V PROGRAM TERMINATED -- IxpTransfer code=0 [32823/ProcUtil.cxx:515]
1108:083319.043 TR-V PROGRAM STARTED -- IxpTransfer cmver=7.5.0.13.0-14027 (pid: 32841) [32841/ProcUtil.cxx:443]

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.