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

Hi,
Is-it possible to have a change in ProjeQtOr concerning relative path in the following conf files which works with simulation ? 
- tool/parametersLocation.php --> variable $parametersLocation
- parameters.php --> variable $logFile

Otherwise, the simulation doesn't work as it is. 

Thanks for your reply in advance. 
After, I can close this topic. 

Best regards,
Florian

Otherwise, the simulation doesn't work as it is. 

Work fine for me with relative path.
What is the error logged ?

Otherwise, the simulation doesn't work as it is. 

Work fine for me with relative path.
What is the error logged ?
 

Hi, 
I have no error logged. Just if I have the path "'../../projeqtor_data/files/config/parameters.php" in my parametersLocation.php of my projeqtortest, I get the error page with cloned environnement : 

 ERROR *
parameter file not found at '../../projeqtor_data/files/config/parameters_NMgZCp.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 .

Because the simulation environnment is under directory "simulation", so the relative_path for this environnement is not good because it should be with "../"  additional.
It is the same issue with log file... 

Maybe there is an additionnal parameter in order to indicate relative path in parameters.php ? 

Thank a lot,

Florian

No, there is no other way than speciying an absolute path.
If you leave simulation path to its defaut, relative path will work, if not an absolute path is mandatory.

Thank a lot,

I can close this topic 🙂

Have a good day !
Florian