Problem running Dynamics AX DB Upgrade Preparation

Hi.

I have a problem running the database upgrade tool for Dynamics AX.

I have sucessfully (I think) completed the upgrade projects for AX 3.0 and have copied the DB to the machine running Dynamics AX.

When running AxDbUpgrade.exe it display the following error:
===============
Copying tables with 1 thread(s).

ACCESSRIGHTSLIST create OK
ACCESSRIGHTSLIST bcp OK
, overwriting import format OKACCESSRIGHTSLIST bulk insert OK, Wed Mar 19 11:19:09 2008

ADDRESS create OK
ADDRESS bcp OK
, overwriting import format OKError while execution the following sql:BULK INSERT [Dynamics2].dbo.[ADDRESS] FROM 'C:...AxaptaTempFolderADDRESS' WITH (FORMATFILE = 'C:...AxaptaTempFolderADDRESS.fmt', ROWTERMINATOR='', FIELDTERMINATOR = '', BATCHSIZE = 10000, KEEPNULLS, TABLOCK, DATAFILETYPE = 'widenative')
retcode -1

ADDRESS bulk insert FAILED, Wed Mar 19 11:19:09 2008

Additional debugging information may be found in C:...AxaptaTempFolderADDRESS. This file may contain confidential information, please ensure that you delete the file and the containing directory.
Errors occurred in table copy. Fix error conditions and restart to complete Pre-Upgrade.
==========

I am unable to get anything intelligable from the file in the temp folder, maybe I'm not using the right program to read it.

Has anyone suggestions on how to proceed from here?

---------------------------------
Låna pengar utan säkerhet.
Sök och jämför hos Yahoo! Shopping.

[Non-text portions of this message have been removed]

Messages in this topic (1) Reply (via web post) | Start a new topic

.

> When running AxDbUpgrade.exe it display the following error:
> ===============
> Copying tables with 1 thread(s).

Vanessa, when I got similar errors, I ran the SQL statement through
SQL Server Management Studio and got a much more informative error. It
should be tremendously more useful than the one you got.

I have had similar errors when I a) tried to upgrade FRx tables, and
b) used a mapped drive.

Good luck
J

Messages in this topic (2) Reply (via web post) | Start a new topic

.

I got a similar error - it appears that the db upgrade tool only functions
probably on a std. version or higher of the SQL-server.
When I received that error, I was trying to run the db upgrade tool on a
developer ed. of SQL-server.

You can identify your SQL version by following these steps:
http://support.microsoft.com/kb/321185

Hope it helps,

Steffen

2008/3/19, J < jblake%40unitederp.com">jblakeunitederp.com>:
>
&gt; > When running AxDbUpgrade.exe it display the following error:
&gt; > ===============
&gt; > Copying tables with 1 thread(s).
>
&gt; Vanessa, when I got similar errors, I ran the SQL statement through
> SQL Server Management Studio and got a much more informative error. It
> should be tremendously more useful than the one you got.
>;
> I have had similar errors when I a) tried to upgrade FRx tables, and
> b) used a mapped drive.
&gt;
> Good luck
>; J
>
>
>

--
Firefox http://getfirefox.com
OpenOffice http://openoffice.org
openSUSE http://www.opensuse.org

[Non-text portions of this message have been removed]

Messages in this topic (3) Reply (via web post) | Start a new topic

.