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
abehrendt
Posts: 8
Registered: ‎07-23-2013
My Device: Z10
My Carrier: Vodafone DE

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.

Hello,

the installation of BES10 proposes unfortunately failed.

Below is an excerpt from the log file.

 

It is an new Win 2008R2 SP1 in German with MAPI 1.2.1 Installed.

 

SQL is installed by the BES10 setup.

 

 

<#03>[30000] (07/23 11:05:44.846):{0x548} SQL being executed:

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = N'PK_EMWSConfigInstance')
BEGIN
ALTER TABLE dbo.EMWSConfigInstance ADD CONSTRAINT PK_EMWSConfigInstance PRIMARY KEY (ServiceInstanceId);
END
<#02>[20000] (07/23 11:05:44.861):{0x548} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft SQL Server Native Client 10.0" - Description "Cannot define PRIMARY KEY constraint on nullable column in table 'EMWSConfigInstance'." Native error = 8111
<#02>[20000] (07/23 11:05:44.861):{0x548} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft SQL Server Native Client 10.0" - Description "Could not create constraint. See previous errors." Native error = 1750
<#02>[20000] (07/23 11:05:44.861):{0x548} [CBESDBInstaller::executeRetryDDL] SQL Error for:

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = N'PK_EMWSConfigInstance')
BEGIN
ALTER TABLE dbo.EMWSConfigInstance ADD CONSTRAINT PK_EMWSConfigInstance PRIMARY KEY (ServiceInstanceId);
END
<#03>[30000] (07/23 11:05:44.861):{0x548} DoAddOn [BAS] returned 3.
<#01>[10000] (07/23 11:05:44.861):{0x548} CBES10DBComp::Install: BDS DB Comp failed to install with error: 10125.
<#01>[10000] (07/23 11:05:44.861):{0x6AC} DoAddOn failed.
<#04>[40000] (07/23 11:05:44.861):{0x6AC} BDSDBInfoDlg executes EnableControls.
<#03>[30000] (07/23 11:05:44.861):{0x6AC} Pause banner animation (OnFinishInstall) for CInstallDlg
<#01>[10000] (07/23 11:05:44.861):{0x6AC} 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] (07/23 11:05:44.861):{0x6AC} Could not load a caption - defaulting to banner title.

Please use plain text.
New Contributor
abehrendt
Posts: 8
Registered: ‎07-23-2013
My Device: Z10
My Carrier: Vodafone DE

Re: 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.

Hello,

 

I have on a Windows 2008 R2 English the same problem.

Please use plain text.
New Member
rlindermeier
Posts: 1
Registered: ‎07-30-2013
My Device: 9900
My Carrier: T-Mobile

Re: 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.

Hello,

I´va the same Problem ... does anybody habe a solution?
Gruß/Regards

Robert Lindermeier
Your-Admin e.K.
Please use plain text.
New Contributor
Madmission
Posts: 5
Registered: ‎03-15-2012
My Device: 9810, BBZ10, BBQ10
My Carrier: Swisscom

Re: 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.

I have the same problem with update from 10.1 to 10.1.2, have some a solution.

 

<#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 ======

Please use plain text.