next »

[Wee Ting C.]

Hi,

I encountered error code -1329, A database index could not be created for a temporary database table needed for a report.

May I know how to solve this issue as I need the "ORDER BY" in the report. My Genero is in AIX, and the database is Informix Dynamic Server.

Thank you.

Regards,
Cheong Wee Ting

[Rene S.]

Hello,

how to solve this issue? By installing updates or using recent versions of fgl. ;-)

The bug  "FGL-2842: I4GL compatibility: ORDER BY in two-pass report doesn't work when too many variables are used" has been fixed on Tue Oct 18 15:31:19 2011 in version 2.33.00.

The runtime is no more creating an index for a temporary database table needed for a report.

Rene

[Wee Ting C.]

Thanks Rene. I will inform my vendor and administrator.

Regards,
Cheong WT

[Wee Ting C.]

Rene or Anyone,

While waiting for the Genero to be upgraded into higher version, and we are still using Genero v2.02, is there any other solutions to overcome the -1329 error code?

Thank you.

Regards,
Cheong WT

[Reuben B.]

First of all, you say Genero 2.02.  That was released in 2006.  To give you some idea of how old that is, Windows XP was the latest release of Windows, and iPhone had not been invented yet.  It is unlikely that any of the servers that Genero 2.02 was supported on are still supported by their manufacturers.  You say AIX, latest AIX that Genero 2.02 was supported on was AIX 6.1 and I think that End of Support date was 30th April 2017. 

I would strongly recommend you (or anyone else reading this in a similar position) consider upgrading to latest 3.10 version.

(a reminder that supported systems documentation can be found with the Documentation download for recent releases, and for older releases in the Archived Releases area on the Product or Documentation downloads page of our website).

With regards your question, do you need to being using ORDER BY?  A common error developers make is to use the same ORDER BY clause in their SQL statement that gets the data for the report, and in the definition of the REPORT.  End result, is you end up sorting the data twice into the same order.  To avoid this unnecessary processing, in your REPORT you can use the ORDER EXTERNAL BY clause ...

http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_reports_Two_Pass_Reports.html
http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_reports_The_ORDER_BY_Section.html

... and thus a temporary database table does not need to be created.

You can also check some of the other possible causes listed alongside the 1329 error in the documentation http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/r_fgl_errors_001.html (index name already used, no diskspace, open file limit)

Finally why did the error start occurring now.  Are you writing a new report, or modifying an existing report?  Did you perhaps go from 8 to 9 values in the ORDER CLAUSE.

Reuben

[Wee Ting C.]

Reuben,

We are aware of the Genero updating. But we have too many clients across the Campus and country. Since then, we still using v2.02.

Yes, it is a new report, which is for process verification. I will see what can I do to overcome this issue.

Thank you.

Regards,
Cheong WT