Versions Compared

Version Old Version 43 New Version 44
Changes made by

Ravikumar Babu CTOO

Ravikumar Babu CTOO

Saved on

Key

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

...

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

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

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}

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


Expand
titleRequest Modeler save is not working


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




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.

...