Community
Showing results for 
Search instead for 
Do you mean 
Reply

Update Act

New Member
Posts: 18
Country: Mexico

Update Act

Hi every body

 

I have the next trouble. when I want to convert mi database from act  2008 (10.0.3.182, Hot fix 1) to Act 2012 premium 

act showme the next message 

 

" Exeception ocurred while executingthe database Schema Update Script Contact your Administrator for assistence"

 

 

aditional showme una link to view the schema error text file whit the next report 

 

 

Please Help me to resolve

 

Changed database context to 'ActTest2012'.Setting Database Compatibility Level...
Local Datetime: 2012-09-20 10:48:10
Servername: ADOLFO-PC\ACT7
Engine Edition: 4 Express Edition
Product Version: 10.50.1600.1 (RTM)
Server Collation: Latin1_General_CI_AS
------------------------------------------------------------------------------
Sync Enabled: False
Sync Role:
------------------------------------------------------------------------------
Database: ActTest2012
Status: ONLINE
Create Version: 661
Configuration option 'user instances enabled' changed from 0 to 0. Run the RECONFIGURE statement to install.-------------------------------------------------------------
Current Build: 14.1.97.0
Update Build: 14.1.97.0
-------------------------------------------------------------DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Dropping indexes and constraints starting... 2012-09-20 10:48:12
Disabling change tracking
Dropping triggers, starting ... 2012-09-20 10:48:48
Dropping Tables, starting... 2012-09-20 10:49:01
Creating Tables, starting... 2012-09-20 10:49:01
Adding calculated fields, starting... 2012-09-20 10:49:04
Altering table TBL_OPPORTUNITY (DAYSOPEN)Altering table TBL_PRODUCTSERVICE (DISCOUNTTYPE)
Table modifications - Adds, Deletes, etc. 2012-09-20 10:49:05Altering table TBL_CONTACT_CONTACTModifying obsolete datatypes
Object removals - procedures, views, etc.
Setting Ctl_Abl_Connectortype Data...2012-09-20 10:49:09
Setting Ctl_Localstring Data...2012-09-20 10:49:10
Setting Syncsettype Data...2012-09-20 10:49:10
Setting Activity Priority Data...2012-09-20 10:49:10
Setting Eventlog Type Data...2012-09-20 10:49:10
Setting Folder Data...2012-09-20 10:49:10
Setting Preference Data...2012-09-20 10:49:10
Setting Role Data...2012-09-20 10:49:10
Setting SyncDbtype Data...2012-09-20 10:49:10
Setting Sysconstant Data...2012-09-20 10:49:10
Setting Sysdomain Data...2012-09-20 10:49:10
Setting Sysdatatypes...2012-09-20 10:49:10
Setting Featureset Data...2012-09-20 10:49:10
Setting Sysentity Data...2012-09-20 10:49:10
Setting Tbl_Syslocalcolumn Data...2012-09-20 10:49:11
Setting Sysoperator Data...2012-09-20 10:49:11
Setting Sysdomain Sysoperator Data...2012-09-20 10:49:11
Setting SystableDomain Data at 2012-09-20 10:49:11.160
Setting Sysvalue Data...2012-09-20 10:49:11
Setting Sysvalue Usage Data...2012-09-20 10:49:11
Setting Permission data at 2012-09-20 10:49:11
Setting Permission Depend Data...2012-09-20 10:49:11
Setting Historytype_Supergroup Data...2012-09-20 10:49:11
Setting Historytype_group Data...2012-09-20 10:49:11
Setting Historytype data...2012-09-20 10:49:11Creating views
Creating functions and viewsCreating View VWX_USERCreating View VWX_TEAMCreating View VWX_RESOURCECreating View VWX_ACCESSORCreating View VWX_CONTACT_USER_ENUMCreating View VWX_GROUP_USER_ENUMCreating View VWX_COMPANY_USER_ENUMCreating View VWX_OPPORTUNITY_USER_ENUMCreating View VWX_WORKFLOWDEF_USER_ENUMCreating View VWX_PERMISSIONINFOCreating View VWX_ROLEINFOCreating View VWX_ROLE_PERMISSION_MATRIXCreating View VWX_USERPERMISSIONCreating view VWT_OPPORTUNITY_STAGE_PROCESSCreating view VWT_WORKFLOW_ARCHIVECreating view VWT_WORKFLOWDEF_ACCESSCreating view VWT_OPPORTUNITY_ACCESSCreating view VWT_COMPANY_ACCESSCreating view VWT_GROUP_ACCESSCreating View VWT_CONTACT_ACCESSCreating view VWT_SECONDARY_CONTACTCreating view VWT_COMPANY_BUSINESSLINKCreating view VWT_CONTACT_BUSINESSLINK Running DBRights...
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
*** Setting rights on procedures...


Adding Constraints at 2012-09-20 10:49:16
ADDING CTL_ABL_FIELD_IS_READONLY_DEF
ADDING CTL_ABL_FIELD_BUSINESS_STATIC_MAP_DEF
ADDING CTL_DBCONFIG_ISCOPIED_DEF
ADDING CTL_EVENTLOG_EVENTDATE_DEF
ADDING CTL_EVENTLOG_SQLUSER_DEF
ADDING CTL_EVENTLOGDETAIL_DETAILDATE_DEF
ADDING CTL_OLEDBVIEW_OLEDBFUNCTION_ISPRIMARYFUNCTION_DEF
ADDING CTL_SQLTRACE_STMTTIME_DEF
ADDING CTL_SQLTRACE_SPID_DEF
ADDING CTL_SYNCDBMAPINFO_ISREPLAY_DEF
ADDING CTL_SYNCDBMAPINFO_NEXT_ADDSYNCROWID_DEF
ADDING CTL_SYNCDBMAPINFO_NEXT_DELSYNCROWID_DEF
ADDING CTL_SYNCDBMAPINFO_NEXT_UPDSENDDATE_DEF
ADDING CTL_SYNCDBMAPINFO_HISTORY_ISREPLAY_DEF
ADDING CTL_SYNCROW_UPDATECOLUMN_APPLYDATE_DEF
ADDING CTL_USERSESSION_PING_TIME_DEF
ADDING TBL_ACCESSOR_ACTIVITY_STATUSNUM_DEF
ADDING TBL_ACCESSOR_DELEGATE_ROWSOURCE_DEF
ADDING TBL_ACTIVITY_SOURCENUM_DEF
ADDING TBL_ACTIVITY_ISEVENT_DEF
ADDING TBL_ACTIVITY_ISDELETED_DEF
ADDING TBL_ACTIVITY_TZ_BIAS_DEF
ADDING TBL_ACTIVITY_TZ_DAYLIGHT_BIAS_DEF
ADDING TBL_ACTIVITY_TZ_STANDARD_BIAS_DEF
ADDING TBL_ACTIVITY_TZ_DAYLIGHT_MONTH_DEF
ADDING TBL_ACTIVITY_TZ_DAYLIGHT_DOW_DEF
ADDING TBL_ACTIVITY_TZ_DAYLIGHT_DAY_DEF
ADDING TBL_ACTIVITY_TZ_DAYLIGHT_HOUR_DEF
ADDING TBL_ACTIVITY_TZ_DAYLIGHT_MINUTE_DEF
ADDING TBL_ACTIVITY_TZ_STANDARD_MONTH_DEF
ADDING TBL_ACTIVITY_TZ_STANDARD_DOW_DEF
ADDING TBL_ACTIVITY_TZ_STANDARD_DAY_DEF
ADDING TBL_ACTIVITY_TZ_STANDARD_HOUR_DEF
ADDING TBL_ACTIVITY_TZ_STANDARD_MINUTE_DEF
ADDING TBL_ACTIVITY_ISINVITATIONSENT_DEF
ADDING TBL_ACTIVITYSERIESITEM_ANCHOROFFSETPERIOD_DEF
ADDING TBL_COMPANY_ISPRIVATE_DEF
ADDING TBL_COMPANY_HASSUBCOMPANY_DEF
ADDING TBL_COMPANY_ACL_ROWSOURCE_DEF
ADDING TBL_COMPANY_CONTACT_ROWSOURCE_DEF
ADDING TBL_COMPANY_OPPORTUNITY_ISMEMBER_DEF
ADDING TBL_COMPANYCONTACT_MAP_ISMANDATORY_DEF
ADDING TBL_CONTACT_ACL_ROWSOURCE_DEF
ADDING TBL_FEATURESET_ISCUSTOM_DEF
ADDING TBL_GROUP_HASSUBGROUP_DEF
ADDING TBL_GROUP_ACL_ROWSOURCE_DEF
ADDING TBL_GROUP_OPPORTUNITY_ISMEMBER_DEF
ADDING TBL_OPPORTUNITY_GROSSMARGINAMT_DEF
ADDING TBL_OPPORTUNITY_WEIGHTEDAMT_DEF
ADDING TBL_OPPORTUNITY_ACL_ROWSOURCE_DEF
ADDING TBL_PERMISSION_TYPENUM_DEF
ADDING TBL_PHONE_COUNTRYCODE_DEF
ADDING TBL_PHONEMASK_ISACTIVE_DEF
ADDING TBL_PICKLIST_ISCUSTOM_DEF
ADDING TBL_PICKLIST_SYSCOLUMN_ISTYPEAHEAD_DEF
ADDING TBL_PRODUCTSERVICE_DISCOUNTTYPENUM_DEF
ADDING TBL_SERIALNUMBER_CREATEDATE_DEF
ADDING TBL_SERIALNUMBER_CREATEUSERID_DEF
ADDING TBL_SYNCDB_ISEXPIRED_DEF
ADDING TBL_SYNCDB_EXPIREACTION_DEF
ADDING TBL_SYNCDB_CONFLICTRULE1_DEF
ADDING TBL_SYNCDB_EXPIREDAYS_DEF
ADDING TBL_SYNCDB_CONFLICTRULE2_DEF
ADDING TBL_SYNCDB_ISINCLUDEATTACH_DEF
ADDING TBL_SYNCSET_TYPENUM_DEF
ADDING TBL_SYNCSET_ISALLUSERSYNC_DEF
ADDING TBL_SYSCOLUMN_SYNCTYPENUM_DEF
ADDING TBL_SYSCOLUMN_ISRESIZEABLE_DEF
ADDING TBL_SYSCOLUMN_ALLOWDATATYPECHANGE_DEF
ADDING TBL_SYSCOLUMN_VALIDACCESSLEVELS_DEF
ADDING TBL_SYSCOLUMN_OLEDBTYPENUM_DEF
ADDING TBL_SYSENTITY_ISDISPLAYED_DEF
ADDING TBL_SYSENTITY_ISDEFINEFIELD_DEF
ADDING TBL_SYSENTITY_ISCUSTOM_DEF
ADDING TBL_SYSENTITY_TYPENUM_DEF
ADDING TBL_SYSENTITYRELATION_ISCUSTOM_DEF
ADDING TBL_SYSENTITYRELATION_ROLETYPENUM_DEF
ADDING TBL_SYSENTITYRELATION_HASCREATEEDIT_DEF
ADDING TBL_SYSENTITYRELATION_HASDETAILS_DEF
ADDING TBL_SYSTABLE_HASPHONEVIRTUALS_DEF
ADDING TBL_SYSTABLE_HASEMAILVIRTUALS_DEF
ADDING TBL_SYSTABLE_HASADDRESSVIRTUALS_DEF
ADDING TBL_SYSTABLERELATION_RELATIONID_DEF
ADDING TBL_TEAM_USER_ROWSOURCE_DEF
ADDING TBL_USER_ISPWDNEVEREXPIRE_DEF
ADDING TBL_USER_ISPWDCASESENSITIVE_DEF
ADDING TBL_USER_ISVERIFIED_DEF
ADDING TBL_USER_UTC_OFFSET_DEF
ADDING TBL_USER_ISFORCEPWDCHG_DEF
ADDING TBL_USER_ISALLOWPWDCHG_DEF
ADDING TBL_USER_DEFAULT_ACL_ENTITYID_DEF
ADDING TBL_WORKFLOW_QUERY_ISUNLOCKED_DEF
ADDING TBL_WORKFLOW_ACL_ROWSOURCE_DEF
ADDING CTL_EVENTLOGDETAIL_STATUSNUM_CHK
ADDING CTL_SYNCDBMAP_SESSIONROW_STATUSNUM_CHK
ADDING CTL_SYNCROW_FILE_ACTIONCODE_CHK
ADDING TBL_ACCESSOR_TYPENUM_CHK
ADDING TBL_ACCESSOR_STATUSNUM_CHK
ADDING TBL_ACCESSOR_ACTIVITY_STATUSNUM_CHK
ADDING TBL_ACCESSOR_DELEGATE_CALLEVEL_CHK
ADDING TBL_ACCESSOR_DELEGATE_ROWSOURCE_CHK
ADDING TBL_ACTIVITY_RECURPERIOD_CHK
ADDING TBL_ACTIVITY_ISPRIVATE_CHK
ADDING TBL_ACTIVITY_RECURMODIFIER_CHK
ADDING TBL_ACTIVITY_RECURDAYTYPE_CHK
ADDING TBL_ACTIVITY_RECURMONTH_CHK
ADDING TBL_ACTIVITY_SOURCENUM_CHK
ADDING TBL_COMPANY_ACL_ROWSOURCE_CHK
ADDING TBL_COMPANY_CONTACT_ROWSOURCE_CHK
ADDING TBL_CONTACT_TYPENUM_CHK
ADDING TBL_CONTACT_ACL_ROWSOURCE_CHK
ADDING TBL_GROUP_ACL_ROWSOURCE_CHK
ADDING TBL_HISTORY_ISPRIVATE_CHK
ADDING TBL_HISTORYTYPE_CLEARTYPENUM_CHK
ADDING TBL_IMPORT_HISTORY_ACTIONTYPENUM_CHK
ADDING TBL_LOGONHISTORY_STATUSNUM_CHK
ADDING TBL_NOTE_ISPRIVATE_CHK
ADDING TBL_OPPORTUNITY_STATUSNUM_CHK
ADDING TBL_OPPORTUNITY_PROBABILITYPCT_CHK
ADDING TBL_OPPORTUNITY_ACL_ROWSOURCE_CHK
ADDING TBL_PERMISSION_TYPENUM_CHK
ADDING TBL_PICKLIST_TYPENUM_CHK
ADDING TBL_PRODUCTSERVICE_DISCTYPENUM_CHK
ADDING TBL_RESOURCE_TYPENUM_CHK
ADDING TBL_STAGE_PROBABILITYPCT_CHK
ADDING TBL_SYNCDB_STATUSNUM_CHK
ADDING TBL_SYNCDB_EXPIREDAYS_CHK
ADDING TBL_SYNCDB_EXPIREACTION_CHK
ADDING TBL_SYNCDB_CONFLICTRULE1_CHK
ADDING TBL_SYNCDB_CONFLICTRULE2_CHK
ADDING TBL_SYNCEXTENDEDDATA_EXTENDEDTYPENUM_CHK
ADDING TBL_SYNCEXTENDEDDATA_NUMTYPE_CHK
ADDING TBL_SYNCSUBSCRIPTION_SUBSTATUS_CHK
ADDING TBL_SYNCSUBSCRIPTION_SUBSOURCE_CHK
ADDING TBL_SYSCOLUMN_SYNCTYPENUM_CHK
ADDING TBL_SYSCOLUMN_RECORDIDENTIFIER_CHK
ADDING TBL_SYSCOLUMN_UPDATETYPE_CHK
ADDING TBL_SYSCOLUMN_TYPENUM_CHK
ADDING TBL_SYSCOLUMN_VALIDACCESSLEVELS_CHK
ADDING TBL_SYSCOLUMN_ACL_ACCESSLEVEL
ADDING TBL_SYSENTITY_TYPENUM_CHK
ADDING TBL_SYSENTITYRELATION_FROM_CARDINALITY_CHK
ADDING TBL_SYSENTITYRELATION_TO_CARDINALITY_CHK
ADDING TBL_SYSTABLE_TYPENUM_CHK
ADDING TBL_TABLEKEY_KEYTYPE_CHK
ADDING TBL_WORKFLOW_ACL_ROWSOURCE_CHK
Adding Indexes at 2012-09-20 10:49:20
Adding Primary Key for table CTL_OLEDBVIEW_JOINDATA
Adding Primary Key for table CTL_SYSTABLEORDER
Adding Primary Key for table TBL_ACTIVITYSERIESAPPLIED
Adding Primary Key for table TBL_ATTACHMENT
Adding Primary Key for table TBL_HISTORY
Adding Primary Key for table TBL_NOTE
Adding Primary Key for table TBL_OPPORTUNITY
Adding Primary Key for table TBL_USER_DEFAULT_ACL
Setting Systable Metadata at 2012-09-20 10:50:03
Setting Sysentity_Systable Data...2012-09-20 10:50:03
Setting Column Metadata at 2012-09-20 10:50:48
Setting syscolumn metadata for ACTIVITYID on TBL_ACTIVITY
Setting syscolumn metadata for ACTIVITYSERIESAPPLIEDID on TBL_ACTIVITY
Setting syscolumn metadata for ACTIVITYTYPEID on TBL_ACTIVITY
Setting syscolumn metadata for CREATEDATE on TBL_ACTIVITY
Setting syscolumn metadata for CREATEUSERID on TBL_ACTIVITY
Setting syscolumn metadata for CREATEUSERID_NAME on TBL_ACTIVITY
Setting syscolumn metadata for DELETED_DATES on TBL_ACTIVITY
Setting syscolumn metadata for DETAILS on TBL_ACTIVITY
Setting syscolumn metadata for DURATION on TBL_ACTIVITY
Setting syscolumn metadata for EDITDATE on TBL_ACTIVITY
Setting syscolumn metadata for EDITUSERID on TBL_ACTIVITY
Setting syscolumn metadata for EDITUSERID_NAME on TBL_ACTIVITY
Setting syscolumn metadata for ENDTIME on TBL_ACTIVITY
Setting syscolumn metadata for EXTERNALID on TBL_ACTIVITY
Setting syscolumn metadata for ISDELETED on TBL_ACTIVITY
Setting syscolumn metadata for ISEVENT on TBL_ACTIVITY
Setting syscolumn metadata for ISINVITATIONSENT on TBL_ACTIVITY
Setting syscolumn metadata for ISPRIVATE on TBL_ACTIVITY
Setting syscolumn metadata for ISRECURENDLESS on TBL_ACTIVITY
Setting syscolumn metadata for ISTIMELESS on TBL_ACTIVITY
Setting syscolumn metadata for LOCATION on TBL_ACTIVITY
Setting syscolumn metadata for MASTERACTIVITYID on TBL_ACTIVITY
Setting syscolumn metadata for ORGANIZEUSERID on TBL_ACTIVITY
Setting syscolumn metadata for ORGANIZEUSERID_NAME on TBL_ACTIVITY
Setting syscolumn metadata for ORIGINALTIME on TBL_ACTIVITY
Setting syscolumn metadata for PARENTACTIVITYID on TBL_ACTIVITY
Setting syscolumn metadata for RECURDAY on TBL_ACTIVITY
Setting syscolumn metadata for RECURDAYTYPE on TBL_ACTIVITY
Setting syscolumn metadata for RECURENDDATE on TBL_ACTIVITY
Setting syscolumn metadata for RECURFREQ on TBL_ACTIVITY
Setting syscolumn metadata for RECURMODIFIER on TBL_ACTIVITY
Setting syscolumn metadata for RECURMONTH on TBL_ACTIVITY
Setting syscolumn metadata for RECURPERIOD on TBL_ACTIVITY
Setting syscolumn metadata for RECURSOURCEACTIVITYID on TBL_ACTIVITY
Setting syscolumn metadata for REGARDING on TBL_ACTIVITY
Setting syscolumn metadata for SOURCENUM on TBL_ACTIVITY
Setting syscolumn metadata for STARTTIME on TBL_ACTIVITY
Setting syscolumn metadata for TZ_BIAS on TBL_ACTIVITY
Setting syscolumn metadata for TZ_DAYLIGHT_BIAS on TBL_ACTIVITY
Setting syscolumn metadata for TZ_DAYLIGHT_DAY on TBL_ACTIVITY
Setting syscolumn metadata for TZ_DAYLIGHT_DOW on TBL_ACTIVITY
Setting syscolumn metadata for TZ_DAYLIGHT_HOUR on TBL_ACTIVITY
Setting syscolumn metadata for TZ_DAYLIGHT_MINUTE on TBL_ACTIVITY
Setting syscolumn metadata for TZ_DAYLIGHT_MONTH on TBL_ACTIVITY
Setting syscolumn metadata for TZ_STANDARD_BIAS on TBL_ACTIVITY
Setting syscolumn metadata for TZ_STANDARD_DAY on TBL_ACTIVITY
Setting syscolumn metadata for TZ_STANDARD_DOW on TBL_ACTIVITY
Setting syscolumn metadata for TZ_STANDARD_HOUR on TBL_ACTIVITY
Setting syscolumn metadata for TZ_STANDARD_MINUTE on TBL_ACTIVITY
Setting syscolumn metadata for TZ_STANDARD_MONTH on TBL_ACTIVITY
Setting syscolumn metadata for WF_CONTEXTID on TBL_ACTIVITY
Setting syscolumn metadata for WF_INSTANCEID on TBL_ACTIVITY
Setting Systablekey Metadata at 2012-09-20 10:50:51
Setting systablekey metadata for CTL_ABL_USER_PREFERENCE_PK ...
Starting Column Description inserts: Sep 20 2012 10:50AMCreating functions and viewsCreating View VRP_MYRECORDCreating View VWX_COLUMNINFOCreating View VWX_CALCCOLUMNINFOCreating View VWX_TABLEKEYINFOCreating View VWX_ENTITYINFOCreating View VWX_ENTITYTABLEINFOCreating View VWX_ENTITYRELATIONINFOCreating View VWX_PICKLISTINFOCreating View VWX_TABLEPAGESIZECreating View VWX_ADDRESSTYPESCreating View VWX_COLUMNINFOCreating View VWX_PHONETYPESCreating View VWX_ENTITY_TABLE_PAGESIZECreating View VWX_COMPANYCONTACT_MAPCreating View VWX_ATTACHMENT_ASSOCIATIONSCreating View VWX_MYDELEGATESCreating View VWX_DELEGATETOCreating View VWX_OLEDBVIEW_COLUMNINFOCreating View VWX_DOMAINOPERATORSCreating View VWX_DOMAINOPERATORVALUESCreating View VWX_SYNCROW_ADDCreating View VWX_SYNCROW_DELETECreating View VWX_SYNCROW_FILECreating View VWX_SYNCROW_UPDATECreating View VWX_SYNCROW_EXCEPTIONCreating View VWX_SYNC_TABLESCreating View VWX_SYNC_COLUMNSCreating View VWX_SYNC_SYNCSETACCESSORSCreating View VWX_SYNCDBCreating View VWX_SYNCAPPLOCKCreating View VWX_SYNCDB_DEVICETABLECreating View VWX_SYNCDBMAPINFO_ALLCreating View VWX_DBLOCKINFOCreating View VWX_EVENTLOGINFOCreating View VWX_GROUP_ALPHAHIERSORTCreating View VWX_COMPANY_ALPHAHIERSORTCreating View VWX_BACKUPAPPLOCKCreating View VWT_OPPORTUNITY_ASSOCIATED_DATACreating View VWX_BI_OpportunityView_FullCreating View VWX_BI_HistoryView_Full
Creating procedures
Running DBRights...
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
*** Setting rights on procedures...
Setting Virtual Record Type Data...2012-09-20 10:51:14
Setting Sysentity Relation data...2012-09-20 10:51:14Setting TBL_SYSATTACHMENT Data...2012-09-20 10:51:14

Setting Primary Fields...2012-09-20 10:51:14
Making istracked modifications...2012-09-20 10:51:14

Making data modifications...2012-09-20 10:51:15
Purging Datefilter From Tbl_Preference
Cleaning syncset records...
Modifying TBL_SYSLOCALCOLUMN for value correction
Modifying TBL_SYSLOCALCOLUMN for value correction
Modifying TBL_SYSDATATYPE for type changes
Making sync related modifications...2012-09-20 10:51:17
Executing stored procedures...2012-09-20 10:51:17.553
PRC_UPD_OLEDBFIELDS Starttime: 2012-09-20 10:51:17.553PRC_UPD_ACCESSORVIRTUALS Starttime: 2012-09-20 10:51:20.040PRC_UPD_TABLECOLUMN Starttime: 2012-09-20 10:51:23.140PRC_UPD_TABLEKEY Starttime: 2012-09-20 10:51:34.517PRC_UPD_VIRTUALCOLUMN Starttime: 2012-09-20 10:51:37.747PRC_UPD_CALCCOLUMN Starttime: 2012-09-20 10:51:40.190PRC_UPD_TABLERELATION Starttime: 2012-09-20 10:51:43.517PRC_UPD_TABLEORDER Starttime: 2012-09-20 10:51:45.960PRC_UPD_TABLEDOMAIN Starttime: 2012-09-20 10:51:48.557PRC_UPD_SYSCOLUMN_ACL Starttime: 2012-09-20 10:51:49.403PRC_UPD_VIEWTABLE_METADATA Starttime: 2012-09-20 10:51:50.447PRC_MAKE_ENTITYACCESSORS_FUNCTION Starttime: 2012-09-20 10:51:52.127ABL_BUILD Starttime: 2012-09-20 10:51:54.480Creating CLR Objects Starting...2012-09-20 10:51:54.483The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
*** Setting rights on procedures...PRC_UPD_ACCESSORACL Starting 2012-09-20 10:52:11.567PRC_UPD_ROLE_PERMISSION Starting 2012-09-20 10:52:15.870PRC_SYNC_UPD_DEVICETABLE: 2012-09-20 10:52:16SERIAL NUMBERS Validation Starting 2012-09-20 10:52:16
Serial Numbers... (Prior Version = 10.03.0182.0000)
----------------------------------------------------------------
Removing Serial Numbers

Purging relational data...2012-09-20 10:52:16Creating trigger CTL_ABL_CONNECTOR_ENTITY_TRD1Creating trigger CTL_ABL_CONNECTOR_ENTITY_TRI1Creating trigger CTL_DBCONFIG_TRI1Creating trigger CTL_DBCONFIG_TRU1Creating trigger CTL_SYNCDB_TRD1Creating trigger CTL_SYNCDB_TRI1Creating trigger TBL_ACCESSOR_ACTIVITY_CLEARED_SYNC_TRDCreating trigger TBL_ACCESSOR_ACTIVITY_CLEARED_SYNC_TRICreating trigger TBL_ACCESSOR_ACTIVITY_CLEARED_SYNC_TRUCreating trigger TBL_ACCESSOR_ACTIVITY_CLEARED_TRID1Creating trigger TBL_ACCESSOR_ACTIVITY_SYNC_TRDCreating trigger TBL_ACCESSOR_ACTIVITY_SYNC_TRICreating trigger TBL_ACCESSOR_ACTIVITY_SYNC_TRUCreating trigger TBL_ACCESSOR_DELEGATE_SYNC_TRDCreating trigger TBL_ACCESSOR_DELEGATE_SYNC_TRICreating trigger TBL_ACCESSOR_DELEGATE_SYNC_TRUCreating trigger TBL_ACCESSOR_PREFERENCE_SYNC_TRDCreating trigger TBL_ACCESSOR_PREFERENCE_SYNC_TRICreating trigger TBL_ACCESSOR_PREFERENCE_SYNC_TRUCreating trigger TBL_ACCESSOR_SETTING_SYNC_TRDCreating trigger TBL_ACCESSOR_SETTING_SYNC_TRICreating trigger TBL_ACCESSOR_SETTING_SYNC_TRUCreating trigger TBL_ACCESSOR_SYNC_TRDCreating trigger TBL_ACCESSOR_SYNC_TRICreating trigger TBL_ACCESSOR_SYNC_TRUCreating trigger TBL_ACCESSOR_TRI1Creating trigger TBL_ACCESSOR_TRU1Creating trigger TBL_ACTIVITYPRIORITY_SYNC_TRDCreating trigger TBL_ACTIVITYPRIORITY_SYNC_TRICreating trigger TBL_ACTIVITYPRIORITY_SYNC_TRUCreating trigger TBL_ACTIVITYSERIESAPPLIED_SYNC_TRDCreating trigger TBL_ACTIVITYSERIESAPPLIED_SYNC_TRICreating trigger TBL_ACTIVITYSERIESAPPLIED_SYNC_TRUCreating trigger TBL_ACTIVITYSERIESITEM_SYNC_TRDCreating trigger TBL_ACTIVITYSERIESITEM_SYNC_TRICreating trigger TBL_ACTIVITYSERIESITEM_SYNC_TRUCreating trigger TBL_ACTIVITYSERIES_SYNC_TRDCreating trigger TBL_ACTIVITYSERIES_SYNC_TRICreating trigger TBL_ACTIVITYSERIES_SYNC_TRUCreating trigger TBL_ACTIVITYTYPE_SYNC_TRDCreating trigger TBL_ACTIVITYTYPE_SYNC_TRICreating trigger TBL_ACTIVITYTYPE_SYNC_TRUCreating trigger TBL_ACTIVITY_SYNC_TRDCreating trigger TBL_ACTIVITY_SYNC_TRICreating trigger TBL_ACTIVITY_SYNC_TRUCreating trigger TBL_ACTIVITY_TRIU1Creating trigger TBL_ADDRESS_SYNC_TRDCreating trigger TBL_ADDRESS_SYNC_TRICreating trigger TBL_ADDRESS_SYNC_TRUCreating trigger TBL_ADDRESS_TRI1Creating trigger TBL_ADDRESS_TRU1Creating trigger TBL_ALARMSNOOZE_SYNC_TRDCreating trigger TBL_ALARMSNOOZE_SYNC_TRICreating trigger TBL_ALARMSNOOZE_SYNC_TRUCreating trigger TBL_AL_ACTIVITY_EXTERNALID_SYNC_TRDCreating trigger TBL_AL_ACTIVITY_EXTERNALID_SYNC_TRICreating trigger TBL_AL_ACTIVITY_EXTERNALID_SYNC_TRUCreating trigger TBL_AL_ACTIVITY_SYNC_TRDCreating trigger TBL_AL_ACTIVITY_SYNC_TRICreating trigger TBL_AL_ACTIVITY_SYNC_TRUCreating trigger TBL_AL_DATAMAPPING_SYNC_TRDCreating trigger TBL_AL_DATAMAPPING_SYNC_TRICreating trigger TBL_AL_DATAMAPPING_SYNC_TRUCreating trigger TBL_AL_DRIVERCONFIG_SYNC_TRDCreating trigger TBL_AL_DRIVERCONFIG_SYNC_TRICreating trigger TBL_AL_DRIVERCONFIG_SYNC_TRUCreating trigger TBL_AL_LINK_SYNC_TRDCreating trigger TBL_AL_LINK_SYNC_TRICreating trigger TBL_AL_LINK_SYNC_TRUCreating trigger TBL_AL_SCHEDULEDFOR_SYNC_TRDCreating trigger TBL_AL_SCHEDULEDFOR_SYNC_TRICreating trigger TBL_AL_SCHEDULEDFOR_SYNC_TRUCreating trigger TBL_AL_SYNCDATA_SYNC_TRDCreating trigger TBL_AL_SYNCDATA_SYNC_TRICreating trigger TBL_AL_SYNCDATA_SYNC_TRUCreating trigger TBL_AL_USERSETTING_SYNC_TRDCreating trigger TBL_AL_USERSETTING_SYNC_TRICreating trigger TBL_AL_USERSETTING_SYNC_TRUCreating trigger TBL_ATTACHMENT_SYNC_TRDCreating trigger TBL_ATTACHMENT_SYNC_TRICreating trigger TBL_ATTACHMENT_SYNC_TRUCreating trigger TBL_ATTACHMENT_TRI1Creating trigger TBL_COMPANYCONTACT_MAP_SYNC_TRDCreating trigger TBL_COMPANYCONTACT_MAP_SYNC_TRICreating trigger TBL_COMPANYCONTACT_MAP_SYNC_TRUCreating trigger TBL_COMPANYQUERY_SYNC_TRDCreating trigger TBL_COMPANYQUERY_SYNC_TRICreating trigger TBL_COMPANYQUERY_SYNC_TRUCreating trigger TBL_COMPANY_ACL_SYNC_TRDCreating trigger TBL_COMPANY_ACL_SYNC_TRICreating trigger TBL_COMPANY_ACL_SYNC_TRUCreating trigger TBL_COMPANY_ACTIVITY_SYNC_TRDCreating trigger TBL_COMPANY_ACTIVITY_SYNC_TRICreating trigger TBL_COMPANY_ACTIVITY_SYNC_TRUCreating trigger TBL_COMPANY_CONTACT_SYNC_TRDCreating trigger TBL_COMPANY_CONTACT_SYNC_TRICreating trigger TBL_COMPANY_CONTACT_SYNC_TRUCreating trigger TBL_COMPANY_HISTORY_SYNC_TRDCreating trigger TBL_COMPANY_HISTORY_SYNC_TRICreating trigger TBL_COMPANY_HISTORY_SYNC_TRUCreating trigger TBL_COMPANY_NOTE_SYNC_TRDCreating trigger TBL_COMPANY_NOTE_SYNC_TRICreating trigger TBL_COMPANY_NOTE_SYNC_TRUCreating trigger TBL_COMPANY_OPPORTUNITY_SYNC_TRDCreating trigger TBL_COMPANY_OPPORTUNITY_SYNC_TRICreating trigger TBL_COMPANY_OPPORTUNITY_SYNC_TRUCreating trigger TBL_COMPANY_SYNC_TRDCreating trigger TBL_COMPANY_SYNC_TRICreating trigger TBL_COMPANY_TRD1Creating trigger TBL_COMPANY_TRI1Creating trigger TBL_COMPANY_TRI2Creating trigger TBL_COMPANY_TRU1Creating trigger TBL_COMPANY_TRU2Creating trigger TBL_CONTACT_ACL_SYNC_TRDCreating trigger TBL_CONTACT_ACL_SYNC_TRICreating trigger TBL_CONTACT_ACL_SYNC_TRUCreating trigger TBL_CONTACT_ACTIVITY_SYNC_TRDCreating trigger TBL_CONTACT_ACTIVITY_SYNC_TRICreating trigger TBL_CONTACT_ACTIVITY_SYNC_TRUCreating trigger TBL_CONTACT_CONTACT_SYNC_TRDCreating trigger TBL_CONTACT_CONTACT_SYNC_TRICreating trigger TBL_CONTACT_CONTACT_SYNC_TRUCreating trigger TBL_CONTACT_CONTACT_TRI1Creating trigger TBL_CONTACT_HISTORY_SYNC_TRDCreating trigger TBL_CONTACT_HISTORY_SYNC_TRICreating trigger TBL_CONTACT_HISTORY_SYNC_TRUCreating trigger TBL_CONTACT_NOTE_SYNC_TRDCreating trigger TBL_CONTACT_NOTE_SYNC_TRICreating trigger TBL_CONTACT_NOTE_SYNC_TRUCreating trigger TBL_CONTACT_OPPORTUNITY_SYNC_TRDCreating trigger TBL_CONTACT_OPPORTUNITY_SYNC_TRICreating trigger TBL_CONTACT_OPPORTUNITY_SYNC_TRUCreating trigger TBL_CONTACT_SOURCE_SYNC_TRDCreating trigger TBL_CONTACT_SOURCE_SYNC_TRICreating trigger TBL_CONTACT_SOURCE_SYNC_TRUCreating trigger TBL_CONTACT_SYNC_TRDCreating trigger TBL_CONTACT_SYNC_TRICreating trigger TBL_CONTACT_TRD1Creating trigger TBL_CONTACT_TRI1Creating trigger TBL_CONTACT_TRU1Creating trigger TBL_COUNTRY_SYNC_TRDCreating trigger TBL_COUNTRY_SYNC_TRICreating trigger TBL_COUNTRY_SYNC_TRUCreating trigger TBL_EMAIL_SYNC_TRDCreating trigger TBL_EMAIL_SYNC_TRICreating trigger TBL_EMAIL_SYNC_TRUCreating trigger TBL_EMAIL_TRI1Creating trigger TBL_EMAIL_TRU1Creating trigger TBL_EXTERNALMAP_SOURCE_SYNC_TRDCreating trigger TBL_EXTERNALMAP_SOURCE_SYNC_TRICreating trigger TBL_EXTERNALMAP_SOURCE_SYNC_TRUCreating trigger TBL_FEATURESET_SYNC_TRDCreating trigger TBL_FEATURESET_SYNC_TRICreating trigger TBL_FEATURESET_SYNC_TRUCreating trigger TBL_GROUPQUERY_SYNC_TRDCreating trigger TBL_GROUPQUERY_SYNC_TRICreating trigger TBL_GROUPQUERY_SYNC_TRUCreating trigger TBL_GROUP_ACL_SYNC_TRDCreating trigger TBL_GROUP_ACL_SYNC_TRICreating trigger TBL_GROUP_ACL_SYNC_TRUCreating trigger TBL_GROUP_ACTIVITY_SYNC_TRDCreating trigger TBL_GROUP_ACTIVITY_SYNC_TRICreating trigger TBL_GROUP_ACTIVITY_SYNC_TRUCreating trigger TBL_GROUP_CONTACT_SYNC_TRDCreating trigger TBL_GROUP_CONTACT_SYNC_TRICreating trigger TBL_GROUP_CONTACT_SYNC_TRUCreating trigger TBL_GROUP_HISTORY_SYNC_TRDCreating trigger TBL_GROUP_HISTORY_SYNC_TRICreating trigger TBL_GROUP_HISTORY_SYNC_TRUCreating trigger TBL_GROUP_NOTE_SYNC_TRDCreating trigger TBL_GROUP_NOTE_SYNC_TRICreating trigger TBL_GROUP_NOTE_SYNC_TRUCreating trigger TBL_GROUP_OPPORTUNITY_SYNC_TRDCreating trigger TBL_GROUP_OPPORTUNITY_SYNC_TRICreating trigger TBL_GROUP_OPPORTUNITY_SYNC_TRUCreating trigger TBL_GROUP_SYNC_TRDCreating trigger TBL_GROUP_SYNC_TRICreating trigger TBL_GROUP_TRD1Creating trigger TBL_GROUP_TRI1Creating trigger TBL_GROUP_TRI2Creating trigger TBL_GROUP_TRU1Creating trigger TBL_GROUP_TRU2Creating trigger TBL_HISTORYTYPE_GROUP_SYNC_TRDCreating trigger TBL_HISTORYTYPE_GROUP_SYNC_TRICreating trigger TBL_HISTORYTYPE_GROUP_SYNC_TRUCreating trigger TBL_HISTORYTYPE_SUPERGROUP_SYNC_TRDCreating trigger TBL_HISTORYTYPE_SUPERGROUP_SYNC_TRICreating trigger TBL_HISTORYTYPE_SUPERGROUP_SYNC_TRUCreating trigger TBL_HISTORYTYPE_SYNC_TRDCreating trigger TBL_HISTORYTYPE_SYNC_TRICreating trigger TBL_HISTORYTYPE_SYNC_TRUCreating trigger TBL_HISTORY_SYNC_TRDCreating trigger TBL_HISTORY_SYNC_TRICreating trigger TBL_HISTORY_SYNC_TRUCreating trigger TBL_IMPORT_HISTORYITEM_SYNC_TRDCreating trigger TBL_IMPORT_HISTORYITEM_SYNC_TRICreating trigger TBL_IMPORT_HISTORYITEM_SYNC_TRUCreating trigger TBL_IMPORT_HISTORY_SYNC_TRDCreating trigger TBL_IMPORT_HISTORY_SYNC_TRICreating trigger TBL_IMPORT_HISTORY_SYNC_TRUCreating trigger TBL_LOGONHISTORY_SYNC_TRDCreating trigger TBL_LOGONHISTORY_SYNC_TRICreating trigger TBL_LOGONHISTORY_SYNC_TRUCreating trigger TBL_NOTETYPE_SYNC_TRDCreating trigger TBL_NOTETYPE_SYNC_TRICreating trigger TBL_NOTETYPE_SYNC_TRUCreating trigger TBL_NOTE_SYNC_TRDCreating trigger TBL_NOTE_SYNC_TRICreating trigger TBL_NOTE_SYNC_TRUCreating trigger TBL_OPPORTUNITY_ACL_SYNC_TRDCreating trigger TBL_OPPORTUNITY_ACL_SYNC_TRICreating trigger TBL_OPPORTUNITY_ACL_SYNC_TRUCreating trigger TBL_OPPORTUNITY_ACTIVITY_SYNC_TRDCreating trigger TBL_OPPORTUNITY_ACTIVITY_SYNC_TRICreating trigger TBL_OPPORTUNITY_ACTIVITY_SYNC_TRUCreating trigger TBL_OPPORTUNITY_HISTORY_SYNC_TRDCreating trigger TBL_OPPORTUNITY_HISTORY_SYNC_TRICreating trigger TBL_OPPORTUNITY_HISTORY_SYNC_TRUCreating trigger TBL_OPPORTUNITY_NOTE_SYNC_TRDCreating trigger TBL_OPPORTUNITY_NOTE_SYNC_TRICreating trigger TBL_OPPORTUNITY_NOTE_SYNC_TRUCreating trigger TBL_OPPORTUNITY_PRODUCTSERVICE_SYNC_TRDCreating trigger TBL_OPPORTUNITY_PRODUCTSERVICE_SYNC_TRICreating trigger TBL_OPPORTUNITY_PRODUCTSERVICE_SYNC_TRUCreating trigger TBL_OPPORTUNITY_PRODUCTSERVICE_TRD1Creating trigger TBL_OPPORTUNITY_PRODUCTSERVICE_TRI1Creating trigger TBL_OPPORTUNITY_SYNC_TRDCreating trigger TBL_OPPORTUNITY_SYNC_TRICreating trigger TBL_OPPORTUNITY_TRI1Creating trigger TBL_OPPORTUNITY_TRU1Creating trigger TBL_PASSWORDHISTORY_SYNC_TRDCreating trigger TBL_PASSWORDHISTORY_SYNC_TRICreating trigger TBL_PASSWORDHISTORY_SYNC_TRUCreating trigger TBL_PERMISSION_DEPEND_SYNC_TRDCreating trigger TBL_PERMISSION_DEPEND_SYNC_TRICreating trigger TBL_PERMISSION_DEPEND_SYNC_TRUCreating trigger TBL_PERMISSION_SYNC_TRDCreating trigger TBL_PERMISSION_SYNC_TRICreating trigger TBL_PERMISSION_SYNC_TRUCreating trigger TBL_PHONEMASK_SYNC_TRDCreating trigger TBL_PHONEMASK_SYNC_TRICreating trigger TBL_PHONEMASK_SYNC_TRUCreating trigger TBL_PHONE_SYNC_TRDCreating trigger TBL_PHONE_SYNC_TRICreating trigger TBL_PHONE_SYNC_TRUCreating trigger TBL_PHONE_TRI1Creating trigger TBL_PHONE_TRU1Creating trigger TBL_PICKLISTITEM_SYNC_TRDCreating trigger TBL_PICKLISTITEM_SYNC_TRICreating trigger TBL_PICKLISTITEM_SYNC_TRUCreating trigger TBL_PICKLISTITEM_TRD1Creating trigger TBL_PICKLISTITEM_TRI1Creating trigger TBL_PICKLISTITEM_TRU1Creating trigger TBL_PICKLIST_SYNC_TRDCreating trigger TBL_PICKLIST_SYNC_TRICreating trigger TBL_PICKLIST_SYNC_TRUCreating trigger TBL_PICKLIST_SYSCOLUMN_SYNC_TRDCreating trigger TBL_PICKLIST_SYSCOLUMN_SYNC_TRICreating trigger TBL_PICKLIST_SYSCOLUMN_SYNC_TRUCreating trigger TBL_PICKLIST_SYSCOLUMN_TRI1Creating trigger TBL_PICKLIST_SYSCOLUMN_TRU1Creating trigger TBL_PICKLIST_TRD1Creating trigger TBL_PREFERENCE_SYNC_TRDCreating trigger TBL_PREFERENCE_SYNC_TRICreating trigger TBL_PREFERENCE_SYNC_TRUCreating trigger TBL_PROCESS_SYNC_TRDCreating trigger TBL_PROCESS_SYNC_TRICreating trigger TBL_PROCESS_SYNC_TRUCreating trigger TBL_PRODUCTSERVICE_SYNC_TRDCreating trigger TBL_PRODUCTSERVICE_SYNC_TRICreating trigger TBL_PRODUCTSERVICE_TRU1Creating trigger TBL_PRODUCT_SYNC_TRDCreating trigger TBL_PRODUCT_SYNC_TRICreating trigger TBL_PRODUCT_SYNC_TRUCreating trigger TBL_RESOURCE_SYNC_TRDCreating trigger TBL_RESOURCE_SYNC_TRICreating trigger TBL_RESOURCE_SYNC_TRUCreating trigger TBL_RESOURCE_TRI1Creating trigger TBL_ROLE_PERMISSION_SYNC_TRDCreating trigger TBL_ROLE_PERMISSION_SYNC_TRICreating trigger TBL_ROLE_PERMISSION_SYNC_TRUCreating trigger TBL_ROLE_SYNC_TRDCreating trigger TBL_ROLE_SYNC_TRICreating trigger TBL_ROLE_SYNC_TRUCreating trigger TBL_SECONDARY_SYNC_TRDCreating trigger TBL_SECONDARY_SYNC_TRICreating trigger TBL_SECONDARY_SYNC_TRUCreating trigger TBL_SECONDARY_TRI1Creating trigger TBL_SERIALNUMBER_SYNC_TRDCreating trigger TBL_SERIALNUMBER_SYNC_TRICreating trigger TBL_SERIALNUMBER_SYNC_TRUCreating trigger TBL_SETTING_SYNC_TRDCreating trigger TBL_SETTING_SYNC_TRICreating trigger TBL_SETTING_SYNC_TRUCreating trigger TBL_STAGE_COLOR_SYNC_TRDCreating trigger TBL_STAGE_COLOR_SYNC_TRICreating trigger TBL_STAGE_COLOR_SYNC_TRUCreating trigger TBL_STAGE_SYNC_TRDCreating trigger TBL_STAGE_SYNC_TRICreating trigger TBL_STAGE_SYNC_TRUCreating trigger TBL_SYNCCONTACT_ACL_SYNC_TRDCreating trigger TBL_SYNCCONTACT_ACL_SYNC_TRICreating trigger TBL_SYNCCONTACT_ACL_SYNC_TRUCreating trigger TBL_SYNCCONTACT_SYNC_TRDCreating trigger TBL_SYNCCONTACT_SYNC_TRICreating trigger TBL_SYNCCONTACT_SYNC_TRUCreating trigger TBL_SYNCDBTYPE_SYNC_TRDCreating trigger TBL_SYNCDBTYPE_SYNC_TRICreating trigger TBL_SYNCDBTYPE_SYNC_TRUCreating trigger TBL_SYNCDB_SYNC_TRDCreating trigger TBL_SYNCDB_SYNC_TRICreating trigger TBL_SYNCDB_SYNC_TRUCreating trigger TBL_SYNCDB_TRD1Creating trigger TBL_SYNCDB_TRI1Creating trigger TBL_SYNCEXTENDEDDATA_SYNC_TRDCreating trigger TBL_SYNCEXTENDEDDATA_SYNC_TRICreating trigger TBL_SYNCEXTENDEDDATA_SYNC_TRUCreating trigger TBL_SYNCEXTENDEDDATA_TYPE_SYNC_TRDCreating trigger TBL_SYNCEXTENDEDDATA_TYPE_SYNC_TRICreating trigger TBL_SYNCEXTENDEDDATA_TYPE_SYNC_TRUCreating trigger TBL_SYNCSETQUERY_SYNC_TRDCreating trigger TBL_SYNCSETQUERY_SYNC_TRICreating trigger TBL_SYNCSETQUERY_SYNC_TRUCreating trigger TBL_SYNCSET_ACCESSOR_SYNC_TRDCreating trigger TBL_SYNCSET_ACCESSOR_SYNC_TRICreating trigger TBL_SYNCSET_ACCESSOR_SYNC_TRUCreating trigger TBL_SYNCSET_SYNC_TRDCreating trigger TBL_SYNCSET_SYNC_TRICreating trigger TBL_SYNCSET_SYNC_TRUCreating trigger TBL_SYNCSUBSCRIPTION_SYNC_TRDCreating trigger TBL_SYNCSUBSCRIPTION_SYNC_TRICreating trigger TBL_SYNCSUBSCRIPTION_SYNC_TRUCreating trigger TBL_SYSCALCCOLUMN_SYNC_TRDCreating trigger TBL_SYSCALCCOLUMN_SYNC_TRICreating trigger TBL_SYSCALCCOLUMN_SYNC_TRUCreating trigger TBL_SYSCOLUMN_ACL_SYNC_TRDCreating trigger TBL_SYSCOLUMN_ACL_SYNC_TRICreating trigger TBL_SYSCOLUMN_ACL_SYNC_TRUCreating trigger TBL_SYSCOLUMN_ACL_TRD1Creating trigger TBL_SYSCOLUMN_ACL_TRI1Creating trigger TBL_SYSCOLUMN_ACL_TRU1Creating trigger TBL_SYSCOLUMN_SYNC_TRDCreating trigger TBL_SYSCOLUMN_SYNC_TRICreating trigger TBL_SYSCOLUMN_SYNC_TRUCreating trigger TBL_SYSCOLUMN_TRD1Creating trigger TBL_SYSCOLUMN_TRI1Creating trigger TBL_SYSCOLUMN_TRU1Creating trigger TBL_SYSENTITYRELATION_SYNC_TRDCreating trigger TBL_SYSENTITYRELATION_SYNC_TRICreating trigger TBL_SYSENTITYRELATION_SYNC_TRUCreating trigger TBL_SYSENTITYRELATION_TRD1Creating trigger TBL_SYSENTITYRELATION_TRI1Creating trigger TBL_SYSENTITYRELATION_TRU1Creating trigger TBL_SYSENTITY_SYNC_TRDCreating trigger TBL_SYSENTITY_SYNC_TRICreating trigger TBL_SYSENTITY_SYNC_TRUCreating trigger TBL_SYSENTITY_SYSTABLE_SYNC_TRDCreating trigger TBL_SYSENTITY_SYSTABLE_SYNC_TRICreating trigger TBL_SYSENTITY_SYSTABLE_SYNC_TRUCreating trigger TBL_SYSENTITY_SYSTABLE_TRI1Creating trigger TBL_SYSENTITY_TRD1Creating trigger TBL_SYSENTITY_TRI1Creating trigger TBL_SYSENTITY_TRU1Creating trigger TBL_SYSTABLEDOMAIN_SYNC_TRDCreating trigger TBL_SYSTABLEDOMAIN_SYNC_TRICreating trigger TBL_SYSTABLEDOMAIN_SYNC_TRUCreating trigger TBL_SYSTABLEKEY_SYNC_TRDCreating trigger TBL_SYSTABLEKEY_SYNC_TRICreating trigger TBL_SYSTABLEKEY_SYNC_TRUCreating trigger TBL_SYSTABLEKEY_SYSCOLUMN_SYNC_TRDCreating trigger TBL_SYSTABLEKEY_SYSCOLUMN_SYNC_TRICreating trigger TBL_SYSTABLEKEY_SYSCOLUMN_SYNC_TRUCreating trigger TBL_SYSTABLEKEY_SYSCOLUMN_TRI1Creating trigger TBL_SYSTABLEKEY_TRD1Creating trigger TBL_SYSTABLE_SYNC_TRDCreating trigger TBL_SYSTABLE_SYNC_TRICreating trigger TBL_SYSTABLE_SYNC_TRUCreating trigger TBL_SYSTABLE_TRD1Creating trigger TBL_SYSTABLE_TRI1Creating trigger TBL_TEAM_SYNC_TRDCreating trigger TBL_TEAM_SYNC_TRICreating trigger TBL_TEAM_SYNC_TRUCreating trigger TBL_TEAM_TRI1Creating trigger TBL_TEAM_USER_SYNC_TRDCreating trigger TBL_TEAM_USER_SYNC_TRICreating trigger TBL_TEAM_USER_SYNC_TRUCreating trigger TBL_TEAM_USER_TRD1Creating trigger TBL_TEAM_USER_TRI1Creating trigger TBL_USER_DEFAULT_ACL_SYNC_TRDCreating trigger TBL_USER_DEFAULT_ACL_SYNC_TRICreating trigger TBL_USER_DEFAULT_ACL_SYNC_TRUCreating trigger TBL_USER_PERMISSION_SYNC_TRDCreating trigger TBL_USER_PERMISSION_SYNC_TRICreating trigger TBL_USER_PERMISSION_SYNC_TRUCreating trigger TBL_USER_SYNC_TRDCreating trigger TBL_USER_SYNC_TRICreating trigger TBL_USER_SYNC_TRUCreating trigger TBL_USER_TRD1Creating trigger TBL_USER_TRI1Creating trigger TBL_USER_TRU1Creating trigger TBL_VIRTUALRECORDTYPE_SYNC_TRDCreating trigger TBL_VIRTUALRECORDTYPE_SYNC_TRICreating trigger TBL_VIRTUALRECORDTYPE_SYNC_TRUCreating trigger TBL_VIRTUALRECORDTYPE_TRD1Creating trigger TBL_VIRTUALRECORDTYPE_TRI1Creating trigger TBL_WORKFLOWDEF_ACL_SYNC_TRDCreating trigger TBL_WORKFLOWDEF_ACL_SYNC_TRICreating trigger TBL_WORKFLOWDEF_ACL_SYNC_TRUCreating trigger TBL_WORKFLOWDEF_SYNC_TRDCreating trigger TBL_WORKFLOWDEF_SYNC_TRICreating trigger TBL_WORKFLOWDEF_SYNC_TRUCreating trigger TBL_WORKFLOWDEF_TRI1Creating trigger TBL_WORKFLOWDEF_TRU1Creating trigger TBL_WORKFLOW_ARCHIVE_SYNC_TRDCreating trigger TBL_WORKFLOW_ARCHIVE_SYNC_TRICreating trigger TBL_WORKFLOW_ARCHIVE_SYNC_TRUCreating trigger TBL_WORKFLOW_QUEUE_SYNC_TRDCreating trigger TBL_WORKFLOW_QUEUE_SYNC_TRICreating trigger TBL_WORKFLOW_QUEUE_SYNC_TRUCreating trigger TBL_WORKFLOW_SUBSCRIPTION_SYNC_TRDCreating trigger TBL_WORKFLOW_SUBSCRIPTION_SYNC_TRICreating trigger TBL_WORKFLOW_SUBSCRIPTION_SYNC_TRU
Setting Foreign Keys at 2012-09-20 10:52:28
Creating Foreign Key ABL_ACTIVITY_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_ACTIVITY_ACTIVITYTYPEID_FKCreating Foreign Key ABL_ACTIVITY_ACTIVITYPRIORITYID_FKCreating Foreign Key ABL_CONNECTOR_CONNECTORTYPEID_FKCreating Foreign Key ABL_CONNECTOR_ACCESSORCONFIG_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_CONNECTOR_ACCESSORCONFIG_ACCESSORID_FKCreating Foreign Key ABL_CONNECTOR_ENTITY_CONNECTORID_FKCreating Foreign Key ABL_CONNECTOR_ENTITY_SYNCDBGUID_FKCreating Foreign Key ABL_CONNECTOR_ENTITYSCHEMA_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_CONNECTOR_ENTITYSCHEMA_ENTITYID_FKCreating Foreign Key ABL_DEPENDENT_ACT_TABLEID_FKCreating Foreign Key ABL_DEPENDENT_ACT_ENTITYID_FKCreating Foreign Key ABL_FIELD_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_FIELD_ACT_COLUMNID_FKCreating Foreign Key ABL_LINK_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_LINK_ACT_ENTITYID_FKCreating Foreign Key ABL_LINK_DEPENDENT_LINKID_FKCreating Foreign Key ABL_LINK_DEPENDENT_DEPENDENTID_FKCreating Foreign Key ABL_LINKREMAP_LINKID_FKCreating Foreign Key ABL_MASTERQUEUE_INPUT_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_MASTERQUEUE_OUTPUT_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_MASTERQUEUE_PREFILTER_CONNECTOR_ENTITYID_FKCreating Foreign Key ABL_SCHEDULEDFOR_SCHEDULEDFORID_FKCreating Foreign Key ABL_SCHEDULEDFOR_ABL_ACTIVITYID_FKCreating Foreign Key ACTIVITY_ABL_ACTIVITY_ACTIVITYID_FKCreating Foreign Key ACTIVITY_ABL_ACTIVITY_ABL_ACTIVITYID_FKCreating Foreign Key EVENTLOG_EVENTLOGTYPEID_FKCreating Foreign Key EVENTLOGDETAIL_EVENTLOGID_FKCreating Foreign Key OLEDBFUNCTION_SYSCOLUMN_COLUMNID_FKCreating Foreign Key OLEDBFUNCTION_SYSCOLUMN_FUNCTIONID_FKCreating Foreign Key OLEDBVIEW_DERIVEDCOLUMN_VIEWNAME_FKCreating Foreign Key OLEDBVIEW_DERIVEDCOLUMN_DATATYPEID_FKCreating Foreign Key OLEDBVIEW_JOINDATA_VIEWNAME_FKCreating Foreign Key OLEDBVIEW_KEYINDEX_VIEWNAME_FKCreating Foreign Key OLEDBVIEW_KEYINDEX_SYSCOLUMN_KEYINDEXID_FKCreating Foreign Key OLEDBVIEW_OLEDBFUNCTION_VIEWNAME_FKCreating Foreign Key OLEDBVIEW_OLEDBFUNCTION_FUNCTIONID_FKCreating Foreign Key OLEDBVIEW_PROVIDERVIEW_PROVIDER_VIEWNAME_FKCreating Foreign Key OLEDBVIEW_PROVIDERVIEW_VIEWNAME_FKCreating Foreign Key SYNC_DEVICETABLE_TABLELUID_FKCreating Foreign Key SYNC_DEVICETABLE_SYNCDB_TYPENUM_FKCreating Foreign Key SYNCACCESSOR_ACCESSORID_FKCreating Foreign Key SYNCDBMAP_ROWEXCEPTION_ROWEXCEPTIONID_FKCreating Foreign Key SYNCDBMAP_ROWFILE_FOLDERID_FKCreating Foreign Key SYNCDBMAP_SESSION_SYNCDBMAPID_FKCreating Foreign Key SYNCDBMAP_SESSIONROW_FKCreating Foreign Key SYNCDBMAPINFO_SYNCDBMAPID_FKCreating Foreign Key SYNCDBMAPINFO_HISTORY_SYNCDBMAPID_FKCreating Foreign Key SYNCROW_ADD_TABLELUID_FKCreating Foreign Key SYNCROW_ADD_ACCESSORLUID_FKCreating Foreign Key SYNCROW_DELETE_TABLELUID_FKCreating Foreign Key SYNCROW_DELETE_ACCESSORLUID_FKCreating Foreign Key SYNCROW_EXCEPTION_TABLELUID_FKCreating Foreign Key SYNCROW_EXCEPTION_SYNCDBMAPID_FKCreating Foreign Key SYNCROW_FILE_FOLDERID_FKCreating Foreign Key SYNCROW_UPDATE_TABLELUID_FKCreating Foreign Key SYNCROW_UPDATECOLUMN_SYNCROWID_FKCreating Foreign Key SYNCROW_UPDATECOLUMN_COLUMNLUID_FKCreating Foreign Key SYNCROW_UPDATECOLUMN_ACCESSORLUID_FKCreating Foreign Key SYNCTABLE_TABLEID_FKCreating Foreign Key SYSTABLEORDER_TABLENAME_FKCreating Foreign Key USER_COLUMNACCESS_USERID_FKCreating Foreign Key USER_COLUMNACCESS_COLUMNID_FKCreating Foreign Key USERSESSION_ACCESSORID_FKCreating Foreign Key WF_COMPLETEDSCOPE_INSTANCESTATEID_FKCreating Foreign Key WF_INSTANCESTATE_USERID_FKCreating Foreign Key ACCESSOR_CREATEUSERID_FKCreating Foreign Key ACCESSOR_EDITUSERID_FKCreating Foreign Key ACCESSOR_ACTIVITY_ACTIVITYID_FKCreating Foreign Key ACCESSOR_ACTIVITY_ACCESSORID_FKCreating Foreign Key ACCESSOR_ACTIVITY_ACTIVITYPRIORITYID_FKCreating Foreign Key ACCESSOR_ACTIVITY_CLEARED_ACCESSOR_ACTIVITYID_FKCreating Foreign Key ACCESSOR_DELEGATE_GRANTTOACCESSORID_FKCreating Foreign Key ACCESSOR_DELEGATE_ACCESSORID_FKCreating Foreign Key ACCESSOR_PREFERENCE_ACCESSORID_FKCreating Foreign Key ACCESSOR_PREFERENCE_PREFERENCEID_FKCreating Foreign Key ACCESSOR_SETTING_ACCESSORID_FKCreating Foreign Key ACCESSOR_SETTING_SETTINGID_FKCreating Foreign Key ACTIVITY_MASTERACTIVITYID_FKCreating Foreign Key ACTIVITY_ACTIVITYSERIESAPPLIEDID_FKCreating Foreign Key ACTIVITY_PARENTACTIVITYID_FKCreating Foreign Key ACTIVITY_RECURSOURCEACTIVITYID_FKCreating Foreign Key ACTIVITY_ACTIVITYTYPEID_FKCreating Foreign Key ACTIVITY_ORGANIZEUSERID_FKCreating Foreign Key ACTIVITY_CREATEUSERID_FKCreating Foreign Key ACTIVITY_EDITUSERID_FKCreating Foreign Key ACTIVITYSERIESAPPLIED_ACTIVITYSERIESID_FKCreating Foreign Key ACTIVITYSERIESITEM_ACTIVITYTYPEID_FKCreating Foreign Key ACTIVITYSERIESITEM_ACTIVITYSERIESID_FKCreating Foreign Key ACTIVITYSERIESITEM_ORGANIZEUSERID_FKCreating Foreign Key ACTIVITYSERIESITEM_ACTIVITYPRIORITYID_FKCreating Foreign Key ACTIVITYTYPE_REGARDING_PICKLISTID_FKCreating Foreign Key ADDRESS_CONTACTID_FKCreating Foreign Key ADDRESS_COMPANYID_FKCreating Foreign Key ADDRESS_GROUPID_FKCreating Foreign Key ADDRESS_TYPEID_FKCreating Foreign Key ADDRESS_OPPORTUNITYID_FKCreating Foreign Key AL_ACTIVITY_LINKDRIVERCLSID_FKCreating Foreign Key AL_DATAMAPPING_LINKDRIVERCLSID_FKCreating Foreign Key AL_LINK_LINKDRIVERCLSID_FKCreating Foreign Key AL_LINK_CONTACTID_FKCreating Foreign Key AL_SCHEDULEFOR_AL_ACTIVITYID_FKCreating Foreign Key AL_SCHEDULEDFOR_SCHEDULEDFORID_FKCreating Foreign Key AL_SYNCDATA_DATAMAPPINGID_FKCreating Foreign Key AL_SYNCDATA_LINKID_FKCreating Foreign Key AL_USERSETTING_LINKDRIVERCLSID_FKCreating Foreign Key AL_USERSETTING_ACTUSERID_FKCreating Foreign Key ALARMSNOOZE_ACCESSOR_ACTIVITYID_FKCreating Foreign Key ATTACHMENT_NOTEID_FKCreating Foreign Key ATTACHMENT_ACTIVITYID_FKCreating Foreign Key ATTACHMENT_HISTORYID_FKCreating Foreign Key ATTACHMENT_WORKFLOWDEFID_FKCreating Foreign Key COMPANY_PARENTCOMPANYID_FKCreating Foreign Key COMPANY_MANAGEUSERID_FKCreating Foreign Key COMPANY_CREATEUSERID_FKCreating Foreign Key COMPANY_EDITUSERID_FKCreating Foreign Key COMPANY_ACL_COMPANYID_FKCreating Foreign Key COMPANY_ACL_ACCESSORID_FKCreating Foreign Key COMPANY_ACTIVITY_COMPANYID_FKCreating Foreign Key COMPANY_ACTIVITY_ACTIVITYID_FKCreating Foreign Key COMPANY_CONTACT_COMPANYID_FKCreating Foreign Key COMPANY_CONTACT_CONTACTID_FKCreating Foreign Key COMPANY_HISTORY_COMPANYID_FKCreating Foreign Key COMPANY_HISTORY_HISTORYID_FKCreating Foreign Key COMPANY_NOTE_COMPANYID_FKCreating Foreign Key TBL_COMPANY_NOTE_NOTEID_FKCreating Foreign Key COMPANY_OPPORTUNITY_COMPANYID_FKCreating Foreign Key COMPANY_OPPORTUNITY_OPPORTUNITYID_FKCreating Foreign Key COMPANYQUERY_COLUMNID_FKCreating Foreign Key COMPANYQUERY_OPERATORID_FKCreating Foreign Key COMPANYQUERY_VALUEID2_FKCreating Foreign Key COMPANYQUERY_VALUEID1_FKCreating Foreign Key COMPANYQUERY_COMPANYID_FKCreating Foreign Key CONTACT_COMPANYID_FKCreating Foreign Key CONTACT_EDITUSERID_FKCreating Foreign Key CONTACT_CREATEUSERID_FKCreating Foreign Key CONTACT_MANAGEUSERID_FKCreating Foreign Key CONTACT_ACL_CONTACTID_FKCreating Foreign Key CONTACT_ACL_ACCESSORID_FKCreating Foreign Key CONTACT_ACTIVITY_CONTACTID_FKCreating Foreign Key CONTACT_ACTIVITY_ACTIVITYID_FKCreating Foreign Key CONTACT_HISTORY_CONTACTID_FKCreating Foreign Key CONTACT_HISTORY_HISTORYID_FKCreating Foreign Key CONTACT_NOTE_CONTACTID_FKCreating Foreign Key CONTACT_NOTE_NOTEID_FKCreating Foreign Key CONTACT_OPPORTUNITY_CONTACTID_FKCreating Foreign Key CONTACT_OPPORTUNITY_OPPORTUNITYID_FKCreating Foreign Key CONTACT_SOURCE_CONTACTID_FKCreating Foreign Key CONTACT_SOURCE_USERID_FKCreating Foreign Key EMAIL_COMPANYID_FKCreating Foreign Key EMAIL_GROUPID_FKCreating Foreign Key EMAIL_TYPEID_FKCreating Foreign Key EMAIL_OPPORTUNITYID_FKCreating Foreign Key EMAIL_CONTACTID_FKCreating Foreign Key GROUP_PARENTGROUPID_FKCreating Foreign Key GROUP_MANAGEUSERID_FKCreating Foreign Key GROUP_CREATEUSERID_FKCreating Foreign Key GROUP_EDITUSERID_FKCreating Foreign Key GROUP_ACL_GROUPID_FKCreating Foreign Key GROUP_ACL_ACCESSORID_FKCreating Foreign Key GROUP_ACTIVITY_GROUPID_FKCreating Foreign Key GROUP_ACTIVITY_ACTIVITYID_FKCreating Foreign Key GROUP_CONTACT_GROUPID_FKCreating Foreign Key GROUP_CONTACT_CONTACTID_FKCreating Foreign Key GROUP_HISTORY_GROUPID_FKCreating Foreign Key GROUP_HISTORY_HISTORYID_FKCreating Foreign Key GROUP_NOTE_GROUPID_FKCreating Foreign Key GROUP_NOTE_NOTEID_FKCreating Foreign Key GROUP_OPPORTUNITY_GROUPID_FKCreating Foreign Key GROUP_OPPORTUNITY_OPPORTUNITYID_FKCreating Foreign Key GROUPQUERY_COLUMNID_FKCreating Foreign Key GROUPQUERY_OPERATORID_FKCreating Foreign Key GROUPQUERY_VALUEID1_FKCreating Foreign Key GROUPQUERY_VALUEID2_FKCreating Foreign Key GROUPQUERY_GROUPID_FKCreating Foreign Key HISTORY_HISTORYTYPEID_FKCreating Foreign Key HISTORY_MANAGEUSERID_FKCreating Foreign Key HISTORY_CREATEUSERID_FKCreating Foreign Key HISTORY_EDITUSERID_FKCreating Foreign Key HISTORYTYPE_ACTIVITYTYPEID_FKCreating Foreign Key HISTORYTYPE_HISTORYTYPEGROUPID_FKCreating Foreign Key HISTORYTYPE_GROUP_HISTORYTYPESUPERGROUPID_FKCreating Foreign Key IMPORT_HISTORY_SOURCEID_FKCreating Foreign Key IMPORT_HISTORYITEM_IMPORT_HISTORYID_FKCreating Foreign Key IMPORT_HISTORYITEM_ENTITYID_FKCreating Foreign Key LOGONHISTORY_USERID_FKCreating Foreign Key NOTE_NOTETYPEID_FKCreating Foreign Key NOTE_MANAGEUSERID_FKCreating Foreign Key NOTE_CREATEUSERID_FKCreating Foreign Key OPPORTUNITY_STAGEID_FKCreating Foreign Key OPPORTUNITY_MANAGEUSERID_FKCreating Foreign Key OPPORTUNITY_CREATEUSERID_FKCreating Foreign Key OPPORTUNITY_EDITUSERID_FKCreating Foreign Key OPPORTUNITY_ACL_OPPORTUNITYID_FKCreating Foreign Key OPPORTUNITY_ACL_ACCESSORID_FKCreating Foreign Key OPPORTUNITY_ACTIVITY_OPPORTUNITYID_FKCreating Foreign Key OPPORTUNITY_ACTIVITY_ACTIVITYID_FKCreating Foreign Key OPPORTUNITY_HISTORY_OPPORTUNITYID_FKCreating Foreign Key OPPORTUNITY_HISTORY_HISTORYID_FKCreating Foreign Key OPPORTUNITY_NOTE_OPPORTUNITYID_FKCreating Foreign Key OPPORTUNITY_NOTE_NOTEID_FKCreating Foreign Key OPPORTUNITY_PRODUCTSERVICE_OPPORTUNITYID_FKCreating Foreign Key OPPORTUNITY_PRODUCTSERVICE_PRODUCTSERVICEID_FKCreating Foreign Key PASSWORDHISTORY_USERID_FKCreating Foreign Key PERMISSION_FEATURESETID_FKCreating Foreign Key PERMISSION_DEPEND_DEPENDID_FKCreating Foreign Key PERMISSION_DEPEND_PERMISSIONID_FKCreating Foreign Key PHONE_COMPANYID_FKCreating Foreign Key PHONE_GROUPID_FKCreating Foreign Key PHONE_TYPEID_FKCreating Foreign Key PHONE_PHONEMASKID_FKCreating Foreign Key PHONE_OPPORTUNITYID_FKCreating Foreign Key PHONE_CONTACTID_FKCreating Foreign Key PHONEMASK_COUNTRYID_FKCreating Foreign Key PICKLIST_DATATYPEID_FKCreating Foreign Key PICKLIST_SYSCOLUMN_PICKLISTID_FKCreating Foreign Key PICKLIST_SYSCOLUMN_COLUMNID_FKCreating Foreign Key PICKLISTITEM_PICKLISTID_FKCreating Foreign Key PRODUCTSERVICE_PRODUCTID_FKCreating Foreign Key RESOURCE_RESOURCEID_FKCreating Foreign Key ROLE_PERMISSION_ROLEID_FKCreating Foreign Key ROLE_PERMISSION_PERMISSIONID_FKCreating Foreign Key STAGE_PROCESSID_FKCreating Foreign Key STAGE_COLOR_USERID_FKCreating Foreign Key STAGE_COLOR_STAGEID_FKCreating Foreign Key SYNCCONTACT_ACL_ACCESSORID_FKCreating Foreign Key SYNCCONTACT_ACL_CONTACTID_FKCreating Foreign Key SYNCDB_SYNCSETID_FKCreating Foreign Key SYNCDB_TYPENUM_FKCreating Foreign Key SYNCEXTENDEDDATA_SYNCDBGUID_FKCreating Foreign Key SYNCEXTENDEDDATA_TYPE_SYNCEXTENDEDDATAID_FKCreating Foreign Key SYNCSET_TYPENUM_FKCreating Foreign Key SYNCSET_ACCESSOR_SYNCSETID_FKCreating Foreign Key SYNCSET_ACCESSOR_ACCESSORID_FKCreating Foreign Key SYNCSETQUERY_SYNCSETID_FKCreating Foreign Key SYNCSETQUERY_VALUEID1_FKCreating Foreign Key SYNCSETQUERY_VALUEID2_FKCreating Foreign Key SYNCSETQUERY_OPERATORID_FKCreating Foreign Key SYNCSETQUERY_COLUMNID_FKCreating Foreign Key SYNCSUBSCRIPTION_SYNCSETID_FKCreating Foreign Key SYNCSUBSCRIPTION_CONTACTID_FKCreating Foreign Key SYSCALCCOLUMN_CALCCOLUMNID_FKCreating Foreign Key SYSCALCCOLUMN_BASECOLUMNID_FKCreating Foreign Key SYSCOLUMN_REF_REALCOLUMNID_FKCreating Foreign Key SYSCOLUMN_TABLEID_FKCreating Foreign Key SYSCOLUMN_DATATYPEID_FKCreating Foreign Key COLUMN_ACCESSOR_COLUMNID_FKCreating Foreign Key SYSCOLUMN_ACL_ACCESSORID_FKCreating Foreign Key SYSDATATYPE_DOMAINID_FKCreating Foreign Key SYSDOMAIN_SYSOPERATOR_DOMAINID_FKCreating Foreign Key SYSDOMAIN_SYSOPERATOR_OPERATORID_FKCreating Foreign Key SYSENTITY_FEATURESETID_FKCreating Foreign Key SYSENTITY_SYSTABLE_ENTITYID_FKCreating Foreign Key SYSENTITY_SYSTABLE_TABLEID_FKCreating Foreign Key SYSTABLE_TABLEDOMAINID_FKCreating Foreign Key SYSTABLEDOMAIN_ENTITYID_FKCreating Foreign Key SYSTABLEKEY_TABLEID_FKCreating Foreign Key SYSTABLEKEY_SYSCOLUMN_COLUMNID_FKCreating Foreign Key SYSTABLEKEY_SYSCOLUMN_TABLEKEYID_FKCreating Foreign Key SYSVALUEUSAGE_OPERATORID_FKCreating Foreign Key SYSVALUEUSAGE_DOMAINID_FKCreating Foreign Key SYSVALUEUSAGE_VALUEID_FKCreating Foreign Key TEAM_TEAMID_FKCreating Foreign Key TEAM_USER_TEAMID_FKCreating Foreign Key TEAM_USER_USERID_FKCreating Foreign Key USER_USERID_FKCreating Foreign Key USER_ROLEID_FKCreating Foreign Key USER_ACCESSOR_ENUM_ACCESSORID_FKCreating Foreign Key USER_ACCESSOR_ENUM_USERID_FKCreating Foreign Key USER_DEFAULT_ACL_USERID_FKCreating Foreign Key USER_DEFAULT_ACL_ACCESSORID_FKCreating Foreign Key USER_DEFAULT_ACL_ENTITYID_FKCreating Foreign Key USER_PERMISSION_USERID_FKCreating Foreign Key USER_PERMISSION_PERMISSIONID_FKCreating Foreign Key VIRTUALRECORDTYPE_TYPEID_FKCreating Foreign Key VIRTUALRECORDTYPE_TABLEID_FKCreating Foreign Key WORKFLOW_ARCHIVE_USERID_FKCreating Foreign Key WORKFLOW_ARCHIVE_TABLEID_FKCreating Foreign Key WORKFLOW_QUEUE_TABLEID_FKCreating Foreign Key WORKFLOW_QUEUE_WORKFLOWDEFID_USERID_FKCreating Foreign Key WORKFLOW_SUBSCRIPTION_USERID_FKCreating Foreign Key WORKFLOW_SUBSCRIPTION_WORKFLOWDEFID_FKCreating Foreign Key WORKFLOWDEF_ENTITYNAME_FKCreating Foreign Key WORKFLOWDEF_ACL_WORKFLOWDEFID_FKCreating Foreign Key WORKFLOWDEF_ACL_ACCESSORID_FK
Executing stored procedures, round two...2012-09-20 10:52:32.563
Rebuild sync table order 2012-09-20 10:52:32.563Rebuild table relation 2012-09-20 10:52:37.020Rebuild table keys for foreign keys2012-09-20 10:53:17.763
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: PRC_REPORT_MAKE_OLEDBFUNCTIONS: ERROR OCCURRED TRYING TO CREATE/ALTER BASE FUNCTION FNR_CONTACT
PRC_REPORT_MAKE_OLEDBFUNCTIONS: ERROR OCCURRED TRYING TO REMOVE FUNCTION METADATA FOR FNR_CONTACT
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Schema Update failed.

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Update Act

Hello Milestone,
There is more than one possible cause:

- User Control Control (Windows Vista, Windows 7, Server 2008). Instructions to disable:
Vista: http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2022...
Win 7: http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2566...

- Low system resources (RAM)

- Damaged database. See this KB for repair instructions using ACT! Diagnostics: http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1964...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 18
Country: Mexico

Re: Update Act

Hi 

 

I checked the part you mention, and I have it set to (never notify me when)  but still the problem persists, I have also checked the knowledge base but without success

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Update Act

Have you run database repairs?

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.