RE: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql

[Pieter Wijnen]

dbcc shrink_file 

-Original Message-
From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince
Sent: 27. juli 2005 13:26
To: development-axapta@yahoogroups.com
Subject: YNT: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql

Thanks, I have one more Question.
 
After truncate database size is still same on harddisk. How can i make it real size?
 
Thanks.



Kimden: development-axapta@yahoogroups.com bu kiþinin yerine: Pieter Wijnen
Gönderilmiþ: Çar 27.07.2005 11:02
Kime: development-axapta@yahoogroups.com
Konu: RE: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql



Try truncate from SQL
TRUNCATE TABLE SYSDATABASELOG

  _ 

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince
Sent: 27. juli 2005 08:06
To: development-axapta@yahoogroups.com
Subject: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql


Hi all

SysDataBaseLog table increased so much that it reached 9 GB :( So i want to delete this log. But it doesn't clear it very quickly. Is it good to drop table from Sql Server? Or is there a way to do it from  Axapta?

Thanks.



[Non-text portions of this message have been removed]






  _ 

YAHOO! GROUPS LINKS


   
*    Visit your group "development-axapta
 " on the web.
 
*    To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]

be>
 
*    Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  .


  _ 




[Non-text portions of this message have been removed]






Yahoo! Groups Links










[Non-text portions of this message have been removed]





 
Yahoo! Groups Links



 










  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

RE: [development-axapta] Axapta and windows user

[Matt Benic]

I don't know about the case where you install Axapta directly using the
install executables but with remote deployment, once a particular (windows)
user has installed Axapta on a machine, it must be fully uninstalled before
another user can run it successfully. The problem seems to be that some
Axapta configuration data is stored for all users, and some only for the
user that installed it, and it gets confused with installation locations and
such.

Regards,
Matt Benic
.Net/Axapta Analyst Developer
UTi Sun Couriers Division
Support the Xbox 360 in SA campaign



-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of Zappia
Alessandro
Sent: 27 July 2005 03:27 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Axapta and windows user


Hello everyone!

I've got some questions about the relationship between axapta
installation and windows users.
- can I install axapta client on a user account (non on an Administrator
one)?
- if I install axapta client on an administrator account, can users from
within their accounts see and use it?

The matter is that I installed axapta on an administrator account, but
when users log in axapta doesn't run (either the configuration utility
doesn't work). I'm not very skilled in axapta installation and in
windows user management. I'd like not to create an users as system
administrator to install and run Axapta!

Thanx you for any help!


[Non-text portions of this message have been removed]






Yahoo! Groups Links














  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] Axapta and windows user

[Zappia Alessandro]

Hello everyone! 
 
I've got some questions about the relationship between axapta
installation and windows users.
- can I install axapta client on a user account (non on an Administrator
one)?
- if I install axapta client on an administrator account, can users from
within their accounts see and use it?
 
The matter is that I installed axapta on an administrator account, but
when users log in axapta doesn't run (either the configuration utility
doesn't work). I'm not very skilled in axapta installation and in
windows user management. I'd like not to create an users as system
administrator to install and run Axapta!
 
Thanx you for any help!


[Non-text portions of this message have been removed]









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

RE: [development-axapta] Excel import error

[Søren Ager]

Den 27. juli 2005 15:15 skrev pallegude:

> Any ideas would be welcome

Are you using extended data types on the fields? If not do so.


Hilsen
  Søren








  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] Excel import error

[pallegude]

Hi guys.
 
I have a problem with importing data via Excel wizard for some new 
tables i have created. Any idea to what is wrong?
 
The tables are straight forward, a field with 2 chars to give 
the "number" and a field with 30 chars to give the description. No 
problem in creating the template, but when importing i get this 
error:
 
Error executing code: SysDictType object not initialised.

Stack trace:
(C) \Classes\SysDictType\baseType
(C) \Classes\SysDataImportExcelClient\read - line 47
(S) \Classes\SysDataImportExcelServer\sheet2Table - line 53
(S) \Classes\SysDataImportExcelServer\importSheets - line 53
(S) \Classes\SysDataImportExcelServer\run - line 7
(S) \Classes\SysDataImport\main - line 10
(S) \Classes\MenuFunction\runServer
(C) \Classes\FormFunctionButtonControl\Clicked

Any ideas would be welcome, and i have posted the question on MS-
Axapta

/Palle 











  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [development-axapta] Re: How to Start !

[Gunish Rai Chawla]

guess i am trying to produce a parallel product for our client!
its a great opprotunity to become aware of the poeple who have done
parallel development and are ahead in terms of experience my
conept of doing it is a bit dynamic with a greater degree of user
flexibility... although i am just starting i would need a great
amount of technical advice from your side... during my development
phases... i am much more keen on doing this myself rather than
accuring a ready made product... axapta draws great interest of mine!
Regards,
Gunish 


On 7/26/05, MDYER7 <[EMAIL PROTECTED]> wrote:
> Gunish,
> 
> We have an integration between Axapta 3.0 and AbleCommerce which is 
> currently running 9 different production sites.  We've implemented a 
> queue system into AbleCommerce so that it attempts to perform all 
> actions in realtime but can queue the requests if Axapta is 
> unavailable for any reason.  This gives us a full separation between 
> Axapta and AbleCommerce.  You can configure individual transactions 
> to require an immediate response from Axapta, to prefer an immediate 
> resonse from Axapta or to always be queued.  We've been working with 
> AbleCommerce and Axapta for the past 5 years.  
> 
> The system is implemented using a Windows service that wraps around 
> the Axapta COM connector.  Requests are sent using standard internet 
> protocols and can be in either XML format or basic data types such as 
> strings, numeric, arrays, structs, etc.  The communications can also 
> utilize (automatic) gZip compression to further improve performance.  
> The system is designed specifically so that the customer can leave 
> their Axapta system on-site and have their AbleCommerce running in an 
> external data center (although AbleCommerce could be on-site too).
> 
> We also have an additional piece that can be added to Axapta to allow 
> Axapta to communicate changes back to the AbleCommerce server.  The 
> same technology can easily be used to establish bi-directional Axapta 
> to Axapta communciations.
> 
> Finally, we've build an integration with the MBSDev Advanced 
> Distribution product (http://www.mbsdev.com).
> 
> Please let me know if you would like further information...
> 
> Best Regards,
> 
> Michael J. Dyer
> Managing Partner
> DigitalEra Group LLC / Digital Enhancements LLC
> Gateway Technology Park
> 4931 SW 75th Avenue
> Miami, FL 33155-4440
> [EMAIL PROTECTED]
> 
> --- In development-axapta@yahoogroups.com, "mr_grac" 
> 
> <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > i found this group with great luck, lol anyway lets see its
> > strength... 
> > i am working on integrating a Online Shopping Cart with Axapta
> > although 
> > it comes with a built in one ... but the one thats there exports a
> > flat 
> > asp website  while i am using a asp.net based shopping cart 
> (Able 
> > Commerce Specifically)
> > although i am directly interacting with the sqlserver to retreieve
> > the 
> > data such as products and categories but i am not willing to 
> put 
> > data in axapta directly threw the sql server. now i wanna know how 
> to 
> > go about using a webservices to insert data using x++ and 
> morphx ... 
> > considering that i dont know the abc of either x++ or MorphX!
> >  also the major issue that is i dont know the clients database 
> > structure  i mean the relations diagram or anything  i am 
> > using the debugger in axapta to find out what tables are affected 
> by 
> > a event and then apply hit and trial to find out the relations
> > this is a BAD Way of going about it !
> > Please Help!
> > 
> > - Thanks 
> > 
> > Gunish
> 
> 
> 
> 
> 
> 
> 
> SPONSORED LINKS 
> Computer part Programming languages Microsoft axapta 
> Support exchange 
> 
> YAHOO! GROUPS LINKS 
> 
> 
>  Visit your group "development-axapta" on the web.
>   
>  To unsubscribe from this group, send an email to:
>  [EMAIL PROTECTED]
>   
>  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
>  To unsubscribe from this group, send an email to:
>  [EMAIL PROTECTED]
>   
>  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
>  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
> 
>





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] Resizing wizard

[Lars Helge Jacobsen]

Hi,
 
Does anyone know how I can resize a wizard?
I've created a wizard to create a reord in a table, but the form size is far to small, and
no matter what properties I set on the wizard form, the size is the same.
 
_
Med vennlig hilsen
 
Lars H. Jacobsen
Systemkonsulent
 
Columbus IT Partner Bergen AS
  
 





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

YNT: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql

[Cenk Ince]

Thanks, I have one more Question.
 
After truncate database size is still same on harddisk. How can i make it real 
size?
 
Thanks.



Kimden: development-axapta@yahoogroups.com bu kiþinin yerine: Pieter Wijnen
Gönderilmiþ: Çar 27.07.2005 11:02
Kime: development-axapta@yahoogroups.com
Konu: RE: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql



Try truncate from SQL
TRUNCATE TABLE SYSDATABASELOG

  _ 

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince
Sent: 27. juli 2005 08:06
To: development-axapta@yahoogroups.com
Subject: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql


Hi all

SysDataBaseLog table increased so much that it reached 9 GB :( So i want
to delete this log. But it doesn't clear it very quickly. Is it good to
drop table from Sql Server? Or is there a way to do it from  Axapta?

Thanks.



[Non-text portions of this message have been removed]






  _ 

YAHOO! GROUPS LINKS


   
*Visit your group "development-axapta
 " on the web.
 
*To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]

 
*Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  .


  _ 




[Non-text portions of this message have been removed]






Yahoo! Groups Links










[Non-text portions of this message have been removed]





 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [development-axapta] External Axapta Training Resources

[James Flavell]

Hi Kang,
 
We are present with offices in Indonesia and Singapore that service the
whole Asia region, with satisified customers in Malaysia, Hong Kong etc.  We
can provide both functional and development training as well as other Axapta
related services and have basically been a DEDICATED Axapta only partner
since it all started back in 1998/1999 (and before that the predecessor to
Axapta which was Concorde XAL) so resources wise we wont send you someone
who has just done the training themselves and is just repeating what is
written in the book but we will share our experiences of things that work
well and thigns that don't work so well (in fact our training sessions tend
to be more for customers who have key users who want explore 'deeper'
matters than what is covered in the 'theory' sessions ).
 
Other alternatives are of course official MBS training sessions (cheap but
depends on when MBS arrange and have to share the trainers time with other
partners...also I am not sure if you need to be a registered MBS partner to
attend)
 
Also FYI I believe there is a company in Malaysia (cannot recall the name
but starts with A or E but its not ESG) that MBS have previously sourced to
run official MBS Axapta training sessions but the feedback I have received
is that it is pretty much going through the MBS training documents and so
alot of theory rather than pratical/experience but maybe they can tailor
make a session similar to what we would usually do.
 
If it is just to get you started then official MBS training I would
recommend given its cost but looking at your web site I am not sure exactly
whether you are an end customer or potential partner etc, maybe you can give
an indication of exactly what yor plans are with Axapta (end customer,
integrating 3rd aprty manufacturing tools ...)
 
If you wish to considered our services please contact me on the email
[EMAIL PROTECTED]
Thanks
James
 
James Flavell
International Business Consultant
Email: [EMAIL PROTECTED] / [EMAIL PROTECTED]
Tel  : +65 97582281(SG)

PT Columbus IT Indonesia
Graha Surya Internusa,
Lantai 8 Suite 806,
Jl. H.R. Rasuna Said Kav. X-O,
Jakarta 12950
Indonesia

Tel: +62 21 527 6630/6640
Fax: +62 21 527 6650


-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Kang Shang Yie
Sent: 27 July 2005 12:56
To: development-axapta@yahoogroups.com
Subject: [development-axapta] External Axapta Training Resources


Hi all,

Anyone knows, if there is some training centre or Axapta expert in 
Malaysia, provides proper Axapta Training in Functional and Development 
module ?

Looking forward for any reply, thanks.

Kind Regards,
Kang








SPONSORED LINKS 
Computer
 part   Programming
 languages   Microsoft
 axapta   
Support
 exchange   

  _  

YAHOO! GROUPS LINKS 


  
*   Visit your group "development-axapta
 " on the web.
  

*   To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
 
  

*   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
 . 


  _  




[Non-text portions of this message have been removed]







  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

RE: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql

[Pieter Wijnen]

Try truncate from SQL
TRUNCATE TABLE SYSDATABASELOG

  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince
Sent: 27. juli 2005 08:06
To: development-axapta@yahoogroups.com
Subject: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql


Hi all

SysDataBaseLog table increased so much that it reached 9 GB :( So i want
to delete this log. But it doesn't clear it very quickly. Is it good to
drop table from Sql Server? Or is there a way to do it from  Axapta?

Thanks.



[Non-text portions of this message have been removed]






  _  

YAHOO! GROUPS LINKS 


  
*   Visit your group "development-axapta
 " on the web.
    
*   To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]

be> 
    
*   Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service  . 


  _  




[Non-text portions of this message have been removed]









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] Re: Table Lookup on Forms by DataAreaId

[allanwallis]

I don't think you understood my reply

I dont know which table you are using for your journal line so for 
this example I will just call it Journal Line and the datasource for 
your lookup I will call LookupTable

Suppose you have a field on that table called CompanyID that 
contains the company identifier you wish as the basis of your Lookup.

In your Lookup form, create an Init method someting like this:-
Public Void Init()
{
JournalLine JournalLine;
Super();
Jounalline=element.args().record();
LookupTable_DS(JournalLine.CompanyID);
}

This will cause your lookup form to present records from the company 
specified on your Journal Line. Isn't that what you want?




--- In development-axapta@yahoogroups.com, "axapta_coder" 
<[EMAIL PROTECTED]> wrote:
> Hi Alla,
> Thanks for your reply. My issue is not setting a default comany of 
a 
> data source.
> My issue is inter-company transactions.
> Imagine doing a GL journal entry where your debit balance is 
posted 
> to a designated GL account in company "100", while the Credit 
> balance must be posted to another GL account in company "200".
> standard Axapta let's you lookup and select an account based on 
your 
> company selection. Using the same logic, I need my custom field to 
> look up company dependent records. It curently looks up records 
> based of my curExt() and not the company I'm selecting on the 
> journal line!
> 
> // Thanks a bunch.
> 
> 
> --- In development-axapta@yahoogroups.com, "allanwallis" 
> <[EMAIL PROTECTED]> wrote:
> > When you specify a datasource in a form, you can specify which 
> company 
> > the data is derived from.
> > So you could for example have one datasource for each company 
and 
> put 
> > each on a separate tab of your lookup form. 
> > 
> > I believe that you can also set the company for the datasource 
in 
> the 
> > init method of your lookup form, e.g. LedgerTable_DS.company
('aaa')
> > 
> > Hope this helps
> > 
> > 
> > 
> > --- In development-axapta@yahoogroups.com, "axapta_coder" 
> > <[EMAIL PROTECTED]> wrote:
> > > 
> > > I have a table from which I'm looking up a field value via a 
> Journal 
> > > Line (LedgerJournalTransDaily).
> > > 
> > > This value is used in relation to an Inter-Company transaction 
> and 
> > > therefore needs to be a company specific lookup. Pretty much 
> like 
> > > standard Inter-Co entries where a GL account is looked up 
based 
> on 
> > > account type but most importantly by company account.
> > > 
> > > I need to make my table lookup to be company dependent and not 
> > looking 
> > > up values from the current company I'm standing on.
> > > 
> > > Any suggestions will be greatly appreciated.







  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [development-axapta] External Axapta Training Resources

[Han Steven]

hi,
 
Maybe you can contact ESG Malaysia, or other mbs partner in Malaysia

Kang Shang Yie <[EMAIL PROTECTED]> wrote:
Hi all,

Anyone knows, if there is some training centre or Axapta expert in 
Malaysia, provides proper Axapta Training in Functional and Development 
module ?

Looking forward for any reply, thanks.

Kind Regards,
Kang







SPONSORED LINKS 
Computer part Programming languages Microsoft axapta Support exchange 

-
YAHOO! GROUPS LINKS 


    Visit your group "development-axapta" on the web.
  
    To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
  
    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


-



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

RE: [development-axapta] Posting Memory Leak

[Matt Benic]

Hi Preston,
I am working with Edine (axapta123456) on this. We have already carried out
the MemSizeUp due to previous memory issues (as she mentions at the end of
the post). This is not the issue. The problem is that we have identified
that there are definitely memory leaks in the posting process leading to a
leak of (on average) 150k with each call to SalesFormLetter.post(), which we
did not notice previously due to the fact that our posting pattern was
different. Basically things have changed as follows due to changed business
requirements:
Before:
-Import batches of 500 Sales Orders into parm tables
-Post all 500 simultaneously

Now
-Import a single invoice 'realtime'
-Post the invoice

As a result, when posting all 2 invoices using the old method, we would
only leak 2/500*150k = 6000k = about 6Mb, which is by no means trivial,
but small enough to not cause leak problems too often (though in retrospect
some of our memory issues now make sense.
Now when importing 2 invoices we are leaking 2*150k = 300k =
about 3Gb!
We are currently running into issues after 3500 invoices, which leaks about
500M, which matches the behaviour on Edine's machine.

We are aware that the SmartHeap garbage collector may eventually reclaim
some of this memory, but by that time we have already experienced out of
memory issues, ie Axapta has already crashed.

Our requirements are that we need to import single invoices and post them
immediately and return the generated voucher numbers. This, combined with
the fact that we cannot have entire batch postings failing due to one
invalid invoices means that we cannot stick to a batched approach of any
kind. We MUST have a 1-1 relation between invoices and posts.

What we want to know is if anyone has written any code to fix this leak, or
if anyone knows how to fix this.

Regards,
Matt Benic
.Net/Axapta Analyst Developer
UTi Sun Couriers Division
Support the Xbox 360 in SA campaign



-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of Preston A.
Larimer
Sent: 26 July 2005 05:33 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Posting Memory Leak


This topic was discussed in the group once before,  you can search the group
at yahoo,  it is also archived

at http://www.mail-archive.com/development-axapta%40yahoogroups.com/  which
I think is an easier search.



This particular thread is at this link



http://www.mail-archive.com/development-axapta@yahoogroups.com/msg04150.html




Hope it helps you out.



-Preston







  _

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of axapta123456
Sent: Tuesday, July 26, 2005 6:21 AM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Posting Memory Leak



Hi,

We are still experiencing problems with the standard sales order
posting process in Axapta v3 SP2.  It seems as if the standard
posting routine in Axapta has a memory leak that causes Ax32.exe to
crash with an out of memory error.  Has anyone of you experienced
this before and do you have any recommendations for us in this
regard?  The details are as follows:

We get the SmartHeap Out of Memory error when trying to import and
post individual sales orders from an external system. The invoices
get imported into Axapta and then posted.  This posting happens on a
per sales order basis.  (Import 1 sales order from the external
system into the temporary posting tables and then post the sales
order)  We suspect that this is due to a memory leak in the Axapta
standard posting process. (Class.SalesFormLetter).  For each sales
order that is posted, a certain amount of memory is allocated (as can
be seen in the Windows task manager) and added to the total memory
usage of the Ax32 process. Only a small amount of the added memory is
released after the posting process.  This cause the total memory
usage of the Ax32 process to keep growing.  (Typical memory leak
behaviour). This causes the SmartHeap Out of Memory error after a
variable amount (about 3500) of sales orders were posted.  We have
tracked this down to the SalesFormLetter.post() instruction in
Axapta.  The posting is run from a client PC and the error occurs in
both 2 and 3-tier mode.

The standard Axapta posting procedure, in SalesFormLetter.run(), is
called for each sales order imported. (The code causes the memory
leak).

The SmartHeapMemorySizeUp() value has been set.

Do anyone have any suggestions in this regard?

Regards,









SPONSORED LINKS


Computer
  part

Programming
  languag

RE: [development-axapta] External Axapta Training Resources

[JasonDykeson]

Take a look @ www.axlearning.com they fly around the world for you!

Regards,

JasonD


-Oorspronkelijk bericht-
Van: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Namens Kang Shang Yie
Verzonden: woensdag 27 juli 2005 5:56
Aan: development-axapta@yahoogroups.com
Onderwerp: [development-axapta] External Axapta Training Resources

Hi all,

Anyone knows, if there is some training centre or Axapta expert in 
Malaysia, provides proper Axapta Training in Functional and Development 
module ?

Looking forward for any reply, thanks.

Kind Regards,
Kang







 
Yahoo! Groups Links



 









  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] External Axapta Training Resources

[Kang Shang Yie]

Hi all,

Anyone knows, if there is some training centre or Axapta expert in 
Malaysia, provides proper Axapta Training in Functional and Development 
module ?

Looking forward for any reply, thanks.

Kind Regards,
Kang











  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] rectify an error

[Srinivas Chenna]

Dear All !
I have installed SQL 2000 ,application ,client and server on my PC at home ..

then  I got an error please ..can u rectify it 

 

SQL  Reported the following error :

[Mocrosoft][ODBC SQL Server Driver][SQL server] can not open data base requested in login AXDB login fails 


"Preston A. Larimer" <[EMAIL PROTECTED]> wrote:This topic was discussed in the group once before,  you can search the group
at yahoo,  it is also archived 

at http://www.mail-archive.com/development-axapta%40yahoogroups.com/  which
I think is an easier search.



This particular thread is at this link



http://www.mail-archive.com/development-axapta@yahoogroups.com/msg04150.html




Hope it helps you out.



-Preston







  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of axapta123456
Sent: Tuesday, July 26, 2005 6:21 AM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Posting Memory Leak



Hi,

We are still experiencing problems with the standard sales order 
posting process in Axapta v3 SP2.  It seems as if the standard 
posting routine in Axapta has a memory leak that causes Ax32.exe to 
crash with an out of memory error.  Has anyone of you experienced 
this before and do you have any recommendations for us in this 
regard?  The details are as follows:

We get the SmartHeap Out of Memory error when trying to import and 
post individual sales orders from an external system. The invoices 
get imported into Axapta and then posted.  This posting happens on a 
per sales order basis.  (Import 1 sales order from the external 
system into the temporary posting tables and then post the sales 
order)  We suspect that this is due to a memory leak in the Axapta 
standard posting process. (Class.SalesFormLetter).  For each sales 
order that is posted, a certain amount of memory is allocated (as can 
be seen in the Windows task manager) and added to the total memory 
usage of the Ax32 process. Only a small amount of the added memory is 
released after the posting process.  This cause the total memory 
usage of the Ax32 process to keep growing.  (Typical memory leak 
behaviour). This causes the SmartHeap Out of Memory error after a 
variable amount (about 3500) of sales orders were posted.  We have 
tracked this down to the SalesFormLetter.post() instruction in 
Axapta.  The posting is run from a client PC and the error occurs in 
both 2 and 3-tier mode.

The standard Axapta posting procedure, in SalesFormLetter.run(), is 
called for each sales order imported. (The code causes the memory 
leak).

The SmartHeapMemorySizeUp() value has been set.

Do anyone have any suggestions in this regard? 

Regards,









SPONSORED LINKS 


Computer
  part 

Programming
  languages 

Microsoft
  axapta 


Support
  exchange 







  _  

YAHOO! GROUPS LINKS 



*  Visit your group "development-axapta
 " on the web.
  
*  To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
 
  
*  Your use of Yahoo! Groups is subject to the Yahoo!
  Terms of Service. 



  _  



[Non-text portions of this message have been removed]





SPONSORED LINKS 
Computer part Programming languages Microsoft axapta Support exchange 

-
YAHOO! GROUPS LINKS 


    Visit your group "development-axapta" on the web.
  
    To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
  
    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


-




    
-
 Start your day with Yahoo! - make it your home page 

[Non-text portions of this message have been removed]









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your 

[development-axapta] [Urgnet] SysDataBaseLog drop from Sql

[Cenk Ince]

Hi all
 
SysDataBaseLog table increased so much that it reached 9 GB :( So i want to delete this log. But it doesn't clear it very quickly. Is it good to drop table from Sql Server? Or is there a way to do it from  Axapta?
 
Thanks.
 


[Non-text portions of this message have been removed]







  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

SV: [development-axapta] Can anybody explain me this syntax

[Allan Ørum]

Hi Thomas

If you dont pass a parameter n to this method, n will get the value from the
tablebuffer _emp.name.
If you do pass a value, n will have this value.

The body, simply gives _emp.name the value n, and returns it.

Regards
Allan

-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] På vegne af Thomas
Sendt: 26. juli 2005 15:09
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Can anybody explain me this syntax

Hello,
I am used to programming Java and C#. But for some reason I have 
problems understanding this syntax:

EmplName name(EmplName n = _emp.name)
{
    _emp.name = n;
    return n;
}

I understand the following:
the method name returns an EmplName. when calling the method you do it 
with a parameter n of the type EmplName. But what dows the n = 
_emp.name do? and what goes on in the method body?







 
Yahoo! Groups Links



 




-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.5/58 - Release Date: 25-07-2005







  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [development-axapta] Can anybody explain me this syntax

[Sonny Wibawa Adi]

Hi, Thomas,


It's like a property in C#.

Here is the code in C# with the same function as the
method in Axapta (which in Axapta, it's called an
'accessor method').

public string name
{
  get
  {
    return _emp.name;
  }
  set
  {
    _emp.name  = value;
  }
}

About the parameter syntax: _Type n [= defValue].
The meaning of [= defValue] is the default value if
the parameter is not set.
So, in C# you can access the property value by calling
the property name like this:

MessageBox.Show(MyObject.name);

In Axapta, you just doing the code like this:

box::info(MyObject.name());

Axapta will set n as the same with _emp.name (in the
argument), so The line code _emp.name = n; will have
no effect to _emp.name (i.e. set _empl.name into n,
which has been set equal to _empl.name).

When you want to set the property value in C#, then it
simply like this:

MyObject.name = "My Name";

In Axapta, this is how we set from the accessor
method:

MyObject.name('My Name');

This will change _empl.name into a new value n in this
line code _emp.name = n;. The returned value is not
processed and the compiler will not give a syntax
error.

In Java, it's like the same with getProperty and
setProperty methods. The difference between Java's set
and get methods with Axapta's accessor method is,
Axapta write the code in only one method using a
default value parameter.

Welcome to OOP in Axapta using X++. :)



Regards,


Sonny Wibawa Adi, MBSCP, MCAD.NET, MCSD.NET, MCP


--- Thomas <[EMAIL PROTECTED]> wrote:

> Hello,
> I am used to programming Java and C#. But for some
> reason I have 
> problems understanding this syntax:
> 
> EmplName name(EmplName n = _emp.name)
> {
> _emp.name = n;
> return n;
> }
> 
> I understand the following:
> the method name returns an EmplName. when calling
> the method you do it 
> with a parameter n of the type EmplName. But what
> dows the n = 
> _emp.name do? and what goes on in the method body?
> 
> 
> 
> 
> 
> 



    

Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [development-axapta] Can anybody explain me this syntax

[Harry (Harshawardhan Deshpande]

hi
 
This reminds me of an incident 2 years back. My CEO decide to indulge in x++ programming (he is functional) and  the first method he had a look was something like the one that you have mentioned. After spending 30 minutes he said this does not make sense, it is as if this method is saying "Hello, I am me"    *lol*
 
anyway to answer your question
 
EmplName[1] name[2](EmplName n = _emp.name)[3]
{
    _emp.name = n; [4]
    return n; [5]
}

[1] returning value is of type EmplName
[2] name of the method
[3] if this value is not provided while calling the method the assign this the value _emp.name 
[4] assign the value of n to _emp.name
[5] return the value of n.
 
Typically while instantiating a class you would call class.name("Harry"). This will set the value of _emp.name to "Harry". Next time you want to use this value you just call class.name() this will return the value "Harry". So basically you use the same method to set the value and retrive the value.
 
Please also note that as per latest best practices "_" is reserved for variables that are being passed as parameters. so your method declaration would be 
 
EmplName name(EmplName _emplName = emp.name)
 
 
regards
 
harry



Thomas <[EMAIL PROTECTED]> wrote:
Hello,
I am used to programming Java and C#. But for some reason I have 
problems understanding this syntax:

EmplName name(EmplName n = _emp.name)
{
    _emp.name = n;
    return n;
}

I understand the following:
the method name returns an EmplName. when calling the method you do it 
with a parameter n of the type EmplName. But what dows the n = 
_emp.name do? and what goes on in the method body?







SPONSORED LINKS 
Computer part Programming languages Microsoft axapta Support exchange 

-
YAHOO! GROUPS LINKS 


    Visit your group "development-axapta" on the web.
  
    To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]
  
    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


-



    
-
 Start your day with Yahoo! - make it your home page 

[Non-text portions of this message have been removed]






  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

RE: [development-axapta] Can anybody explain me this syntax

[Oliver Mestdagh]

I believe when the method is called, if you supply the EmplName parameter with a null value,
then n gets set to the value of _emp.name.
_emp.name would have been defined in an outer scope.
 
The method essentialy would be used to get or set the EmplName.
 
ie. name("Thomas) would return "Thomas"
    once the above was called,
    name() would also return "Thomas"
 
 
I believe...

-Original Message-
From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Thomas
Sent: Tuesday, 26 July 2005 11:09 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Can anybody explain me this syntax


Hello,
I am used to programming Java and C#. But for some reason I have 
problems understanding this syntax:

EmplName name(EmplName n = _emp.name)
{
    _emp.name = n;
    return n;
}

I understand the following:
the method name returns an EmplName. when calling the method you do it 
with a parameter n of the type EmplName. But what dows the n = 
_emp.name do? and what goes on in the method body?








SPONSORED LINKS 
Computer   part   Programming   languages   Microsoft   axapta   
Support   exchange   

  _  

YAHOO! GROUPS LINKS 


  
*   Visit your group " development-axapta  " on the web.
  

*   To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]  
  

*   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service  . 


  _  




[Non-text portions of this message have been removed]









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[development-axapta] Re: Table Lookup on Forms by DataAreaId

[axapta_coder]

Hi Alla,
Thanks for your reply. My issue is not setting a default comany of a 
data source.
My issue is inter-company transactions.
Imagine doing a GL journal entry where your debit balance is posted 
to a designated GL account in company "100", while the Credit 
balance must be posted to another GL account in company "200".
standard Axapta let's you lookup and select an account based on your 
company selection. Using the same logic, I need my custom field to 
look up company dependent records. It curently looks up records 
based of my curExt() and not the company I'm selecting on the 
journal line!

// Thanks a bunch.


--- In development-axapta@yahoogroups.com, "allanwallis" 
<[EMAIL PROTECTED]> wrote:
> When you specify a datasource in a form, you can specify which 
company 
> the data is derived from.
> So you could for example have one datasource for each company and 
put 
> each on a separate tab of your lookup form. 
> 
> I believe that you can also set the company for the datasource in 
the 
> init method of your lookup form, e.g. LedgerTable_DS.company('aaa')
> 
> Hope this helps
> 
> 
> 
> --- In development-axapta@yahoogroups.com, "axapta_coder" 
> <[EMAIL PROTECTED]> wrote:
> > 
> > I have a table from which I'm looking up a field value via a 
Journal 
> > Line (LedgerJournalTransDaily).
> > 
> > This value is used in relation to an Inter-Company transaction 
and 
> > therefore needs to be a company specific lookup. Pretty much 
like 
> > standard Inter-Co entries where a GL account is looked up based 
on 
> > account type but most importantly by company account.
> > 
> > I need to make my table lookup to be company dependent and not 
> looking 
> > up values from the current company I'm standing on.
> > 
> > Any suggestions will be greatly appreciated.










  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.