Production Database backup Request

Production Database backup Request Life cycle service

Using following steps you can request the database backup of production to your UAT Sandbox environment.


Step-1 Click on hamburger Icon and click on support menu item.

Step-2 Now click on Service request tab from left panel.

Step-3 Now click on Add icon a popup window will appear with 3 Different Request.

Step-4  Three type of service request available. Please click on Database Refresh Request.

Following are some information about service request.

Data Point in time restore request 
      This request we use to request Microsoft to restore the production DB on any particular date.

Other Request 
      In this service request we can ask for different options, Like ICM ticket or can request them to update the statistics of production database.

Database Refresh Request
     This service request we use to restore database from production to UAT.  

Step-5 On 1st Drop down select the source environment name. On 2nd drop down select target server name. provide the time window. and acknowledge the both agreement and click next.

Step-6 Mark check box to acknowledge the terms and conditions and click submit. 

You request submitted to Microsoft.

Please feel free to contact me if you are facing any issue while following this blog.

D365 Support Ticket Using LCS

D365 Support Ticket Using LCS

There are Two type of Tickets are available in LCS for D365FO 

1. Normal Support Ticket 
2. Production Outage

Normal Support Ticket

This ticket is available for you all hosted environment of LCS. using following steps you can create the ticket.


Step-1  Login to LCS to Enter on your project tile.
Step-2  click on ham-burger icon and click on support menu item

Step-3 Click on support tab from left panel and then click on submitted to Microsoft Tab.
Step-4 Now Click on Submit incident.

Step-5 There are 5 different category available please select the category as per your requirement and click next. in my case i have selected last category.

Step-6 In below image you can find more sub category. select the issue related category and click on next. For demo purpose i have selected Document routing agent.

Step-7 Fill the required field. select environment and enter all information related to the Error you are facing and click next.

Step-8 Enter Contact person information, To whom Microsoft will contact to discuss the issue.

In the last of the screen you find the additional Email section. 

Here you can Enter the email address so Microsoft will remain them in loop of email conversation. 

Step-9  This is the final step of normal support ticket. Please select subscription type of ticket and category and click submit. 

Production Outage

This type of ticket Microsoft reveal for their customer on end of the Dec-2017. This ticket only available for production server only. Microsoft engineer use to called this Red Button.

using following steps you create Production outage.

Step-1  Login to LCS to Enter on your project tile.
Step-2  click on ham-burger icon and click on support menu item

Step-3 Click on support tab from left panel and then click on submitted to Microsoft Tab.
Step-4 Now Click on Report production outage.

Step-5 Set the check box yes and select the issue type from drop down and click continue.

Step-6 Enter the title of the issue. 
Step-7 Mark check box yes if you receiving any error message.
Step-8 Mark check box yes if you if you tried this on another browser.
Step-9 Mark check box yes if you know when production outage begin.
Step-10 Enter Detail of the issues and click next.

Step-10 Enter the contact person Information and click next. In next window you will get the ticket reference number.

Please feel free to contact me if you are facing any issue while following this blog.

Container Functions D365FO-AX 2012

Container Functions D365FO-AX 2012

Today, I am Sharing the functions of container, I have explored during in my career.

Container View

conView

Parameters

cconView(container,Caption,false);

reference screenshot

Insert in container

conIns

Parameters

conIns(container,position,anytype of value);

Example

   container   objContainer;
    int     position=1;
    // insert in container
   objContainer =conIns(objContainer,position,"Sohail Sheikh");

reference screenshot

Length of container 

conLen

Parameters

conLen(containerobject); // will return int

 Example

 container   objContainer=["Sohail Sheikh"];
    int     position=1,len=0;
    

 // container length   
   len=conLen(objContainer);
    info(strFmt("%1",len));

reference screenshot

Pull Data from container

conpeek

Parameters


conpeek(container,position)// will return anytype

Example
  container   objContainer=["Sohail Sheikh"];
    int     position=1;
    str objValue;

        
    // pull data from container   
    objValue=conPeek(objContainer,position);
        info(strFmt("%1",objValue));
 
reference screenshot

Replace Data of container

conpoke

Parameters

conPoke(container,position,anyvalue)// will return container

Example

   container   objContainer=["Sohail Sheikh"];

    int     position=1;

    str objValue;

        

    

     objContainer=conPoke(objContainer,position,"Sheikh Sohail Hussain");

    objValue=conPeek(objContainer,position);    

    info(strFmt("%1",objValue));

reference screenshot

Container Insert Operator 

Parameters

Example
    container   objContainer=["Sohail Sheikh"];
    int     position=1;
    str objValue;

        // insert using operator 
    objContainer+="Inserted";
       
    

    info(strFmt("%1,%2",conPeek(objContainer,1),conPeek(objContainer,2)));

reference screenshot

Find value in Container  

conFind

Parameters

conFind(container,anytype)// will return true or false


Example
 container   objContainer=["Sohail Sheikh"];
    int     position=1;
    str objValue;

        // insert using operator 
    objContainer+="Inserted";
    
      if(conFind(objContainer,"Inserted"))
    {
        info("Value found");
    }

   
reference screenshot

Delete value in Container  

conDel

Parameters

conDel(container,startPosition,EndPosition)// will return container

Example
container   objContainer=["Sohail Sheikh"];
    int     position=1;
    str objValue;

        // insert using operator 
    objContainer+="Inserted";
    
    info(strFmt("Container length Before delete %1",conLen(objContainer)));
    objContainer=conDel(objContainer,2,2);
  
   
   info(strFmt("Container length After delete %1",conLen(objContainer)));

    
reference screenshot

Container  to Str

con2Str

Parameters

conStr(container)// string

Example

  container   objContainer=["Sohail Sheikh"];
    int     position=1;
    str objValue;

        // insert using operator 
    objContainer+="Inserted";
    
    info(con2Str(objContainer));

reference screenshot

Container  Null

conNull

Parameters

conNull()// set the container null

Example

 container   objContainer=["Sohail Sheikh"];
    int     position=1;
    str objValue;

        // insert using operator 
    objContainer+="Inserted";
    
    info(strFmt("Container length Before set null %1",conLen(objContainer)));

 objContainer=conNull(); 
   

   info(strFmt("Container length After set null %1",conLen(objContainer)));


reference screenshot

Str to container

str2con

Parameters

str2Con(stringValues,separator);// will return container

 str objValue;

    container   objContainer;

    objContainer=str2con("Sheikh,Sohail",",");

    

    info(strFmt("%1",con2Str(objContainer)));

reference screenshot

Batch Job Schedule X++ D365FO

Batch Job Schedule D365FO

With the following X++ sample code you can schedule a Batch job.

Sample Code

static void batchJobSchedule(Args _args)

    {

        BatchHeader objBatchheader;

        SysRecurrenceData sysRecurrenceData;

        Batch batch;

        BatchJob batchJob;

        RetailCDXScheduleRunner objRetailSchedule;

        BatchInfo objBatchInfo;

        BatchRetries noOfRetriesOnFailure = 0;

        ;

        // Setup the RunBaseBatch Job

        objBatchheader = Batchheader::construct();

        objRetailSchedule = new RetailCDXScheduleRunner();

        objBatchInfo = objRetailSchedule.batchInfo();

        objBatchInfo.parmRetriesOnFailure(noOfRetriesOnFailure);

        objBatchInfo.parmCaption("Description should be here"); // Description Batch Job

        objBatchInfo.parmGroupId('YourBatchGroup'); // Batch Gorup

        objBatchInfo.parmBatchExecute(NoYes::Yes);

        objBatchheader.addTask(objRetailSchedule);

        // Set the recurrence data

        sysRecurrenceData = SysRecurrence::defaultRecurrence();

        SysRecurrence::setRecurrenceStartDateTime(sysRecurrenceData, DateTimeUtil::addSeconds(DateTimeUtil::utcNow(), 20)); // Set range of recurrence

        SysRecurrence::setRecurrenceNoEnd(sysRecurrenceData);

        SysRecurrence::setRecurrenceUnit(sysRecurrenceData, SysRecurrenceUnit::Minute); // Set reccurence pattern

        objBatchheader.parmRecurrenceData(sysRecurrenceData);

        // Set the batch alert configurations

        objBatchheader.parmAlerts(NoYes::No, NoYes::Yes, NoYes::No, NoYes::Yes, NoYes::Yes);

        objBatchheader.save();

        // Update the frequency to run the job to every two minutes

        ttsbegin;

        select forupdate batchJob

            join batch

            where batchJob.RecId == batch.BatchJobId

            && batch.ClassNumber == classnum(RetailConnScheduleRunner);

        sysRecurrenceData = batchJob.RecurrenceData;

        sysRecurrenceData = conpoke(sysRecurrenceData, 8, [10]);

        batchJob.RecurrenceData = sysRecurrenceData;

        batchJob.update();

        ttscommit;

    }

Enable AOS Authorization field using security privilege

Enable AOS Authorization field using security privilege 

Yesterday one of my team member were facing Access Denied error on some fields of table HcmPersonDetails while selecting the record. even she provide the complete rights on this table.

After spending few hours on this issue we found difference in fields properties.
AOS Authorization set as Yes.

Resolution

For the resolution, I have suggested her to add all the required fields in the privilege as well and perform build and sync the database. 

Please feel free to contact me if you are facing any issue while implementing of this blog.

Email SSRS Report As Attachment D365FO

SSRS Report Email Attachment Dynamics 365FO

In one of my projects, We have a requirement to send the SSRS report as an attachment to an Email.

As everyone knows that this task is too simple in AX 2012, Where we save the file in client or server file systems and then send it as an Email attachment.

But the things are a bit more complicated when it comes to D365 in the cloud. You are no longer able to save the file locally as storage.

Following is the code to convert the SSRS report in Binaries 

public class ConvertReportPDF

{

    public static void main(Args _args)

    {

       

  

        Filename                        fileName = "P000173_AbcTest.pdf";

        SrsReportRunController    controller = new SrsReportRunController();

        SLD_TaxProfileContract   contract = new SLD_TaxProfileContract();

        SRSPrintDestinationSettings     settings;

        Array                           arrayFiles;

        System.Byte[]                   reportBytes = new System.Byte[0]();

        SRSProxy                        srsProxy;

        SRSReportRunService             srsReportRunService = new SrsReportRunService();

        Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[]  parameterValueArray;

        Map reportParametersMap;

        SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();

        ;

  

        contract.parmAccountNum('K-VDR-000001');

        contract.parmAccountType(SLD_AccountType::Vendor);

        // Provide details to controller and add contract

        controller.parmArgs(_args);

        controller.parmReportName(ssrsReportStr(SLD_TaxProfile, Report));

        controller.parmShowDialog(false);

        controller.parmLoadFromSysLastValue(false);

        controller.parmReportContract().parmRdpContract(contract);

        // Provide printer settings

        settings = controller.parmReportContract().parmPrintSettings();

        settings.printMediumType(SRSPrintMediumType::File);

        settings.fileName(fileName);

        settings.fileFormat(SRSReportFileFormat::PDF);

        // Below is a part of code responsible for rendering the report

        controller.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());

        controller.parmReportContract().parmReportExecutionInfo(executionInfo);

        srsReportRunService.getReportDataContract(controller.parmreportcontract().parmReportName());

        srsReportRunService.preRunReport(controller.parmreportcontract());

        reportParametersMap = srsReportRunService.createParamMapFromContract(controller.parmReportContract());

        parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);

        srsProxy = SRSProxy::constructWithConfiguration(controller.parmReportContract().parmReportServerConfig());

        // Actual rendering to byte array

        reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(),

                                              parameterValueArray,

                                              settings.fileFormat(),

                                              settings.deviceinfo());

    

        // You can also convert the report Bytes into an xpp BinData object if needed

        container binData;

        Binary binaryData;

        System.IO.MemoryStream mstream = new System.IO.MemoryStream(reportBytes);

        binaryData = Binary::constructFromMemoryStream(mstream);

       // System.IO.File::WriteAllBytes("C:\\backup\\"+fileName,reportBytes); // You can save the file on your local instance for verification

       

        if(binaryData)

        {

            binData = binaryData.getContainer();

        }

        Map map=new Map (Types::String,Types::String);

        map.insert("message","Its working fine for me");

        SLD_EmailAttachment::sendPDFEamilAttachment("EmailRecpt","en-us","ShaikhSohailHussain@gmail.com",map,binData,"P000173_AbcTest");

    }

}

USE following code to send as Email Attachment 

class SLD_EmailAttachment

{

  

    public static void sendPDFEamilAttachment( SysEmailId      _emailId,

        LanguageId      _language,

        SysEmailAddress             _emailAddr,

        Map             _mappings,container _binData,str _fileName)

    {

        SysEmailItemId                   nextEmailItemId;

        SysEmailTable                    sysEmailTable;

        SysEmailMessageTable             sysEmailMessageTable;

        SysEmailContents                 sysEmailContents;

        SysOutgoingEmailTable            outgoingEmailTable;

        SysOutgoingEmailData             outgoingEmailData;

        Filename filename, FileExtension;

      

        FileExtension=".pdf";

       

        select sysEmailTable

               join    sysEmailMessageTable

                where sysEmailMessageTable.EmailId==sysEmailTable.EmailId

                    && sysEmailMessageTable.EmailId== _emailId

                    && sysEmailMessageTable.LanguageId==_language;

       

        if(sysEmailTable.RecId>0)

        {

            sysEmailContents=SysEmailMessage::stringExpand(sysEmailMessageTable.Mail, _mappings);

            nextEmailItemId = EventInbox::nextEventId();

      

            filename =strFmt("%1_%2.pdf",nextEmailItemId,_fileName);

    

    

            outgoingEmailTable.clear();

            outgoingEmailTable.Origin=sysEmailTable.Description;

            outgoingEmailTable.EmailItemId = nextEmailItemId;

            outgoingEmailTable.IsSystemEmail = NoYes::Yes;

            outgoingEmailTable.Sender = sysEmailTable.SenderAddr;

            outgoingEmailTable.SenderName = sysEmailTable.SenderName;

            outgoingEmailTable.Recipient = _emailAddr;

            outgoingEmailTable.Subject = SysEmailMessage::stringExpand(sysEmailMessageTable.Subject, _mappings);

            outgoingEmailTable.Priority = eMailPriority::High;

            outgoingEmailTable.WithRetries = NoYes::NO;

            outgoingEmailTable.RetryNum = 0;

            outgoingEmailTable.UserId = curUserId();

            outgoingEmailTable.Status = SysEmailStatus::Unsent;

            outgoingEmailTable.Message =  sysEmailContents;

            outgoingEmailTable.LatestStatusChangeDateTime = DateTimeUtil::getSystemDateTime();

            outgoingEmailTable.TemplateId= _emailId;

            outgoingEmailTable.insert();

            if(conLen(_binData)>0)

            {

                outgoingEmailData.clear();

                outgoingEmailData.EmailItemId = nextEmailItemId;

                outgoingEmailData.DataId = 1;

                outgoingEmailData.EmailDataType = SysEmailDataType::Attachment;

                outgoingEmailData.Data = _binData;

                outgoingEmailData.FileName = filename;

                outgoingEmailData.FileExtension =FileExtension;

                outgoingEmailData.insert();

            }

        }

    }

}