Creating schema on SQL 2012 fails

This article applies to Microsoft Dynamics AX for all regions.

Symptoms

Creating schema on SQL 2012 fails with error below:
 
Initialize-AXModelStore : The pipeline has been stopped.


Cause

Cannot create trigger 'TempSchema.UpdateChangedBy' because its schema is different from the schema of the target table or view.
 
And the sql statement is

CREATE TRIGGER [TempSchema].UpdateChangedBy ON Model

   AFTER UPDATE

Resolution

Use [dbo].model instead of model, so that system can convert dbo to the current schema.

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website: You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

PartnersCustomersIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.


Installation information

If you have customizations for one or more of the methods or the tables that are affected by this hotfix, you must apply these changes in a test environment before you apply the hotfix in a production environment.
For more information about how to install this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
893082 How to install a Microsoft Dynamics AX hotfix

Prerequisites

You must have Microsoft Dynamics AX 2012 installed to apply this hotfix.

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.

File information

The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
File nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot Applicable60,28004-Nov-201121:58x86
Axupdate.exeNot Applicable60,26404-Nov-201121:58x86
Licensetermsar.rtfNot Applicable2,17007-Nov-201112:25Not Applicable
Licensetermscs.rtfNot Applicable91,09928-Jun-201108:14Not Applicable
Licensetermsda.rtfNot Applicable101,04328-Jun-201108:14Not Applicable
Licensetermsde.rtfNot Applicable116,49628-Jun-201108:14Not Applicable
Licensetermsen.rtfNot Applicable110,06728-Jun-201108:14Not Applicable
Licensetermses.rtfNot Applicable96,85028-Jun-201108:14Not Applicable
Licensetermset.rtfNot Applicable102,77828-Jun-201108:14Not Applicable
Licensetermsfi.rtfNot Applicable105,98928-Jun-201108:14Not Applicable
Licensetermsfr.rtfNot Applicable129,86928-Jun-201108:14Not Applicable
Licensetermshe-il.rtfNot Applicable43,37628-Jun-201108:14Not Applicable
Licensetermshu.rtfNot Applicable92,86328-Jun-201108:14Not Applicable
Licensetermsis.rtfNot Applicable36,27528-Jun-201108:15Not Applicable
Licensetermsit.rtfNot Applicable114,94728-Jun-201108:15Not Applicable
Licensetermsja.rtfNot Applicable105,77828-Jun-201108:15Not Applicable
Licensetermslt.rtfNot Applicable122,40028-Jun-201108:15Not Applicable
Licensetermslv.rtfNot Applicable105,28928-Jun-201108:15Not Applicable
Licensetermsnb-no.rtfNot Applicable115,55828-Jun-201108:15Not Applicable
Licensetermsnl.rtfNot Applicable109,75628-Jun-201108:15Not Applicable
Licensetermspt-br.rtfNot Applicable101,38228-Jun-201108:15Not Applicable
Licensetermsru.rtfNot Applicable148,30728-Jun-201108:15Not Applicable
Licensetermssv.rtfNot Applicable115,13828-Jun-201108:15Not Applicable
Licensetermsth.rtfNot Applicable153,64428-Jun-201108:15Not Applicable
Licensetermstr.rtfNot Applicable104,21028-Jun-201108:15Not Applicable
Licensetermszh-hans.rtfNot Applicable99,13128-Jun-201108:15Not Applicable
Clientoba32.mspNot Applicable21,221,37613-Aug-201223:55Not Applicable
Clientoba64.mspNot Applicable21,221,37613-Aug-201223:55Not Applicable
Components32.mspNot Applicable18,472,96013-Aug-201223:54Not Applicable
Components64.mspNot Applicable35,729,40813-Aug-201223:55Not Applicable
Helpserver64.mspNot Applicable901,12013-Aug-201223:55Not Applicable
Objectserver32.mspNot Applicable7,286,78413-Aug-201223:55Not Applicable
Objectserver64.mspNot Applicable9,248,76813-Aug-201223:54Not Applicable
Retaildatabaseutility.mspNot Applicable307,20013-Aug-201223:55Not Applicable
Retailheadquarters32.mspNot Applicable802,81613-Aug-201223:55Not Applicable
Retailheadquarters64.mspNot Applicable802,81613-Aug-201223:54Not Applicable
Retailpos.mspNot Applicable2,994,17613-Aug-201223:54Not Applicable
Retailposplugins.mspNot Applicable299,00813-Aug-201223:55Not Applicable
Retailstoreconnect32.mspNot Applicable430,08013-Aug-201223:55Not Applicable
Retailstoreconnect64.mspNot Applicable430,08013-Aug-201223:54Not Applicable
Retailtransactionservice.mspNot Applicable122,88013-Aug-201223:54Not Applicable
Setupsupport32.mspNot Applicable11,804,67213-Aug-201223:54Not Applicable
Setupsupport64.mspNot Applicable19,087,36013-Aug-201223:54Not Applicable
Traceparser.mspNot Applicable442,36813-Aug-201223:54Not Applicable
Axsetupsp.exe6.0.1108.12881,378,53611-Jul-201206:19x86
Axutillib.dll6.0.1108.806821,48021-May-201200:18x86
Microsoft.dynamics.servicing.operations.dll6.0.888.43635,75209-Jun-201106:36x86
Axsetupsp.resources.dll6.0.947.491382,84804-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491370,56004-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491374,65604-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491374,65604-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491370,56004-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491378,75204-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491370,56004-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491374,65604-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491370,56004-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491374,65604-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491370,56004-Nov-201121:58x86
Axsetupsp.resources.dll6.0.947.491407,42404-Nov-201121:58x86

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
內容

文章識別碼:2744296 - 最後檢閱時間:2013年7月5日 - 修訂: 1

意見反應