Article - CS317387
SyncDB failed with SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12170: TNS:Connect timeout occurred in Servigistics Service Parts Management
Modified: 27-Nov-2019
Applies To
- Servigistics Service Parts Management 10.4.0.1 N/A to 12.0.1.1
Description
- SyncDB failed with SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12170: TNS:Connect timeout
- Error message:
- 2019-11-20 20:12:48,119[SyncDbTask-1] ERROR com.svg.core.util.EventLog - Task Synchronize Database failed with message: SQL Loader failed.
java.lang.RuntimeException: SQL Loader failed.
at com.svg.core.dataprovider.BulkInsert.bulkInsert(BulkInsert.java:256)
at com.svg.core.process.Output.commitUpdates(Output.java:302)
at com.svg.core.process.Output.writeRow(Output.java:187)
at com.svg.core.process.Output.write(Output.java:169)
at com.svg.core.process.abc.ABCSetOutput.write(ABCSetOutput.java:44)
at com.svg.core.process.abc.ABCSetProcess.process(ABCSetProcess.java:67)
at com.svg.core.process.Process.execute(Process.java:43)
at com.svg.core.process.Process.execute(Process.java:56)
at com.svg.core.process.Connector.run(Connector.java:130)
at com.svg.core.process.Connector.process(Connector.java:124)
at com.svg.core.process.abc.ABCSetConnector.process(ABCSetConnector.java:23)
at com.svg.core.process.AbstractConnector.run(AbstractConnector.java:82)
at com.svg.core.process.abc.ABCConnector.process(ABCConnector.java:30)
at com.svg.core.process.AbstractConnector.run(AbstractConnector.java:82)
at com.svg.core.process.syncdb.SyncConnector.process(SyncConnector.java:46)
at com.svg.core.process.AbstractConnector.run(AbstractConnector.java:82)
at com.svg.core.task.BatchTask.runConnector(BatchTask.java:55)
at com.svg.core.task.AbstractTask.run(AbstractTask.java:172)
at java.lang.Thread.run(Thread.java:662)
This is a printer-friendly version of Article 317387 and may be out of date. For the latest version click CS317387