Page 1 of 1

No possibility to create a report based on postgresql

Posted: Thu May 10, 2018 7:44 pm
by MichalCh
Hi,

I've connected to postgresql database directly and for schema "public" I can retrieve all the columns. But when I click on "preview" (I do not have to put even any data on the report template) there is an error that sort of "relation" does not exists.

I'm attaching two screenshots where you can see clearly what I mean and also a .txt file with two queries so you can easily create yourself and insert some data.

I'm using the newest JS Stimulsoft client.

Hope to hear from you soon!

Best wishes,
Michal Choldrych

Re: No possibility to create a report based on postgresql

Posted: Fri May 11, 2018 7:50 pm
by Edward
Hi Michal,

Thank you for the bug report, do you mind to send us a sample JS test, that reproduces the issue, so we could help in fixing the problem or to provide a required fix.
Sorry about that, but that would be of a great help.

Thank you very much,
Edward
3153380

Re: No possibility to create a report based on postgresql

Posted: Mon May 14, 2018 9:47 am
by tayar
Hi Edward,

The issue is Independent from the Designer version used. I can reproduce same with WPF Designer.
Attached is a sample report.

Best regards
Vitaly

Re: No possibility to create a report based on postgresql

Posted: Mon May 14, 2018 11:06 pm
by Edward
Hi Vitaly,

Thank you for the sample report and your comment. We will update you in this topic and will reply to your email request as well once the solution for the problem is found.
The workaround has been explained here for now:
viewtopic.php?f=8&t=56192

Thank you,
Edward

Re: No possibility to create a report based on postgresql

Posted: Tue May 15, 2018 6:41 am
by tayar
Hi Edward,

There is no workaround on the topic you mentioned. That topic mentions databases other than public.
This one says that even with pubic it does not work

Best regards
Vitaly

Re: No possibility to create a report based on postgresql

Posted: Wed May 16, 2018 5:10 am
by Edward
Hi Vitaly,

Yes, you are correct, that is a slightly different issue, true. Are you using the latest PostGreSql 10.4 and Windows 10 x64? I have done a quick test with that database. With the schema that was mentioned in the above topic.
The report was rendered without any issue. Please check my report attached.
PostgresReport_MyDb.mrt
(6.57 KiB) Downloaded 520 times
I think I need to kindly request the db script to create the database schema that you used for the test you explained and kindly provided the mrt report for us.

Thank you,
Edward

Re: No possibility to create a report based on postgresql

Posted: Wed May 16, 2018 9:37 am
by tayar
Hi Edward,

The designer runs on Windows 10 x64.
The DB is PostgreSQL 9.6.5 on x86_64-pc-linux-gnu (running within docker)

Another interesting observation, the connection string in the report you sent contains
Min Pool Size=0
wich is not recognized in my environment. The data adapter has been automatically downloaded by the designer (Npgsql 2.2.7.0).

Below is a table creation script used for this tests (on the default schema public)

Code: Select all

CREATE TABLE public."Reservation"
(
  "Id" uuid NOT NULL,
  "TenantId" uuid NOT NULL,
  "PropertyId" uuid NOT NULL,
  "Arrival" date,
  "Departure" date,
  "Adults" integer,
  "Children" integer,
  "FirstName" text,
  "LastName" text,
  "Title" text,
  "ReservationStatus" text,
  "VIP" text,
  "Notes" text,
  "RoutingInstructions" text,
  "PurchaseElements" text,
  "InventoryStatus" text,
  CONSTRAINT "PK_Reservation" PRIMARY KEY ("Id")
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public."Reservation"
  OWNER TO postgres;

-- Index: public."idx_Arrival"

-- DROP INDEX public."idx_Arrival";

CREATE INDEX "idx_Arrival"
  ON public."Reservation"
  USING btree
  ("PropertyId", "Arrival");

The report itself is attached to a previous post

Re: No possibility to create a report based on postgresql

Posted: Thu May 17, 2018 6:43 pm
by Lech Kulikowski
Hello,

Please try to use the following query:

Code: Select all

select * from public."Reservation"
Thank you.

Re: No possibility to create a report based on postgresql

Posted: Fri May 18, 2018 7:29 am
by tayar
Hello Lech,

yes, this is correct. This query works. However the query has not been written manually but generated automatically by Stimulsoft designer while selecting the available tables. End user has no idea and knowledge that they need to modify query. Also in our environment they won't know anything about existing schemas

Thanks
Vitaly

Re: No possibility to create a report based on postgresql

Posted: Mon May 21, 2018 7:24 am
by Lech Kulikowski
Hello Vitaly,

We have added this task to our to-do list.

Thank you.