Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, February 9, 2014

Database does not have a valid owner - SQL restore error

Hi,

"Database diagram support object cannot be installed because this database does not have a valid owner".

You may get this error while restoring the database from external source (in *.bak format).

Solution:

Right click on the database properties in the permission tab select grand privilege to all( tick the check box).

now error free for restore.

Regards,

Unable to construct an object from the class in the batch framework

Hi,

when we want to run a custom class in the server as a batch job we need to extend the RunBaseBatch class and schedule a job for it.

When the test was successful, We scheduled the job and waited for the batch job status to go from Waiting to Ended, and to surprise to get an error.

"Unable to construct an object from the class Sample Class in the batch framework. Make sure that the X++ code has been compiled to Microsoft .NET Framework CIL, and that the constructor does not require any parameters"

Steps on how to do this:

1.Open a new development environment and click Build and then choose Generate Incremental CIL.




Then, to double check if the job run well, go to System Administration > Inquiries > Batch Jobs and look for your job. It status should now be Ended.

Regards

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...