"ORA-01756: quoted string not properly terminated" During Import of Objects into ODI 12c (Doc ID 2389407.1)

Last updated on MARCH 03, 2021

Applies to:

Symptoms

When using Smart Import to import objects into Oracle Data Integrator (ODI) 12c, a popup appears during the object mapping phase with the following error message:

java.lang.RuntimeException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-01756: quoted string not properly terminated
  at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:636)
  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:452)
  ...
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-01756: quoted string not properly terminated
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2945)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalIssueDetectionForChildFCOs(IssueDetectionEngine.java:2961)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalIssueDetectionForChildFCOs(IssueDetectionEngine.java:2962)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.doIssueDetectionForSmartImportObject(IssueDetectionEngine.java:3008)
  at com.sunopsis.dwg.smartie.SmartImportManager.getSmartImportHierarchy(SmartImportManager.java:2565)
  ...
Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-01756: quoted string not properly terminated
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)
  ...

Cause

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