Last news: 
Now, I'v only this error in the log :

2022-06-07 10:40:09.016 ** ERROR ** [V9.5.4] Erreur simulation - Impossible de créer la base de données

even with Script log... 

I can see the new databases in postgresql : 

                                          Liste des bases de données
       Nom       | Propriétaire  | Encodage | Collationnement | Type caract. |         Droits d'accès
-----------------+---------------+----------+-----------------+--------------+---------------------------------
 postgres        | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =T/postgres                    +
                 |               |          |                 |              | postgres=CTc/postgres
 projeqtortest   | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   | projeqtortest=CTc/projeqtortest
 simu_boexgt     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_ktuvcf     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_lljiyz     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_ugmhds     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_ycyjzz     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 template0       | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =c/postgres                    +
                 |               |          |                 |              | postgres=CTc/postgres
 template1       | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =Tc/postgres                   +
                 |               |          |                 |              | postgres=CTc/postgres
 template1_old   | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | postgres=CTc/postgres

And I can create table with my user in the simu database... so why It's not working ? 
 

To use the simulation feature, DB user muwt have rights to create new DB "with grant options"

Hi,
Thanks for your answer but the DB user called "projeqtortest" has already the good rights, see : 

postgres-# du+
                                                      Liste des rôles
  Nom du rôle  |                                    Attributs                                    | Membre de | Description
---------------+---------------------------------------------------------------------------------+-----------+-------------
 postgres      | Superutilisateur, Créer un rôle, Créer une base, Réplication, Contournement RLS | {}        |
 projeqtortest | Superutilisateur, Créer un rôle, Créer une base, Réplication, Contournement RLS | {}        |

postgres-# l
                                          Liste des bases de données
       Nom       | Propriétaire  | Encodage | Collationnement | Type caract. |         Droits d'accès
-----------------+---------------+----------+-----------------+--------------+---------------------------------
 postgres        | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =T/postgres                    +
                 |               |          |                 |              | postgres=CTc/postgres
 projeqtortest   | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   | projeqtortest=CTc/projeqtortest
 simu_lnbcdk     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |

Thanks for your help,

Best regards,
Florian

Hi,

I see in your log a DB called 'simu_lnbcdk'.
Was it present before the clone process ?
If not, it means the process correctly creates the DB, but an error occurs somewhere else
(all DB population is in the same try / catck block so any other error will raise same error message)

We'll add some extra debugging code in V9.5.5 to help debug this point.

Hi,
The DB called "simu__lnbcdk" was well created by ProjeQtOr, it wasn't here befor. 

Thanks for extra debugging, I hope we will see the issue with that. 

Wait & see... 

Florian

Hi,
I've installed the last version 9.5.5 and we can see this error in log : 

2022-06-15 15:20:06.890 ===== TRACE ===== first_test - Début de création de l'environnement
2022-06-15 15:20:06.894 ===== TRACE ===== first_test - Début de la copie de la base de données simu_nbedig
2022-06-15 15:20:06.894 ----- DEBUG -----  => Create Database simu_nbedig
2022-06-15 15:20:07.048 ----- DEBUG -----  => Connect to new DB simu_nbedig
2022-06-15 15:20:07.067 ----- DEBUG -----  => Create Table accessprofile
2022-06-15 15:20:07.073 ----- DEBUG -----  => Create Table accessright
2022-06-15 15:20:07.102 ----- DEBUG -----  => Create Table accessscope
2022-06-15 15:20:07.107 ----- DEBUG -----  => Create Table accessscopespecific
2022-06-15 15:20:07.112 ----- DEBUG -----  => Create Table action
2022-06-15 15:20:07.117 ----- DEBUG -----  => Create Table activity
2022-06-15 15:20:07.129 ----- DEBUG -----  => Create Table activityprice
2022-06-15 15:20:07.134 ----- DEBUG -----  => Create Table activityworkunit
2022-06-15 15:20:07.138 ----- DEBUG -----  => Create Table affectation
2022-06-15 15:20:07.145 ----- DEBUG -----  => Create Table alert

[... many create Table lines after....] 

2022-06-15 15:20:09.125 ----- DEBUG -----  => Create Table workflowstatus
2022-06-15 15:20:09.146 ----- DEBUG -----  => Create Table workperiod
2022-06-15 15:20:09.155 ----- DEBUG -----  => Create Table worktoken
2022-06-15 15:20:09.161 ----- DEBUG -----  => Create Table worktokenclientcontract
2022-06-15 15:20:09.167 ----- DEBUG -----  => Create Table worktokenclientcontractwork
2022-06-15 15:20:09.172 ----- DEBUG -----  => Create Table worktokenmarkup
2022-06-15 15:20:09.179 ----- DEBUG -----  => Create Table workunit
2022-06-15 15:20:09.181 ----- DEBUG -----  => Execute script to create all tables
2022-06-15 15:20:09.239 ** ERROR ** [V9.5.5] Erreur simulation - Impossible de créer la base de données
2022-06-15 15:20:09.239 ** ERROR ** [V9.5.5] SQLSTATE[42703]: Undefined column: 7 ERREUR:  la colonne « id » de la relation « accessprofile » n'existe pas

Thanks for help. 

Best regards,
Florian

It seems the user, that created the DB, cannot create tables on the DB.

The user "projeqtortest" can create table. If I use psql with this user on the DB "simu_lnbcdk", I can create a table intituled "test" : 

projeqtortest=# c simu_lnbcdk
Connexion SSL (protocole : TLSv1.3, chiffrement : TLS_AES_256_GCM_SHA384, bits : 256, compression : désactivé)
Vous êtes maintenant connecté à la base de données « simu_lnbcdk » en tant qu'utilisateur « projeqtortest ».
simu_lnbcdk=# create table test (col_test varchar(20));
CREATE TABLE
simu_lnbcdk=# select * from test;
 col_test
----------
(0 ligne)

simu_lnbcdk=# dt
             Liste des relations
    Schéma     | Nom  | Type  | Propriétaire
---------------+------+-------+---------------
 projeqtortest | test | table | projeqtortest
(1 ligne)

I tested creating the access profile of the table with the database table script projeqtortest which is as follows: 

CREATE TABLE IF NOT EXISTS projeqtortest.accessprofile
(
    id integer NOT NULL DEFAULT nextval('accessprofile_id_seq'::regclass),
    name character varying(100) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    description text COLLATE pg_catalog."default" DEFAULT NULL::character varying,
    idaccessscoperead numeric(12,0) DEFAULT NULL::numeric,
    idaccessscopecreate numeric(12,0) DEFAULT NULL::numeric,
    idaccessscopeupdate numeric(12,0) DEFAULT NULL::numeric,
    idaccessscopedelete numeric(12,0) DEFAULT NULL::numeric,
    sortorder numeric(3,0) DEFAULT NULL::numeric,
    idle numeric(1,0) DEFAULT '0'::numeric,
    isnonproject numeric(1,0) DEFAULT 0,
    isextended numeric(1,0) DEFAULT 0,
    CONSTRAINT accessprofile_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

And I get this error : 

ERREUR:  la relation « accessprofile_id_seq » n'existe pas
LIGNE 3 :     id integer NOT NULL DEFAULT nextval('accessprofile_id_se...

I've tried to create sequence with script of projeqtortest's database which is as follow : 

CREATE SEQUENCE IF NOT EXISTS projeqtortest.accessprofile_id_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1
    OWNED BY accessprofile.id;

And I get this error : 

ERREUR:  la relation « accessprofile » n'existe pas

I have to delete the last line "OWNED BY accessprofile.id" If I want to succeed in creating the sequence. 
After, I can create the table  accessprofile without error. 

I hope that could be help you to resolve this issue. 

EDIT: Of course, I can create sequences & functions with projeqtortest user. 

Florian

I've got this problem too... 
I cannot delete a simulation database:

2022-06-16 17:10:07.585 ===== TRACE ===== Début de suppression d'un environnement de simulation - base test
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] ERROR **
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] on file '/var/www/html/projeqtor/model/DataCloning.php' at line (1102)
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] cause = Undefined variable: connexion
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Undefined variable: connexion in DataCloning.php at line 1102
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Error while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] EXCEPTION **
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] on file '/var/www/html/projeqtor/model/DataCloning.php' at line (986)
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] cause = Call to a member function exec() on null
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] => #0 /var/www/html/projeqtor/tool/cronExecutionStandard.php (157) -> deleteDataCloning()
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] => #1 /var/www/html/projeqtor/model/Cron.php (547) -> dataCloningCheckRequest()
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] => #2 /var/www/html/projeqtor/tool/cronRun.php (33) -> run()
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Call to a member function exec() on null
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Exception while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] CRON abnormally stopped

Hi,

Last issue is different, you just cannot connect to the db with credentials.

Hi,

I have installed the V10 (congratulations for better performances ! ) and I always have the same issue: 

2022-06-22 11:50:03.832 ----- DEBUG -----  => Create Table workperiod
2022-06-22 11:50:03.839 ----- DEBUG -----  => Create Table worktoken
2022-06-22 11:50:03.844 ----- DEBUG -----  => Create Table worktokenclientcontract
2022-06-22 11:50:03.850 ----- DEBUG -----  => Create Table worktokenclientcontractwork
2022-06-22 11:50:03.854 ----- DEBUG -----  => Create Table worktokenmarkup
2022-06-22 11:50:03.859 ----- DEBUG -----  => Create Table workunit
2022-06-22 11:50:03.860 ----- DEBUG -----  => Execute script to create all tables
2022-06-22 11:50:04.583 ** ERROR ** [V10.0.0] Erreur simulation - Impossible de créer la base de données
2022-06-22 11:50:04.583 ** ERROR ** [V10.0.0] SQLSTATE[42703]: Undefined column: 7 ERREUR:  la colonne « id » de la relation « accessprofile » n'existe pas

Best regards,
Florian

OK,
So our technical improvment on V10 about UTF8 is not enough.
We keep the ticket open for further investigation.

Thanks for testing.

Hi,
My error is linking about UTF8 ? 
In any case, I already like the improvements made concerning the performance of the application. 
This will help me get my company approved for using this app.

Best regards,
Florian

My error is linking about UTF8 ? 

Sorry , mismatch with other post.
Your issue have nothing to do with UTF8.
It's about rights on DB.
DB user must have rights to : create the DB, connect to the new DB, create tables on the new DB.
He new to have credentials "with grant options"

Hi,
Always same issue with 10.0.0.1
Even if my DB user "projeqtortest" is SUPERUSER with all privileges (see previsous posts)
If I create DB manually with projeqtortest, I can connect and create objects in ma new database...
So I don't understand ?
How to realise this simulation ? Where I can found this code in projeqtor ?

Thanks for your help,
Florian

Hi there,
I have always the same issue with 10.0.3... 

I don't know... What rights should I give to the PostgreSQL projeqtortest user, please?
Because my projeqtortest user is SUPER USER with all rights 
When I'm login manualy with this user on postgresql instance, I can create databases & tables & sequences & functions...  

Can you tell me where I can found the code in projeqtor which execute the sql ? 

Thank you so much,

Best regards,
Florian

Hi,
I search in DataCloning.php and I have found this line 577: 

 SELECT column_name , data_type , column_default, is_nullable, character_maximum_length, numeric_precision, numeric_scale
                   FROM information_schema.columns
                   WHERE table_schema = 'public' AND table_name = '$tableName'
                   ORDER BY ordinal_position";

It is a part of the issue because my projeqtor Database is not on public schema but on "projeqtortest" schema ! 

If I execute this request, I get 0 rows.
If I execute with "projeqtortest" schema, I get rows (of course with replace $tableName by a good name like 'accessprofile') 
Is there possible to get a variable in parameter file to configure schema name with PostgreSQL, please ? 

Even after modify this request with "projeqtortest" in the file, I get always error in projeqtor. I think there is others line to modify with it... 
 

Hi,
We'll have a look.
Ticket #6381 recorded

Hi, 

I've updated ProjeQtOr to 10.0.4, and always the same issue (with paramDbSchema='projeqtortest' in parameters.php): 

2022-08-12 09:30:03.712 ===== TRACE ===== test_10.0.4 - Début de création de l'environnement
2022-08-12 09:30:03.741 ===== TRACE ===== test_10.0.4 - Début de la copie de la base de données simu_zdpykb
2022-08-12 09:30:03.742 ----- DEBUG ----- => Create Database simu_zdpykb
2022-08-12 09:30:03.998 ----- DEBUG ----- => Connect to new DB simu_zdpykb
2022-08-12 09:30:04.045 ----- DEBUG ----- => Create Table accessprofile
2022-08-12 09:30:04.068 ----- DEBUG ----- => Create Table accessright
2022-08-12 09:30:04.118 ----- DEBUG ----- => Create Table accessscope
2022-08-12 09:30:04.124 ----- DEBUG ----- => Create Table accessscopespecific
2022-08-12 09:30:04.130 ----- DEBUG ----- => Create Table action
2022-08-12 09:30:04.136 ----- DEBUG ----- => Create Table activity
2022-08-12 09:30:04.150 ----- DEBUG ----- => Create Table activityprice
2022-08-12 09:30:04.156 ----- DEBUG ----- => Create Table activityskill
2022-08-12 09:30:04.161 ----- DEBUG ----- => Create Table activityworkunit
2022-08-12 09:30:04.166 ----- DEBUG ----- => Create Table affectation
2022-08-12 09:30:04.173 ----- DEBUG ----- => Create Table alert
2022-08-12 09:30:04.178 ----- DEBUG ----- => Create Table approvalstatus
2022-08-12 09:30:04.183 ----- DEBUG ----- => Create Table approver
2022-08-12 09:30:04.188 ----- DEBUG ----- => Create Table asset
2022-08-12 09:30:04.193 ----- DEBUG ----- => Create Table assetcategory
2022-08-12 09:30:04.198 ----- DEBUG ----- => Create Table assignment
2022-08-12 09:30:04.221 ----- DEBUG ----- => Create Table assignmentrecurring

[...]

2022-08-12 09:30:06.247 ----- DEBUG ----- => Create Table weightmode
2022-08-12 09:30:06.253 ----- DEBUG ----- => Create Table work
2022-08-12 09:30:06.329 ----- DEBUG ----- => Create Table workcommand
2022-08-12 09:30:06.340 ----- DEBUG ----- => Create Table workcommandbilled
2022-08-12 09:30:06.346 ----- DEBUG ----- => Create Table workcommanddone
2022-08-12 09:30:06.352 ----- DEBUG ----- => Create Table workelement
2022-08-12 09:30:06.358 ----- DEBUG ----- => Create Table workflow
2022-08-12 09:30:06.365 ----- DEBUG ----- => Create Table workflowprofile
2022-08-12 09:30:06.372 ----- DEBUG ----- => Create Table workflowstatus
2022-08-12 09:30:06.390 ----- DEBUG ----- => Create Table workperiod
2022-08-12 09:30:06.399 ----- DEBUG ----- => Create Table worktoken
2022-08-12 09:30:06.407 ----- DEBUG ----- => Create Table worktokenclientcontract
2022-08-12 09:30:06.413 ----- DEBUG ----- => Create Table worktokenclientcontractwork
2022-08-12 09:30:06.420 ----- DEBUG ----- => Create Table worktokenmarkup
2022-08-12 09:30:06.426 ----- DEBUG ----- => Create Table workunit
2022-08-12 09:30:06.428 ----- DEBUG ----- => Execute script to create all tables
2022-08-12 09:30:06.607 ** ERROR ** [V10.0.4] Erreur simulation - Impossible de créer la base de données
2022-08-12 09:30:06.607 ** ERROR ** [V10.0.4] SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « id » de la relation « accessprofile » n'existe pas


                                                                                                	
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs

"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do."  ~ Think Different
                                                                        

                                                        
 
                                                    
	                                        

The CREATE DATABASE failed.
You must use superuser account or give projeqtor user rights '

CREATEDB'

My user already has the CREATEDB rights. 
But, after reboot, I finally have the cloned environnment named "WhqIDk" ! 

But I have another issue  when I click on "Go to this cloned environnment" button, I get : 

 ERROR *
parameter file not found at '../../projeqtor_data/files/config/parameters_WhqIDk.php'
Check file '/tool/parametersLocation.php' or remove it to use '/tool/parameters.php'.

If problem persists, you may get some help at the forum at ProjeQtOr web site .

But I have this file: 

srvphp:/var/www/projeqtortest/projeqtor# ls -l /var/www/projeqtortest/projeqtor_data/files/config/
total 12
-rwxrwxrwx 1 www-data www-data 1256  2 mai   11:37 index.php
-rw-r--r-- 1 www-data www-data  634 12 août  09:21 parameters.php
-rw-r--r-- 1 www-data www-data  658 17 août  15:24 parameters_WhqIDk.php

Thanks,
Florian
 

After editing  with absolute path instead of relative path in parametersLocation.php and simulation parameters.php I can acces to the simulation environnment 🙂 ! 

 It is more practice to have relative path in conf files but it is a problem to projeqtor obviously. 

Best regard,
Florian