12-13-2018 12:47 PM
we use ERDAS Apollo 2016.
We have two services that include the same ecw file. Except from the service name, the paths are the same and generating an ORA-01427 error.
The sub-query is SELECT ID FROM Folder WHERE FullName='/Folder1/Mosaic1/' and is returning more than one result thus generating the Oracle error.
To me it's a totally normal usage and should not generate an error.
Is there a workaround except modifying the path ?
12-14-2018 12:38 AM
The workflow you describe should work, you can define two services with the same folder/dataset name.
You mean there is a constraint in the Oracle table ("folder") that prevents the query to return more than one result? What are the consequences of that? Can you use the services normally?
Please submit a support ticket so the support team can investigate. I did a quick test with a Postgres install and there is no issue. Maybe this is specific to Oracle or specific to your DB in particular.
12-14-2018 05:48 AM - edited 12-14-2018 05:49 AM
running a subquery that returns more than one record is a legitimate DB error.
Here's the entry in the log :
 ERROR com.erdas.iws.database - NCS::IWS:B:atastore::FolderQueriesQ::GetVMChildren Query::exec of query ' SELECT FullName, VirtualMosaicZIndex FROM Folder WHERE ParentFolderID=(SELECT ID FROM Folder WHERE FullName=:FolderName) AND VirtualMosaic=1 UNION SELECT FullName, VirtualMosaicZIndex FROM Dataset WHERE FolderID=(SELECT ID FROM Folder WHERE FullName=atasetName) ORDER BY VirtualMosaicZIndex ASC' failed. Details:
ORA-01427: sous-requête ramenant un enregistrement de plus d'une ligne)
Thanks for your help.
01-11-2019 01:31 AM
I have tested again and I don't have the issue. Maybe this is related to Oracle or your installation.
Please submit a support ticket so the team can investigate deeper.
01-11-2019 08:50 AM
thanks for your answer.
The problem is that Apollo sends this query (see previous post) which I don't have control over. This query is faulty since it contains a subquery which returns more than one row.
I'm using Apollo 16.00.0000.01202.
Are you using the same version ?