Versions Compared

Version Old Version 28 New Version 29
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

Key

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

General


Expand
titleHow 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
titleWhere are the generated reports get stored?

The generated reports are stored in the server where Sigma is deployed. However, you can specify custom location to store the reports, such as a specific target folder, FTP directory or cloud storage.


Expand
titleWhat to do when multiple notifications are sent instead of one?

Multiple emails were triggered even though there was only one entry in the table (od_pending_mail) from where CT picks up records to be sent as email. To troubleshoot, Refer these kind of errors found in the SystemOut.log (WebSphere log).

  • WTRN0006W: Transaction {0} has timed out after {1} seconds
    example :
    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
  • 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
    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)

    Where <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
titleHow to view the Data builder performance metrics?

Refer the CT_DATA_SOURCE_METRICS table, to view the Data builder performance metrics collection in detail:

Column NameDescription
APPLICATION_IDSIGMA
DATA_SRC_IDIt displays all the data source ID used in the Data builder.
REFERENCE_KEYA 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_IDA random data source instance ID is generated.
REFERENCE_TYPEREPORT
DATA_REQUEST_INFOIt displays the query data source used in the data builder, if not {} is displayed.
ROW_COUNTIt displays the number of records fetched. 
CREATED_DATEIt displays the report generated timestamp.
FETCH_TIMEIt displays the time taken to fetch the functional data.


...