"Instance time" & "Date modified" fields have same timestamp

[former_member375889]

Hi,

We have SAP BO 4.2 SP 3 production environment which is stand alone system. Installed in windows 2008 server.

Recently we see that in reports history, all the scheduled instances which has ran for past dates are reflecting the same date and time stamps in "Instance Time" field. Click on "Success" field will have correct Start time and EndTime.

Eg: Instance ran on 12th sept 2017, if you see the "Instance time" field in report history it will show as 16-Jan-2019 00:00. Where as click on "success" field, will show starttime: 12-Sep-2017 01:15 and Endtime: 12-Sep-2017 01:34

Also, some of the reports, users and users & group, universes - "Date Modified" field has same date and timestamp in CMC. These objects are not modified at the same time but reflecting the new timestamp.

Eg: 4 reports inside a folder, will have same "Datemodifed" timestamp in CMC like 16-Jan-2019 00:00

Has any one faced the similar issue, if yes, what was the solution implemented to fix it.

Thanks,

Nischitha

[former_member375889]

Hi Joe,

We have not run the reposcan in our system. Any other suggestions?

Thank you

.

[Joe_Peters]

This can happen if you've run reposcan with the -repair option. It will make updates to report instances (such as changing obsolete submitter IDs), and in doing so the "last updated time" property will change.

[omacoder]

Were the instances migrated through promotion management? This happened to all of our instances when we migrated them from 4.1 to a new 4.2 platform. It is an issue in promotion management. I'm not sure if it has been fixed.

[former_member375889]

Hi Brian,

I can confirm that there were no instances migrated through promotion management. We will migrated only the reports and both the source and destination environments are of same version and patch levels.

Also, another point is the timestamp which is updated twice in the reports & instances/universe/users & groups are of odd hours, where no one will login and migrate the reports/objects.

Thanks,

Nischitha

[DellSC]

If you're using the base version of 4.2 SP3 without any patches, it's probably issues in the software. 4.2 SP3 had a bunch of problems when it was released and has a number of patches available. I would either install the latest patch (4.2 SP3 patch 13 hotfix 4) or upgrade to the latest version which is 4.2 SP6 patch 4.

-Dell