[Axapta-Knowledge-Village] Re: Strange behaviour of AX
Hi, sorry to disturb you again and again. For the table DEL_BMModuleParm, for the field BuildID, EnumType propery is in bold but no enum attached against it, means, the attached enum may be removed at later point of time. Now, If the Enum removed without removing the references from the AOT, it would have print the enum id of that removed Enum. but, it's printing only 65535. Since The enum id value printing 65535 means balnk, how come the EnumType property still in bold? After making the EnumType property into normal (by pressing enter as we know) it's printing enum id as 65535. Fine. but, how it can possible to print the same enum id in both the cases? Please clarify. Thanks Regards, KBS --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya loya.su...@... wrote: Hi, The Enum has been deleted without removing the reference so the enumid is still there. This is what you can do. Go to the EnumType field and just press enter (The property should change to Normal ie not bold) This means there is no enum attached. This should solve your problem. Once you do this the EnumId value will be 65535 (meaning blank) in AX 4.0. Regards, Sumit On Mon, Jun 29, 2009 at 11:49 AM, tkbsmanian tkbsman...@... wrote: Exactly. But, even if the field attached with some enum type and after removed from AOT (i.e., field is empty but, property is in Bold), it's printing the id value of removed/un-available enum in AOT. Please check. Regards, KBS --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Sumit Loya loya.sumit@ wrote: Hi, What has happened is that the name of the Enum was changed so the EnumType field is empty (But the property is in Bold) which means there is an enum attached to the field but it is not found in the AOT. So the Enum Id is not empty but there is no name in the EnumType field. For your second query, when you create a new field of Enum type and do not assign anything, system by default assigns ABC type enum, this is what i have noticed and that is why it is displaying an Enum name Regards, Sumit On Sat, Jun 27, 2009 at 11:09 PM, tkbsmanian tkbsmanian@ wrote: Sumit, Thanks for your screenshots. But, my question is simple and straight forward (applicable for both AX40 AX5.0; but not to AX3.0). 1. How can it indicates that there is some enum attached even if EnumType field is empty (as you replied)? If it indicates so, why it is not printing the EnumName for DEL_BMBuildTable in AX4.0? 2. Why it is printing the EnumName for the user created field which doesn't have EnumType/not attached against EnumType property? (Having same field and table properties of DEL_BMBuildTable) Note : There is not only 'DEL_BMBuildTable'. There are 17 in AX4.0 and 13 in AX5.0 such as DEL_BMModuleParm, DEL_BMModuleTable, DEL_BMParm, DEL_BMTableSetup etc. Please clarify. Thanks Regards, Balasubramanian Kuamaran. --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com, Sumit Loya loya.sumit@ wrote: Hi, If you look at the properties of the field, you will notice that EnumType field is empty but it indicates that there is some enum attached. Looks like the Base Enum attached with the field has been deleted in AX 4.0. In AX 2009 the Enum Type has been changed to ABC. This code will work in AX 2009. Attached are the screen shots of the two in 4.0 and 2009. Hope this resolves your query. Regards, Sumit On Thu, Jun 25, 2009 at 9:09 PM, tkbsmanian tkbsmanian@ wrote: Hi All, Today i came up with one strange thing. I executed the script given below. Please go through and let me know why its happening in such a way... 1. static void enumId(Args _args) 2. { 3. EnumId enumId; 4. SysDictEnum sysDictEnum; 5. 6. SysDictTable sysDictTable; 7. SysDictField sysDictField; 8. ; 9. 10. sysDictTable = new SysDictTable(978); 11. sysDictField = new SysDictField(sysDictTable.id(), 1); 12. 13. if (sysDictField.enumId()) 14. { 15. if (sysDictField.type() == Types::Enum 16. || sysDictField.baseType() == Types::Enum) 17. { 18. sysDictEnum = new SysDictEnum(sysDictField.enumId()); 19. 20. if (sysDictEnum) 21. { 22. info (sysDictEnum.name()); 23. } 24. } 25. } 26. } Note : TableName : DEL_BMBuildTable FieldName : BuildID This script which ideally should print the BaseEnum name attached to the field, is not printing the value. The reason is, though
[Axapta-Knowledge-Village] Re: Strange behaviour of AX
Exactly. But, even if the field attached with some enum type and after removed from AOT (i.e., field is empty but, property is in Bold), it's printing the id value of removed/un-available enum in AOT. Please check. Regards, KBS --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya loya.su...@... wrote: Hi, What has happened is that the name of the Enum was changed so the EnumType field is empty (But the property is in Bold) which means there is an enum attached to the field but it is not found in the AOT. So the Enum Id is not empty but there is no name in the EnumType field. For your second query, when you create a new field of Enum type and do not assign anything, system by default assigns ABC type enum, this is what i have noticed and that is why it is displaying an Enum name Regards, Sumit On Sat, Jun 27, 2009 at 11:09 PM, tkbsmanian tkbsman...@... wrote: Sumit, Thanks for your screenshots. But, my question is simple and straight forward (applicable for both AX40 AX5.0; but not to AX3.0). 1. How can it indicates that there is some enum attached even if EnumType field is empty (as you replied)? If it indicates so, why it is not printing the EnumName for DEL_BMBuildTable in AX4.0? 2. Why it is printing the EnumName for the user created field which doesn't have EnumType/not attached against EnumType property? (Having same field and table properties of DEL_BMBuildTable) Note : There is not only 'DEL_BMBuildTable'. There are 17 in AX4.0 and 13 in AX5.0 such as DEL_BMModuleParm, DEL_BMModuleTable, DEL_BMParm, DEL_BMTableSetup etc. Please clarify. Thanks Regards, Balasubramanian Kuamaran. --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Sumit Loya loya.sumit@ wrote: Hi, If you look at the properties of the field, you will notice that EnumType field is empty but it indicates that there is some enum attached. Looks like the Base Enum attached with the field has been deleted in AX 4.0. In AX 2009 the Enum Type has been changed to ABC. This code will work in AX 2009. Attached are the screen shots of the two in 4.0 and 2009. Hope this resolves your query. Regards, Sumit On Thu, Jun 25, 2009 at 9:09 PM, tkbsmanian tkbsmanian@ wrote: Hi All, Today i came up with one strange thing. I executed the script given below. Please go through and let me know why its happening in such a way... 1. static void enumId(Args _args) 2. { 3. EnumId enumId; 4. SysDictEnum sysDictEnum; 5. 6. SysDictTable sysDictTable; 7. SysDictField sysDictField; 8. ; 9. 10. sysDictTable = new SysDictTable(978); 11. sysDictField = new SysDictField(sysDictTable.id(), 1); 12. 13. if (sysDictField.enumId()) 14. { 15. if (sysDictField.type() == Types::Enum 16. || sysDictField.baseType() == Types::Enum) 17. { 18. sysDictEnum = new SysDictEnum(sysDictField.enumId()); 19. 20. if (sysDictEnum) 21. { 22. info (sysDictEnum.name()); 23. } 24. } 25. } 26. } Note : TableName : DEL_BMBuildTable FieldName : BuildID This script which ideally should print the BaseEnum name attached to the field, is not printing the value. The reason is, though the field is the type of Enum, no BaseEnum or EDT derived from BaseEnum attached to that field. Upto this ok. Line#18 of the above script failed on initializing because of no Enum attached to the field though it got passed at Line#13, since it's getting the value of 65535, which is max range for this object (type), which is actually not attached into the field. Now, 1. If i delete the enum attached to the field, which is type of Enum from standard SYS layer object, and after saved and sync, if i run the same script with the corresponding TableId and FieldId changes. It's printing the name. Why? How? 2. I created new table and added new field type of Enum and didn't attached any BaseEnum. Saved it. If i run the above script, with the corresponding TableId and FieldId changes, it's printing 'ABC' as default value. Why? How? Like said in the above two scenarios, why it is not happening for the tables like 'DEL_BMBuildTable'? (also configkey enabled) Any info/thought would be appreciated. Thanks Regards, Balasubramanian Kumaran.
[Axapta-Knowledge-Village] Re: Strange behaviour of AX
Sumit, Thanks for your screenshots. But, my question is simple and straight forward (applicable for both AX40 AX5.0; but not to AX3.0). 1. How can it indicates that there is some enum attached even if EnumType field is empty (as you replied)? If it indicates so, why it is not printing the EnumName for DEL_BMBuildTable in AX4.0? 2. Why it is printing the EnumName for the user created field which doesn't have EnumType/not attached against EnumType property? (Having same field and table properties of DEL_BMBuildTable) Note : There is not only 'DEL_BMBuildTable'. There are 17 in AX4.0 and 13 in AX5.0 such as DEL_BMModuleParm, DEL_BMModuleTable, DEL_BMParm, DEL_BMTableSetup etc. Please clarify. Thanks Regards, Balasubramanian Kuamaran. --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya loya.su...@... wrote: Hi, If you look at the properties of the field, you will notice that EnumType field is empty but it indicates that there is some enum attached. Looks like the Base Enum attached with the field has been deleted in AX 4.0. In AX 2009 the Enum Type has been changed to ABC. This code will work in AX 2009. Attached are the screen shots of the two in 4.0 and 2009. Hope this resolves your query. Regards, Sumit On Thu, Jun 25, 2009 at 9:09 PM, tkbsmanian tkbsman...@... wrote: Hi All, Today i came up with one strange thing. I executed the script given below. Please go through and let me know why its happening in such a way... 1. static void enumId(Args _args) 2. { 3. EnumId enumId; 4. SysDictEnum sysDictEnum; 5. 6. SysDictTable sysDictTable; 7. SysDictField sysDictField; 8. ; 9. 10. sysDictTable = new SysDictTable(978); 11. sysDictField = new SysDictField(sysDictTable.id(), 1); 12. 13. if (sysDictField.enumId()) 14. { 15. if (sysDictField.type() == Types::Enum 16. || sysDictField.baseType() == Types::Enum) 17. { 18. sysDictEnum = new SysDictEnum(sysDictField.enumId()); 19. 20. if (sysDictEnum) 21. { 22. info (sysDictEnum.name()); 23. } 24. } 25. } 26. } Note : TableName : DEL_BMBuildTable FieldName : BuildID This script which ideally should print the BaseEnum name attached to the field, is not printing the value. The reason is, though the field is the type of Enum, no BaseEnum or EDT derived from BaseEnum attached to that field. Upto this ok. Line#18 of the above script failed on initializing because of no Enum attached to the field though it got passed at Line#13, since it's getting the value of 65535, which is max range for this object (type), which is actually not attached into the field. Now, 1. If i delete the enum attached to the field, which is type of Enum from standard SYS layer object, and after saved and sync, if i run the same script with the corresponding TableId and FieldId changes. It's printing the name. Why? How? 2. I created new table and added new field type of Enum and didn't attached any BaseEnum. Saved it. If i run the above script, with the corresponding TableId and FieldId changes, it's printing 'ABC' as default value. Why? How? Like said in the above two scenarios, why it is not happening for the tables like 'DEL_BMBuildTable'? (also configkey enabled) Any info/thought would be appreciated. Thanks Regards, Balasubramanian Kumaran.
[Axapta-Knowledge-Village] Re: RecId Generation
Thanks sumit. But, my question/focus is different. --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya loya.su...@... wrote: Hi, Read this article... http://sumit-theaxfactor.spaces.live.com/blog/cns!596957786228C73F!212.entry It may answer some of your questions. Regards, Sumit On Tue, Jun 23, 2009 at 12:14 AM, tkbsmanian tkbsman...@... wrote: Hi All, 1. How to fetch the next RecId value from the SQL query without calling AX APIs and without updating the 'NextVal' of 'SystemSequences' as well (as it is from in-memory pool)? 2. How does AOS handles RecId allocation/prevents RecId dupication, if multiple (249)clients connects to the same AOS and creates the record in same table simultaneously? (i've read from one blog saying RecId allocation is from client machine's in-memory pool of size 250) 3. How does AOS handles RecId allocation/prevents RecId duplication, if more than 250 clients connects to the same AOS and creates the record in same table simultaneously? and on what basis? Any info/idea on the above would highly appreciated. Thanks Regards, KBS
[Axapta-Knowledge-Village] RecId Generation
Hi All, 1. How to fetch the next RecId value from the SQL query without calling AX APIs and without updating the 'NextVal' of 'SystemSequences' as well (as it is from in-memory pool)? 2. How does AOS handles RecId allocation/prevents RecId dupication, if multiple (249)clients connects to the same AOS and creates the record in same table simultaneously? (i've read from one blog saying RecId allocation is from client machine's in-memory pool of size 250) 3. How does AOS handles RecId allocation/prevents RecId duplication, if more than 250 clients connects to the same AOS and creates the record in same table simultaneously? and on what basis? Any info/idea on the above would highly appreciated. Thanks Regards, KBS
[Axapta-Knowledge-Village] Re: Excel Import - XML generation
Hi, 1. Do you need the Excel data into Xml data? Why don't you generate Xml after successful Excel import, from table? Not clear need more clarity. 2. Validation methods from table level will be called based on the validation level defined in the definition group used for the excel export/import. If the validation level is 'None' no validation methods will be called. If it is 'Table' only validateWrite() method on the table will be called. If it is 'Field' then both validateWrite() and validateField() method on the table will be called. Hope this may be helpful. \Balasubramanian Kumaran --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha E mail2eani...@... wrote: Hi all, How to generate XML when the data is imported via Excel?? I could not trace which table level method is called when the data is Excel-imported??? -- Best Regards, Anitha Eswaran.
[Axapta-Knowledge-Village] Re: Can i install Ax 4.0 Object Server in Windows Xp for Demo Purposes?
Hi, I came across with the steps to install AX 4.0 in XP (i.e. without domain) while going through AxForum. I didn't test the same ever before but,it goes like this Thanks to 'AxForum'. Setup on a computer which does not belong to any domain: Unfortunately setup of AX 4 on the computer outside a domain is prohibited by installer. But there is a trick for doing such thing and Ax 4 works good. This trick is tested under Windows XP SP2, it does not work on Vista. 1. Change the value of there registry key HKEY_LOCAL_MACHINE\ SYSTEM\ ControlSet001\ Control\ ComputerName\ ActiveComputerName to any value whick does not match name of your computer. 2. Set value of environment variable named UserDnsDomain to any other value 3. Run setup.exe 4. Restore values, changed on the steps 1, 2 5. Go to client and server setup in control panel and change computer name to the real name of your computer Just try the above and pls let me if it is working successfully. Regards, Balasubramanian.K --- In Axapta-Knowledge-Village@yahoogroups.com, Anil Ozay [EMAIL PROTECTED] wrote: Hi, If you logon your XP with domain account, yes you can. I install it on my Vista. I logon the system with my domain account : ERA\anilo and install it. Regards, Anýl Özay Software Engineer era_imza ERA Biliþim Danýþmanlýk Hizmetleri A.Þ. Erdoðan Özkardeþler Sk. No:9/9 Gayrettepe / Ýstanbul T:+90(212) 288 77 65 F:+90(212) 288 77 64 GSM: +90 (530) 519 0 888 http://www.erasolution.com/ www.erasolution.com DynamicsS(rgb)_4170_4155_4255[2] From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of tkbsmanian Sent: Tuesday, August 12, 2008 9:08 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Can i install Ax 4.0 Object Server in Windows Xp for Demo Purposes? Hi, Dynamics AX4.0 AOS installation is not allowed only on the Operating systems list given below. 1. Windows server 2003 R2, Standard Edition 2. Windows server 2003 R2, Web Edition 3. Windows server 2003 R2, Enterprise Edition 4. Windows server 2003 R2, Datacenter Edition 5. Windows server 2003 SP1, Standard Edition 6. Windows server 2003 SP1, Web Edition 7. Windows server 2003 SP1, Enterprise Edition 8. Windows server 2003 SP1, Datacenter Edition 9. Windows small business server 2003, Standard Edition Regards, Balasubramanian.K --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , sivlogu sivlogu@ wrote: Hi there, Can i install all the roles of Ax 4.0 in Windows Xp system for Demo Purposes? While i am trying to do so, i could not able to install Object Server. Thanks in Advance, Loganathan S
[Axapta-Knowledge-Village] Re: Can i install Ax 4.0 Object Server in Windows Xp for Demo Purposes?
Hi, Dynamics AX4.0 AOS installation is not allowed only on the Operating systems list given below. 1. Windows server 2003 R2, Standard Edition 2. Windows server 2003 R2, Web Edition 3. Windows server 2003 R2, Enterprise Edition 4. Windows server 2003 R2, Datacenter Edition 5. Windows server 2003 SP1, Standard Edition 6. Windows server 2003 SP1, Web Edition 7. Windows server 2003 SP1, Enterprise Edition 8. Windows server 2003 SP1, Datacenter Edition 9. Windows small business server 2003, Standard Edition Regards, Balasubramanian.K --- In Axapta-Knowledge-Village@yahoogroups.com, sivlogu [EMAIL PROTECTED] wrote: Hi there, Can i install all the roles of Ax 4.0 in Windows Xp system for Demo Purposes? While i am trying to do so, i could not able to install Object Server. Thanks in Advance, Loganathan S
[Axapta-Knowledge-Village] ,
Hi
[Axapta-Knowledge-Village] How can i fetch published data/values from Website?
Hi All, I'm having an specific requirement to read the values (table cell) form web site and import the same values into AX. It's similar to updating the current Exchange rate value into Ax from the particular web site where the exchange rates are being published. Now, the problem is, i'm not able to read the values from the web site through AX. Can anybody help me regarding the same that, how can i read the values from web site and populate the values into AX. Also, if anybody knows how to access/read the website values using .NET script, please provide the details info on the same. Thanks in advance, Balu.
[Axapta-Knowledge-Village] Printing barcode vertically in reports. Urgent!!!
Hi, i've an requirement to ptint the bar code vertically (rotating to 90 degree against default) in reports. Since barcode is a string and there is no rotating properties available, the idea is capture the barcode as image and rotate that into 90 degrees in report. But, struck with capturing the image of the barcode. are any methods there in Axapta to capture the particular field as image? Any other ideas to print barcode vertically should also be appreciated. Thanks in Advance.
[Axapta-Knowledge-Village] Re: Cannot execute the required database operation.The SQL database has issued an er
Hi Sumit, I encountered the above said problem immediately after importing the .dat and .def files into the application. If it is related to permissions issue, where can i see the permissions and how to rectify this problem? Plz advise me. \Balu. --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya [EMAIL PROTECTED] wrote: Hi, This error is related to the permissions see if the code is running on server or client or the user running the job has rights to execute the SQL statements generated. Regards, Sumit On Fri, May 16, 2008 at 4:57 PM, tkbsmanian [EMAIL PROTECTED] wrote: Hi All, I'm encountering a problem while synchronizing Tables and the error message is as below. Cannot execute the required database operation. The SQL database has issued an error. Cannot execute a data definition language command on (). The SQL database has issued an error. Request for the permission of type 'SqlStatementExecutePermission' failed. (S)\Classes\SqlStatementExecutePermission\demand (S)\Classes\Statement\executeQuery (C)\Forms\SysSQLShowRows\Methods\buildListView - line 25 (C)\Forms\SysSQLShowRows\Methods\run - line 8 (S)\Classes\SqlScanMain\checkUniqueRule - line 34 (S)\Classes\SqlScanMain\checkIndexesForTable - line 187 (S)\Classes\SqlScanMain\handleTable - line 46 (S)\Classes\SqlScanMain\run - line 53 (S)\Classes\SysSqlAdminClass\handleSelectedItems - line 125 (C)\Forms\SysSqlAdmin\Methods\runThroughTablesAndIndexes - line 44 (C)\Classes\FormButtonControl\Clicked - line 4 (C)\Classes\FormMenuButtonControl\Clicked I've done as many ways as i know like... 1. Synchronized the table on AOT. 2. Synchronized through AdministrationPeriodicSQL Administration a. All Tables Table actions Synchnonize b. All Tables Table actions Check\Synchronize Start c. All Tables Table actions Check\Synchronize {checked Remove unknown indexec} Start 3. Deleted all *.ali *.aoi files from application and re-started the AOS. But, still i'm getting the same problem as i mentioned above. I'll appreciate, if anybody give me the solution for the same. Thanks in advance, Balu.
[Axapta-Knowledge-Village] Cannot execute the required database operation.The SQL database has issued an er
Hi All, I'm encountering a problem while synchronizing Tables and the error message is as below. Cannot execute the required database operation. The SQL database has issued an error. Cannot execute a data definition language command on (). The SQL database has issued an error. Request for the permission of type 'SqlStatementExecutePermission' failed. (S)\Classes\SqlStatementExecutePermission\demand (S)\Classes\Statement\executeQuery (C)\Forms\SysSQLShowRows\Methods\buildListView - line 25 (C)\Forms\SysSQLShowRows\Methods\run - line 8 (S)\Classes\SqlScanMain\checkUniqueRule - line 34 (S)\Classes\SqlScanMain\checkIndexesForTable - line 187 (S)\Classes\SqlScanMain\handleTable - line 46 (S)\Classes\SqlScanMain\run - line 53 (S)\Classes\SysSqlAdminClass\handleSelectedItems - line 125 (C)\Forms\SysSqlAdmin\Methods\runThroughTablesAndIndexes - line 44 (C)\Classes\FormButtonControl\Clicked - line 4 (C)\Classes\FormMenuButtonControl\Clicked I've done as many ways as i know like... 1. Synchronized the table on AOT. 2. Synchronized through AdministrationPeriodicSQL Administration a. All Tables Table actions Synchnonize b. All Tables Table actions Check\Synchronize Start c. All Tables Table actions Check\Synchronize {checked Remove unknown indexec} Start 3. Deleted all *.ali *.aoi files from application and re-started the AOS. But, still i'm getting the same problem as i mentioned above. I'll appreciate, if anybody give me the solution for the same. Thanks in advance, Balu.