My Oracle Support Banner

startSqlImport: ORA-01776 Error When Run On Tables With Read-only Properties (Doc ID 2228518.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Commerce Platform - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to use startSQLImport on a customCatalog that contains read-only properties, startSQLImport fails with the following exception:

CONTAINER:atg.adapter.gsa.sqlimport.ImportException; SOURCE:CONTAINER:atg.adapter.gsa.sqlimport.ImportException; SOURCE:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLSyntaxErrorException: ORA-01776: cannot modify more than one base table through a join view
Error /atg/epub/sqlimport/SQLImportService
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.SQLImporter.addError(SQLImporter.java:1804)
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.SQLImporter.addErrors(SQLImporter.java:1838)
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.SQLImporter.doCheckouts(SQLImporter.java:2227)
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.SQLImporter.doImport(SQLImporter.java:1991)
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.SQLImporter.execute(SQLImporter.java:1328)
Error /atg/epub/sqlimport/SQLImportService at com.atg.epub.sqlimport.SQLImportCoordinator.invokeSqlImporter(SQLImportCoordinator.java:53)
Error /atg/epub/sqlimport/SQLImportService at com.atg.epub.sqlimport.SQLImportCoordinator.execute(SQLImportCoordinator.java:30)
Error /atg/epub/sqlimport/SQLImportService at com.atg.service.BasicScheduledService.taskToExecute(BasicScheduledService.java:9)
Error /atg/epub/sqlimport/SQLImportService at com.atg.epub.sqlimport.SQLImportScheduledService.callSuperTaskToExecute(SQLImportScheduledService.java:18)
Error /atg/epub/sqlimport/SQLImportService at com.atg.epub.sqlimport.SQLImportScheduledService.taskToExecute(SQLImportScheduledService.java:10)
Error /atg/epub/sqlimport/SQLImportService at com.atg.service.AbstractScheduledService.doScheduledTask(AbstractScheduledService.java:31)
Error /atg/epub/sqlimport/SQLImportService at atg.service.scheduler.SingletonSchedulableService.performScheduledTask(SingletonSchedulableService.java:253)
Error /atg/epub/sqlimport/SQLImportService at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:479)
Error /atg/epub/sqlimport/SQLImportService at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:780)
Error /atg/epub/sqlimport/SQLImportService Caused by :CONTAINER:atg.adapter.gsa.sqlimport.ImportException; SOURCE:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLSyntaxErrorException: ORA-01776: cannot modify more than one base table through a join view
Error /atg/epub/sqlimport/SQLImportService
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.BatchCheckoutSQL.execute(BatchCheckoutSQL.java:152)
Error /atg/epub/sqlimport/SQLImportService at atg.adapter.gsa.sqlimport.SQLExecutorThread.run(SQLExecutorThread.java:101)
Error /atg/epub/sqlimport/SQLImportService at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
Error /atg/epub/sqlimport/SQLImportService at java.util.concurrent.FutureTask.run(FutureTask.java:262)
Error /atg/epub/sqlimport/SQLImportService at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
Error /atg/epub/sqlimport/SQLImportService at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
Error /atg/epub/sqlimport/SQLImportService at java.lang.Thread.run(Thread.java:745)

 

 

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
Cause
Solution
References


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