Solution can't be imported

Questions and answers for all installation-related topics for Servoy products

Solution can't be imported

Postby cuoredisardegna » Sun Apr 09, 2017 7:13 pm

Hi to All,

could SomeOne of You resolve this problem?

While importing a solution on servoy 7 I see this error message:

Could not import solution: org.postgresql.util.PSQLException: ERRORE: la precisione di NUMERIC (65531) deve essere compresa fra 1 e 1000
Posizione: 1181


Tanks in advance.

Gianni Pinna
cuoredisardegna
 
Posts: 63
Joined: Mon May 07, 2012 5:34 am

Re: Solution can't be imported

Postby Bernd.N » Mon Apr 10, 2017 10:21 am

Google translates: "the precision of NUMERIC (65531) must be between 1 and 1000"
It seems postgres has problems in creating a numeric field.

How did you create the numeric fields in your tables?
The usual way with help of the Servoy table editor, or directly in postgres and then with "Synchronize with DB server..." ?
Are there any "unusual" numeric fields in your tables?

Try
Code: Select all
SELECT * FROM information_schema.columns

to get all fields of your database and put that into a new temporary table with SELECT INTO...
There is a field "numeric_precision" in that table.
Sort the complete table by that field und you might see the column that creates the problem.

num.png
num.png (44.04 KiB) Viewed 717 times
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 474
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Solution can't be imported

Postby cuoredisardegna » Thu Apr 13, 2017 4:25 pm

Hi Bernd,
sincerly tank You for Your luminous suggest, that I have seen today.

But there is a problem in the problem.
I hope that You can resolve.
I do not know how to execute Your query in order to see the column that creates the problem: the laptop in wich the source DB was working crashed.
I can connect to anoter lap_top only the old hard_disk with USB cable.
So I don't know if there is a possibility to import the source DB from old hard disk to the new lap_top.
I Know that it can seem a trivial problem: I excuse.
Tanks again and in advance.

Gianni Pinna
cuoredisardegna
 
Posts: 63
Joined: Mon May 07, 2012 5:34 am

Re: Solution can't be imported

Postby Bernd.N » Thu Apr 13, 2017 5:05 pm

Hi Gianni,
I would ask a hardware expert for this task.
Maybe it is possible to start postgres on the old hard_disk from outside, if not a hardware expert could mount the old hard_disk to a new computer and then start it as usual.
As long as the old hard disk did not crash itself that should be possible.

I do not know how to get a postgres DB back when you have only the files left and can not get the original postgres system to run.
It should be possible, but that would be a task for a postgres expert.
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 474
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Solution can't be imported

Postby cuoredisardegna » Sat Apr 15, 2017 2:18 pm

Hi Bernd,
tank to Your suggestion I could resolve.

Tank You, humbly.
Happy Easter, Bernd.
Gianni Pinna
cuoredisardegna
 
Posts: 63
Joined: Mon May 07, 2012 5:34 am


Return to Installation

Who is online

Users browsing this forum: No registered users and 4 guests

cron