Re: [development-axapta] Re: Importing Axapta enterprise data from an Oracle DB to a SQL DB

2005-06-22 Thread Lalith Jayantha 




Hi Mikkeal 

can you pls send the  whitepaper for me too.
here is my email address 

[EMAIL PROTECTED]

Thank you

Lalith

--- Alejandro Ibarra <[EMAIL PROTECTED]> wrote:

> Hi Mikael, here is my email address:
> [EMAIL PROTECTED]
> 
> Thank's
> 
>  --- Mikael Sorensen <[EMAIL PROTECTED]>
> escribió:
> 
> > Leave a valid e-mail address, and I'll send it to
> > you.
> > 
> > //Mikael
> > 
> > --- In development-axapta@yahoogroups.com,
> Alejandro
> > Ibarra 
> > <[EMAIL PROTECTED]> wrote:
> > > Hi Mikael, i think that your whitepaper could
> help
> > a
> > > lot, can you pass me the document to check it
> out.
> > > 
> > > thank's
> > >  --- Mikael Sorensen <[EMAIL PROTECTED]>
> > > escribió:
> > > 
> > > > If you need to migrate the entire database
> from
> > > > Oracle to MS SQL, I 
> > > > have a whitepaper, explaining how to do it.
> > > > 
> > > > //Mikael
> > > > 
> > > > --- In development-axapta@yahoogroups.com,
> > Alejandro
> > > > Ibarra 
> > > > <[EMAIL PROTECTED]> wrote:
> > > > > Hi, i'm having problems importing an Axapta
> > > > enterprise
> > > > > data from Oracle to SQL, when i import de
> data
> > in
> > > > the
> > > > > Axapta with the SQL DB it's take a long time
> > an
> > > > never
> > > > > end. If someone know a better way to do this
> > tell
> > > > me
> > > > > please.
> > > > > 
> > > > > Alex!
> > > > > 
> > > > >
> > __
> > > > > Correo Yahoo!
> > > > > Espacio para todos tus mensajes, antivirus y
> > > > antispam ¡gratis! 
> > > > > Regístrate ya -
> > http://correo.espanol.yahoo.com/
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > 
> > > 
> > >
> __
> > > Correo Yahoo!
> > > Espacio para todos tus mensajes, antivirus y
> > antispam ¡gratis! 
> > > Regístrate ya - http://correo.espanol.yahoo.com/
> > 
> > 
> > 
> > 
> > 
> 
> 
> __
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y
> antispam ¡gratis! 
> Regístrate ya - http://correo.espanol.yahoo.com/ 
> 
> 
> 


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











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.

[development-axapta] Long Query time

2005-06-22 Thread Raal Goff 




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.

Re: [development-axapta] Upgrade error

2005-06-22 Thread Luk Gary 




any location can i find the instruction?

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


-
It's very bad solurion to to upgrade like this. v3.0
differs from v2.5 and 
some objects code are upgraded, so if you copy .aod
and object file from one 
to another version you'll get inconsistency. No
chances to do upgrade in 
this way.
Better read some instructions how to do that. It's
more complex then you 
think

Kuni
- Original Message - 
From: "Luk Gary" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, June 22, 2005 4:08 PM
Subject: [development-axapta] Upgrade error


> Dear All
>
> I am doing upgrade process process from Ax2.5 sp3 to
> Ax3.0 sp3. I have do the following process. There
are
> two location (point 5 & point 8) and pop up error
and
> failure to upgrade finally. Can anyone help me to
> verify what is the problem here and giving me a
> solution or hints. Very thanks
>
> 1. Copy all. aod files form verson 2.5 application
> folder to the old folder in 3.0 application.com
>
> 2. Copy all .aod containing modifications (e.g
> ax.usr.aod) form version 2.5 applicaion folder to
3.0
> applcaion folder.
>
> 3. copy all client specific labels form version2.5
> applicaion to 3.0 applicaion.
>
> 4. Run database synchronization and reindex.
>
> 5. Compile the whole applicaion with with a infolog
> pop up, a content example below:
>
> Unable to save : Version of Group BOMLine on th
server
> is newer
> Unable to save : Version of Group BOM on the server
is
> newer
> Unable to save : Version of Group Administration on
> the server is newer
> .etc
>
> 6 No any compile error after poin 5, so I use our
2.5
> database to start "Upgrade check list funcion"
>
> 7. All processing run smoothly except synchronize
> database
>
> 8. After database synchronization , many error
appear.
> we have found that there are 3 type of errors
>

> Error Code: 207
>
> Information:
> [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid
> column name 'PARENTID'.
>
> statment:
> CREATE VIEW PROJDATAVIEW AS SELECT A.NAME AS
> NAME,A.PROJID AS PROJID,
> A.PROJGROUPID AS PROJGROUPID,A.PARENTID AS
> FATHERID,A.CUSTACCOUNT
> AS CUSTACCOUNT,A.DATAAREAID AS DATAAREAID,A.RECID AS
> RECID FROM PROJTABLE A
>
>
--
> Error Code: 8152
>
> Information:
> [Microsoft][ODBC SQL Server Driver][SQL
Server]String
> or binary data would be truncated.
>
> Statment:
> INSERT INTO X26X SELECT BOMID,{fn SUBSTRING
> NAME,1,30)},ITEMGROUPID,
>
CHECKBOM,APPROVEDBY,APPROVED,MODIFIEDDATE,MODIFIEDTIME,
> MODIFIEDBY,DATAAREAID,RECID FROM BOMTABLE
>
-
> Error Code:
> 1505
>
> Information:
> [Microsoft][ODBC SQL Server Driver][SQL
Server]CREATE
> UNIQUE INDEX terminated
> because a duplicate key was found for index ID 2.
> Most significant primary key is 'el'.
>
> Statment:
> CREATE UNIQUE  INDEX I_155LINEIDX ON
> INVENTJOURNALTRANS (DATAAREAID,JOURNALID,LINENUM)
>
---
>
>
>
>
>
>
>
>
>
> 
> Yahoo! Sports
> Rekindle the Rivalries. Sign up for Fantasy Football
> http://football.fantasysports.yahoo.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
> 





-
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.




    
__ 
Discover Yahoo! 
Have fun online with music videos, cool games, IM and more. Check it out! 
http://discover.yahoo.com/online.html












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.

[development-axapta] RE: Syntax of table browser ?

2005-06-22 Thread Keith Wallace 




It is the X++ SQL syntax rather than standard SQL.

Regards,
Keith

   Date: Wed, 22 Jun 2005 12:01:39 -
   From: "icham_2000" <[EMAIL PROTECTED]>
Subject: Syntax of table browser ?

Hi All,

Which syntax is used for coding in the table browser, Is it X++ Coding 
or SQL Syntax ?

Thank you

Best regards













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.

SV: [development-axapta] AOS shut down randomly

2005-06-22 Thread Stefan Lundquist (Priv) 




Hi,
I assume you are using Oracle ?
If you shutdown/restart Orcale (for exaple for taking a db backup) leaving
AOS running and not restarting AOS afterwards, you may have such errors.

/Stefan

  -Ursprungligt meddelande-
  Från: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] jaren_chia
  Skickat: den 21 juni 2005 09:18
  Till: development-axapta@yahoogroups.com
  Ämne: [development-axapta] AOS shut down randomly


  Hi,

  I have a client,just upgraded from axapta version 2.5 SP 3 to Version
  3.0 SP3. They are having serious problem with AOS shut down at random
  interval, sometimes in early morning(where less activity on AOS),
  sometimes during working hours.

  I have checked the AOS setting, we did not set the timeout for
  connection, so it's not possible the AOS shut down when inactivity.

  This is some of the event log from AOS server :

  Event Type:  Information
  Event Source:  Axapta Object Server
  Event Category:  None
  Event ID:  134
  Date:    20/6/2005
  Time:    8:53:27 AM
  User:    N/A
  Computer:  KUAOS
  Description:
  Object Server Axapta3: User css disconnected (session 65529, thread
  0xee0)

  Event Type:  Error
  Event Source:  Axapta Object Server
  Event Category:  None
  Event ID:  110
  Date:    20/6/2005
  Time:    8:53:52 AM
  User:    N/A
  Computer:  KUAOS
  Description:
  Object Server Axapta3: Fatal system condition - quitting for restart
  due to errors generating RecIDs.


  Event Type:  Error
  Event Source:  Axapta Object Server
  Event Category:  None
  Event ID:  140
  Date:    20/6/2005
  Time:    8:53:52 AM
  User:    N/A
  Computer:  KUAOS
  Description:
  Object Server Axapta3: Fatal SQL condition during login. Error
  message: "ORA-12516: TNS:listener could not find available handler
  with matching protocol stack
  "

  Event Type:  Error
  Event Source:  Axapta Object Server
  Event Category:  None
  Event ID:  163
  Date:    20/6/2005
  Time:    8:53:52 AM
  User:    N/A
  Computer:  KUAOS
  Description:
  Object Server Axapta3: SQL diagnostics: ORA-12516: TNS:listener could
  not find available handler with matching protocol stack
  , Connect information was: Username = [axtest], Service = [AXDB]


  Event Type:  Error
  Event Source:  Axapta Object Server
  Event Category:  None
  Event ID:  117
  Date:    20/6/2005
  Time:    8:53:53 AM
  User:    N/A
  Computer:  KUAOS
  Description:
  Object Server Axapta3: The database reported (session 43 (css)): ORA-
  24324: service handle not initialized
  . The SQL statement was: "INSERT INTO SYSTRACETABLESQL
  (TRACECONTAINER,STATEMENT,CALLSTACK,TEXT,TEXTDETAILS,TRACETIME,CATEGOR
  Y,CODE,CONNECTIONTYPE,CONNECTIONSPID,CONNECTIONID,ISLOBSINCLUDED,ISMOR
  EDATAPENDING,ROWSAFFECTED,ROWSIZE,ROWSPERFETCH,ISSELECTEDFORUPDATE,ISS
  TARTEDWITHINTRANSACTION,STATEMENTTYPE,STATEMENTID,STATEMENTREUSECOUNT,
  DETAILTYPE,CREATEDDATE,CREATEDTIME,CREATEDBY,DATAAREAID,RECID) VALUES
  (EMPTY_BLOB(),EMPTY_CLOB(),EMPTY_CLOB(),EMPTY_CLOB(),EMPTY_CLOB
  (),:in1,:in2,:in3,:in4,:in5,:in6,:in7,:in8,:in9,:in10,:in11,:in12,:in1
  3,:in14,:in15,:in16,:in17,:in18,:in19,:in20,:in21,:in22) RETURNING
  TRACECONTAINER,STATEMENT,CALLSTACK,TEXT,TEXTDETAILS
  INTO :out1,:out2,:out3,:out4,:out5"

  Event Type:  Error
  Event Source:  Axapta Object Server
  Event Category:  None
  Event ID:  117
  Date:    20/6/2005
  Time:    8:53:23 AM
  User:    N/A
  Computer:  KUAOS
  Description:
  Object Server Axapta3: The database reported (session 33 (lml)): ORA-
  24324: service handle not initialized
  . The SQL statement was: "SELECT /*+ INDEX(A I_273SERIESIDX)
  FIRST_ROWS
  */A.NUMBERSEQUENCE,A.TXT,A.LOWEST,A.HIGHEST,A.NEXTREC,A.BLOCKED,A.FORM
  AT,A.CONTINUOUS,A.CYCLIC,A.CLEANATACCESS,A.INUSE,A.NOINCREMENT,A.DEL_R
  ESTRICTIONLEVEL,A.CLEANINTERVAL,A.LATESTCLEANDATE,A.LATESTCLEANTIME,A.
  ALLOWCHANGEUP,A.ALLOWCHANGEDOWN,A.MANUAL,A.FETCHAHEADQTY,A.FETCHAHEAD,
  A.DEL_FORCEDATEORDER,A.MODIFIEDTRANSACTIONID,A.RECID FROM
  NUMBERSEQUENCETABLE A WHERE ((SUBSTR(NLS_LOWER(DATAAREAID),1,3)
  =NLS_LOWER(:in1)) AND (SUBSTR(NLS_LOWER(NUMBERSEQUENCE),1,10)
  =NLS_LOWER(:in2))) FOR UPDATE"



  Can anyone suggest what is the possible cause?
  They are using oracle DB 9.2.0.6 .
  They are also running a web application using com connector, whenever
  the aos shut down, the com connector cannot get back the connection
  and we will get the exception on the web application.

  Is it possible to run a batch during AOS start, to restart the COM
  connector? How can it be done?


  Your help is greatly appreciated, thank you.


  Jaren







--
  Yahoo! Groups Links

    a.. To visit your group on the web,

Re: [development-axapta] Upgrade error

2005-06-22 Thread Kuni 




It's very bad solurion to to upgrade like this. v3.0 differs from v2.5 and 
some objects code are upgraded, so if you copy .aod and object file from one 
to another version you'll get inconsistency. No chances to do upgrade in 
this way.
Better read some instructions how to do that. It's more complex then you 
think

Kuni
- Original Message - 
From: "Luk Gary" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, June 22, 2005 4:08 PM
Subject: [development-axapta] Upgrade error


> Dear All
>
> I am doing upgrade process process from Ax2.5 sp3 to
> Ax3.0 sp3. I have do the following process. There are
> two location (point 5 & point 8) and pop up error and
> failure to upgrade finally. Can anyone help me to
> verify what is the problem here and giving me a
> solution or hints. Very thanks
>
> 1. Copy all. aod files form verson 2.5 application
> folder to the old folder in 3.0 application.com
>
> 2. Copy all .aod containing modifications (e.g
> ax.usr.aod) form version 2.5 applicaion folder to 3.0
> applcaion folder.
>
> 3. copy all client specific labels form version2.5
> applicaion to 3.0 applicaion.
>
> 4. Run database synchronization and reindex.
>
> 5. Compile the whole applicaion with with a infolog
> pop up, a content example below:
>
> Unable to save : Version of Group BOMLine on th server
> is newer
> Unable to save : Version of Group BOM on the server is
> newer
> Unable to save : Version of Group Administration on
> the server is newer
> .etc
>
> 6 No any compile error after poin 5, so I use our 2.5
> database to start "Upgrade check list funcion"
>
> 7. All processing run smoothly except synchronize
> database
>
> 8. After database synchronization , many error appear.
> we have found that there are 3 type of errors
> 
> Error Code: 207
>
> Information:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
> column name 'PARENTID'.
>
> statment:
> CREATE VIEW PROJDATAVIEW AS SELECT A.NAME AS
> NAME,A.PROJID AS PROJID,
> A.PROJGROUPID AS PROJGROUPID,A.PARENTID AS
> FATHERID,A.CUSTACCOUNT
> AS CUSTACCOUNT,A.DATAAREAID AS DATAAREAID,A.RECID AS
> RECID FROM PROJTABLE A
>
> --
> Error Code: 8152
>
> Information:
> [Microsoft][ODBC SQL Server Driver][SQL Server]String
> or binary data would be truncated.
>
> Statment:
> INSERT INTO X26X SELECT BOMID,{fn SUBSTRING
> NAME,1,30)},ITEMGROUPID,
> CHECKBOM,APPROVEDBY,APPROVED,MODIFIEDDATE,MODIFIEDTIME,
> MODIFIEDBY,DATAAREAID,RECID FROM BOMTABLE
> -
> Error Code:
> 1505
>
> Information:
> [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
> UNIQUE INDEX terminated
> because a duplicate key was found for index ID 2.
> Most significant primary key is 'el'.
>
> Statment:
> CREATE UNIQUE  INDEX I_155LINEIDX ON
> INVENTJOURNALTRANS (DATAAREAID,JOURNALID,LINENUM)
> ---
>
>
>
>
>
>
>
>
>
> 
> Yahoo! Sports
> Rekindle the Rivalries. Sign up for Fantasy Football
> http://football.fantasysports.yahoo.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
> 












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.

RE: [development-axapta] Syntax of table browser ?

2005-06-22 Thread Koen Govaers 




X++ Coding

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of icham_2000
Sent: woensdag 22 juni 2005 14:02
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Syntax of table browser ?

Hi All,

Which syntax is used for coding in the table browser, Is it X++ Coding 
or SQL Syntax ?

Thank you

Best regards







 
Yahoo! Groups Links



 













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.

RE: [development-axapta] Syntax of table browser ?

2005-06-22 Thread Koen Govaers 




Take tablebrowser of custtable modify sql syntax like follows press
refresh data

Salestable salestable;
;

SELECT * FROM CustTable join salestable where salestable.custaccount ==
Custtable.Accountnum


Cheers

koen
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of icham_2000
Sent: woensdag 22 juni 2005 14:02
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Syntax of table browser ?

Hi All,

Which syntax is used for coding in the table browser, Is it X++ Coding 
or SQL Syntax ?

Thank you

Best regards







 
Yahoo! Groups Links



 













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.

[development-axapta] Lookup ConfigId in Query

2005-06-22 Thread hwimmer 




Hi
We are using config id's a lot for items. In standard forms, MBS 
programmed something so that e.g. in the SalesTable form, after you've 
entered the item id, you'll only get the config's of that item.

In queries, however, this does not work. Go to any report that prints 
out item data and where you can add ConfigId as range.
When you click on the lookup for the config id, you will get *all* 
configs in the system and you cannot even search for an item.

Did anybody already make that:
a) make it possible to search for items in the config id lookup 
(called from a query)
b) only display configs of items entered in the query

Cheerio,
Helmut













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.

RE: [development-axapta] Syntax of table browser ?

2005-06-22 Thread Matt Benic 




X++, though there are a number of limitations, for example the inability to
include multiple tables in a query..

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 icham_2000
Sent: 22 June 2005 02:02 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Syntax of table browser ?


Hi All,

Which syntax is used for coding in the table browser, Is it X++ Coding
or SQL Syntax ?

Thank you

Best regards








Yahoo! Groups Links



















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.

[development-axapta] Upgrade error

2005-06-22 Thread Luk Gary 




Dear All

I am doing upgrade process process from Ax2.5 sp3 to
Ax3.0 sp3. I have do the following process. There are
two location (point 5 & point 8) and pop up error and
failure to upgrade finally. Can anyone help me to
verify what is the problem here and giving me a
solution or hints. Very thanks

1. Copy all. aod files form verson 2.5 application
folder to the old folder in 3.0 application.com

2. Copy all .aod containing modifications (e.g
ax.usr.aod) form version 2.5 applicaion folder to 3.0
applcaion folder. 

3. copy all client specific labels form version2.5
applicaion to 3.0 applicaion.

4. Run database synchronization and reindex. 

5. Compile the whole applicaion with with a infolog
pop up, a content example below:

Unable to save : Version of Group BOMLine on th server
is newer 
Unable to save : Version of Group BOM on the server is
newer 
Unable to save : Version of Group Administration on
the server is newer
.etc

6 No any compile error after poin 5, so I use our 2.5
database to start "Upgrade check list funcion"

7. All processing run smoothly except synchronize
database

8. After database synchronization , many error appear.
we have found that there are 3 type of errors

Error Code: 207

Information:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'PARENTID'.

statment:
CREATE VIEW PROJDATAVIEW AS SELECT A.NAME AS
NAME,A.PROJID AS PROJID,
A.PROJGROUPID AS PROJGROUPID,A.PARENTID AS
FATHERID,A.CUSTACCOUNT 
AS CUSTACCOUNT,A.DATAAREAID AS DATAAREAID,A.RECID AS
RECID FROM PROJTABLE A

--
Error Code: 8152

Information:
[Microsoft][ODBC SQL Server Driver][SQL Server]String
or binary data would be truncated.

Statment:
INSERT INTO X26X SELECT BOMID,{fn SUBSTRING
NAME,1,30)},ITEMGROUPID,
CHECKBOM,APPROVEDBY,APPROVED,MODIFIEDDATE,MODIFIEDTIME,
MODIFIEDBY,DATAAREAID,RECID FROM BOMTABLE
-
Error Code:
1505

Information:
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE
UNIQUE INDEX terminated
 because a duplicate key was found for index ID 2.
Most significant primary key is 'el'.

Statment:
CREATE UNIQUE  INDEX I_155LINEIDX ON
INVENTJOURNALTRANS (DATAAREAID,JOURNALID,LINENUM) 
---
 







    
 
Yahoo! Sports 
Rekindle the Rivalries. Sign up for Fantasy Football 
http://football.fantasysports.yahoo.com











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.

[development-axapta] Syntax of table browser ?

2005-06-22 Thread icham_2000 




Hi All,

Which syntax is used for coding in the table browser, Is it X++ Coding 
or SQL Syntax ?

Thank you

Best regards














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.

[development-axapta] syssearchName table

2005-06-22 Thread Tomasz Dudek 
Hello All!

I currently moving data from one MSSQL database to another and I have a
problem with sysSearchName table.
What is job of this table?
There are above 100 000 records in sysSearchName table. Can I leave table in
destination database empty?

Tomasz Dudek






 
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] Re: SQL Syntax in Axapta Table browser

2005-06-22 Thread Koh Meng Chiat 




Hi all,

Really appreciate your helps.  IT WORKS!!! :)  






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

> Hi,
> 
> You could put only X++ coding in the table browser
> and not SQL Syntax
> 
> Regards
> 
> --- In development-axapta@yahoogroups.com, Koh Meng
> Chiat 
> <[EMAIL PROTECTED]> wrote:
> > Hello all,
> > 
> > The SQL statement i wrote to filter out the
> records
> > doesn't work in table browser.  Could anyone shed
> some
> > lights on it??
> > 
> > SELECT * FROM InventTransPosting where 
> > InventTransPosting.Transdate >="4/30/2005"  and
> > InvenTransPosting.Transdate <="5/31/2005";
> > 
> > Thanks in advance.
> > 
> > Best Regards,
> > 
> > Jack 
> > 
> > __
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> > http://mail.yahoo.com
> 
> 
> 
> 
> 


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











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.

Re: [development-axapta] Re: SQL Syntax in Axapta Table browser

2005-06-22 Thread Koh Meng Chiat 




Hi Anil,

May i know what is mkdate (dd,mm,) used for??

Best Regars,

Jack Koh 

--- Anil Ozay <[EMAIL PROTECTED]> wrote:

> Hi Jack,
> 
> Use this statement :
> 
> SELECT InventTransPosting where
> InventTransPosting.TransDate >= mkdate(30,04,2005) 
> &&
> InventTransPosting.TransDate <= mkdate(31,05,2005)
> 
> Best Regards,
> 
> Anýl Özay
> 
> --- In development-axapta@yahoogroups.com, Koh Meng
> Chiat 
> <[EMAIL PROTECTED]> wrote:
> > Hello all,
> > 
> > The SQL statement i wrote to filter out the
> records
> > doesn't work in table browser.  Could anyone shed
> some
> > lights on it??
> > 
> > SELECT * FROM InventTransPosting where 
> > InventTransPosting.Transdate >="4/30/2005"  and
> > InvenTransPosting.Transdate <="5/31/2005";
> > 
> > Thanks in advance.
> > 
> > Best Regards,
> > 
> > Jack 
> > 
> > __
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> > http://mail.yahoo.com
> 
> 
> 
> 
> 
> 


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











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.

SV: [development-axapta] Creating a RunBaseBatch Class

2005-06-22 Thread Thomas Jensen 




Hi Brandon

Take a look at the tutorial_runbasebatch class.

Regards
Thomas

-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Brandon George
Sendt: 21. juni 2005 14:28
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Creating a RunBaseBatch Class

Hello All!

Can anyone please give me an example of a Batch Job class, which I believe
is called a RunBaseBatch, and extends from that class.

I have a few Batch Operations I need to create, and I was wondering if there
was any examples anywhere that could tell me best practices, example
how-to's, etc.

If anyone has every created one and can give me a few pointers I would
appreciate it!

Thanks,
Brandon





 
Yahoo! Groups Links



 













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.

RE: [development-axapta] Creating a RunBaseBatch Class

2005-06-22 Thread Steen Rabøl 




Try one on the tutorial* samples in the AOT

 

  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Brandon George
Sent: 21. juni 2005 15:28
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Creating a RunBaseBatch Class

 

Hello All!

Can anyone please give me an example of a Batch Job class, which I believe
is called a RunBaseBatch, and extends from that class.

I have a few Batch Operations I need to create, and I was wondering if there
was any examples anywhere that could tell me best practices, example
how-to's, etc.

If anyone has every created one and can give me a few pointers I would
appreciate it!

Thanks,
Brandon






  _  

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. 



[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 the Yahoo! Terms of Service.

[development-axapta] Add Icon to Toolbar

2005-06-22 Thread kamchung322 




Hi All, 

Is it possible to add icon to toolbar ? 

Regards.

Kenneth. 













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.

RE: [development-axapta] Creating a RunBaseBatch Class

2005-06-22 Thread ANIL OZAY 




Hi Brandon,

You can find a tutorial on :

Classes/Tutorial_RunBaseBatch

Or

Classes/LedgerRecalcPeriod

I hope this help you..

Best Regards,

Anil Ozay

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Brandon George
Sent: Tuesday, June 21, 2005 3:28 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Creating a RunBaseBatch Class

Hello All!

Can anyone please give me an example of a Batch Job class, which I believe
is called a RunBaseBatch, and extends from that class.

I have a few Batch Operations I need to create, and I was wondering if
there
was any examples anywhere that could tell me best practices, example
how-to's, etc.

If anyone has every created one and can give me a few pointers I would
appreciate it!

Thanks,
Brandon





 
Yahoo! Groups Links



 













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.

RE: [development-axapta] Creating a RunBaseBatch Class

2005-06-22 Thread Lennart Conrad 




Hi Brandon
 
Here are some places to start:
 
The RunbaseBatch tutorial: \Classes\Tutorial_RunbaseBatch
MSDN:
http://msdn.microsoft.com/library/default.asp?url="">
SCON/AOS-best_practices/SCON_Use_of_RunBase.asp
 
You can also look at the class documentation of the RunBaseBatch class
 
Best regards,

Lennart Conrad
Microsoft Business Solutions
This posting is provided "AS IS" with no warranties, and confers no
rights.


From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Brandon George
Sent: 21. juni 2005 14:28
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Creating a RunBaseBatch Class
 
Hello All!

Can anyone please give me an example of a Batch Job class, which I
believe
is called a RunBaseBatch, and extends from that class.

I have a few Batch Operations I need to create, and I was wondering if
there
was any examples anywhere that could tell me best practices, example
how-to's, etc.

If anyone has every created one and can give me a few pointers I would
appreciate it!

Thanks,
Brandon







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]

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

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.

[development-axapta] Product Builder Problem

2005-06-22 Thread axapta developer 




Hi Everyone,
 
I'm experiencing a problem with the Product Builder:
 
When configuring an item using PB, either from a sales line or the "test model" function within the PB itself, once the mandatory values have been entered and the user clicks "OK," Axapta crushes.
 
Does anyone have a suggestion on what might be causing this, and what a possible solution might be?
 
Thanks for your help!

    
-
Yahoo! Sports
 Rekindle the Rivalries. Sign up for Fantasy Football

[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 the Yahoo! Terms of Service.

Re: [development-axapta] Re: Importing Axapta enterprise data from an Oracle DB to a SQL DB

2005-06-22 Thread Alejandro Ibarra 




Hi Mikael, here is my email address:
[EMAIL PROTECTED]

Thank's

 --- Mikael Sorensen <[EMAIL PROTECTED]>
escribió:

> Leave a valid e-mail address, and I'll send it to
> you.
> 
> //Mikael
> 
> --- In development-axapta@yahoogroups.com, Alejandro
> Ibarra 
> <[EMAIL PROTECTED]> wrote:
> > Hi Mikael, i think that your whitepaper could help
> a
> > lot, can you pass me the document to check it out.
> > 
> > thank's
> >  --- Mikael Sorensen <[EMAIL PROTECTED]>
> > escribió:
> > 
> > > If you need to migrate the entire database from
> > > Oracle to MS SQL, I 
> > > have a whitepaper, explaining how to do it.
> > > 
> > > //Mikael
> > > 
> > > --- In development-axapta@yahoogroups.com,
> Alejandro
> > > Ibarra 
> > > <[EMAIL PROTECTED]> wrote:
> > > > Hi, i'm having problems importing an Axapta
> > > enterprise
> > > > data from Oracle to SQL, when i import de data
> in
> > > the
> > > > Axapta with the SQL DB it's take a long time
> an
> > > never
> > > > end. If someone know a better way to do this
> tell
> > > me
> > > > please.
> > > > 
> > > > Alex!
> > > > 
> > > >
> __
> > > > Correo Yahoo!
> > > > Espacio para todos tus mensajes, antivirus y
> > > antispam ¡gratis! 
> > > > Regístrate ya -
> http://correo.espanol.yahoo.com/
> > > 
> > > 
> > > 
> > > 
> > > 
> > 
> > 
> > __
> > Correo Yahoo!
> > Espacio para todos tus mensajes, antivirus y
> antispam ¡gratis! 
> > Regístrate ya - http://correo.espanol.yahoo.com/
> 
> 
> 
> 
> 


__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 











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.