Versions Compared

Version Old Version 49 New Version Current
Changes made by

Ravikumar Babu CTOO (Unlicensed)

Ravikumar Babu CTOO (Unlicensed)

Saved on

Key

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

...

Expand
titleApplication shows blank page after log-in

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.


Expand
titleGetting system error message in application.

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.


Expand
titleHow to add new language in the end application?

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


Expand
titleHow to add a custom load mask in the application?

Refer Enabling Custom Load Mask.


Data Rendering or Data Submission

...

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: 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 has been is 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 failmodify 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.


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 get data from Web Service for an app

Check for the following pattern in the error logs:

Code Block
linenumberstrue
[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 responsethe stack trace to find the details of the web service that did not return the success response.


Expand
titleDoes CT Platform support data persistancy across pages or forms in wizard?

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.


Expand
titleHow to create a custom publisher for Request Modeler?

Refer Custom Publisher.

...

Expand
titleHow to map request model ID to an existing form designed in Studio?

Refer Configuring Request Modeler Actions for Self-Designed FormsModeler Actions for Self-Designed Forms.


Expand
titleHow to configure event wiring for form items?

Refer Form Items Event Wiring.


Expand
titleWhat are the APIs available from CT Platform for forms and form items?

Refer Form and Form Item APIs.


Refer Form Items Event Wiring.
Expand
titleHow to configure event wiring for form items?
use the performance timer?

Use the following syntax to use the performance timer:

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



Database

Expand
titleHow to get information from stored procedures or functions with parameters, such as log-in user ID, language, in datasource?

Data can be fetched using Instruction classes (Java class) in Canvas. Canvas uses iBatis library for database access. Callable statements can be used to access Stored Procedures and Functions to get the data.


Login ID, Language etc. will be passed as parameters by Canvas which can be used to filter data accordingly.

...