Re: [development-axapta] Business Connector Error
Steven: Please check you have the proper password in Business Connector tab (Axapta Configuration Utility). Also, in General Tab - user should be present. Then Shut Down and Register again. I hope you are using COM+ option. I too had faced this problem sometime back, but the above steps solved it. Another way to find the detailed error is checking the Event Viewer (Administrative Tools) Application tab Regards, Dilip Steven <[EMAIL PROTECTED]> wrote: Hi There, I am trying to test the business connector in Axapta, and am getting a message that the business connector was loaded without problem, but i am then getting the following error: "Could not logon to Microsoft Axapta This may be due to wrong or unspecified user name and password for COM-logon in AxConfig, or that permissions to the COM-logon do not exist. Error information Method 'logon2' in COM object of class 'AxaptaComConnector.Axapta2' returned error code 0x80004005 (E_FAIL) which means: Message file error : Cannot load text file, since no language was specified. Please restart the Axapta Business Connector before logging on." Does anyone know how to resolve this issue? The default language is set in the configuration utility on the general tab, so i am not sure where this error is picked up. Thanks, Steven 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. - - Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars. [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] Using COM Objects in Axapta
Aravind, You can use the COM object = new COM("Microsoft.Word"); Under AOT, check for some classes like SysExcelApplication etc..It can be used as a starting point and you can further build upon it. Regards, Dilip Aravindan Muniappan <[EMAIL PROTECTED]> wrote: Hi, How to use COM Object in Axapta. E.g; Can we integrate Microsoft MPP from Axapta Thanks. - Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [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. - - Yahoo! Mail Use Photomail to share photos without annoying attachments. [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] Performance Issue
Maverick: Try using INSERT_RECORDSET / UPDATE_RECORDSET..This will speed up the operation. Good luck Regards, Dilip Maverick <[EMAIL PROTECTED]> wrote: Hi All, I have some code which is processing thousands of update on the table. This process is doing all the updates on one table. Updates consists of inserting new record and updation of a record. The process consist of a loop, doing updation on a table on every record conditionally. And this is done several times. And table consists of million of records. What are the ways to optimize the process. Please do tell me all the points to be taken care in the CODE,TABLE and in the SQL. Like: When should TTSCOMMIT be done. If it is done after every update it will take too much time. And if it is after thousands of update, it takes runtime memory. What about Index, should it be primary OR cluster. What properties of SQL Server should be set for better updation. If you would like to put light on any other point, it willl be very helpful. Thanks Maverick [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. - - Yahoo! DSL Something to write home about. Just $16.99/mo. or less [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: RE : [development-axapta] Axapta programming version control
In 4.0 which would be releasing in 2nd Quarter, Microsoft is incorporating version control Steeve Gilbert <[EMAIL PROTECTED]> wrote: Hi Andrew, It seems like finding information on version control for Axapta is a hard task. I've started taking a look around and it seems that there are very few products. Beside NextInnovation, I've seen axSource in the add-in catalogue but it isn't supported anymore. I'm starting to believe no one use version control in Axapta world. I don't recall seeing a post like "We use that version control system and it's working great... bla..." Regards, Steeve... -Message d'origine- De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Andrew Staples Envoyé : 27 décembre 2005 13:57 À : development-axapta@yahoogroups.com Objet : [development-axapta] Axapta programming version control Hello, We have several developers working on Axapta modifications, some internal, some outsourced. We're looking for version control software that works within Axapta. PerfectProgramming out of Australia had such a product, but it looks like their website is down. Has anyone used their software, or are there recommendations for other products? There is also a product (seems like it is in beta) called Axapta Source Code Management at nextinnovation.dkhas anyone used this product? Or have you integrated with 3rd party programs to manage your development efforts? Thanks, Andrew Yahoo! Groups Links 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. - - Yahoo! DSL Something to write home about. Just $16.99/mo. or less [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] RecID
Tx for the info about SystemSequences table, i did some testing and found that the "nextval" field value cannot be relied upon e.g. when you shut down axapta and again start it, the nextval field will be randomly updated. Also, e.g. if you try creating a new customer and try to compare the Recid of that record with the "nextval" value..It's different so I think its the axapta kernel which generates the recid at run-time and the nextval cannot be relied on..Appreciate further thoughts on this.. "MALEK, Tomas" <[EMAIL PROTECTED]> wrote: Hi, record Id is stored in systemSequences table (line with Id equal '-1') Tomas. -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dilip N Sent: Tuesday, January 03, 2006 9:03 AM To: development-axapta@yahoogroups.com; Axapta Village (E-mail) Subject: Re: [development-axapta] RecID Hi, As per my knowledge goes, Recid is auto-generated whenever you create a record. This is handled at kernel level and no table is involved which stores the last recid. Please enlighten if I'm wrong. Regards, Dilip "Jayaprakash M." <[EMAIL PROTECTED]> wrote: Hi, Axapta generates Recid in a sequential order, i want to know which table and which field is involved to store the latest recid generated. Can any one give me the table name. Regards, jay [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. - - Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping [Non-text portions of this message have been removed] Yahoo! Groups Links 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. - - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. [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] RecID
Hi, As per my knowledge goes, Recid is auto-generated whenever you create a record. This is handled at kernel level and no table is involved which stores the last recid. Please enlighten if I'm wrong. Regards, Dilip "Jayaprakash M." <[EMAIL PROTECTED]> wrote: Hi, Axapta generates Recid in a sequential order, i want to know which table and which field is involved to store the latest recid generated. Can any one give me the table name. Regards, jay [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. - - Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping [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] Calling external web services
Hi, You can use the WebService class to do this. Make sure that that you are passing the paramater as a wsdl file. If possible can you paste the code snippet out here? Regards, Dilip Zappia Alessandro <[EMAIL PROTECTED]> wrote: Hello and happy new year everybody! Some of you ever tried to call a webservice from within axapta?I took a look to the tutorial_webservicesDemo form, but it doesn't seem to work, I always get the following message: "Method 'MSSoapInit' in COM object of class 'MSSOAP.SoapClient' returned error code 0x80020009 (DISP_E_EXCEPTION) which means: WSDLReader:Loading of the WSDL file failed HRESULT=0x80070057 - WSDLReader:XML Parser failed at linenumber 0, lineposition 0, reason is: Download della risorsa specificata non riuscito. HRESULT=0x1." Some of you can help? I'm not very skilled in WS, so I don't exactly know where to start to understand the problem! Any help is very appreciated! Zappia Alessandro Cluster Reply S.r.l Via Galileo Galilei, 2 Silea (TV) cell: 3480323803 e-mail: [EMAIL PROTECTED] [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. - - Yahoo! for Good - Make a difference this year. [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] for copying the database
Hi Aparna, Assuming that your Axapta database is in SQL, you can copy the tables data from your custom solution to your Axatpa database via DTS (Import/Export Wizard). This utility comes with SQL Enterprise Manager. Many other techniques are also available like bcp etc. Another technique would be to export data from your custom database into an excel sheet, and then from Axapta (Administration->Periodic->Data Import ), you can import the data in Axapta. HTH Regards, Dilip Aparna Raina <[EMAIL PROTECTED]> wrote: Hi All, we build a small application in Visual Basic which is working as Account Receivable module of Axapta and using the same tables which exists in axapta in the same format. the backend we used is SQL. I want to import the tables in Axapta so that the items and the quantity must hit in axapta. is there any possibility of doing this. if yes then what is the way and the flow of doing this. Thanks in Advance Aparna Send instant messages to your online friends http://in.messenger.yahoo.com [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. - - Yahoo! for Good - Make a difference this year. [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] Questions on Axapta 3.0 SP4 Upgradation
Thanks Michael and Hilda. Michael, You are right HF30SP4_011 help fixed the problem, but I have another issue here related to "Compare Layers" and "Code Upgrade" I would like to know what would be the layers to compare after a service pack upgradation. Actually, I applied 3.0 SP4 and when I see the Class SalesFormLetter in AOT..It show something like this (sys,syp,usr).. Because of some customizations done by developers on this class, i believe the user layer code has overriden the syp layer, i came to know about this because on another machine I have a fresh installation of SP4 with no user customizations on it and i compared the code for SalesFormLetter class in both machines. Now my question here is, If we do a "Compare Layers", followed by a "Code Upgrade", should we compare : a. sys-usr layer b.sys-oldusrlayer ( i guess oldusr and usr are same-this is what it says in Developer guide) c.sys-oldsys layer d. syp-usr layer e. syp-oldusr layer f. syp-sys layer I'm bit confused here. Would appreciate if anyone help me on this? Thanks and Regards, Dilip hilda cabrejos <[EMAIL PROTECTED]> wrote: Hello We had the same problem trying to upgrade from sp3 to sp4, what saved us was that we were working on sp2.5 and the solution was to upgrade from sp2.5 to sp4, this because sp4 as I understand has all the hotfixes of sp3. I´ll try to talk with our partner to ask if there is another tip. Hilda Michael Niemeyer <[EMAIL PROTECTED]> wrote: Hi Dilip, you find the hotfix in partnerguide .The description her is: " Under certain circumstances, execution of the mentioned data upgrade jobs can run extremely long time during the upgrade " I don't know if it help's in your case, think you have to contac your VAR to get and test the hotfix. With the hotfix you get an description how to use too. Best regards Michael >From: Dilip N <[EMAIL PROTECTED]> >Reply-To: development-axapta@yahoogroups.com >To: development-axapta@yahoogroups.com >Subject: RE: [development-axapta] Questions on Axapta 3.0 SP4 Upgradation >Date: Mon, 29 Aug 2005 18:28:06 -0700 (PDT) > >Hi Michael, > >I checked my HotFix Axapta 3.0 folder which comes with the installation CD, >but couldn't find the file listed below. Should I contact my VAR for this? >Or is it downloadable from some site? > >And, could you please let me know what does this hotfix actually do and >when it should be applied? i.e. after installation of 3.0 SP4..I mean >precisely after which step? i.e. >compilation,license,pre-synchronize,synchronize etc. because rite now i >have success only till synchronize step. > >Any other workarounds for a quick upgradation? Any suggestions/tips >recommened. > >Thanks and Regards, >Dilip > >Michael Niemeyer <[EMAIL PROTECTED]> wrote: >Hi, > >you have HF30SP4_011 - Upgrade to sp4 taking extremely long time, Hot Fix ? > > >Michael > > >From: "diliprnair27" <[EMAIL PROTECTED]> > >Reply-To: development-axapta@yahoogroups.com > >To: development-axapta@yahoogroups.com > >Subject: [development-axapta] Questions on Axapta 3.0 SP4 Upgradation > >Date: Mon, 29 Aug 2005 09:16:58 - > > > >Hi, > > > >I'm trying to upgrade a local installation on PC for testing from 3.0SP1 >to > >3.0SP4. The client, app and database is on the same machine. Database > >size is 40GB and we have a lot of customizations at usr layer. > > > >Initially, I followed the steps prescribed in documentation about > >Upgradation of service packs. I was stuck in Post-synchronize step and >for > >hours together it won't happen. CPU utilization shows very high. > >COmpilation, Pre-synchronize and synchronize steps have no problem but > >the post-synchronize doesn't seem to happen. I tried for 2 days but no > >luck. > > > >The, next step I tried is created the default db "AXDB" and then >installed > >a > >fresh copy of SP4 and I could complete all steps. Later I changed my > >database to copy of our production database and then imported the AOT > >(usr layer) into the fresh app. But the import is taking long time and > >doesn't seem to complete. i tried 2 times but no success. > > > >Can anyone help me with the upgradation steps? Thanks in advance. > > > >Regards, > >Dilip > > > > > > > > > > > > > > > > > > > >SPONSORED LINKS >Microsoft business solution Microsoft axapta Basic programming language >Computer programming languages Programming languages Java programming >language > >- >YAHOO! GROUPS LINKS > > > Visit your g
RE: [development-axapta] Windows CE .NET
Hi, I have desinged a Pocket PC solution which communicates with Axapta for my sales team. Initially, I used the PDA pages which you can find in web forms in AOT. You can setup your enterprise portal and then connect it via Pocket PC. But this solution required that there should be uninterrupted network service, but this is not often the case when our salesforce go to field. So, I designed an "usually offline and online only when needed" solution which uses .Net Compact Framework architecture and SQL CE Merge Replication to communicate to the SQL Server which hosts our ERP database. And now it's implemented and salesman are using it without any problems. If you need further help, u can reach me offline on [EMAIL PROTECTED] Thanks and Regards, Dilip Matt Benic <[EMAIL PROTECTED]> wrote: I am not aware of such a version, I'm guessing your best bet would be to try and use the mobile ready Axapta web components (haven't used that myself I'm afraid) or work through a servver which connects to axapta using the Axapta Business Connector COM object. I don't know is CE platforms can run something like the ABC locally? Regards, Matt Benic - .Net/Axapta Analyst Developer UTi Sun Couriers Division | Cnr Olievenhoutbosch Rd & Brakfontein Rd, Centurion, 0061 [EMAIL PROTECTED] | O 012-6732288 | F 012-6732344 -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of gonzalo_edo Sent: 31 August 2005 04:38 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Windows CE .NET Hi all, there's any known version of AX 3.0 SP3 or similar that runs under Windows CE .NET ?? Or any have experience with Symbol Hand Held BarCode Scanners MC3000 and Terminal Services? Can I do it throught Axapta with Api's or how? This is really urgent, hope you all can help me. Best Regards. Gonzalo. Yahoo! Groups Links SPONSORED LINKS Microsoft business solution Microsoft axapta Basic programming language Computer programming languages Programming languages Java programming language - 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. - - Yahoo! Mail Stay connected, organized, and protected. Take the tour [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft business solution Microsoft axapta Basic programming language Computer programming languages Programming languages Java programming language 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] Questions on Axapta 3.0 SP4 Upgradation
Hi Michael, I checked my HotFix Axapta 3.0 folder which comes with the installation CD, but couldn't find the file listed below. Should I contact my VAR for this? Or is it downloadable from some site? And, could you please let me know what does this hotfix actually do and when it should be applied? i.e. after installation of 3.0 SP4..I mean precisely after which step? i.e. compilation,license,pre-synchronize,synchronize etc. because rite now i have success only till synchronize step. Any other workarounds for a quick upgradation? Any suggestions/tips recommened. Thanks and Regards, Dilip Michael Niemeyer <[EMAIL PROTECTED]> wrote: Hi, you have HF30SP4_011 - Upgrade to sp4 taking extremely long time, Hot Fix ? Michael >From: "diliprnair27" <[EMAIL PROTECTED]> >Reply-To: development-axapta@yahoogroups.com >To: development-axapta@yahoogroups.com >Subject: [development-axapta] Questions on Axapta 3.0 SP4 Upgradation >Date: Mon, 29 Aug 2005 09:16:58 - > >Hi, > >I'm trying to upgrade a local installation on PC for testing from 3.0SP1 to >3.0SP4. The client, app and database is on the same machine. Database >size is 40GB and we have a lot of customizations at usr layer. > >Initially, I followed the steps prescribed in documentation about >Upgradation of service packs. I was stuck in Post-synchronize step and for >hours together it won't happen. CPU utilization shows very high. >COmpilation, Pre-synchronize and synchronize steps have no problem but >the post-synchronize doesn't seem to happen. I tried for 2 days but no >luck. > >The, next step I tried is created the default db "AXDB" and then installed >a >fresh copy of SP4 and I could complete all steps. Later I changed my >database to copy of our production database and then imported the AOT >(usr layer) into the fresh app. But the import is taking long time and >doesn't seem to complete. i tried 2 times but no success. > >Can anyone help me with the upgradation steps? Thanks in advance. > >Regards, >Dilip > > > > > > SPONSORED LINKS Microsoft business solution Microsoft axapta Basic programming language Computer programming languages Programming languages Java programming language - 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] SQL sync error
Information_schema.views is a system view which resides in master database. First step, you just check whether this view is present in the location by expanding master database->VIews, Nextly, you check if proper permissions like dbo is the owner of the view..I believe it might be corrupted. or if you have another sql server hosted, just try using that copy of master database..maybe backup this master db and restore the other master db.. Good luck :-) James Flavell <[EMAIL PROTECTED]> wrote: Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can help as I am not able to do any sync to my databases because of this... Thanks James Error given during sync: Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCES') DROP VIEW LEDGERBALANCES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCESDIM') DROP VIEW LEDGERBALANCESDIM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNUSERSPERLINES') DROP VIEW BMRUNUSERSPERLINES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMUSERSCRIPTTIMINGAGG') DROP VIEW BMUSERSCRIPTTIMINGAGG Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNSTEPSPREADING') DROP VIEW BMRUNSTEPSPREADING Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMSCRIPTSTEP') DROP VIEW BMSCRIPTSTEP Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERVENDPAYMPROPOSAL') DROP VIEW LEDGERVENDPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERCUSTPAYMPROPOSAL') DROP VIEW LEDGERCUSTPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'CUSTVIEW') DROP VIEW CUSTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERACCOUNTVIEW') DROP VIEW LEDGERACCOUNTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERTRANSVIEW') DROP VIEW LEDGERTRANSVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_N
Re: [development-axapta] Re: Long Query time
For deep introspection, you can also try running the SQL Profiler with different events and watch the output.. HTH kwc_thydev <[EMAIL PROTECTED]> wrote: Hi, You should use Axapta's built-in SQL trace to check which accessplan Axapta generates to process your SQL statement. regards, Karsten Wollesen Thy Data Center Development A/S --- In development-axapta@yahoogroups.com, "Raal Goff" <[EMAIL PROTECTED]> wrote: > Im using an sql statement to run an sql query, but it seems to be taking > an excessively long amount of time to run. When I run the query on the > database directly it takes about 2mins to return the full set, but if I > run it through Axapta using either a statement or while select{} loop it > takes about 9 minutes for EACH LOOP. > > Is there any reason why a query would be running so long? It is doing a > table join against itself, (eg ledgertrans is joining against > ledgertrans) but I wouldn't imagine that would be a terrible problem, as > the database server itself seems to run the query just fine, and in less > time. It does return quite a few results as well (something in the order > of 200,000 results) but ive see Axapta handle that amount of records > before. > > Anyone have any idea why a query would be taking so long to run? > > Cheers, > > -- > Raal Goff > Software Developer > NAS Insurance Brokers > T 08 9480 8900 > F 08 9481 1166 > W www.nasinsurance.com.au - 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 the Yahoo! Terms of Service. - Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football [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] Third Party COM
Hi, For starter, you can check the built-in classes like CCADOConnection, CCRecordset,CCommand,CCFields etc..I had written a small program wherein I can connect to .net component/vb component and retreive the value..i have also tried getting recordset into Axapta and it works..If you wanna more details, feel free to ask me.. Dilip Axapter <[EMAIL PROTECTED]> wrote: Hi all, I made some code to integrate third party software with Axapta through the third party's COM Object. but it fails because Axapta does not receive the changed recordset even though the third party COM's engine is passing it back. It thinks it still has the original unopened recordset. I can pass data to the engine but passing it back doesn't work. This might be a problem with the Axapta COM handling because I'm not having this problem with VB, ASP, or even the (real) C++ where it works ok. Is it any problem with the VB ActiveX.dll ??? Also I tried changing the engine to see if changing between by val and by ref made any difference...if 'by val' (like the criteria set - csPass) then can pass data in but not out. If 'by ref' like the recordset - rsSecurityKey then it is not passing any data in or out...! So again, I need to know how to pass recordset data in and out from a VB activeX dll from Axapta X++.. Does anyone had experience just like me ?? thanks in advance, Axapter [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. - - Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football [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.