Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
Contributor
stentofon
Posts: 12
Registered: ‎03-25-2013
My Device: Z10

Error installing BES 10

Performed a clean uninstall of BESx 5.

 

Installed BES10.

 

Create new database, and this fails with the following error;

 

COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft SQL Server Native Client 10.0" - Description "Incorrect syntax near the keyword 'WHERE'." Native error = 156

 

Anyone have the solution to this?

Please use plain text.
Guru III
knottyrope
Posts: 30,609
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Error installing BES 10

you might have left SQL behind which still has the old BES database, this is not remove when doing an uninstall.

 

easy fix call BESMgmt name BESMgmt10 and it wont try to use the old name

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
Contributor
stentofon
Posts: 12
Registered: ‎03-25-2013
My Device: Z10

Re: Error installing BES 10

Hello Knottyrope.  Thanks for your reply, as I see you're very busy across these forums.

 

I had deleted the old BESMgmt database in SQL Studio prior to starting the BES10 install.  I went back and deleted all BES related databases created during this failed attempt at install and started again.

 

When creating the new BESMgmt database, it fails with the same error, and the error message displayed is;

'The setp application could not update the database schema files and did not create or upgrade the database'

 

The log shows this;

 

<#02>[20000] (03/26 09:16:03.049):{0x22E4} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft SQL Server Native Client 10.0" - Description "Incorrect syntax near the keyword 'WHERE'." Native error = 156

<#02>[20000] (03/26 09:16:03.049):{0x22E4} [CBESDBInstaller::executeRetryDDL] SQL Error for:

/*==============================================================*/ /* Index: UQ_EASUsers_UserDN                                    */ /*==============================================================*/ IF NOT EXISTS (select 1 from sysindexes where id = OBJECT_ID(N'dbo.EASUsers')                and name = 'UQ_EASUsers_UserDN' and indid > 0 and indid < 255) BEGIN    CREATE unique INDEX UQ_EASUsers_UserDN ON dbo.EASUsers (       UserDN ASC,       ExternalDirectoryServiceInstanceId ASC    )    WHERE (UserDN IS NOT NULL) AND (ExternalDirectoryServiceInstanceId IS NOT NULL) END

<#01>[10000] (03/26 09:16:03.049):{0x3710} Failed to install/upgrade database BESMgmt - SQL Error.

<#04>[40000] (03/26 09:16:03.051):{0x3710} BDSDBInfoDlg executes EnableControls.

<#03>[30000] (03/26 09:16:03.051):{0x3710} Pause banner animation (OnFinishInstall) for CInstallDlg

<#01>[10000] (03/26 09:16:03.051):{0x3710} The setup application could not update the database schema files and did not create or upgrade the database. For more information, check the installation log files on the computer.

<#03>[30000] (03/26 09:16:03.051):{0x3710} Could not load a caption - defaulting to banner title.

 

Does that give you any further detail to work with?

Thanks in advance.

Please use plain text.
Guru III
knottyrope
Posts: 30,609
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Error installing BES 10

make a new database called BESMgmt10 there might be some SQL jobs left behind that are not compatable.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
Contributor
stentofon
Posts: 12
Registered: ‎03-25-2013
My Device: Z10

Re: Error installing BES 10

No good.  It fails in the same format no matter what I call the new database.

Please use plain text.
Guru III
knottyrope
Posts: 30,609
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Error installing BES 10


 

Double check permission according to this

 

KB02276 - Assigning permissions for a BlackBerry Enterprise Server service account

 

 



What is the BESAdmin service account?
http://supportforums.blackberry.com/t5/BlackBerry-Enterprise-Solution/What-is-the-BESAdmin-service-a...

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.
Contributor
stentofon
Posts: 12
Registered: ‎03-25-2013
My Device: Z10

Re: Error installing BES 10

Got past this stage by uninstalling everything including SQL 2005 and re-installing using the SQL 2008 express that is supplied with BES 10.

 

Now I'm stuck at the 'Create an Administrator account' step, where the system is 'unable to obtain LDAP information about the BlackBerry Service administrator account'

 

The log shows;

<#03>[30000] (03/27 14:56:11.381):{0x1CD4} CBASAdministrativeAccountCon::UseCurrentWindowsAccount: sets user current account to [1]
<#04>[40000] (03/27 14:56:12.363):{0x1CD4} AdvancedAdminDlg executes DisableControls.
<#03>[30000] (03/27 14:56:12.363):{0x1CD4} CAdvancedAdminDlg::smileysurprised:nNextImpl: Use current reader account [BESadmin], domain [stentofon.local] which are different than the current login account.
<#03>[30000] (03/27 14:56:12.363):{0x239C} CBASAdministrativeAccountCon::Validate: begins - Mode=1, UseCurrAcct=1, WinUser[administrator], WinDom[STENTOFON], BASUser[admin], BASPwd[XXXXXXXX], BASPwdCon[XXXXXXXX], AE[0]CES[1], IVA[1/0/0] LD[1]WD[0] RO[0]
<#01>[10000] (03/27 14:56:12.363):{0x239C} CBASUtilitiesCon::GetADUserInfo - Container not initialized, cannot execute function
<#01>[10000] (03/27 14:56:12.363):{0x239C} CBASAdministrativeAccountCon::Validate: GetADUserInfo failed, code 3
<#03>[30000] (03/27 14:56:12.363):{0x239C} CBASAdministrativeAccountCon::Validate: result code from validating was [13] - [Mode=1, UseCurrAcct=1, WinUser[administrator], WinDom[STENTOFON], BASUser[admin], BASPwd[XXXXXXXX], BASPwdCon[XXXXXXXX], AE[0]CES[1], IVA[1/0/0] LD[1]WD[0] RO[0]]
<#01>[10000] (03/27 14:56:12.363):{0x239C} CDataContainer::smileyvery-happy:oValidate: CBASAdministrativeAccountCon failed to validate. Result: 13.
<#01>[10000] (03/27 14:56:12.363):{0x1CD4} [CBASAdministrativeAccountCon::smileyvery-happy:oValidate]: Validation failed
<#03>[30000] (03/27 14:56:12.363):{0x1CD4} Could not load a caption - defaulting to banner title.
<#04>[40000] (03/27 14:56:56.201):{0x1CD4} AdvancedAdminDlg executes EnableControls.

 

I have tried specifing a different account, and also tried to use Blackberry Administraton Service authentication which fails with 'An unexpected error occurred'.  The log shows;

 

<#03>[30000] (03/27 14:58:49.571):{0x1CD4} CBASAdministrativeAccountCon::AuthenticationMethod: sets authentication method to [2]
<#04>[40000] (03/27 14:58:51.240):{0x1CD4} AdvancedAdminDlg executes DisableControls.
<#03>[30000] (03/27 14:58:51.240):{0x324} CBASAdministrativeAccountCon::Validate: begins - Mode=2, UseCurrAcct=1, WinUser[administrator], WinDom[STENTOFON], BASUser[admin], BASPwd[XXXXXXXX], BASPwdCon[XXXXXXXX], AE[0]CES[1], IVA[1/0/0] LD[1]WD[0] RO[0]
<#01>[10000] (03/27 14:58:51.240):{0x324} CBASUtilitiesCon::Hash - Container not initialized, cannot execute function
<#01>[10000] (03/27 14:58:51.240):{0x324} CBASAdministrativeAccountCon::Validate: encode BAS password failed, code 3
<#03>[30000] (03/27 14:58:51.240):{0x324} CBASAdministrativeAccountCon::Validate: result code from validating was [11] - [Mode=2, UseCurrAcct=1, WinUser[administrator], WinDom[STENTOFON], BASUser[admin], BASPwd[XXXXXXXX], BASPwdCon[XXXXXXXX], AE[0]CES[1], IVA[1/0/0] LD[1]WD[0] RO[0]]
<#01>[10000] (03/27 14:58:51.240):{0x324} CDataContainer::smileyvery-happy:oValidate: CBASAdministrativeAccountCon failed to validate. Result: 11.
<#01>[10000] (03/27 14:58:51.240):{0x1CD4} [CBASAdministrativeAccountCon::smileyvery-happy:oValidate]: Validation failed
<#03>[30000] (03/27 14:58:51.240):{0x1CD4} Could not load a caption - defaulting to banner title.
<#04>[40000] (03/27 14:59:12.004):{0x1CD4} AdvancedAdminDlg executes EnableControls.

 

Any suggestions? The error seems similar but not exactly to this - http://btsc.webapps.blackberry.com/btsc/viewdocument.do?noCount=true&externalId=KB21663&sliceId=2&cm...

 

Please use plain text.
Regular Contributor
DHulka
Posts: 53
Registered: ‎06-25-2012
My Device: Z10

Re: Error installing BES 10

SQL 2008 is required now with BES 10. SQL 2005 worked with BDS for Playbooks but not with the new BES 10.

Please use plain text.
Contributor
stentofon
Posts: 12
Registered: ‎03-25-2013
My Device: Z10

Re: Error installing BES 10

We are now on 2008 which fixed the original problem but now we're stuck at the last step.
Please use plain text.
Guru III
knottyrope
Posts: 30,609
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Error installing BES 10

make a sql auth account and then assign a role to user after,this will be handy if you ever have a DC issue as you can still log into the server with the auth account

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.