RE: [development-axapta] Enterprise Portal
In the web site tab , make sure the server library and directory is pointing to the root folder of the web site. Thanks Mey >From: "Malcolm Burtt" <[EMAIL PROTECTED]> >Reply-To: development-axapta@yahoogroups.com >To: "Axapta Yahoo Group" >Subject: [development-axapta] Enterprise Portal >Date: Tue, 19 Jul 2005 09:17:13 +0100 > >Hi all > >I'm trying to set up Enterprise Portal as a standalone site on IIS (i.e. >not as a sub-directory of the default site). When EP is configured to >run as a virtual directory on the default site it all works fine, but if >I run it as a standalone site then I get a blank web page with the >following HTML source... > >
> function URLEncode(Tx)
> {
> return escape(Tx);
> }
> > > >HREF=""> > >HREF=""> > > >Has anyone got any thoughts on what I might be doing wrong? > >Thanks in advance... > >Malcolm Burtt >Global IT Group >"Business Solutions designed for YOUR business processes" >Global IT Group is the trading name of Touchstone Global Business >Solutions Ltd. and is part of the Touchstone Group PLC. > > > > >[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.
[development-axapta] Configuration rules
hi there, I have set up a BOM with configuration groups and rules, however, i find that the 'deselect' option does not work. When i configure the BOM, the deselect rule does not seem to apply, and i am able to select options that i have deselected in the rules. The select rule works perfectly... Has anyone had this problem before? Would you know which code needs some changing? (i am on AXapta 3, SP3) Thanks in Advance Yifat 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: Axapta TTS Control and Record Locking
I made some experiments and found that what I told you about using NOLOCK is not actually true. Axapta will only use NOLOCK on those tables which have CacheLookup set to Found, Found&Empty or EntireTable (whether inside or outside of tts scope). Some of the "popular" tables have this setting, some may not. So when Axapta is reading from tables without appropriate CacheLookup set select will not have NOLOCK clause so you might have the classic reader-waits-for-writer situation. This is the case I'm talking about in point 5. It is my understanding now that selects with NOLOCK clause will never wait for a lock, at least I was not able to create such a situation myself. Other then that - when using SQL Server you can expect some additional writers vs. writers locking issues other that when two transactions are trying to update the same row. Eg. two simultaneous inserts to the some table will cause one of the transactions to wait. Sorry replying so late and good luck -- lewickiw --- In development-axapta@yahoogroups.com, "Kang Shang Yie" <[EMAIL PROTECTED]> wrote: > Hi Lewickiw, > > Thanks, your reply has cleared some of the doubts on my mind. For the > item 5 that you mentioned below, have you experienced any scenario > like that ? Hope you can share it if you met this problem before ? > > Looking forward for your reply, thanks. > > Kind Regards, > Kang > > > --- In development-axapta@yahoogroups.com, "lewickiw" <[EMAIL PROTECTED]> > wrote: > > > > Hi > > > > First, no explicit table locks are issued by Axapta. Locks are only > > created implicitly by insert/update/delete/select forupdate > > statements. At least AFAIK. There's nothing you can do about them > > other then restructure your code wrt sql statements. > > > > Second - it does not matter whether query is executed from static or > > dynamic method or job or whatever. > > > > > > Here is a quick summary of how database locking works in Axapta : > > > > 1. locks are only acqired for the lifetime of a transaction, locks > are > > freed when transaction ends, if no tts-block is active each single > > statement is a transaction, locks are then freed when statement ends > > > > 2. normal selects (w/o forupdate) within tts block or not will never > > acquire locks, neither read nor write lock (note : if SQL Server is > > used Axapta will use dirty reads to faciliate non-locking reads, > > Oracle allows no-locking reads in read commited mode using MVRC) > > > > 3. select forupdate will lock selected records in exclusive mode > (read > > & write), forupdate declaration is IGNORED if not within tts block, > > exact semantics differ between SQLServer and Oracle : SQL Server > locks > > records as they are retrieved, Oracle locks ALL returned rows first, > > before returning the first row from a query > > > > 4. updates will lock updated records in exclusive mode (read & > write) > > > > 5. updates/inserts/deletes statesments will not cause any additional > > locking on Oracle (other then the updated row being locked in an > > update statement), they will however acquire IX locks on the > modified > > table on SQLServer, this may sometimes cause readers to stall (but > > sometimes not, this depends, I don't know the exact rules) > > > > > > With SQL Server things can get more complicated because of lock > > escalation :-( > > > > > > Have fun > > -- > > lewickiw > > > > --- In development-axapta@yahoogroups.com, "Kang Shang Yie" > > <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > Is there anyone can give me a clear picture on Axapta Transaction > > > Control and Data Locking ? There is few queries in my mind as I > have > > > encountered performance issue on my client live site. > > > > > > 1. Within the ttsBegin..ttsCommit, will Axapta issue table > locking on > > > all querying tables data ? or it varies or depends on our SQL > > > statements ? > > > > > > 2. Anyway to better reform our queries to make sure every single > SQL > > > will not do table locking but records or rows locking only ? > > > > > > 3. Will static method cause read-locking on the data we selected ? > > > > > > Please advise as any of your comments is greatly appreciated ! > > > 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] Modifying width of user id column
Hi all, I'm trying to expand the width of the Id column on the table SysUserInfo. The field is of the EDT userId. I can't find this EDT in the AOT. Is this EDT protected by the system somehow? If it is protected, is this modification possible by any other "approved" means? Regards, Christoph Malherbe 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
[development-axapta] Data Encrption
Hi all, I have one question. What is the highest security level of encryption scope? a) RC4 encryption (128 bit) b) No encryption c) With user supported key d) 32 bit encryption ? Thanks Stasys 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] Enterprise Portal
Hi all I'm trying to set up Enterprise Portal as a standalone site on IIS (i.e. not as a sub-directory of the default site). When EP is configured to run as a virtual directory on the default site it all works fine, but if I run it as a standalone site then I get a blank web page with the following HTML source...
function URLEncode(Tx)
{
return escape(Tx);
}
HREF=""> HREF=""> Has anyone got any thoughts on what I might be doing wrong? Thanks in advance... Malcolm Burtt Global IT Group "Business Solutions designed for YOUR business processes" Global IT Group is the trading name of Touchstone Global Business Solutions Ltd. and is part of the Touchstone Group PLC. [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.
AW: [development-axapta] Re: Data Encrption
Yes - I that's the method behind. It's clear why you won't see the code of that method, isn't it? :-) But you can use it anyway. Regards Herbert -Ursprüngliche Nachricht- Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von abdulabsi Gesendet: Montag, 18. Juli 2005 14:03 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Re: Data Encrption Thanks Herbert for your fast response, do you mean the Dictionary.BuildPassword() method?? I tried to do so but I can not see the code of this method... Regards, Absi -- In development-axapta@yahoogroups.com, "Leberbauer Herbert - News" <[EMAIL PROTECTED]> wrote: > Hi! > > Take a look at the methods which en/decrypt the passwords for the web-users. > > HTH > Herbert > > -Urspr?he Nachricht- > Von: development-axapta@yahoogroups.com > [mailto:[EMAIL PROTECTED] Im Auftrag von abdulabsi > Gesendet: Montag, 18. Juli 2005 13:06 > An: development-axapta@yahoogroups.com > Betreff: [development-axapta] Data Encrption > > Dear All, > > One question regarding Data encryption in Axapta.I am not sure if it is > possible to implment the following scenario in Axapta. > > 1-One User entered new records in one form say CustTable. > 2-he pressed a button Say"Encrpyt Data befor sending to the DB."... > 3-Data is encrypted and stored in the DB 4-when Others came to view it,They > should enter the Decrytpion key to be able to view it > correctly.Otherwize,garbage should be viewed. > > Is this doable throw Axapta, or SQL > please Advise if you have any idea in this regards > > Worm Regards, > Absi > > > > > > > > > Yahoo! Groups Links 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.
