XMA: Result column truncated in XMA_REPORT

XMA: Result column truncated in XMA_REPORT

This can be addressed by changing the column width to 255 characters in SQLCI and then running the report or query again.

In SQLCI, before running the query:

SET VARCHAR_WIDTH 255;


Example before change:
14:57 14JUL21 200,01,2390 XYPRO Product:XYGATEMA Msg#:188 Level:Critical Msg:XYG100 2021-07-14:14:58:16.643556

Example after change:
14:56 14JUL21 200,01,3240 XYPRO Product:XYGATEMA Msg#:188 Level:Critical Msg:XYGATEMA process \GALAXY.$Z55V:3332208249 (\GALAXY.$QA1.TMA00.APPMOVE) had a critical but possibly retryable transient error -8300 SQL Error : SqlCode : -8300 Details : ***SQLCA 100


If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.


 

    • Related Articles

    • XMA: What is the datetime format in REPSAMP?

      REPSAMP is the report sample file in the XMA installation subvolume. Datetime format in the REPSAMP is MM-DD :HH . Replace 99-99:99 with the time frame you require. For example, the query below will retrieve records between 8.00pm 2018/05/25 and ...

    • XMA: Send XMA messages to SIEM via HPE SSL proxy

      Step 1: initiate an HPE SSL proxy if the HPE SSL Proxy is not running - Mode: PROXYC - SUBNET: the name of the TCPIP stack - PORT: HPE SSL proxy client port, this is the same as the port specified next to the IPALERT_PORT entry in the FILTER ...

    • XSM: How to create a report of users not logged on in over 90 days.

      In releases v1.65 and greater: 1. Launch the XYGATESM GUI 2. Select the Reporting tab 3. On the tree, right click on the name of the node you are currently connected to 4. Choose Add new report 5. From the list, choose the Last Logon - Greater than ...

    • XMA: SLSENDER fails to start after upgrading to Merged Audit 2.65

      There is a known issue where SLSENDER will not start after upgrading to XMA 2.65. If the customer cannot start SLSENDER after upgrading, the post upgrade steps below can be used. If we know a customer will be upgrading to XMA 2.65, pre-upgrade steps ...

    • XYGATE: Installing XMA using XAI

      Copy the following file, to your Desktop as an icon, from the following link. \\fs.xypro.com\filesrv\HP\HP_XYGATE_DISTRIBUTION\Release_tracking Click on the icon to open the file. Click on the ?Summary? tab at the bottom of the file. You will see the ...