RE: [Axapta-Knowledge-Village] SQL Duplicate company error

Mon, 29 Aug 2005 19:40:44 -0700

Title: Message
I think your steps are quite as I suggest.  Basically you need to create the table in CUS layer and USR separately so try:
 
Rename axcus.aod to temp_axcus.aod so basically axapta thinks there is no CUS layer
Login to USR layer
Add the new table
Logout
Rename temp_axcus.aod back to axcus.aod
Rename axusr.aod to temp_axusr.aod
Login to CUS
Add the new table (it should not exist in AOT because you renamed USR layer aod)
Logout
Renanem temp_axusr.aod to axusr.aod
Login (now basically you have both USR and CUS that not aware of each others new table and so I would expect you have two elements in the AOT)
 
This basically is like bringing to independent layers together (not a good idea ever).
 
Try that and see
Thanks
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi
Sent: 30 August 2005 11:22
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] SQL Duplicate company error

Hi  James,
 
as per your advice to duplicate the problem, I did as the following.
 
1. Created a new Table SUNExample with 2 fields and populated data.
2. Exporrted the Table /
3. Logged on to 'CUS' layer ( We don;t have access to VAR ) and reimported the SUNExample Table. There I added a third table to this table so that I made sure the same table name exists with different versions and populated diffferent data.
 
 
4. Now , I logged on to USR layer and duplicated the company - No problem or no SQL trans error.
 
5. Now, I logged in now to CUS layer and duplicated the company - No problem.
 
I am using SP3 and Ax3.
Microsoft Ax acts sometimes very fishy :(.
seems, like sometime IE crashes without reason. seems its also the same fishy :((
 
But, I will keep an eye and will discuss with you if I get this problem again.
 
kind regards
subbu

James Flavell <[EMAIL PROTECTED]> wrote:
I think this problem is the same as what I posted earlier about export always crashing and it was because having some tables in both VAR and USR but as diferent eleemnts (i.e. 2 tables appear in the AOT with samename).  I guess when Axapta gets to one of them it finds actual there is no SQL table name or something liek that and hence the error.
 
Once the programmer cleans up this mess I am pretty sure it will work.
 
Sync and compile every other day seems very wrong to me....
Thanks for your input
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi
Sent: 25 August 2005 22:01
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] SQL Duplicate company error

Hi James,
 
This problem I face almost every alternative day. But I do get SQL error  on a  Table. Interesting it didn.t specify the table name for you.
 
What I do is, I will check/sync , reindex and do complete application compilation.
Then it works for me.
 
Best of luck.
Thanks,
subbu
 
 
James Flavell <[EMAIL PROTECTED]> wrote:
Has really noone faced this problem before?
 
Thanks
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
Sent: 19 August 2005 17:26
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] SQL Duplicate company error

Can anyone help me to know why I get this message when I try the duplicate company function in 'Company Accounts' 
 
 Cannot execute the required database operation.,The SQL database has issued an error.
 SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.
 SQL statement: DELETE FROM  WHERE DATAAREAID = {fn LCASE('DJF')} 
 
I guess it is because there is no table name after the FROM but what has caused that?  DJF is the new company I want to create via the duplicate and so from what I understand this DJF does not exist to start with so why is it doing a delete anyway?
 
Is there a stored SQL procedure or something that Axapta calls to do the duplicate as I am wondering maybe something is amiss in it (BTW the data export is done via pure Axapta codes or more direct SQL commands issued by Axapta?  this may be the reason my data export also crashes maybe...).

Thanks
James
 

Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.

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

Sharing the knowledge on Axapta.


YAHOO! GROUPS LINKS



Reply via email to