Page Comparison

...

General

Expand

title	How does Sigma work?

Reports are configured in Sigma Studio by operation or IT users. Report consumers log-on to Sigma Application (portal) and generate or schedule the reports that they have access to based on their entitlement.

...

Expand

title	What to do when multiple notifications are sent instead of one?

Multiple emails get triggered even though only one entry in the table (OD_PENDING_MAIL) from where CT picks up records to be sent as email. In such cases refer these kind of errors found in the SystemOut.log (WebSphere log).

WTRN0006W: Transaction {0} has timed out after {1} seconds

For example:

Code Block

language	powershell

WTRN0006W: Transaction 00000188D7CBD648000000455D953708CCA97D4013E3EDB45FD179E3597A7D478393378300000188D7CBD648000000455D953708CCA97D4013E3EDB45FD179E3597A7D478393378300000001 has timed out after 120 seconds

Solution: Increase the total transaction lifetime timeout and maximum translation timeout in seconds. These settings can be updated through the WebSphere Application Server console, using Servers > Server Types > WebSphere application servers > server_name > [Container Settings] Container Services > Transaction Service

Reference links : https://www.ibm.com/support/pages/troubleshooting-java-transaction-service-jts-problems

https://www.ibm.com/docs/en/was-nd/8.5.5?topic=server-transaction-service-settings

WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@1f5b7ee3. The error code was XAER_RMERR.

Solution:

Run the following commands as user SYS:

Code Block

language	powershell

grant select on pending_trans$ to <user>;
grant select on dba_2pc_pending to <user>;
grant select on dba_pending_transactions to <user>;
grant execute on dbms_system to <user>;  //If using Oracle 10.2.0.3 or lower JDBC driver 
grant execute on dbms_xa to <user>; //If using Oracle 10.2.0.4 or higher JDBC driver

In the above commands, <user> is the username configured in the Oracle datasource's authentication alias.

Reference link : https://www.ibm.com/support/pages/exception-occurs-during-recovery-oracle-database-transactions

Sigma Studio (for Configuring Reports)

Expand

title	Are all the formats automatically enabled for all reports?

No. The report designers (Sigma Studio users) can configure or enable specific formats for each reports. Report consumers or generators (Sigma Application users) can generate the reports in the enabled formats only.

...

Expand

title	How to view the Data builder performance metrics?

Refer the CT_DATA_SOURCE_METRICS table, to view the Data builder and SQL query data source performance metrics collection in detail:

Column Name	Description
APPLICATION_ID	SIGMA
DATA_SRC_ID	It displays all the data source ID used in the Data builder.
REFERENCE_KEY	A unique key is generated, when a report which has data builder configured is generated and hence this can be used to analyze the metrics of that particular report instance.
DATA_SRC_INSTANCE_ID	A random data source instance ID is generated.
REFERENCE_TYPE	REPORT
DATA_REQUEST_INFO	It displays the query of the SQL data source, if not {} is displayed.
ROW_COUNT	It displays the number of records fetched.
CREATED_DATE	It displays the report generated timestamp.
FETCH_TIME	It displays the time taken to fetch the functional data.

...

Expand

title	How do PostgreSQL DB users enable the scheduler's update, remove, pause, and resume options?

To enable the scheduler update, remove, pause, and resume options available to PostgreSQL DB users, the following property files need to be modified in the CTResources.jar file.

canvas-default-alertschdlrquartz.properties
canvas_reporting_quartz.properties

1. Change the org.quartz.jobStore.driverDelegateClass key value to org.quartz.impl.jdbcjobstore.PostgreSQLDelegate in the canvas-default-alertschdlrquartz.properties file.

2. Replace the org.quartz.jobStore.driverDelegateClass key value with org.quartz.impl.jdbcjobstore.PostgreSQLDelegate in the canvas_reporting_quartz.properties file.

Sigma Application (Portal for Generating Reports)

Expand

title	What actions report-consumers can perform on Sigma Application (portal)?

Report consumers can perform the following on Sigma Application (portal):

Generate and download reports
- Choose report formats from among those configured
- Change column positions
- Add or remove configured columns
- Change column-level configurations
- Change report orientation and page size
- Use sort and group by columns if configured
- Choose contacts and notification channels
Save base reports with customizations
Regenerate executed reports
Schedule reports
- Configure multiple schedules for a report
- Configure retry frequency in case of failures
- Pause, resume and delete report schedules
Create group reports

...

Version	Old Version 1	New Version Current
Changes made by	DevaDarshini.S	DevaDarshini.S
Saved on	Nov 08, 2023	Mar 11, 2024

Versions Compared

Key

General

Sigma Studio (for Configuring Reports)

Sigma Application (Portal for Generating Reports)

Page Comparison

Versions Compared

Key

<span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-0">[data-colorid=</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-2">k9nxihx8xf</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-3">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-4">k9nxihx8xf</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-5">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-8">itionk8wif</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-9">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-51">#dddddd</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-52">}</span>General

Sigma Studio (for Configuring Reports)

Sigma Application (Portal for Generating Reports)

General