1. Mauricio Pulla
  2. Valentina Reports ADK
  3. Среда, Июль 31 2019, 04:42 PM
  4.  Подписаться через email
Xojo 2019 r1 and Valentina 9.3.2 blank reports

I did a migration of Valentina report 6 to 9.3.2, you can see the reports from Valentina Studio (they have problems with the fields when they have can_grow, I am waiting for an arrangement), but when executing the reports from an application with Xojo 2019 R1, the reports are blank.

I am using the ValentinaPlugin.xojo_plugin plugins that comes with Valentina Studio 9.3.1 64 bits.

How to fix the problem of blank reports?

I have Xojo 2019 r1, Valentina Report 9.3.2, Valentina Studio 9.3.1 and postgresql 11.4 64 bit

Regards
Mauricio
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Mauricio,

Could you please add a screenshot of a problem with can_grow?

About a Xojo problem.
It is a local project, everything on Linux, the app is desktop, right?
In Xojo application, did you try to open the same project file and generate the same report that were previously used in the Valentina Studio? Or you used a project file from version 6 without opening in the Valentina Studio?
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
Hello Sergey

The screenshots, please you can see it in this in this link

https://valentina-db.com/en/discussion-forums/6219-migration-for-valentina-6-3-to-valentina-9-3-1-64-bit


The projects are valentina server report 9.3.2 is on a ubuntu 16.4 server.
The applications are desktop for windows, linux and Mac, we also have web applications.


The xojo application opens the same reports as valentina studio in version 9.6.3.

In valentina 6 the reports work.
It is migrated from 6 to 9 to cover this error
https://valentina-db.com/en/discussions/6159-error-in-report-with-groups


Migration to version 9.3.1 was not possible. I had errors, I could not even edit the reports with Valentina study (the error is explained in the first link), they recommended me to go to version 9.3.2, something must be wrong.

Regards
Mauricio
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Did you try to turn OFF and then ON the can_grow property? No difference?

What if you preview this report, but check Borders and Warning options on the Profile tab, like on the screenshot.
What will you get?
Вложения
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
Hello Sergey

<<Did you try to turn OFF and then ON the can_grow property?
Yes

<< No difference?
Any

<<What if you preview this report, but check Borders and Warning options on the Profile tab, like on the screenshot.
<<What will you get?

Can_grow does not work.

Regards.
Mauricio
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Mauricio,

Unable to reproduce it yet, maybe it's something in data that the sizes are not measured for can_grow, but it worked in 6.3.

What if you create a new test report with just one of these fields, with can_grow option.
Will you get the same result?

==
What about Xojo - is empty PDF generated for this report with can_grow problem?
Did you try to execute it in Xojo - maybe there is some exception?
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
Hello Sergey.

I will be absent until next 2019-08-05.
Please if you have more suggestions to try.

<<What about Xojo - is empty PDF generated for this report with can_grow problem?
Everyone


<<Did you try to execute it in Xojo - maybe there is some exception?
Si no tengo exception.

Regards.
Mauricio
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Please try to generate a report from Xojo app and add the latest logfile from /opt/VServer/vlogs.
Maybe there will be some pointers on why the generated report is empty.
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
Hello Sergey

Attached is a screenshot of a new report with the can_grow ON property.

I get the data from postgreql 11.04 on ubuntu the field that can_grow has is character varying.

From Valentina Studio, export to pdf, the pdf is blank

Attached log, remove the log header, if you need it I would like to send it to you privately

My database has encoding UTF8 and the connection to valentnina is UTF-16 - LittleEndian, maybe there may be the problem.
How do I change the encoding of the connection?

Regards.
Mauricio

It does not allow me to load the .log or .txt file, I copy the content.

2019-08-05 15:10:03.544588 (TID 140323134834880): ERROR: Cannot initialize bonjour service (error code 2887d)
2019-08-05 15:10:06.546964 (TID 140323134834880): ERROR: Cannot initialize bonjour service (error code 2887d)
2019-08-05 15:10:09.558296 (TID 140323134834880): ERROR: Cannot initialize bonjour service (error code 2887d)
2019-08-05 15:10:12.564096 (TID 140323134834880): ERROR: Cannot initialize bonjour service (error code 2887d)

2019-08-05 15:10:12.565000 (TID 140323134834880): VProject facilities are available
2019-08-05 15:10:12.565098 (TID 140323134834880): Server started

2019-08-06 07:18:31.585637 (TID 140322965964544): (UID 19) Connection established with '192.168.1.106:59563'. ( vClient-connections count: '0')
2019-08-06 07:18:31.592854 (TID 140322949179136): (UID 20) Connection established with '192.168.1.106:59564'. ( vClient-connections count: '0')
2019-08-06 07:18:31.630248 (TID 140322940786432): (UID 19) vClient-connection established. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:18:31.635011 (TID 140322940786432): (UID 19) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 07:18:31.637896 (TID 140322932393728): (UID 20) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 07:18:31.639054 (TID 140322965964544): (UID 21) Notification connection established with '192.168.1.106:59568'
2019-08-06 07:18:31.640222 (TID 140322932393728): (UID 20) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 07:18:31.645163 (TID 140322957571840): (UID 20) SqlConnection object created.
2019-08-06 07:18:31.647289 (TID 140322965964544): (UID 19) NotificationCenter object created.
2019-08-06 07:18:31.670251 (TID 140322932393728): (UID 20) Closing vClient-connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:18:31.675136 (TID 140322932393728): (UID 19) SqlConnection object created.
2019-08-06 07:18:37.036114 (TID 140322965964544): (UID 19) Database '(null)' remoteID 1946210256 registered.
2019-08-06 07:18:37.037951 (TID 140322932393728): (UID 19) Database '(null)' remoteID 1946210256 unregistered.
2019-08-06 07:18:37.130442 (TID 140322932393728): (UID 19) Database 'trabajo_proceso.vsp' remoteID 1946210256 registered.
2019-08-06 07:18:37.408598 (TID 140322940786432): (UID 19) Database: trabajo_proceso; User: sa: OK
2019-08-06 07:18:37.410134 (TID 140322965964544): (UID 19) Database: trabajo_proceso; User: sa: OK
2019-08-06 07:26:31.704379 (TID 140322957571840): (UID 29) Connection established with '192.168.1.106:59731'. ( vClient-connections count: '1')
2019-08-06 07:26:31.747914 (TID 140322932393728): (UID 29) Closing connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:30:31.757466 (TID 140322957571840): (UID 33) Connection established with '192.168.1.106:59786'. ( vClient-connections count: '1')
2019-08-06 07:30:31.802741 (TID 140322932393728): (UID 33) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 07:30:31.804056 (TID 140322932393728): (UID 33) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 07:30:31.805563 (TID 140322957571840): (UID 33) SqlConnection object created.
2019-08-06 07:30:31.814123 (TID 140322949179136): (UID 33) Closing vClient-connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:38:31.833089 (TID 140322965964544): (UID 33) Connection established with '192.168.1.106:60500'. ( vClient-connections count: '1')
2019-08-06 07:38:31.877026 (TID 140322940786432): (UID 33) Closing connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:42:31.875213 (TID 140322940786432): (UID 33) Connection established with '192.168.1.106:60807'. ( vClient-connections count: '1')
2019-08-06 07:42:31.920289 (TID 140322949179136): (UID 33) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 07:42:31.921594 (TID 140322949179136): (UID 33) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 07:42:31.923452 (TID 140322940786432): (UID 33) SqlConnection object created.
2019-08-06 07:42:31.931783 (TID 140322957571840): (UID 33) Closing vClient-connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:50:31.949102 (TID 140322965964544): (UID 34) Connection established with '192.168.1.106:61460'. ( vClient-connections count: '1')
2019-08-06 07:50:31.991741 (TID 140322957571840): (UID 34) Closing connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 07:54:32.004638 (TID 140322949179136): (UID 34) Connection established with '192.168.1.106:61881'. ( vClient-connections count: '1')
2019-08-06 07:54:32.047906 (TID 140322932393728): (UID 34) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 07:54:32.048411 (TID 140322932393728): (UID 34) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 07:54:32.049627 (TID 140322949179136): (UID 34) SqlConnection object created.
2019-08-06 07:54:32.053397 (TID 140322965964544): (UID 34) Closing vClient-connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 08:02:32.076051 (TID 140322932393728): (UID 34) Connection established with '192.168.1.106:62569'. ( vClient-connections count: '1')
2019-08-06 08:02:32.119046 (TID 140322949179136): (UID 34) Closing connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 08:03:32.167058 (TID 140322965964544): (UID 34) Connection established with '192.168.1.106:62647'. ( vClient-connections count: '1')
2019-08-06 08:03:32.211652 (TID 140322940786432): (UID 34) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 08:03:32.212790 (TID 140322940786432): (UID 34) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 08:03:32.215816 (TID 140322932393728): (UID 34) Database '(null)' remoteID 1678436112 registered.
2019-08-06 08:03:32.217422 (TID 140322940786432): (UID 34) Database '(null)' remoteID 1678436112 unregistered.
2019-08-06 08:03:32.217665 (TID 140322940786432): (UID 34) Database 'trabajo_proceso.vsp' remoteID 1678436112 registered.
2019-08-06 08:03:35.954119 (TID 140322949179136): (UID 34) Database 'trabajo_proceso.vsp' remoteID 1678436112 unregistered.
2019-08-06 08:03:35.954179 (TID 140322949179136): (UID 34) Closing database 'trabajo_proceso': OK
2019-08-06 08:03:35.963518 (TID 140322949179136): (UID 34) Database 'trabajo_proceso.vsp' has been successfully closed.
2019-08-06 08:03:35.963578 (TID 140322949179136): (UID 34) Database 'trabajo_proceso.vsp' object memory released.
2019-08-06 08:03:35.963627 (TID 140322949179136): (UID 34) Closing vClient-connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 08:06:32.139953 (TID 140322932393728): (UID 34) Connection established with '192.168.1.106:62888'. ( vClient-connections count: '1')
2019-08-06 08:06:32.186450 (TID 140322949179136): (UID 34) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 08:06:32.187853 (TID 140322949179136): (UID 34) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 08:06:32.189771 (TID 140322932393728): (UID 34) SqlConnection object created.
2019-08-06 08:06:32.198499 (TID 140322940786432): (UID 34) Closing vClient-connection. ( vClient-connections count: '1'. Available: 'unlimited')
2019-08-06 08:08:53.387148 (TID 140322965964544): (UID 34) Connection established with '192.168.1.106:63181'. ( vClient-connections count: '1')
2019-08-06 08:08:53.446508 (TID 140322965964544): (UID 34) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 08:08:53.448146 (TID 140322965964544): (UID 34) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 08:08:53.457979 (TID 140322932393728): (UID 34) vClient-connection established. ( vClient-connections count: '2'. Available: 'unlimited')
2019-08-06 08:08:53.459248 (TID 140322932393728): (UID 34) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-08-06 08:08:53.482303 (TID 140322965964544): (UID 34) SqlConnection object created.
2019-08-06 08:14:32.222737 (TID 140322940786432): (UID 35) Connection established with '192.168.1.106:63615'. ( vClient-connections count: '2')
2019-08-06 08:14:32.276267 (TID 140322940786432): (UID 35) Closing connection. ( vClient-connections count: '2'. Available: 'unlimited')
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Mauricio,

If the PDF is blank from within the Valentina Studio, too - it usually means that there are no fonts installed.
Please try to install some standard fonts, like:
sudo apt-get install ttf-mscorefonts-installer
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
Hello Sergey.

The pdf, now has data but the texts are wrong, it is cut, mounted and the fields with can_grow still does not grow.

Regards
Mauricio
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
The fonts most used are courier new, Arial
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Just in case - did you try to restart the system after fonts installation?
Комментарий
There are no comments made yet.
Mauricio Pulla Ответ принят
Hello Sergey

Apparently the problem was solved by restarting the server.
I will continue testing and comment on the results.

Thank you
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories