APOLLO & ECW/JP2 Discussions

Wondering how others have configured their ERDAS APOLLO server or what data they are crawling? The ERDAS APOLLO Discussion board is a place to find information, share ideas and more. Join the community, connect, contribute and share.
Showing results for 
Search instead for 
Do you mean 
Reply
Occasional Contributor
Posts: 7
Registered: ‎11-21-2016

ERDAS Apollo 2016 Core Console - Sort by Name or Title - error

[ Edited ]

Hi,

 

the 'Sort by Name' or 'Title' is not working in the ERDAS Apollo 2016 Core Console.

The log file  contains entries like this:

 

2017-06-27 10:25:32:623 [139640258426624] ERROR com.erdas.iws.database - GetChildVirtualDatasets Query::prepare of query 'SELECT FullName, VirtualMosaicZIndex FROM Folder WHERE ParentFolderID=34 UNION SELECT FullName, VirtualMosaicZIndex FROM Dataset WHERE FolderID=34 ORDER BY CapabilitiesTitle DESC' failed. Details: ERROR:  column "capabilitiestitle" does not exist
LINE 1: ...aicZIndex FROM Dataset WHERE FolderID=34 ORDER BY Capabiliti...
                                                             ^
(42703) QPSQL: Unable to prepare statement
2017-06-27 10:25:45:080 [139640258426624] ERROR com.erdas.iws.database - GetChildVirtualDatasets Query::prepare of query 'SELECT FullName, VirtualMosaicZIndex FROM Folder WHERE ParentFolderID=34 UNION SELECT FullName, VirtualMosaicZIndex FROM Dataset WHERE FolderID=34 ORDER BY CapabilitiesName DESC' failed. Details: ERROR:  column "capabilitiesname" does not exist
LINE 1: ...aicZIndex FROM Dataset WHERE FolderID=34 ORDER BY Capabiliti...
                                                             ^
(42703) QPSQL: Unable to prepare statement

 

I tried to add capabilitiestitle and capabilitiesname columns with the values of capstitle and capsname to the dataset table but that ony resulted in warnings like:

 

 

2017-06-27 10:25:22:254 [139640258426624] WARN  com.erdas.iws.database - Load Found unknown field 'capabilitiestitle'.
2017-06-27 10:25:22:254 [139640258426624] WARN  com.erdas.iws.database - Load Found unknown field 'capabilitiesname'.

 

so to me it looks like com.erdas.iws.database needs to be updated with the current column names. Does anyone have a workaround for this?

 

My installation details:

 

ERDAS APOLLO Essentials 2016
Version: 16.0.0. Build: 1103
Linux(x86_64)
Database: PostgreSQL

Kind Regards,

Sirko