nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MediaBin 4.6 upgrade

kshitiz

We are currently using Mediabin 4.5.2 with Oracle and TS 6.5 SP2. We need to upgrade MediaBin to 4.6. I have few queries regarding this:

1. Can we safely upgrade from 4.5.2 to 4.6 without effecting our asset repository in oracle DB? Also, will folder permissions be retained as such?

2. Is there any additional configurations or patch installation needs to be done for TS 6.5 to connect to MB 4.6?

3. After upgrading to 4.6, is there any configurations (like LDAP etc) which needs to be re-done?

4. If anyone has previously done the same activity, can you guide in terms of what challenges we can face or precautions to be taken care of? Pointers to any KB article will be helpful.

Waiting for a speedy response.

Find more posts tagged with

Comments

kshitiz

We tried the upgrade on our development server. But were unsuccessful.

We followed the steps mentioned in MediaBin 4.6 Admin Guide. After the setup was complete, however, the MediaBin server is not coming up. On checking the MBP.log we found the following error:

Incompatible schema versions expected "4.6" found "4.5.1"

Interestingly, when we started the setup intially, it had said that "MediaBin 4.5.1 is detected, Would you like to upgrade?". But we were on 4.5.2.

Can anyone give any suggestions??

msrinivas

Very interesting! I would recommend contacting support. It is either a bug in the installer that it detects a 4.5.2 system as 4.5.1 or you are pro'ly on 4.5.1 Smiley Wink

Either way, I have done multiple SQL based upgrades and they have been much smoother. I have not done any Oracle based upgrades.

kshitiz

Thanks. I have already raised a case with IW Support. I thought maybe somebody else in the forum had faces such problem and can provide solution. IW Support does take their own sweet time.

Migrateduser

We've been long time Mbin customers and we've only had one conversion go well.

We use MS SQL Server and when we upgraded from 4.5.2 to 4.5.3 I noticed in our MBSettings table that there were multiple entries that should have not been there. Our ServerID was in there mutliple times with different values and did not match our *real* ServerID. Therefore, I restored our old database to the db server, we ended up deleting those rows from the table and reran the conversion again. That fixed our issue.

I know you said you are on Oracle however, I thought I would mention our solution anyways, and maybe looking at your server configuration in that table before upgrade may be helpful.

RajatChopra

This does not bode well :-(. We are looking at an upgrade in a few weeks.
Kshitiz,
Are there are upgrade path documents available? I know there is a webcast for mid-september on MediaBin upgrade. Definitely need to plan around that time so as to get maximum out of it.

Currently on 4.5.1 , SQL Server 2000

msrinivas

We've been long time Mbin customers and we've only had one conversion go well.

We use MS SQL Server and when we upgraded from 4.5.2 to 4.5.3 I noticed in our MBSettings table that there were multiple entries that should have not been there. Our ServerID was in there mutliple times with different values and did not match our *real* ServerID. Therefore, I restored our old database to the db server, we ended up deleting those rows from the table and reran the conversion again. That fixed our issue.

I know you said you are on Oracle however, I thought I would mention our solution anyways, and maybe looking at your server configuration in that table before upgrade may be helpful.

What was the upgrade procedure that you followed?

Did you have any other version of MB before 4.5.2?

Did you have any kind of false starts with the upgrade?

Did you move from a MB cluster to a single server or vice versa?

I have seen the server ID thing with regards to the last question that I asked you. Other wise by far the upgrades with SQL have always been fairly smooth.

msrinivas

This does not bode well :-(. We are looking at an upgrade in a few weeks.
Kshitiz,
Are there are upgrade path documents available? I know there is a webcast for mid-september on MediaBin upgrade. Definitely need to plan around that time so as to get maximum out of it.

Currently on 4.5.1 , SQL Server 2000

Please refer to the 4.6 admin guide.

Migrateduser

I'm not sure if those questions were targetted at me or not. I am going to skip answering them as I do not want to control this thread.

Coincidentally, Lyman is heading a webcast on Sept 12 about Mbin 4.6 Upgrades.

http://interwoven.market2lead.com/go/interwoven/DevNetWC091207

kshitiz

I was able to resolve the problem through IW support's help. Apparantely, the setup hasn't done upgrade of DB format as required by 4.6. After the upgradation, we have to run MBPAdminConsole.exe present under the installation directory of MB server. It prompts for upgrade of Database. Run it. After which Server was running fine and getting connected through Windows Client as well as Web Client.

However, now I'm facing connectivity issue of MB with TS. I'm using TS 6.5 and I'm not able to import the files from MB which I was able to do previously. I'm wondering whether ecm connector 2.0 is compatible with MB 4.6.

When trying to import file, the MB browser isn't showing image previews but broken file icons (see attached s1.jpg)

And when I'm trying to import any file, I'm getting an error (see attached s2.jpg)

Any solution??

msrinivas

I'm not sure if those questions were targetted at me or not. I am going to skip answering them as I do not want to control this thread.

Coincidentally, Lyman is heading a webcast on Sept 12 about Mbin 4.6 Upgrades.

http://interwoven.market2lead.com/go/interwoven/DevNetWC091207

I did quote you previously. So yeah those questions were for you. It's ok if you choose not to respond.

msrinivas

I was able to resolve the problem through IW support's help. Apparantely, the setup hasn't done upgrade of DB format as required by 4.6. After the upgradation, we have to run MBPAdminConsole.exe present under the installation directory of MB server. It prompts for upgrade of Database. Run it. After which Server was running fine and getting connected through Windows Client as well as Web Client.

However, now I'm facing connectivity issue of MB with TS. I'm using TS 6.5 and I'm not able to import the files from MB which I was able to do previously. I'm wondering whether ecm connector 2.0 is compatible with MB 4.6.

When trying to import file, the MB browser isn't showing image previews but broken file icons (see attached s1.jpg)

And when I'm trying to import any file, I'm getting an error (see attached s2.jpg)

Any solution??

Any SPs on TS? Did you try doing iwreset? Did you verify that MB webservices is running correctly (I know if it wasn't you pro'ly would not be able to connect)?

As an aside, the 4.6 documentation clearly states on page 47:

"If this is an Upgrade of an existing installation, please continue with the section titled
“Complete Additional Installs and Upgrades” on page 51. You should not perform the
Database configuration step for an Upgrade installation."

That is exactly opposite of what support had you do. Can you please raise a doc bug for this?

msnider

On upgrading to 4.6, there is a known issue where certain filesizes are not converted to the newer KB values and instead the filesize is returned as zero. The ECM connector looks at the filesize and determines that if it is zero then there is no preview available....which explains why the thumbnails are broken.

This is an issue with the MediaBin server and not the ECM connector or the MediaBin web service. Contact support to get the patch that fixes this issue.

Mark

kshitiz

On upgrading to 4.6, there is a known issue where certain filesizes are not converted to the newer KB values and instead the filesize is returned as zero. The ECM connector looks at the filesize and determines that if it is zero then there is no preview available....which explains why the thumbnails are broken.

This is an issue with the MediaBin server and not the ECM connector or the MediaBin web service. Contact support to get the patch that fixes this issue.

Mark

I found out a patch (#1834) which probably solves the problem. But the patch is for SQL Server and not Oracle.

lyman

Sorry to be jumping onto the thread late. Since I am, let me quickly touch on a few items that I do not think were explained fully.

Not every software version of MediaBin has involved a schema change which is why the 4.5.2 version of the code indicates a 4.5.1 schema. We have been understandably cpnservative about schema changes and therefore there are a lot fewer options for this field than versions.

Stacy thanks for the plug about the upcoming talk :-).

The only case in which security descriptors have been a problem through any upgrade is when people have local accounts assigned permissions and try to upgrade and switch boxes at the same time. This is an issue with the fact that Windows identifiers for local accounts do not automatically port from one machine to another. We strongly encourage people to use domain accounts if at all possible. If trying to switch machines and one is already locked into local accounts, support has access to some scripts that make the transition a bit easier (essentially the scripts export and re-import security).

I will shake the bushes to see about getting an Oracle patch for the Original Filesize problem. The issue arose when we introduced support for files > 2 GB in MediaBin 4.6 and it no longer was practical to store the file size in bytes in a single DWORD value. Since MediaBin does not natively support metadata of type long long we recalibrated to represent file size in kb.

The file size problem had an unintended side effect with the TeamSite connector. Without patching the file size of existing assets is marked as zero and TeamSite skips over them or at least fails to show their thumbnail.

For those who have not yet taken the step to upgrade, this problem was fixed and current upgrades should not exhibit the problem. If you are not sure if you have the problem, simply look at what is displayed as "Original Filesize" for any of the assets that were inserted pre-upgrade.

Again apologies for the late response and hope we can get everything ironed out and I really hope that this does not discourage anyone because 4.6 has a lot of features worth the effort!

Cheers,

Lyman Hurd

lyman

Okay the following URL should have the fixes for both SQL and Oracle!

Patch 1834

http://support.interwoven.com/patches/download_patchesNewV2.asp?isDownloading=1834&src=nt_mb46_p72699.exe

On behalf of the server team, we do apologize for the oversight! Again this is only for old upgrades exhibiting the problem.

Cheers,

Lyman Hurd

lyman

Oops. I have just been informed that this patch has a minor issue. Please do not use until we get back to you.

Cheers,

Lyman Hurd

kshitiz

Oops. I have just been informed that this patch has a minor issue. Please do not use until we get back to you.

Cheers,

Lyman Hurd

Thanks for the help. Our upgradation activity is stalled just because of this unresolved problem. IW Support team has also not responded yet. If you can provide the Oracle patch quickly.

Migrateduser

IWOV support probably will not respond because they know Lyman is already involved.

We have not performed our 4.5.3 -> 4.6 upgrade yet. How will we know if we need this patch prior to upgrade? Will there be a public announcement or will poor unsuspecting customers have to endure a painful upgrade and later to find that they need to use the 1834 patch first?

lyman

Every asset you insert into MediaBin should have an "Original File Size". Prior to the patch old assets will appear not to have one.

This is because we migrated to the new precision by adding a new field, i.e., you have not lost any data but we are not displaying it. After the patch (or in the case of a new 4.6 upgrade this is automatic in the process), the old data is copied (divided by 1024) to the new location and you will see it.

The upside of this arrangement is that the patch "does no harm" if accidentally applied twice.

Cheers,

Lyman Hurd

PS The patch is in the hands of QA which is trying to get it posted as fast as possible!

lyman

To quote release engineering!

"The new updated (w/both SQL and Oracle sql files) patch package and readme have been posted up on the support site:"

Again you will know you need this if files migrated to MediaBin 4.6 lack a piece of metadata of type "Original File Size". If you have not yet performed the upgrade the latest code should handle this without further intervention.

Cheers,

Lyman Hurd

kshitiz

To quote release engineering!

"The new updated (w/both SQL and Oracle sql files) patch package and readme have been posted up on the support site:"

Again you will know you need this if files migrated to MediaBin 4.6 lack a piece of metadata of type "Original File Size". If you have not yet performed the upgrade the latest code should handle this without further intervention.

Cheers,

Lyman Hurd

Thanks for the help. I have applied the patch and the problem is resolved.

We will be doing the upgrade activity on our production server soon. You have written that "latest code should handle this without further intervention". Does that mean that if we download the MB 4.6 setup again, we wouldn't have to apply this patch again?

bradstew

To quote release engineering!

"The new updated (w/both SQL and Oracle sql files) patch package and readme have been posted up on the support site:"

Again you will know you need this if files migrated to MediaBin 4.6 lack a piece of metadata of type "Original File Size". If you have not yet performed the upgrade the latest code should handle this without further intervention.

Cheers,

Lyman Hurd

I performed an upgrade on Oracle from 4.5.1 to 4.6.1 on 7/19/08 and this problem still exists for me (I have other major problems as well that I'm going through IW support for).

cliff1

I believe the MB SOAP Client from 4.5.2 is compatible with 4.6.x, so the ecmconnector should also be compatible. I believe we tested TS 6.5 SP3 with MB 4.6, but I don't have the docs in front of me to verify this. The ecmconnector code in 6.5 SP2 and SP3 is nearly identical, so both should work with MB 4.6.

I'm not sure about the broken image icon issue, but the 2nd issue (failure to import) is very likely caused by permissions on the IIS wstransfer folder used by the MB WebServices. I believe the name of this folder has changed between 4.5.2 and 4.6 and you need to make sure anonymous access is available. I suspect both issues have to do with some minor configuration issue on the MB Web Services side, so best to read through the latest config notes and double check the configuration.

Note: there have been a couple of issues with the base 4.6 product that have caused a few ecmconnector issues. None of the problems I'm aware of explain the specific items you have reported, but I would recommend 4.6.1 rollup patch 1 if you are not already there.

-Cliff

tracyaskam

There have been several threads about MB 4.6 and if patches are included or not. Please note that 4.6 was release Q2 last year and we have had several updated releases since then (4.6.1 and 4.6.1 SP1).
We highly recommend to utilize the most current version available when performing an upgrade or deploying a new system. Cliff's recommendation is most appropriate to get to the latest and greats as there have been fixes to bugs. I have just validated that both of these maintenance releases are posted on the IWOV Support Site.

Regards,
Tracy

Director Product Management, MediaBin