Hello,

Thanks for reaching out. 

To troubleshoot the issues, compilation logs can be found in application logs. In order to get it, please restore it and review the logs list.

Please let us know whether additional questions arise. 

Best regards,

Anastasiia

Hi Anastasiia,



Could you share the full list of of possible application logs files names pertaining to:

 

1) Schema generation

2) Compilations



So that we know exactly which files we need to examine for any troubleshooting.



Thank you,



Damien

Dear Damien,

Thanks for your question.

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

Best regards,

Anastasiia

Anastasiia Marushenko,

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 ?



Thank you,



Damien

Anastasiia Marushenko,

Hi, what is the table we must use to this query? I mean in tablename, wich table I need to ask to get compilation errors?

Select top 200 * from "tablename" (nolock) where Logger"='Build' order by "Date" desc

Hi again, What setting in the nlog.config should I configure to have detailed errors in the compilation?



I change this one, but not sure is the correct one, so I have not build.log file in the log folder

<logger name="ConfigurationBuild" writeTo="universalAppender" minlevel="Fatal" final="true" />



Thanks

Hello,

Please be informed that the sole fact of the schemas being a bit different is not a problem, the question is does it cause any actual issues to the performance of the site? Also, please specify if the Test env is a full copy of Dev and if so, was that schema present on the Test env before copying? Also, did you make any changes to the schemas yourself?

Kind regards,

Mira

Hello Petrika,

Parameter IsLocked mainly affects if you can edit the schema or the package.  Only the author of the lock can edit these elements. In the database, this author isn't mentioned and you can see only IsLocked.

The system will check the author on the other level.

Hello,

Thank you for your question!

Please, run database structure update for these objects.

After that, 

select Generate For All Schemas (source code) as on the screenshot below:





 

And compile the system:

This should resolve the issue.

In case it persists after these recommendations - please, let us know.

Regards,

Anastasiia

Anastasiia Lazurenko,

I tried the recommendations you sent but it still did not work. This happened because I was using the landing version 7.18.2.1236 and the package version was newer (7.18.4.1532). After downgrading the package version everything was compiled successfully. 

Hello,

Thank you for updating us. Good to know the issue is no longer in place.

Regards,

Anastasiia

Hi Yosef,

You can find the chain of articles here that describes multiple schema configurations:

https://academy.creatio.com/documents/technic-sdk/7-16/introduction-3

The diff array article among others describes the possbile operations that you refer to

https://academy.creatio.com/documents/technic-sdk/7-16/diff-array

Regards,

Dean

dean parrett,

Thank you for the quick response but this isn't exactly what I'm looking for, it sure is a great start for beginners!



What I'm looking for is like an "extended" list. If I want to enable or disable an item, I would be adding the ' "enable": true ' to the diff. This is nowhere to be found on the second link.



While programming I found bits and pieces of information of these properties in different posts, but I'm looking for something more complete in one place.



If anyone knows or has made a list like this, please let me know!

Thank you

Yosef,

All available information can be found here:

https://academy.creatio.com/documents/technic-sdk/7-16/javascript-api-platform-core

https://academy.creatio.com/api/jscoreapi/7.15.0/index.html

Best regards,

Angela