Page Comparison

Check for the following

pattern in the

error logs:

[com.intellectdesign.canvas.cache.handler.LocalCacheHandlerProxy][ERROR] {[CTAUD00155CTCAC00033]:AuditHandlerInstruction.logException() - Encountered exception. Exception message : An SQLException occurred while executing the insert operation.

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.

Check the following:

• Any errors in the browser console.
• Any network call failing
• Check if users' entitlements have changed
• Any errors in the CT server logs. If so, share it to CT Support team via Jira.

Scenario: The error message, “We were not able to complete your request due to a system error. As a result, no action is taken. Please contact Customer Support for further assistance. Reference id : be2fa6ca-c84f-4a8d-b7a7-1462cd0f2267” is displayed in a pop up when performing an action in the end application.

Solution: 

Check the network tab of the browser console to verify the parameters passed for the request. Copy the reference number from the pop up and search for it in all the “.log” files within the work folder path to find the reason for the server side exception.

Refer Adding a New Language in your Application - from Canvas 18.1 onwards.

Refer Enabling Custom Load Mask.

Check for the following error pattern in the log file:

[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.

Check for the following error pattern in the log file:

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

Solution: Request Modeler assigns a random and unique reference number for each request, which needs to be stored in the REFERENCE column in OD_AUDIT table in CT schema. Check in your code if the request data is modified to make the value of REFERENCE_NO column to null. If so, modify the code to make it not null because Request Modeler needs the reference number for internal processing. If you need to use or process a reference for functional logic, use a different column/variable to capture it.

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:

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.

Check for the following pattern in the error logs:

[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.

Check for the following pattern in the error logs:

[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 failing.

Check for the following pattern in the error logs:

[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.

Check for the following pattern in the error logs:

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.

Refer Amount page for more information.

Check for the following pattern in the error logs:

[com.intellectdesign.canvas.viewdefinition.SimpleViewDefinitionInstruction][ERROR]
				 {[CTVDF00386]:Database Exception occurred in fetchData() while retrieving the View data for the view id : SOME_VIEW_ID}

Solution:

• Check the app's datasource and the its response.
• At the end of the stack trace, check the root cause mentioned in the "Caused by:" section.

Check for the following pattern in the error logs:

[com.intellectdesign.canvas.connectors.camel.DefaultRoute][ERROR]
			 {[CTVDF00933]:Caught Exception while making a web service call {}}

Solution: Check the stack trace to find the details of the web service that did not return the success response.

Scenario: Data persistence is sometimes required at every page while moving to next page as end-users of the application can quit the application at any stage and come back to resume the work.

Solution: CT Platform does not maintain the state of each form or page. Implementation team must write code to handle persist data across pages or forms for the required functional behaviour in the application.

Refer Custom Publisher.

Refer Additional Ready-made Activities supported by Request Modeler.

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

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.

To insert a form in another form, perform the following steps:

1. In Canvas Studio, click Create > Form. The Form Designer displays.
2. In the left pane of Form Designer, click Containers & More.
3. In Component category, click Form.
4. From the list of existing forms, select a form and click Save. Selected form will be inserted in the form design area.

Yes. Define filesets in the ondemandjsfile.xml grouping the JS files needed. Use canvas.core.downloadManager object's requireScripts API to fetch this fileset before loading the form.

Refer Posting Data using the POST Method.

Refer Configuring Request Modeler Actions for Self-Designed Forms.

Refer Form Items Event Wiring.

Refer Form and Form Item APIs.

Use the following syntax to use the performance timer:

PerformanceTimer performanceTimer = new PerformanceTimer(); performanceTimer.startTimer("MyClassName.myMethodName");
// write your logic here 
performanceTimer.endTimer();