Re: [development-axapta] Axapta QueryRange Sql
you can always check by printing query.toString(). On Wed, Jun 10, 2009 at 5:14 PM, muzzyk34 muzzy...@yahoo.com wrote: hi everyone; I am wondering how does axapta convert queryrange to Sql sentences? exaple: I have a report and I add a range to ask name of customer after I write range field to 'Mich*' then how does axapta convert Sql SELECT * FROM CUSTOMER WHERE CustomerName LIKE 'Mich%' does anyone know that?? Which class or which method do this.. [Non-text portions of this message have been removed]
Re: [development-axapta] Error running export to file as batch but no problem when run normally by the user
Hi James,
The last time I saw this problem it was because the runbasebatch framework
needed the pack and unpack methods. The In Process Production Costing report
would not run in batch. Path = (Production - Reports - Balance - In Process
Production Costing.).
We had to create a pack method that looked like this:
public container pack()
{
return [#CurrentVersion, #CurrentList];
}
and we had to create an unpack method that looked like this:
public boolean unpack(container packedClass)
{
container _base;
boolean _ret;
Integer _version= RunBase::getVersion(packedClass);
switch (_version)
{
case #CurrentVersion:
[_version, #CurrentList, _base] = packedClass;
_ret = true;
break;
default:
_ret = false;
}
return _ret;
}
- Original Message -
From: Varden Morris
To: development-axapta@yahoogroups.com
Sent: Wednesday, June 10, 2009 9:36 AM
Subject: Re: [development-axapta] Error running export to file as batch but
no problem when run normally by the user
Are you using a relative or absolute path? You should share the folder with
write access for the user that executes the AOS service. Ensure that you are
using an absolute path such as \\ComputerName\ShareFolderName. If you use a
relative path such as C:\FolderName\AnotherFolder then it will work if the job
is executed from the client computer and the folder is on that computer.
However, if the batch job is set to run on the server and the same folder path
does not exists on the AOS computer you will have a problem.
Regards,
Varden Morris
Varalth Solutions Inc.
693 Abbottsfield Road NW
Edmonton, Alberta T5W 4R4
Canada
(780) 752-0406
www.varalth.com
CONFIDENTIALITY NOTICE
This message and any attachments are confidential. If you have received this
transmission in error, please be advised that any disclosure, copying,
distribution or action taken in reliance upon this communication is strictly
prohibited. If you have received this communication in error, please contact
the sender immediately. Please note that any views or opinions presented in
this email are solely those of the author and do not necessarily represent
those of the company. Finally, the recipient should check this email and any
attachments for the presence of viruses. The company accepts no liability for
any damage caused by any virus transmitted by this email.
From: James Flavell djf1...@gmail.com
To: development-axapta@yahoogroups.com
Sent: Wednesday, June 10, 2009 12:03:00 AM
Subject: [development-axapta] Error running export to file as batch but no
problem when run normally by the user
H i everyone
I have a strange problem that I have a class that basically creates a text
file of the item onhand information.
The class works fine when run by the user but when I set it to run in batch
it gives an error when the following code is called by the batch client:
new FileIOPermission( FileName, 'w').assert( );
File = new AsciiIO(FileName, 'w');
The error says about ASCIIIO is not initialised.
I get the error even if I start the batch client in the same logged in AX
session that works if the user runs the export directly so I am a little
lost
Also I took the export and put it on a dev server and it worked okay using
the batch client! So I am wondering when the batch client is running what
user id is it running as? The user id that logged into AX and started the
batch client or the user id that is in the AOS service start up or something
else?
Does anyone have any idea why the batch running would give this error since
the export works fine when run directly by the user?
This is AX4.0 SP1 or SP2 I cannot remember right now
Thanks
James
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
RE: [development-axapta] Error running export to file as batch but no problem when run normally by the user
Thank you all who have responded so fast Varden you were right in that once I tested changing the account on the AOS service to an account I know had rights to the folder then it worked perfectly. Thank you and the rest very much for all you speedy help. One question I have is if the AOS service is using NT AUTHORITY\NETWORK SERVICE is it wise to give this account access to folders or should I create some kind of new AOS service account (and if so what kind of permissions should I give it). I guess this is more a best practice type of query as I am not familiar with windows server permission and how best to configure an account for somethign like an AOS service. And sorry one final query that just popped in my head. If the users start to print reports to file and submit these as batch jobs then will the AOS service account need to have rights to write to whatever folders the user has typed in the report options? Thanks once again to you all :) James _ From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Varden Morris Sent: 10 June 2009 21:37 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Error running export to file as batch but no problem when run normally by the user Are you using a relative or absolute path? You should share the folder with write access for the user that executes the AOS service. Ensure that you are using an absolute path such as \\ComputerName\ShareFolderName. If you use a relative path such as C:\FolderName\AnotherFolder then it will work if the job is executed from the client computer and the folder is on that computer. However, if the batch job is set to run on the server and the same folder path does not exists on the AOS computer you will have a problem. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: James Flavell djf1...@gmail. mailto:djf1994%40gmail.com com To: development- mailto:development-axapta%40yahoogroups.com axa...@yahoogroups.com Sent: Wednesday, June 10, 2009 12:03:00 AM Subject: [development-axapta] Error running export to file as batch but no problem when run normally by the user H i everyone I have a strange problem that I have a class that basically creates a text file of the item onhand information. The class works fine when run by the user but when I set it to run in batch it gives an error when the following code is called by the batch client: new FileIOPermission( FileName, 'w').assert( ); File = new AsciiIO(FileName, 'w'); The error says about ASCIIIO is not initialised. I get the error even if I start the batch client in the same logged in AX session that works if the user runs the export directly so I am a little lost Also I took the export and put it on a dev server and it worked okay using the batch client! So I am wondering when the batch client is running what user id is it running as? The user id that logged into AX and started the batch client or the user id that is in the AOS service start up or something else? Does anyone have any idea why the batch running would give this error since the export works fine when run directly by the user? This is AX4.0 SP1 or SP2 I cannot remember right now Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
SV: [development-axapta] Axapta QueryRange Sql
This happens somewhere in the kernel. You don't have access to this. Fra: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] På vegne af muzzyk34 Sendt: 10. juni 2009 13:14 Til: development-axapta@yahoogroups.com Emne: [development-axapta] Axapta QueryRange Sql hi everyone; I am wondering how does axapta convert queryrange to Sql sentences? exaple: I have a report and I add a range to ask name of customer after I write range field to 'Mich*' then how does axapta convert Sql SELECT * FROM CUSTOMER WHERE CustomerName LIKE 'Mich%' does anyone know that?? Which class or which method do this.. [Non-text portions of this message have been removed]
[development-axapta] Development Tool AxAssist updated to 1.13.0 version. DAX IDE extension
AxAssist tool make the daily work in the DAX Editor easier. Works on all versions of DAX (3.0, 4.0 and 2009). Also its work on some AX6.0 beta versions. AxAssist works independently on DAX functionality, except small changes in class EditorScripts. Details are described in Installation (http://axassist.com/downloads/installation) section. Please read it before installation. There is some features of this utility: - Code reformatter (auto indent for variables according to your setting) Additional suggestions in Editor: - Variable names list (customized list of possible variable names) - Macros list - Name matching (suggestion list based on AOT names) - Acronyms (suggestion list based on AOT short names - e.g. IT = InventTrans, ITy = ItemType, etc) - User list (customized suggestion list in DAX Editor) - Customized tooltips in suggestion list (on local language!) Customizable hotkeys and additional toolbar in DAX Editor: - Up to 40 managing Hotkeys (run your x++ code by hotkey, e.g. any of EditorScripts method) - Managing Toolbar in Editor Extended navigation: - Browsing elements directly in Editor - Opening elements directly from Editor - Browsing table in one click - Advanced caption for AOT element - Switching between object methods without using AOT What's New: http://axassist.com/downloads/history Detailed information of new and old features (with pictures): http://axassist.com/features/all Download page: http://axassist.com/downloads/downloads If you have any problems, questions, suggestions let us know please: http://axassist.com/support -- Best Regards, Alexander
