The following errors was occured when I install CRM 4.0 over existing CRM 3.0:
1)
12:57:23| Error| remark: deleted column in primary key
12:57:23| Error| tablename: userfiscalcalendarbase
12:57:23| Error| columnname: userfiscalcalendarid
12:57:23| Error|
12:57:23| Error| The primary keys in the Microsoft Dynamics CRM database
are not consistent with Microsoft Dynamics CRM 3.0 primary keys.

2)
12:57:35| Error| remark: deleted default constraint on column
12:57:35| Error| tablename: userfiscalcalendarbase
12:57:35| Error| columnname: period9
12:57:35| Error|
12:57:35| Error| The default value constraints in the Microsoft Dynamics
CRM database are not consistent with Microsoft Dynamics CRM 3.0 default value
constraints.

"userfiscalcalendarbase" table is an empty table in my CRM Database.
Only related solution that I found in Microsoft website is:
http://support.microsoft.com/kb/919641/ . this solution didnot resolve my
problem.
--
Mohsen Ahmadi,
msnahm@hotmail.com
IR-0912 *** ****

start from the basic , restore the CRM 3.0 . I dont know what sort of
setup you have , so you need to check the logfile when you repair /re-
install the CRM 3.0 for any possible error.

Have you ever deleted modified any thing inside CRM databse? if
possible compare the userfiscalcalendarbase" table with a Test
installation of CRM 3.0 (like primay key , constraints ) side by
side .

/Aamir

I had a new Installation of CRM 3.0 and then upgraded it to crm 4.0. Actually
I tried to start a new Installation of crm 4.0 but on one of the installation
wizard step (Setup Requirement) it reported 3 warning and 2 errors and then
stop continuing the procedure.
Also what I said in my previous post I got it from the installation Log
file(CRM40svrsetup.log).

--
Mohsen Ahmadi,
msnahm@hotmail.com
IR-0912 *** ****


"Aamir Bashir" wrote:

If you have no data in CRM 3.0 then its best you should start with CRM
4.0 instead of going from the trouble of trouble shooting CRM 3.0 ? or
its too late?

/Aamir

I use crm 3.0 for 2 years and I have data in CRM 3.0 database. I said in
previous post that only "userfiscalcalendarbase" table is empty table.
--
Mohsen Ahmadi,
msnahm@hotmail.com
IR-0912 *** ****


"Aamir Bashir" wrote:

The best thing is to troubleshoot CRM 3.0 before upgrading to CRM 4.0.
When you repair then you will find the error .
If you have installed CRM 3.0 on Test system then compare the
"UserFiscalCalendarBase" table including columns and constraints .You
need to check if default constar constraint meet the constraint of
your "userfiscalcalendarbase" table.

/Aamir