Access violation when opening an existing index that is linked to an Oracle database

SYMPTOMS

When you access a Web Client that contains an index that is linked to an Oracle database you observe following error: "ZyNET error This application generated an access violation at address 0x6000F206 (reading address 0x00000008)".

(The memory reading-address could be different per installation/configuration).

CAUSE

The Index database module connection and WebClient are not (correctly) updated after an Information Management Platform upgrade as the Oracle10g.xml SQL dialect value is not applied anymore in Information Management Platform 6.4 (Service Pack 1).

RESOLUTION

• Modify the ADO.xml file of each databasefields index with an Oracle connection.
• The ADO.xml can be found in the  .\ZyLAB Data\Indexes\<Indexname> folder of the index that contains the database fields module.

(example)

<parameter id="SQL_DIALECT">Oracle10g.xml</parameter>
 change it to:  
<parameter id="SQL_DIALECT">Oracle11g.xml</parameter>

and set CaseSensitivKeyFields to false:

<parameter id="CaseSensitivKeyFields">False</parameter>

APPLIES TO

6.4; 6.4 SP1