Server: ZABBIX 1.8.4 (Oracle Call Interface)
Server Database: Oracle RDBMS 11.2.0.1
OS: CentOS release 5.5
PHP: 5.1.6-27.el5_5.3
PHP OCI8-Module: 5.1.6-27.el5_5.3 with oracle-instantclient11.2-basic-11.2.0.2.0-1

I havn't chosen a proper priority by mistake.
Because of this issue it's not possible to see historical information of log files or items without integer values via the GUI.

Maybe someone can change the priority to 'Major'.

I think it's not a duplicate of ZBX-3671:

• ZBX-3671 is SQL related.
• this issue seems to be PHP/OCI related.

Yes, these are different issues. I linked them because if we fix one of them, we should also fix the other one. Perhaps I should have expressed that connection in comments, instead of linking.

We can not reproduce this errors. Please apply the attached patch and report back if it helps.

It would be nice to have a screenshot of this error message.

Patch 3693.patch hasn't changed anything (see screenshot 3693.patch.png)

The attached file nls_database_parameters.txt includes the result of:

SQL> select * from nls_database_parameters;

and represents the NLS settings of the database.

Please could you select the same data from the database using sqlplus utility and attach a screenshot? It seems that data in the database is in non-UTF8 encoding, however we expect it to be UTF8. Note that Zabbix writes everything using UTF8 encoding.

See nls_database_parameters-sqlplus_zbxsrv.png for the desired screenshot.
I've installed SQL*Plus on the ZABBIX (GUI-)Server and took the screenshot from that session.

I think I've misunderstood Your request and have replaced the file 'nls_database_parameters-sqlplus_zbxsrv.png' by these two files:

• history_log-gui.png
• history_log-sqlplus.png

Jens, do you have any news? I would appreciate if you could say if the patch helped or not.

The patch didn't solve the issue -the error message disappered but the issue still exist.

The fact that ZABBXIX is able to get the most recent value for the affected items in the "Latest data" let me imagine, that it must hafe to do with the way the data is gathered for the "Hhistory" view.

BTW: I've upgraded ther Server/Web-Frontend to 1.8.6

I've upgraded ther Server/Web-Frontend to 1.8.5 and not to 1.8.6

I've to correct myself again:
The issue exists for text- and log-based history.
The error message about "Lob form missmatch" appears only for Log-based History.

NLS Settings of another run with latest Oracle RDBMS

We've made another run with Oracles latest RDBMS release 11.2.0.2.0 (see nls_database_parameters_2.txt). The error exists with this release too.

Is it possible to get the database parameters of a working test environment?
I begin to suspect PHP....I'll hope to be able to test the GUI with PHP 5.3 soon

See new problems in ZBX-4188 .

Feel free to close this issue. I decided to move Zabbix from Oracle to PostgreSQL and won't further follow this issue.

please reopen if there are further problems with this