We have sometimes issues with schema generation and/or compilation.
When we update the system (for example 8.0.0 to 8.0.1) , we can easily find the logs related to generating schemas in the update logs.
But when in "normal conditions", which logs (log names) both in the web app and in the logs folders on Windows should we looking at (to follow progress, to identify any issues) when:
1. Generating schemas
2. Compiling
Any other way to (console debug) to troubleshoot these 2 scenarios ?
All needed application logs for shema generation and compilation can be found in the folder C:\Windows\Temp\Creatio folder. You need to restore the logs and make the following query for your list:
PostgreSQL: Select * from "tablename" where "Logger"='Build' order by "Date" desc limit 200
MSSQL: Select top 200 * from "tablename" (nolock) where Logger"='Build' order by "Date" desc
Yes we know we can find all the application logs in that folder.
There are multiple different logs. Concerning schema generation and compilation, we have find a couple different ones showing up in the past, not always all of them, which sometimes show up after quite a while of generating, and it's hard to say if we need to let the system running or if the system is just stuck...
Please let me reiterate the question: ..... Could you share two full list of of possible application logs file names [for all 3 DBs : MSSQL, PostgreSQL & Oracle] pertaining to:
1. Schema Generation (for example if you just click on "Generate all schemas") and
2. Compilation (if you click on "Compile all")
Thank you for the SQL scripts:
1) Can you share the script for Oracle ?
(yes, their is a 3rd database that you support.. and if not possible to do it with Oracle, indicate specifically that there no script possible. We never know if it is not possible with Oracle, if you forget to provide the information, the latter happens more often)
2) I can be mistaken here: doesn't the table the "build" only show "compilation" information, not schema generation ? For example, if we only do a schema generation (no compilation), will we find information there ?
Full generation is needed to build links between
configuration items. Items can be objects and schemas or
links between packages and their dependencies.
Full generation links them.
Compilation, in addition to its main purpose also generates
source files along the /src path which are necessary when
working with no-code elements and allow you to create an
instance between an object and a table in the DB.
Full generation is needed to build links between
configuration items. Items can be objects and schemas or
links between packages and their dependencies.
Full generation links them.
Compilation, in addition to its main purpose also generates
source files along the /src path which are necessary when
working with no-code elements and allow you to create an
instance between an object and a table in the DB.
We trigger Generate source code for all items on our on-premise system. But upon checking "\Pkg\[Our Custom Package]\Schemas" in our local directory some schemas were missing what could be the problem? Most of our source code schemas were not generated.
Please try to perform the following actions in configurations:
1. Update database structure where needed.
2. Generate source code for all items.
3. Compile all items.
4. Flush Redis.
5. Restart the website.
This should help.
In case there appeared errors on the generation or compilation step, please check the logs (usually can be found in C:\Windows\Temp\Creatio\Youre_Site_Name) to find out the reason of such behavior.
