SAP ASE DBACOCKPIT HADR COLLECTOR PROBLEM

[former_member194509]

Hi Dear Experts,

HADR Path collector gettin below errors. Have you any experience with this problem ?

Server message:

Msg 535, Level 16, State 1: Server 'SID', Line 1:

Difference of two datetime fields caused overflow at runtime.

Start of routine: saptools..SP_DBH_HADR_PATHS (Log Level: 3)

Difference of two datetime fields caused overflow at runtime.

Start of routine: saptools..SP_DBH_HADR_PATHS (Log Level: 3)

Difference of two datetime fields caused overflow at runtime.

Start of routine: saptools..SP_DBH_HADR_PATHS (Log Level: 3)

Difference of two datetime fields caused overflow at runtime.

Regards

[victoria_normand]

Hello Fazil,

Can you implement SAP Note 2526630 - SYB: Transaction Log Usage: Difference of two Datetime Fields Caused Overflow at Runtime ?
It is not currently included on the DBACockpit Correction Collection.
Best regards,
Victoria.

[former_member194509]

Hello Maria,

I applied yet and now monitoring the system. I will inform you about result.

Thanks for your recommendation.

Regards.

[former_member194509]

Hello Again,

My problem still continue....

Start of routine: saptools..SP_DBH_HADR_PATHS (Log Level: 3) 2017/12/16 21:57:00 Difference of two datetime fields caused overflow at runtime. 2017/12/16 21:45:03 Start of routine: saptools..SP_DBH_HADR_PATHS (Log Level: 3) 2017/12/16 21:45:03 Server message: 2017/12/16 21:45:03 Error in job scheduling / execution (job exit code = 0; job user code = 1-) 2017/12/16 21:45:03 Msg 2601, Level 16, State 6: 2017/12/16 21:45:03 Server 'SID', Line 1: 2017/12/16 21:45:03 Attempt to insert duplicate key row in object 'DBH_HADR_PATHS_PROTOCOL' with unique index 'DBH_HADR_PATHS_PROTOCOL~0' 2017/12/16 21:45:03 Command has been aborted. 2017/12/16 21:45:03 Attempt to insert duplicate key row in object '%.*s' with unique index '%.*s'%S_EED 2017/12/16 21:30:03 Error in job scheduling / execution (job exit code = 0; job user code = 1-)

Regards,

[victoria_normand]

Hello Fazil,
Which is your SAP Basis version ?
Best regards,
Victoria.

[former_member194509]

Hi Dear Madhvi,

Yes i applied last DBA Cockpit Correction Note. Our NW version is 740 and ASE Version is 16.0.02.05

Thanks,

Regards

[madhvi_pai]

Hi Fazil,

Are the latest set of DBACockpit corrections applied on this system? Can you please furnish the NW and ASE versions in this case?

Thanks,

Madhvi Pai

SAP Product Support