The AOS Server cannot tbe reached. Setup cannot continue in ssrs installation AX 2012

The AOS Server cannot tbe reached. Setup cannot continue in ssrs installation AX 2012

Hi,
I am getting this error while installing SSRS Report in my local. I am getting this following error.

For this you need to check the Business proxy account in your local database. Because i am restoring the Another Domain Database it consist of Another Domain proxy account.

So, you want to change the proxy account to login domain.

Go to System Administration module --> Setup --> System 

Click on System service accounts.

Enter your login Alias and Network Domain 

 Issues is resolved.

Its went to next steps.

Thank you.

Searching for updates in Axapta Installation long time

 Searching for updates in Axapta Installation long time

While i am going to install Ax 2012 R2 it takes long time it is in searching stage

don't know what happend..?

After searching of some blog i got this solution.

You need to turn off the windows update as below screen shot.

I selected the "Never check for Updates (not recommended)" .

After then installation goes for next steps.

I followed this link. Its work for me.

https://community.dynamics.com/ax/f/33/t/156739

Thank you for this suggestions.

Error 2503 called runscript when not marked in progress in ax 2012

Error 2503 called runscript when not marked in progress in ax 

For this error while i am going to uninstallation. I following this youtube link this will resolved my problem


https://www.youtube.com/watch?v=AE_6vYMm7vY

Follow this process step by step it will resovle my issues.

Thank you for this link.

Query lookup in ax 2012 using x++ code

Query lookup in ax 2012 using x++ code

public void lookup()

{

    Query                   query;

    QueryBuildDataSource    vendTable;

    QueryBuildRange         range;

    SysTableLookup          sysTableLookup;

    query               = new Query();

    vendTable           = query.addDataSource(tableNum(VendTable));

    range               = vendTable.addRange(fieldNum(VendTable, AccountNum));

    range.value("INMF-000001");//here we can pass range

    sysTableLookup = SysTableLookup::newParameters(tableNum(VendTable), this);

    //here true is used for getting accountNum only.

    sysTableLookup.addLookupfield(fieldNum(VendTable, AccountNum),true);

   //here we can get the method like this way.

    sysTableLookup.addLookupMethod(tableMethodStr(VendTable, Name));

    

    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();

}

Args Lookup methods in AX 2012 using X++ code

Args Lookup methods in AX 2012 using X++ code

public void lookup()
{
    Args     args;
    Object  formRun;
    ;
    super();
    args = new Args();
    args.caller(this);
    args.name(formStr(VendTableLookup));//VendTableLookup is a form calling for lookup purpose
    args.lookupField(fieldNum(VendTable, AccountNum));
    args.lookupValue( "");// here you can pass the value

    formRun = classfactory.formRunClass(args);
    formRun.init();
    this.performFormLookup(formRun);
}

or

public void lookup()
{
    super();
    VendTable::lookupVendTable(this);
}

[Microsoft][SQL Server Native Client 11.0]Unspecified error occurred on SQL Server. Connection may have been terminated by the server

 [Microsoft][SQL Server Native Client 11.0]Unspecified error occurred on SQL Server. Connection may
have been terminated by the server

Object Server 01:  The database reported (session 1 (-AOS-)): [Microsoft][SQL Server Native Client 11.0]Unspecified error occurred on SQL Server. Connection may
have been terminated by the server.. The SQL statement was: "SELECT COUNT(T1.TZENUM) FROM TIMEZONESLIST T1"


While i am going to start the server its showing me a warning message.

I went to event viewer, reason for not starting the server. It showing the below issues.




I Opened the SQL database and checked.

Here the "TimeZonesList" table is corrupted. So, I delete the table.

After that, i copy and paste this code in the database and Execute this command for re-creation same table.
Got a message completed successfully.


CREATE TABLE [dbo].[TIMEZONESLIST](
[TZENUM] [int] NOT NULL DEFAULT ((0)),
[TIMEZONEKEYNAME] [nvarchar](64) NOT NULL DEFAULT (''),
[ENUMNAME] [nvarchar](64) NOT NULL DEFAULT (''),
[ENUMPOSITION] [int] NOT NULL DEFAULT ((0)),
[RECVERSION] [int] NOT NULL DEFAULT ((1)),
[RECID] [bigint] NOT NULL,
 CONSTRAINT [I_65496TZENUM] PRIMARY KEY CLUSTERED 
(
[TZENUM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


as picture as below.










After then start the service. It will work fine.


Thank You.

Example of Macros in ax 2012

Example of Macros in ax 2012

You can create a temporary text message using like this

here the TestMacro is not present in Macro node in ax 2012

i created a temporary Macro 

from this i called Macro and getting the information using like this...

static void TestMacro(Args _args)

{

    #define.test("Hai hello how do you do?")

    

    info(strFmt("%1",#test()));

}

Thank you.

Exception from HRESULT: 0xC0048021 at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite)

page contents

Exception from HRESULT: 0xC0048021 at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite)

If you're using Excel 2013 like I am, the problem is caused by DMConfig XML file.

Go to the DMConfig.xml file in the 

C:\Program Files\Microsoft Dynamics AX\60\DataImportExportFramework folder and replace the 

PipelineComponentInfo_Multicast, 

PipelineComponentInfo_ExcelSource, 

PipelineComponentInfo_ExcelDestination nodes by the following:

<PipelineComponentInfo_Multicast>
    {33D831DE-5DCF-48F0-B431-4D327B9E785D}  </PipelineComponentInfo_Multicast>
  <PipelineComponentInfo_ExcelSource>
    {9F5C585F-2F02-4622-B273-F75D52419D4A}
  </PipelineComponentInfo_ExcelSource>
  <PipelineComponentInfo_ExcelDestination>
    {90E2E609-1207-4CB0-A8CE-CC7B8CFE2510}
  </PipelineComponentInfo_ExcelDestination>

It will solve the issue.

Thank you

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'

Hi Every one,

This is  my first blog.

I got a error while opening a CustTable form in AX2012R3 like..

“SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'tempdb'.” 
As show in below figure.

Solution:

After Some R&D on some administrations and I open my SQL using Run.

è   Windows + R

è   Type : SSMS

Press OK button.

Before that you have to know your AOS service is running on login Account or Network Account.

My service is running on Network Account. So I go for NT AUTHORITY\NETWORK SERVICE.

SQL will be opened after that I went to securities --> Login --> NT AUTHORITY\NETWORK SERVICE

Right Click --> Properties --> Select User Mapping --> Select TempDB --> And below select db_ddladmin, db_datareader and db_datawriter.

Press OK.

And opened the form. This issues never repeat again.

Please find the below figure.

Thank you.

Any concern about this blog will be accepted.