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 server does not start up!

suj

We have a 4.5.3 mediabin server running on a domain account. We had a change in the service account this morning and the mediabin service is not starting up after the service account change. We have verified the service account and password and it is working fine. The service does not start up even after reverting to the old account. Looks like it is trying to do a query (probably only on service start up) and it is failing.

This is the error in MBP.log
-------------------------------------------------
12/05/06 09:41:14 ******************** MediaBin Server Version 4.5.3 Build 15 starting. ********************
12/05/06 09:41:14 Service account user: GLOBAL\popuri
12/05/06 09:41:14 Error with SQL: SELECT TABLE_NAME FROM user_tables ORDER BY TABLE_NAME
12/05/06 09:41:14 Invalid object name 'user_tables'.

State Smiley Frustrated

0002,Native:208,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

12/05/06 09:41:14 CRepository2::CacheCBIRSpecs() Unable to initialize: A repository error occurred. Check the log or message.
12/05/06 09:41:14 Repo Init Failed.
----------------------------------------------

This is a strange error because the query that it uses looks like an Oracle query because SQL server does not have a view/table named user_tables. It uses the sysobjects table. I have checked the registry and the MBDatabaseType key has SQL Server against it. Also the ODBC connection is working fine.

ENV: MB 4.5.3 Build 15/Win2003

Any help is highly appreciated.

TIA

Find more posts tagged with

Comments

suj

This case was resolved through support. MB uses a user_tables view which requires dbo as the owner which somehow got changed to mediabinSQLUser, probably during an upgrade.

sanrajesh

I'm not sure my same as yours. I upgraded my MediaBin version from 4.0 to 4.5.3.

My MediaBin server shows running in the Services. But the enterprise manager 4.5.3/ Windows client 4.5.3 cannot open and throws error "Unable to connect to server; The MediaBin server is not running".

Log file shows as follows:
02/02/07 17:36:36 License Error: number of servers in cluster 2, exceeds licensed value 1.

Any idea?

msrinivas

You have a single server license but you actually have configured a cluster server with two servers. So

a) Get rid of the second server or
b) Get a cluster server license from IWOV

If you feel that the error is incorrect then you will have to manually clean up the MBSettings SQL table to get rid of the second server listed. I wouldnt recommend you doing it but work with support on it.

HTH

sanrajesh

Checked with the client and confirmed they are not using cluster server.

1) What is the alternative approach to solve this issue?

2) Can you please help me which table data I need to clean up. For clear understanding I'm providing the MBsetting data as follows.

3) Do I need to clear any other registry settings as well?

{33B2252E-8638-48b1-9C70-39623C30E97F} LogDaysRetention 30
{FA1DCC90-612E-4d0c-A533-CC22FFF52BF8} LogDaysRetention 30
{F0351DF9-A0BC-4468-A665-B2A102D840AD} Port 32456
{00000000-0000-0000-0000-000000000000} LDAPPort 389
{F0351DF9-A0BC-4468-A665-B2A102D840AD} ServerNum 4
{F0351DF9-A0BC-4468-A665-B2A102D840AD} Version 4.0 SP1b9
{00000000-0000-0000-0000-000000000000} Version 4.5.3
{2E99016C-5A0C-4777-813A-D5A099AADCB4} Version 4.5.3 Build 15
{2E99016C-5A0C-4777-813A-D5A099AADCB4} maxConcurrentJobs 5
{F0351DF9-A0BC-4468-A665-B2A102D840AD} maxConcurrentJobs 5
{2E99016C-5A0C-4777-813A-D5A099AADCB4} ServerNum 7
{00000000-0000-0000-0000-000000000000} VideoPreviewAudioPath Audio for near-CD quality (64 Kbps stereo).prx
{00000000-0000-0000-0000-000000000000} LDAPGroupNameAttribute cn
{00000000-0000-0000-0000-000000000000} LDAPUserLongNameAttribute cn
{00000000-0000-0000-0000-000000000000} LDAPGroupDescriptionAttribute description
{00000000-0000-0000-0000-000000000000} LDAPUserDescriptionAttribute description
{2E99016C-5A0C-4777-813A-D5A099AADCB4} InstallDirectory E:\Program Files\MediaBin Server
{F0351DF9-A0BC-4468-A665-B2A102D840AD} InstallDirectory E:\Program Files\MediaBin Server
{00000000-0000-0000-0000-000000000000} LDAPGroupClass groupofuniquenames
{00000000-0000-0000-0000-000000000000} LDAPUserClass inetorgperson
{534FC1DD-82A5-445E-A599-2B9AF477AF02} Name MBPAdmins
{EA1C125D-50B4-4BB2-983C-03D571767237} Name MBPCanGetCheckout
{7754EEB9-77AF-4F3C-9457-F5BB7DB0E561} Name MBTaskAdmins
{00000000-0000-0000-0000-000000000000} Name MediaBin Development Server on VISGVOLMB01TD
{F0351DF9-A0BC-4468-A665-B2A102D840AD} Name MediaBin Development Server on VISGVOLMB01TD
{534FC1DD-82A5-445E-A599-2B9AF477AF02} Description MediaBin Platform Administrators
{2E99016C-5A0C-4777-813A-D5A099AADCB4} RepoOdbcDataSourceName MediaBin Repository
{F0351DF9-A0BC-4468-A665-B2A102D840AD} RepoOdbcDataSourceName MediaBin Repository
{2E99016C-5A0C-4777-813A-D5A099AADCB4} Name MediaBin Server on VISGVOLMB01TD
{7754EEB9-77AF-4F3C-9457-F5BB7DB0E561} Description MediaBin Task Administrators
{00000000-0000-0000-0000-000000000000} VideoPreviewVideoPath MediaBin-254x254-20fps.prx
{2E99016C-5A0C-4777-813A-D5A099AADCB4} RepoOdbcUserName MediaBinSQLUser
{F0351DF9-A0BC-4468-A665-B2A102D840AD} RepoOdbcUserName MediaBinSQLUser
{00000000-0000-0000-0000-000000000000} LDAPGroupBaseDN ou=VisaDAMS,ou=Applications,ou=AP,ou=OCB,ou=vol,o=visa.com
{00000000-0000-0000-0000-000000000000} LDAPUserBaseDN OU=VOLUser,ou=AP,ou=OCB,ou=vol,o=visa.com
{534FC1DD-82A5-445E-A599-2B9AF477AF02} Member S-1-5-32-544
{00000000-0000-0000-0000-000000000000} MBDatabaseType SQLServer
{00000000-0000-0000-0000-000000000000} LDAPServer sx930volldap1td
{00000000-0000-0000-0000-000000000000} LDAPUserLogonAttribute uid
{00000000-0000-0000-0000-000000000000} LDAPGroupMembersAttribute uniquemember
{EA1C125D-50B4-4BB2-983C-03D571767237} Description Users who can retrieve checked-out images
{2E99016C-5A0C-4777-813A-D5A099AADCB4} RepoOdbcPassword 12345
{F0351DF9-A0BC-4468-A665-B2A102D840AD} RepoOdbcPassword 12345
{2E99016C-5A0C-4777-813A-D5A099AADCB4} IPAddress VISGVOLMB01TD

Please advice me.

Thanks
RAJESH

FurnaceFace

I've installed MediaBin 4.6 server and I'm getting this error in the MBP startup log:

03/07/08 14:01:05 ******************** MediaBin Server Version MediaBin 4.6.1 Build 7 starting. ********************
03/07/08 14:01:05 Service account user: TestServer\MediaBinUser
03/07/08 14:01:10 Error with SQL: select id from containers where id = parentid and name = ?, 'Media Database'
03/07/08 14:01:10 ORA-01460: unimplemented or unreasonable conversion requested

State:37000,Native:1460,Origin:[Oracle][ODBC][Ora]
03/07/08 14:01:10 Repo Init Failed.

Anyone have any ideas why this is happening?

OS: Windows 2003 - SP2

Thanks,
/FF

msrinivas

What version of Oracle? Is the DB user schema owner? Are you trying to upgrade or is this a new install?

Migrateduser

THAT'S THE SAME PASSWORD ON MY LUGGAGE! :rolleyes:

lyman

Please take your question offline with support. The MBSettings table is not very "user serviceable" and I hate to make blanket statements about editing it in this forum lest the next person to come along tries to apply the advice!

If they are in fact only running a single server the "fix" will indeed come in the form of edits to this table.

Cheers,

Lyman Hurd

Checked with the client and confirmed they are not using cluster server.

1) What is the alternative approach to solve this issue?

2) Can you please help me which table data I need to clean up. For clear understanding I'm providing the MBsetting data as follows.

3) Do I need to clear any other registry settings as well?

{33B2252E-8638-48b1-9C70-39623C30E97F} LogDaysRetention 30
{FA1DCC90-612E-4d0c-A533-CC22FFF52BF8} LogDaysRetention 30
{F0351DF9-A0BC-4468-A665-B2A102D840AD} Port 32456
{00000000-0000-0000-0000-000000000000} LDAPPort 389
{F0351DF9-A0BC-4468-A665-B2A102D840AD} ServerNum 4
{F0351DF9-A0BC-4468-A665-B2A102D840AD} Version 4.0 SP1b9
{00000000-0000-0000-0000-000000000000} Version 4.5.3
{2E99016C-5A0C-4777-813A-D5A099AADCB4} Version 4.5.3 Build 15
{2E99016C-5A0C-4777-813A-D5A099AADCB4} maxConcurrentJobs 5
{F0351DF9-A0BC-4468-A665-B2A102D840AD} maxConcurrentJobs 5
{2E99016C-5A0C-4777-813A-D5A099AADCB4} ServerNum 7
{00000000-0000-0000-0000-000000000000} VideoPreviewAudioPath Audio for near-CD quality (64 Kbps stereo).prx
{00000000-0000-0000-0000-000000000000} LDAPGroupNameAttribute cn
{00000000-0000-0000-0000-000000000000} LDAPUserLongNameAttribute cn
{00000000-0000-0000-0000-000000000000} LDAPGroupDescriptionAttribute description
{00000000-0000-0000-0000-000000000000} LDAPUserDescriptionAttribute description
{2E99016C-5A0C-4777-813A-D5A099AADCB4} InstallDirectory E:\Program Files\MediaBin Server
{F0351DF9-A0BC-4468-A665-B2A102D840AD} InstallDirectory E:\Program Files\MediaBin Server
{00000000-0000-0000-0000-000000000000} LDAPGroupClass groupofuniquenames
{00000000-0000-0000-0000-000000000000} LDAPUserClass inetorgperson
{534FC1DD-82A5-445E-A599-2B9AF477AF02} Name MBPAdmins
{EA1C125D-50B4-4BB2-983C-03D571767237} Name MBPCanGetCheckout
{7754EEB9-77AF-4F3C-9457-F5BB7DB0E561} Name MBTaskAdmins
{00000000-0000-0000-0000-000000000000} Name MediaBin Development Server on VISGVOLMB01TD
{F0351DF9-A0BC-4468-A665-B2A102D840AD} Name MediaBin Development Server on VISGVOLMB01TD
{534FC1DD-82A5-445E-A599-2B9AF477AF02} Description MediaBin Platform Administrators
{2E99016C-5A0C-4777-813A-D5A099AADCB4} RepoOdbcDataSourceName MediaBin Repository
{F0351DF9-A0BC-4468-A665-B2A102D840AD} RepoOdbcDataSourceName MediaBin Repository
{2E99016C-5A0C-4777-813A-D5A099AADCB4} Name MediaBin Server on VISGVOLMB01TD
{7754EEB9-77AF-4F3C-9457-F5BB7DB0E561} Description MediaBin Task Administrators
{00000000-0000-0000-0000-000000000000} VideoPreviewVideoPath MediaBin-254x254-20fps.prx
{2E99016C-5A0C-4777-813A-D5A099AADCB4} RepoOdbcUserName MediaBinSQLUser
{F0351DF9-A0BC-4468-A665-B2A102D840AD} RepoOdbcUserName MediaBinSQLUser
{00000000-0000-0000-0000-000000000000} LDAPGroupBaseDN ou=VisaDAMS,ou=Applications,ou=AP,ou=OCB,ou=vol,o=visa.com
{00000000-0000-0000-0000-000000000000} LDAPUserBaseDN OU=VOLUser,ou=AP,ou=OCB,ou=vol,o=visa.com
{534FC1DD-82A5-445E-A599-2B9AF477AF02} Member S-1-5-32-544
{00000000-0000-0000-0000-000000000000} MBDatabaseType SQLServer
{00000000-0000-0000-0000-000000000000} LDAPServer sx930volldap1td
{00000000-0000-0000-0000-000000000000} LDAPUserLogonAttribute uid
{00000000-0000-0000-0000-000000000000} LDAPGroupMembersAttribute uniquemember
{EA1C125D-50B4-4BB2-983C-03D571767237} Description Users who can retrieve checked-out images
{2E99016C-5A0C-4777-813A-D5A099AADCB4} RepoOdbcPassword 12345
{F0351DF9-A0BC-4468-A665-B2A102D840AD} RepoOdbcPassword 12345
{2E99016C-5A0C-4777-813A-D5A099AADCB4} IPAddress VISGVOLMB01TD

Please advice me.

Thanks
RAJESH

lyman

Check that you are running the very latest ODBC driver from Oracle.

Cheers,

Lyman Hurd

I've installed MediaBin 4.6 server and I'm getting this error in the MBP startup log:

03/07/08 14:01:05 ******************** MediaBin Server Version MediaBin 4.6.1 Build 7 starting. ********************
03/07/08 14:01:05 Service account user: TestServer\MediaBinUser
03/07/08 14:01:10 Error with SQL: select id from containers where id = parentid and name = ?, 'Media Database'
03/07/08 14:01:10 ORA-01460: unimplemented or unreasonable conversion requested

State:37000,Native:1460,Origin:[Oracle][ODBC][Ora]
03/07/08 14:01:10 Repo Init Failed.

Anyone have any ideas why this is happening?

OS: Windows 2003 - SP2

Thanks,
/FF