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' and 'Sort by Title' - error

Hi,

 

The 'Sort by Name' and 'Sort by Title' functions at the console are not working correctly. I'll the the following errors:

 

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 adn capsname  to the dataset table but that only resulted in below warnings:

 

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'.

 

Does anyone here know of a solution or workaround for this problem? To me it looks like com.erdas.iws.database neesd to be updated with the current column names.

 

My installation details are:

 

ERDAS Apollo Essentials 2016 (EP02)
Version: 16.0.0 Build: 1103
Linux (x86_64)
Database: PostgreSQL

 

Kind Regards,

Sirko

Moderator
Moderator
Posts: 350
Registered: ‎11-16-2015

Re: ERDAS Apollo 2016 Core Console 'Sort by Name' and 'Sort by Title' - error

Hi Sirko,

 

It looks like a bug.

Is it a migration from a previous release or it is a new install?

Please contact the support to report that.

Regards,

 

Florent

Occasional Contributor
Posts: 7
Registered: ‎11-21-2016

Re: ERDAS Apollo 2016 Core Console 'Sort by Name' and 'Sort by Title' - error

Hi Florent,

 

its a migration from 2016 EP01, but the sortring wasn't working there either correctly.

 

Kind Regards,

Sirko

Highlighted
Moderator
Moderator
Posts: 350
Registered: ‎11-16-2015

Re: ERDAS Apollo 2016 Core Console 'Sort by Name' and 'Sort by Title' - error

And was it a migration from a previous release (2015, etc.)?