Microsoft Dynamics Support

server · Guest

message unavailable

john · Guest

thank you for your time, i received help last night but i did not rate the
person who did help me..

i have over 400 rows of different products and 5-8 different collums of
suppliers.
iwould like to be able to enter the prices of each supplier and for excell
to highlight the cheapest price automaticaly.

the person who answered last night was a great help with the formula of
=A1=MIN($A$1:$A$5)
and then format the font and cell color......
but how can i move that conditional format down all 400 rows with out having
to do each row at a time? thank you for your time!! john

Søren Rasmussen · Guest

Did you let the Dynamics AX setup create the database? That does the security
setup of the database for you.

..søren

"Ralph" wrote:

Søren Rasmussen · Guest

Now I get the message below when trying to start the AOS-service afterwards.
It generates the index files without problems.

The error message in the eventlog is as follows:
"Object Server 03: Dialog issued for client-less session 1: While
synchronizing table 'SQLDICTIONARY', the layout of the table in the
SQL database appeared to be incompatible with the Microsoft Dynamics data
dictionary.
The name of the table in the database is 'SQLDICTIONARY'. This mismatch can be
caused by importing table definitions from an XPO file during test or
development,
or even by copying and overwriting the entire AOD file.

If you choose to, Microsoft Dynamics can drop the mismatching table to allow
the creation
of the 'SQLDICTIONARY' table, as it should appear according to the Microsoft
Dynamics data dictionary.

Contents of the 'SQLDICTIONARY' are: The table contains records.

Do you want to drop the table and continue?"

So I tried deleting the table SQLDictionary. Then I got an error on the
following tables which I all deleted: SQLStorage, SystemSequences,
SysRecordLevelSecurity and SysEncryptionKey. I know it's not quite best
practice but I had to do something. After doing this I'm now stuck on

"Object Server 03: Dialog issued for client-less session 1: [Microsoft][ODBC
SQL Server Driver][SQL Server]There is already an object named 'I_65497RECID'
in
the database. [ALTER TABLE SYSENCRYPTIONKEY ADD CONSTRAINT I_65497RECID
PRIMARY KEY CLUSTERED (RECID) ] "

Help......!

"Bill Thompson" wrote:

Roger Lindkvist · Guest

Duplicate function normally works very well. Do not use DAT company because
this company is used to keep company independent data for all companies.
Another problem source could be if you are using shared tables in virtual
companies. Then the duplicate function can run into problems. There was also
a data problem with mixed up company id's (dataarea) between the copied and
original company but that problem has been solved in later versions.

Another issue with duplicate function is that it copies all registers not
only parameter and master data registers but also transaction register. So it
is good for test transactions and problem solving.
--
Roger Lindkvist

"Stan F Vaninger" wrote:

Brian · Guest

Stan,
I am wondering if you had been able to get the answer you're looking for.
We are also trying to establish a test company with only setup data. We
plan to use this in the manner that you have detailed below. Testing,
training, etc.... If you have any information that would be beneficial I
would appreciate knowing how to proceed.

Thank you,
Brian

"Stan F Vaninger" wrote:

Trevor · Guest

Additional Information:

MBS informed us that the problem is more likely to occur when both AOS and
SQL Server are installed on the same machine ( this is not recommended)

Also apparently even though the SQL server is online the DB comes online
according to the order it was created…

One alternative solution is to add dependency on Dynamics Server$01-Company1
service for MSSQLSERVER for the service to consistently start automatically.
However even if it been setup as automatic and the AOS service is failing to
report the ‘failure’ to the Service Control Manager.

Another is by creating a batch file containing:
sleep 60 (you may use a utility to sleep 60 seconds)
net start "Dynamics Server$01-Company1" (starting the service via AutoRun)

under registry
key HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run

As far as I am aware this is a future improvement\fix.

"Trevor" wrote:

Atamjeet · Guest

Thanks Mike,

Your help was really great.

Regards
Atamjeet Singh Bhatia

"Mike Frank" wrote:

Penguin · Guest

In this case, I think that you can use sp_exec system stored procedure to run
an string (e.g

create procedure sp_selectcard
@cardno numeric,@trans numeric
as
exec 'select top '+ convert(string, @trans) +' custid,card_number from
detail_prepaidcard where card_number=@cardno'
....
)
I hope that sample can help u.
Penguin

"Abdul Basith" wrote:

Ram · Guest

Hi Jacob, I am facing this same issue. I will appreciate if you can provide
me the details how you corrected this issue. Thanks.

Ram

"jacobn" wrote:

Joseph Patenaude · Guest

Hello Ralph

The In the Microsoft Dynamics AX Overview / Implementation Guide, Microsoft
best practices suggests using a domain user in the “Log On” for the AX
service. The domain account, on the computer this is running the AOS, should
be at least a member of the “Power Users” local group. It also needs to be
given the db_reader, db_writer and db_ddladmin roles on the Dynamics AX
database. It also has to be added to the “Users” list inside an AX client.

You can also remove the interactive rights of the user inside Group Policy
manager.

Please post here if you need more details

"Ralph" wrote:

Joseph Patenaude · Guest

I forgot a detail in the Dynamics Database in SQL. The Domain User must also
have the execute rights on the createserversessions and createusersessions
stored procedures.

"Joseph Patenaude" wrote:

Thomas Jensen · Guest

Hi Fred,

AxOldToNewRecIds is not an official AX table but created on the fly when
running the SysRecIdRepair class in AX 3.0. So before using AXDBUpgrade simply
drop the table from the database.

Regards
Thomas

Dave Jones · Guest

There is an add-on tool from Ignify that supports Data Archival for Dynamics AX
http://www.ignify.com/DynamicsAXData.asp

Thanks
Dave

"Support" wrote:

Dave Jones · Guest

Standard Axapta doesn't support this but the Ignify tool supports Axapta Data
archival
http://www.ignify.com/DynamicsAXData.asp
Thanks
Dave

"frankie" wrote: