Versions Compared

Version Old Version 44 New Version 45
Changes made by

Ravikumar Babu CTOO

Ravikumar Babu CTOO

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleGetting error when setting up the application in a new environment

Check for the following pattern in the error logs:

Code Block
linenumberstrue
[server.startup : 0][][][][c.i.c.a.s.AlertsSchedulerFactory][ERROR]
				 {[CTALT01097]:Exception occurred while starting a scheduler and the exception is {} }
org.quartz.SchedulerConfigException: Failure occured during job recovery.
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:663)

Solution: Check if any of the configuration in canvas-default-alertschdlrquartz.properties file is updated by comparing with the values in the original file in the CT platform release. If the value of the key org.quartz.jobStore.dataSource is changed, ensure that there is a datasource in that name.


Expand
titleCT Server error occurs in logs

Check for the following pattern in the error logs:

Code Block
linenumberstrue
[com.intellectdesign.canvas.cache.handler.LocalCacheHandlerProxy][ERROR] {[CTCAC00033]:Could not load 'com.intellectdesign.canvas.cache.entitlement.EntitlementCacheBuilder'.

Solution: Include the CTReadyApps.jar from the CT release to the application's dependencies folder.


Data Rendering or Data Submission 

Expand
titleGrid widget has date column configured in Studio, but it is not rendering in end application

Check for the following error pattern in the log file:

Code Block
linenumberstrue
[com.intellectdesign.canvas.data.conversion.util.JSONToHashMapConverter][ERROR]
			 {[CTBAS00014]:The String is either not in proper date format or is not a date: Format: dd/mm/yyyy , Value:  31-12-2030

Solution: If such date format mismatch occurs, then change the value of the date field to the user-preferred format.

...

Expand
titleData submit to database via Request Modeler flow is failing

Check for the following error pattern in the log file:

Code Block
linenumberstrue
{[CTAUD00155]:AuditHandlerInstruction.logException() - Encountered exception.
				 Exception message : An SQLException occurred while executing the insert operation.

Solution: Check if the request data has been modified to make the value of REFERENCE_NO column to null. If so, then the insert to the REFERENCE column in the OD_AUDIT table will fail.

...

Expand
titleData fetch from DB table throws error

Scenarios:

  • Data fetch from DB table throws error in logs
  • Upgrading to latest CT binaries throws error in logs

For above scenarios, check for the following pattern in the error logs:

Code Block
linenumberstrue
Cause: java.sql.SQLSyntaxErrorException
Cause: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Cause: java.sql.SQLSyntaxErrorException: Unknown column
Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;
Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "COLUMN_NAME": invalid identifier
java.sql.BatchUpdateException: ORA-00904: "COLUMN_NAME": invalid identifier

Solution: For any exception of the above pattern, check the ctdblogs to find the SQL ID of the query that is failing. If the query is related to functional database/schema, fix the query. If the query is within CT or includes a CT table, check if all the incremental scripts were applied properly. Even then if not resolved, inform the CT Platform support team.

...

Expand
titleCouldn't connect to functional DB

Check for the following pattern in the error logs:

Code Block
linenumberstrue
[com.intellectdesign.canvas.database.IBatisDatabaseAccess][ERROR]
			 {[CTDBL00088]:An SQLException occurred while executing the select operation}
java.sql.SQLException: The Network Adapter could not establish the connection

Solution: Check if the connectivity to the functional DB is working.

...

Expand
titleCouldn't save data on DB

Check for the following pattern in the error logs:

Code Block
linenumberstrue
[com.intellectdesign.canvas.database.IBatisDatabaseAccess][ERROR]
			 {[CTDBL00105]:An SQLException occurred while executing the Batch Insert operation}

Solution: For any exception of the above pattern, check the ctdblogs to find the SQL ID of the batch insert query that is failingcheck the ctdblogs to find the SQL ID of the batch insert query that is failing.


Expand
titleCouldn't save data on DB

Check for the following pattern in the error logs:

Code Block
linenumberstrue
[c.i.c.d.TransactionManager][ERROR]
			 {[CTDBL00003]:Caught exception in getTransaction(USER_TXN_NAME)}

Solution: Check if the JNDI is configured as a datasource in the server.


Expand
titleRequest Modeler save is not working

Check for the following pattern in the error logs:

Code Block
linenumberstrue
Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'BUSINESS_KEY' at row 1

Solution: Check the data passed through the request modeler. It is advised to configure a unique key as the BUSINESS_KEY while creating the request modeler in Studio. The value passed must not be more than 256 characters.


Encryption

Expand
titleHow to enable encryption of business data, request and response between client and server in the application built using Canvas?

You can enable encryption for the application built using Canvas by setting the 'ENCRYPT_SERVER_CALLS' property to 'Y' in the 'systempreferences.properties' file.

Note

When you enable encryption, Canvas will encrypt all requests coming to your application including log out.

A sample 'systempreferences.properties' file is available in CTModelHouseResource.jar in the Model House application that comes as part of the Canvas platform package.

Note that you must stop and start your application server to enable this feature. After the application server is restarted, access the widgets in the application and check the Network tab in the browser console to verify the encryption.

...

Expand
titleEncryption is enabled, but not working

Check for following error pattern in the log file:

Code Block
linenumberstrue
[c.i.c.s.e.EncryptionUtils][ERROR] {[CTCOM00155]:Error occured in the decrypt JWT method : {}}
com.intellectdesign.canvas.servercomm.encryption.DecryptionException: no_error_message
	at com.intellectdesign.canvas.servercomm.encryption.AESEngine.decrypt
Caused by: javax.crypto.IllegalBlockSizeException: last block incomplete in decryption
	at org.bouncycastle.jcajce.provider.symmetric.util.BaseBlockCipher.engineDoFinal(Unknown Source) 

[com.intellectdesign.canvas.servercomm.encryption.PublicKeyImpl][ERROR] 
		{[CTRND00412]:Exception occurred in the Encryption and decryption of Req/Res : {}}
javax.crypto.BadPaddingException: unknown block type

Solution:

If such error pattern occurs (line numbers 1, 2, 4, 7-9) in the logs, then check the following:

  1. Java version must be higher than 1.8.251.
  2. If the CT version is lower than 19.1.7.6_17307, then the bcprov-jdk16-1.46.jar file must be present.
  3. If the CT version is above 19.1.7.6_17307, then the bcprov-ext-jdk15to18-169.jar must be present.
  4. If the CT version is lower than 19.1.1.0, then the bcprov-ext-jdk15on-150.jar must be present.

...