Extra field in header returned in Oracle stream

I have a simple program that connects a flexmonster pivot table to an Oracle database. In the table, the data for the given column is wrong. I debugged the response from the compressor and saw that there is an extra field in the header of the oscv stream. The field is the first field whose value is “+,”. This is the root of my problem. Is this a known issue or is there some config I missed.I attached a portion of the oscv stream to illustrate the issu

3 answers

Public
Dmytro Zvazhii Flexmonster November 19, 2018

Hello Paul,
Thank you for writing. The described issue is not a known one.
Could you please specify what server-side technology you are using for connecting to the Oracle database?
Also, it would be nice to have a sample of Oracle table with the sample data for reproducing the issue. 
Waiting to hear from you.
Regards,
Dmytro

Public
Paul Mageau November 19, 2018

Server side web application : Ubuntu, Apache, PHP
Database : Oracle12 , hosted by our IT department. I have no idea what the hosting env is.
The csv file I uploaded is a sample of the Oracle table data. The data is correct, the header produced by compressor isn’t.
 
I was able to reproduce this with a trival table
ID    NAME
1      foo
2      bar
 
and got back this result…as you can see, the +, is superfluous and the header is missing the second column.
___ocsv2___2.6.6/2.213
+,+ID
1,foo
2,bar

Public
Dmytro Zvazhii Flexmonster November 20, 2018

Hello Paul,
Thank you for your prompt response. 
We are going to investigate the issue and fix it, ETA Dec 17.
Could you please also specify which one of PHP compressor methods you were using for compression?
That will be very helpful in our further investigation.
Waiting for your feedback.
Regards,
Dmytro

Please login or Register to Submit Answer