My Oracle Support Banner

Cannot Import Platform Devices, getting error : "Transaction Aborted" (Doc ID 2420602.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Oracle Communications Session Monitor - Version 4.0 and later
Information in this document applies to any platform.

Symptoms

Import of JSON file on 3.3.93.6 release fails.

User performed export of Platform Devices on 4.0.0.2.0 release and is using this file in JSON format to import on 3.3.93.6 release.

Import fails with error "transaction aborted"

From /var/log/messages:

The import fails with below error:

May 15 09:02:59 ocsm vsp: An exception occured.
May 15 09:02:59 ocsm vsp: Traceback (most recent call last):
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/vsp/VspWebFrontend.py", line 1277, in noauthWrapper
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/vsp/SipDevices.py", line 1287, in importSipDevicesConfirm
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/vsp/SipDevices.py", line 1391, in _import_sip_devices_last_step
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/vsp/SipDevices.py", line 1205, in _importSipDevices
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/libpalladion/db/DbWrapper.py", line 418, in genericInsertMultiple
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/libpalladion/db/DbWrapper.py", line 100, in _sql
May 15 09:02:59 ocsm vsp: File "/usr/lib/python2.7/site-packages/libp/db/ConnectionPool.py", line 261, in execute
May 15 09:02:59 ocsm vsp: File "/mysql/connector/cursor.py", line 491, in execute
May 15 09:02:59 ocsm vsp: File "/mysql/connector/connection.py", line 635, in cmd_query
May 15 09:02:59 ocsm vsp: File "/mysql/connector/connection.py", line 553, in _handle_result

May 15 09:02:59 ocsm vsp: ProgrammingError: 1054 (42S22): Unknown column 'vq_status' in 'field list' >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

May 15 09:03:06 ocsm ccalls: ERROR [ccalls_worker_broker_000] transaction aborted due to error (1213) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


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