#35 ASEMON Logger V3.1.6 doesnt work with RepServer

[Hardeep]

Hi JPM,
Again i would need your help on ASEMON Logger upgrade task.

I have upgraded ASEMON Logger from V2.7.21 to V3.1.6 and i found that Logger stopped connecting to RepServer (RS157 SP305).

Would you please sugest that Logger V3.1.6 is compatible with RS157 or I have to do some other configuration to make it working with Replication Server.

ASE Version is ASE160 SP03 PL08 HF1

Error message I am geting is

=====================

2020/10/21 10:47:38.447 main - Start Asemon_logger V3.1.6
2020/10/21 10:47:38.467 main - Current directory is : /dba/sybase/asemon/3.1.6
2020/10/21 10:47:38.467 main - Java version : 1.8.0_262
2020/10/21 10:47:38.468 main - Classpath is : /dba/sybase/asemon/asemon_logger/dist/Asemon_logger_V3.jar:/dba/sybase/asemon/asemon_logger/lib/jdom.jar:/dba/sybase/asemon/asemon_logger/lib/xerces.jar:/dba/sybase/asemon/asemon_logger/lib/java-getopt-1.0.9.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jconn4.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jTDS3.jar
2020/10/21 10:47:38.468 main - Config file used : /dba/sybase/asemon/config/ASEMGLDEVF70B.xml
2020/10/21 10:47:38.639 main - textsize for retreiving text (XML documents) for 'ASEMGLDEVF70B': 65536
2020/10/21 10:47:38.639 main - textsize for retreiving text (XML documents) for 'REPMGLDEVF70B': 65536
2020/10/21 10:47:38.690 main - Try to connect to srv : ASEMGLDEVF70B
2020/10/21 10:47:38.715 main - Srv found in interfaces or SQL.INI file. Host=sybaseasehost Port=20002
2020/10/21 10:47:38.715 main - Using password from passwords file for 'ASEMGLDEVF70B.perfmon_dba'
2020/10/21 10:47:38.868 main - Connected to archive server : ASEMGLDEVF70B Database : asemon_ASEMGLDEVF70B
2020/10/21 10:47:38.871 main - Check/create sp_sysmon procs in archive database
2020/10/21 10:47:38.956 main - Try to connect to srv : REPMGLDEVF70B
2020/10/21 10:47:38.971 main - Srv found in interfaces or SQL.INI file. Host=sybaseasehost Port=27002
2020/10/21 10:47:38.972 main - Using password from passwords file for 'REPMGLDEVF70B.perfmon_dba'
2020/10/21 10:47:38.999 main - ERROR connectSRV (1). Srv=REPMGLDEVF70B : java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data.
2020/10/21 10:47:39.000 main - ERROR connectSRV (2). Srv=REPMGLDEVF70B : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/21 10:47:39.000 main - ERROR connectSRV (2). Srv=REPMGLDEVF70B : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/21 10:47:39.000 main - Try to connect to srv : ASEMGLDEVF70B
2020/10/21 10:47:39.012 main - Srv found in interfaces or SQL.INI file. Host=sybaseasehost Port=20002
2020/10/21 10:47:39.013 main - Using password from passwords file for 'ASEMGLDEVF70B.perfmon_dba'
2020/10/21 10:47:39.053 main - connectMonitoredASE - connected to : ASEMGLDEVF70B Version : 1600
2020/10/21 10:47:39.053 main - Time difference (ms) between ASE and asemon_logger (positive when ASE is in advance) : -7
2020/10/21 10:47:39.055 main - Set textsize to 65536

As always many thanks for your support and great help.

Regards,
Hardeep

[Jean-Paul Martin]

Hi Hardeep,
YES I know this problem : it is due to jConnect V16 when asemon tries to connect using the "encrypt password" to a RS 15.7.1 (it works with RS 16)
Two possible workarounds :
1) uncomment the line :
<traceflag> disableENCPASS </traceflag>
in the config file
2) or, replace jConnect used by asemon_logger installation with a older version

First workaround is better

Best regards
Jpm

[Hardeep]

Thanks Jpm,
I have tried to disable encrypted password option but then Logger stopped working for ASE as well.
Considering our security & compliance policies , we can't disable password encryption option at ASE level.

Is there an option to disable encrypted password only at Repserver level.
I mean to define it under <monitoredsrv><srv> instead of <asemon><options></options></asemon></srv></monitoredsrv>

=======

2020/10/21 18:11:37.150 main - Start Asemon_logger V3.1.6
2020/10/21 18:11:37.173 main - Current directory is : /dba/sybase/asemon/3.1.6
2020/10/21 18:11:37.173 main - Java version : 1.8.0_262
2020/10/21 18:11:37.174 main - Classpath is : /dba/sybase/asemon/asemon_logger/dist/Asemon_logger_V3.jar:/dba/sybase/asemon/asemon_logger/lib/jdom.jar:/dba/sybase/asemon/asemon_logger/lib/xerces.jar:/dba/sybase/asemon/asemon_logger/lib/java-getopt-1.0.9.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jconn4.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jTDS3.jar
2020/10/21 18:11:37.174 main - Config file used : /dba/sybase/asemon/config/ASEMGLDEVD93F.xml
2020/10/21 18:11:37.355 main - textsize for retreiving text (XML documents) for 'ASEMGLDEVD93F': 65536
2020/10/21 18:11:37.355 main - textsize for retreiving text (XML documents) for 'REPMGLDEVD93F': 65536
2020/10/21 18:11:37.356 main - Active traceflag : 4 = disable ENCRYPT PASSWORD
2020/10/21 18:11:37.404 main - Try to connect to srv : ASEMGLDEVD93F
2020/10/21 18:11:37.426 main - Srv found in interfaces or SQL.INI file. Host=sybaseasehost Port=20002
2020/10/21 18:11:37.427 main - Using password from passwords file for 'ASEMGLDEVD93F.perfmon_dba'
2020/10/21 18:11:37.485 main - ERROR connectSRV (1). Srv=ASEMGLDEVD93F State= JZ00L Err= 0 Msg=JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
2020/10/21 18:11:37.486 main - ERROR connectSRV (2). Srv=ASEMGLDEVD93F State= 01ZZZ Err= 1640 Msg=Adaptive Server requires encryption of the login password on the network.

Regards,
Hardeep

[Jean-Paul Martin]

Do a separate config file for your RepServer and activate the "disableENCPASS" flag only in this config file
Start a dedicated asemon_logger for this RepServer with this config file
Regards
Jpm

[Hardeep]

Thanks Jpm
I don’t think this is viable option for my environment. My monitored server is also having password encryption enabled.
So , individual REP XML wont work for me as a solution. Seems like i have to rely on older version of jConnect .

  <asemon>
      <admin_port> </admin_port>  <!-- admin_port is not mandatory. If defined, it allows to connect to asemon with isql -->
      <name> </name>              <!-- asemon_logger name is mandatory only if admin_port is defined. Used to save the sa password of asemon_logger in passwords file -->
      <options>
      <traceflag> disableENCPASS </traceflag>
      </options>
  </asemon>

  <ArchiveSrv>
      <name> ASEMGLDEVD93F </name>
      <user> perfmon_dba </user>
      <useKerberos> NO </useKerberos>
      <database> asemon_ASEMGLDEVD93F </database>
      <charset>  </charset>
      <GranteeList>  </GranteeList>
      <poolsize> 2 </poolsize>
      <packet_size> </packet_size> <!-- not mandatory. If defined, overrides default network packet size of the archive server -->
      <useLongSrvNames> NO </useLongSrvNames> <!-- Put YES here if server names have more than 20 chars and archive server version is V15 or greater -->
  </ArchiveSrv>

  <MonitoredSrv>
      <SRV>
          <name> REPMGLDEVD93F </name>
          <user> perfmon_dba </user>
          <useKerberos> NO </useKerberos>
          <charset>  </charset>
          <packet_size> </packet_size> <!-- not mandatory. If defined, overrides default network packet size of the monitored server -->
          <srvDescriptor> RS16 </srvDescriptor>
          <purgearchive daysToKeep="32"  deleteSleep="100" />
          <textsize> 65536 </textsize>
      </SRV>
  </MonitoredSrv

Regards
Hardeep

[Jean-Paul Martin]

Yes, your only solution is to revert to a previous jConnect

By the way I didn't test a more recent jConnect (V16.0 SP03 PL09)
May be you could try and tell me if it fixes the problem.

Regards
Jpm

[Hardeep]

Sure, we have recently rolled out ASE/PEP V16.0 SP03 PL09 in our cloud environment

I will share the results how ASEMON goes with jConnect (V16.0 SP03 PL09) and whether its able to connect RS157 with this version.

Regards,
Hardeep

[Hardeep]

FYI
I have used latest released jConnect (V16.0 SP03 PL09) to connect to RS157 instance but that didn't work.

2020/10/22 09:46:25.996 main - Start Asemon_logger V3.1.6
2020/10/22 09:46:26.015 main - Current directory is : /dba/sybase/asemon/3.1.6
2020/10/22 09:46:26.015 main - Java version : 1.8.0_262
2020/10/22 09:46:26.016 main - Classpath is : /dba/sybase/asemon/asemon_logger/dist/Asemon_logger_V3.jar:/dba/sybase/asemon/asemon_logger/lib/jdom.jar:/dba/sybase/asemon/asemon_logger/lib/xerces.jar:/dba/sybase/asemon/asemon_logger/lib/java-getopt-1.0.9.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jconn4.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jTDS3.jar
2020/10/22 09:46:26.016 main - Config file used : /dba/sybase/asemon/config/REPMGLDEVD93F.xml
2020/10/22 09:46:26.184 main - textsize for retreiving text (XML documents) for 'REPMGLDEVD93F': 65536
2020/10/22 09:46:26.234 main - Try to connect to srv : ASEMGLDEVD93F
2020/10/22 09:46:26.259 main - Srv found in interfaces or SQL.INI file. Host=usyddbd32697 Port=20002
2020/10/22 09:46:26.259 main - Using password from passwords file for 'ASEMGLDEVD93F.perfmon_dba'
2020/10/22 09:46:26.370 main - Connected to archive server : ASEMGLDEVD93F Database : asemon_ASEMGLDEVD93F
2020/10/22 09:46:26.373 main - Check/create sp_sysmon procs in archive database
2020/10/22 09:46:26.435 main - Try to connect to srv : REPMGLDEVD93F
2020/10/22 09:46:26.450 main - Srv found in interfaces or SQL.INI file. Host=sybasehost Port=27002
2020/10/22 09:46:26.451 main - Using password from passwords file for 'REPMGLDEVD93F.perfmon_dba'
2020/10/22 09:46:26.477 main - ERROR connectSRV (1). Srv=REPMGLDEVD93F : java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data.
2020/10/22 09:46:26.477 main - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.478 main - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.482 REPMGLDEVD93F_AmStats   - Start thread.
2020/10/22 09:46:26.484 REPMGLDEVD93F_DISKSPCE  - Start thread.
2020/10/22 09:46:26.486 REPMGLDEVD93F_RSConfig  - Start thread.
2020/10/22 09:46:26.488 REPMGLDEVD93F_RSInfo    - Start thread.
2020/10/22 09:46:26.489 REPMGLDEVD93F_RSMem     - Start thread.
2020/10/22 09:46:26.490 REPMGLDEVD93F_RSMemDet  - Start thread.
2020/10/22 09:46:26.492 REPMGLDEVD93F_RSStats   - Start thread.
2020/10/22 09:46:26.495 REPMGLDEVD93F_Trends    - Start thread.
2020/10/22 09:46:26.498 REPMGLDEVD93F_RSWhoSQM  - Start thread.
2020/10/22 09:46:26.567 REPMGLDEVD93F_RSWhoSQM  - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.567 REPMGLDEVD93F_RSWhoSQM  - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.567 REPMGLDEVD93F_RSWhoSQM  - Connection  to REPMGLDEVD93F is closed. Trying to reconnect every 10 s ...

Regards,
Hardeep

[Jean-Paul Martin]

Hi Hardeep, thank you forthe feedback

If you have a SAP support contract you should open an incident about this password encryption problem with RS15.7 and jConnect V16
I cannot do myself as I am not a SAP customer

Regards
Jpm

[Hardeep]

Thanks Jpm ,
Really appreciate your help.

Regards
Hardeep