Missing ms_upgrade1222.sql

[Former Member]

All,

On a DS ver. 3 job server (running on Windows), I started at 12.2.0.0, and ran the 12.2.3.4 patch, DATACLNT_4-10008118. This brings Designer, the Job Server, and the Job Engine up to 12.2.3.4 -- no problems, other than the need to run it twice to get Designer back.

My repo's, however, are still at 12.2.0.0000. When I run Repository Manager to upgrade a repo (on SQL Server), it throws an error, saying I'm missing ms_upgrade1222.sql. Judging from the name (of the missing file), it looks like I'm missing the script to bring the repo's up to 12.2.2.0000. Questions:

1) Does anybody have this file? If so... I could use it. It's supposed to be in admin\repo\MSSQL.

2) Does it, perhaps, come w/ the 12.2.2.0 patch, and perhaps they (SAP) forgot to bring it along w/ the 12.2.3.4 patch? Or, good heavens, did I really need to apply all the "DATACLNT_" patches in order, one after another?

Thanks.

Jeff

Edited by: Jeff Prenevost on Feb 5, 2012 3:00 PM

Follow-up in case anybody's interested: there's a whole slew of *1222 files, .SQL and .ATL, that weren't present under \admin\repo after application of the same patch as on another job server where all these files were present. Seems like maybe the patch was different, but sure looks the same, and both result in the Designer, Job Server, and Job Engine all getting reported at 12.2.3.4. Copied all the files over and now Repository Manager is happy. Pretty weird.

[denise_meyer]

Hi Jeff,

I believe the reason with the 12.2.3.4 patch that you saw this issue is you probably ran the install right over your current install of Data services. As it states in the release notes for 12.2.3.4 release, for the Windows install, you are required to uninstall first following these steps:

You must uninstall the existing SAP BusinessObjects Data Services 12.x before installing 12.2.3.4 by following the below steps:

1) Perform the steps described in "Using configurations from a previous version ‟ section in "SAP BusinessObjects Data Services Installation Guide for Windows ‟ to backup the configuration files.

2) Un-install existing SAP BusinessObjects Data Services.

3) Install 12.2.3.4 and choose option to re-use the configurations at the time of installation.

Hope this helps you understand why these files were most likely missing from your install (as well as the Designer exe that you mentioned you did have to run the install twice to get it to show up).

Thanks,

Denise