Skip to Content
-1

SAP ASE DBACOCKPIT HADR COLLECTOR PROBLEM

Nov 24, 2017 at 11:59 AM

108

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Madhvi Pai
Dec 04, 2017 at 04:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
FAZIL KURUCU Dec 05, 2017 at 08:30 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Maria Victoria NORMAND
Dec 13, 2017 at 03:30 PM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hello Maria,

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

Thanks for your recommendation.

Regards.

0

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,

0

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

0