My Oracle Support Banner

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

Last updated on JULY 16, 2018

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!


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