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

Thu, 25 Aug 2005 17:17:08 -0700

Title: Message
Thanks,
 
I think you can replicate by doing:
 
Mod in usr layer.
Export to XPO
Logout
Rename axusr.aod
Start up in VAR layer
Import XPO
Logout
Put back axusr.aod
 
Now I think you  will have table with appear twice in AOT
 
The funny thing is full compile works, also I think even sync works....so not sure where the corrupt AOT data is kept
 
Thanks
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi
Sent: 26 August 2005 01:21
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] SQL Duplicate company error

Hi James,
 
This kind of errors I get in my home installation axapta. I think you may be right if we have same Tables with different fields in USR/CUS, we may get this error  I don;t not get these kind of errors in our DEV/QA environment because we maintain always in one layer only.
 
Let me see if I clean up the USR layer , I can duplicate the problem.
thanks for the input and will let you know soon.
 
Thanks & 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!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.

Sharing the knowledge on Axapta.



SPONSORED LINKS
Business finance course Business to business finance Small business finance
Business finance consultant Business finance magazine Business finance schools

YAHOO! GROUPS LINKS



Reply via email to