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
New Contributor
Posts: 5
Registered: ‎03-15-2012
My Device: 9810, BBZ10, BBQ10
My Carrier: Swisscom

Can't upgrade from BES 10.1 to BES10.1.1 or 10.1.2. same Error

<#03>[30000] (08/13 09:12:48.509):{0x1AF4} SQL being executed:
 
INSERT INTO EASReferences (OwnerReferenceId, OwnerReferenceTypeId, OwnerReferenceTypePlugInId,
                           ReferenceTypeId, ReferenceTypePlugInId, Sequence, ReferenceId)
SELECT OwnerReferenceId,
       OwnerReferenceTypeId,
       OwnerReferenceTypePlugInId,
       ReferenceTypeId,
       ReferenceTypePlugInId,
       CASE b.PlugInId WHEN 2 THEN 1
                       WHEN 3 THEN 2
                       WHEN 4 THEN 3
                              ELSE 4 END AS Sequence,
       ReferenceId
  FROM (SELECT i1.ServiceInstanceId AS OwnerReferenceId, 1 AS OwnerReferenceTypeId,
               0 AS OwnerReferenceTypePlugInId, 2 AS ReferenceTypeId,
               0 AS ReferenceTypePlugInId, i2.ServiceInstanceId AS ReferenceId
  FROM EASServiceInstances i1
 INNER JOIN EASServiceInstances i2 ON i1.InstalledOnServerId = i2.InstalledOnServerId
 WHERE i1.PlugInId = 1 AND i1.Type = 1
   AND i2.PlugInId IN (2, 3, 4, 100, 101, 102, 114) AND i2.Type = 1
EXCEPT
    SELECT OwnerReferenceId, OwnerReferenceTypeId, OwnerReferenceTypePlugInId,
           ReferenceTypeId, ReferenceTypePlugInId, ReferenceId
      FROM EASReferences
     WHERE OwnerReferenceTypeId = 1 AND OwnerReferenceTypePlugInId = 0
       AND ReferenceTypeId = 2 AND ReferenceTypePlugInId = 0
) AS a
INNER JOIN EASServiceInstances AS b ON a.ReferenceId = b.ServiceInstanceId
<#02>[20000] (08/13 09:12:48.570):{0x1AF4} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft SQL Server Native Client 10.0" - Description "Cannot insert duplicate key row in object 'dbo.EASReferences' with unique index 'UQ_EASReferences_Sequence'. The duplicate key value is (37, 1, 0, 2, 0, 1)." Native error = 2601
<#02>[20000] (08/13 09:12:48.570):{0x1AF4} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft SQL Server Native Client 10.0" - Description "The statement has been terminated." Native error = 3621
<#02>[20000] (08/13 09:12:48.570):{0x1AF4} [CBESDBInstaller::executeRetryDDL] SQL Error for:

INSERT INTO EASReferences (OwnerReferenceId, OwnerReferenceTypeId, OwnerReferenceTypePlugInId,
                           ReferenceTypeId, ReferenceTypePlugInId, Sequence, ReferenceId)
SELECT OwnerReferenceId,
       OwnerReferenceTypeId,
       OwnerReferenceTypePlugInId,
       ReferenceTypeId,
       ReferenceTypePlugInId,
       CASE b.PlugInId WHEN 2 THEN 1
                       WHEN 3 THEN 2
                       WHEN 4 THEN 3
                              ELSE 4 END AS Sequence,
       ReferenceId
  FROM (SELECT i1.ServiceInstanceId AS OwnerReferenceId, 1 AS OwnerReferenceTypeId,
               0 AS OwnerReferenceTypePlugInId, 2 AS ReferenceTypeId,
               0 AS ReferenceTypePlugInId, i2.ServiceInstanceId AS ReferenceId
  FROM EASServiceInstances i1
 INNER JOIN EASServiceInstances i2 ON i1.InstalledOnServerId = i2.InstalledOnServerId
 WHERE i1.PlugInId = 1 AND i1.Type = 1
   AND i2.PlugInId IN (2, 3, 4, 100, 101, 102, 114) AND i2.Type = 1
EXCEPT
    SELECT OwnerReferenceId, OwnerReferenceTypeId, OwnerReferenceTypePlugInId,
           ReferenceTypeId, ReferenceTypePlugInId, ReferenceId
      FROM EASReferences
     WHERE OwnerReferenceTypeId = 1 AND OwnerReferenceTypePlugInId = 0
       AND ReferenceTypeId = 2 AND ReferenceTypePlugInId = 0
) AS a
INNER JOIN EASServiceInstances AS b ON a.ReferenceId = b.ServiceInstanceId
<#03>[30000] (08/13 09:12:48.573):{0x1AF4} DoAddOn [BAS] returned 3.
<#01>[10000] (08/13 09:12:48.573):{0x1AF4} CBES10DBComp::Install: BDS DB Comp failed to install with error: 10125.
<#01>[10000] (08/13 09:12:48.573):{0x22AC} DoAddOn failed.
<#04>[40000] (08/13 09:12:48.574):{0x22AC} BDSDBInfoDlg executes EnableControls.
<#03>[30000] (08/13 09:12:48.575):{0x22AC} Pause banner animation (OnFinishInstall) for CInstallDlg
<#01>[10000] (08/13 09:12:48.575):{0x22AC} 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] (08/13 09:12:48.575):{0x22AC} Could not load a caption - defaulting to banner title.
<#03>[30000] (08/13 09:12:53.352):{0x22AC} Could not load a caption - defaulting to banner title.
<#03>[30000] (08/13 09:12:55.569):{0x22AC} Cancelling from BDSMainFrameDlg.
<#03>[30000] (08/13 09:12:55.569):{0x22AC} Executing stop from BDSMainFrameDlg.
====== END OF LOG ======

Guru III
Posts: 32,114
Registered: ‎06-25-2008
My Device:

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

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

Re: Can't upgrade from BES 10.1 to BES10.1.1 or 10.1.2. same Error

[ Edited ]

are you running SQL 2008 and using English language?

 

 




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


New Contributor
Posts: 5
Registered: ‎03-15-2012
My Device: 9810, BBZ10, BBQ10
My Carrier: Swisscom

Re: Can't upgrade from BES 10.1 to BES10.1.1 or 10.1.2. same Error

We are runing on SQL 2008R2 and using English language, correct

BlackBerry Employee
Posts: 750
Registered: ‎05-15-2008
My Device: Z10
My Carrier: Rogers

Re: Can't upgrade from BES 10.1 to BES10.1.1 or 10.1.2. same Error

[ Edited ]

You will need to open a support case with BlackBerry to look into why you are getting this database related error and likely run a script to correct the bad data.

New Contributor
Posts: 5
Registered: ‎03-15-2012
My Device: 9810, BBZ10, BBQ10
My Carrier: Swisscom

Re: Can't upgrade from BES 10.1 to BES10.1.1 or 10.1.2. same Error

And how can i open a case on blackberry?

BlackBerry Employee
Posts: 750
Registered: ‎05-15-2008
My Device: Z10
My Carrier: Rogers

Re: Can't upgrade from BES 10.1 to BES10.1.1 or 10.1.2. same Error

Info about support is available at:

 

http://ca.blackberry.com/support/programs/technical.html#tab-1