Community
Showing results for 
Search instead for 
Do you mean 
Reply

Convert ACT 2000 database to ACT 2011

New Member
Posts: 2
Country: USA

Convert ACT 2000 database to ACT 2011

Am trying to convert an ACT 2000 db to ACT 2011.  Have fixed several issues with database already, but am now "stuck" with an error message that says "Conversion has been halted with the following message"

Value cannot be null

Parameter Name:  file

In the knowledgebase, it recommended going into ACTDiag and changing parameters for the Database Command Time Out Default and Database Connection Time Out Default, so these have been changed to 100000.

However, the same error message still appears.


Any suggestions would be most welcome.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Convert ACT 2000 database to ACT 2011

Can you post the conversion log? It would show what part caused the failure.

You might also see this article ... it's often better to do repairs in 6.0
http://blog.glcomputing.com.au/2010/01/tips-for-converting-act-60-or-earlier.html
New Member
Posts: 2
Country: USA

Re: Convert ACT 2000 database to ACT 2011

Here's the log.Updating database...
  Added First Name Prefix: Don
  Added First Name Prefix: Dona
  Added Last Name Prefix: van der
  Added Last Name Prefix: von der
Converting Contacts...
       4139 of 4139 converted.
Converting Users...
       27 of 27 converted.
The user record for '' has unknown record manager. Set to current user.
The user record for '' has unknown record manager. Set to current user.
The user record for '' has unknown record manager. Set to current user.
Converting Groups...
       29 of 29 converted.
Converting Activities...
       7124 of 7124 converted.
Converting Notes and Histories...
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Maintenance\Sept\Hanscomb_WXdeMaint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Maintenance\Sept\Hanscomb_WSMaint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Proposals\Sales\Wiley & Co_WinEx Master_Invoice.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Proposals\Sales\Bituminex_WX WX Master_Upgrade.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\Womack Paving Inc_Construction Laser.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\SECO Llc_Lead.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\Dave Valente_ Lead.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\Cassel Consulting_  Software Advice Lead.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\David Wallis Lead_ Cameron           604-5762935 WXM Google  .txt': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\David Wallis Lead_ Cameron           604-5762935 WXM Google  .txt': the file is missing.
Unable to convert the attachment 'C:\Users\William.Beard\Desktop\prints\AM-XConstruction_2181001_WXde_maintconf.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\ROCTEK DEMOCameron           604-5762935 WXM Google  .txt': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Maintenance\March\PezzucoConstruction_2280001_SSC_WXM_maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Dealers\Leads\Sheedy Paving_ WinEx Master Lead.htm': the file is missing.
Unable to convert the attachment 'C:\Documents and Settings\sales1\Desktop\Roctek WinEx Master_Proposal.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Maintenance\January\WallaceBuild_maint.rtf': the file is missing.
Unable to convert the attachment 'C:\Users\William.Beard\Desktop\prints\jan\Humphries&Company_maint.pdf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2012ActDocs\Maintenance\January\CivilDynamics_main.rtf': the file is missing.
Unable to convert the attachment 'C:\Users\William.Beard\Documents\ACT\Document\FletcherExc_proposal.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2011ActDocs\Maintenance Faxes\August\PDFs\BSIConstructors.pdf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2011ActDocs\Maintenance Faxes\June\MeyerExc_0788450_WXde_maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Payment Receipts\Maintenance Receipts\HenselPhelps_1160003_WXM_maintconf.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2011ActDocs\Maintenance Faxes\February\StuartOlson_1224006_WXM_maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2011ActDocs\Maintenance Faxes\February\StuartOlson_1224006_WXM_maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2011ActDocs\Payment Receipts\GulfSeaboard.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Payment Receipts\Maintenance Receipts\NickFalcone_0788056_WXP_maintconf.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\MegaEngineering_WXMUpgrade.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Maintenance Faxes\March\SouthFloridaWaterManagement_1831001_WX_maint_MIGHTBETAXEXEMPT.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\eWXP_MaintProp_WXMUpgradeEmail.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\eWXP_MaintProp_WXMUpgradeEmail.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\TheWeitzCo_Upgrades for WinScale and WinEx takeoff software.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\BlundallAssociates_WX-deEmail.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\ JTSConstruction_Re WinEx-de with LineTracker technology.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\AustinCo_ Re WinEx-de with LineTracker technology.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\DeltaAsphalt_Re WinEx-de with LineTracker technology.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Advertisements\EmaiedToCustomers\DallasCarico_Re WinEx-de with LineTracker technology.htm': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Maintenance Faxes\January\BlakesleeArpaiaChapmanInc_1667002_001_WXP2.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Maintenance Faxes\January\KitchellContractors_1052011_WXP1_maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2010ActDocs\Maintenance Faxes\January\JRExcavating_2017001_WXP1_maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\PrairieViewAandMUni_2194001_002_eWXP_conf.ADT': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\BWPeacock_WXMEval.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Proposals\Maintenance Proposals\Templates\WinscaleMaintenane.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Advertisements\May\GradingandExcavating_eWXP_QuarterPage_may copy.zip': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Plug Replacements\Lost Plugs\VersatileCoatings_LostPlugInstructionLetter.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Plug Replacements\Lost Plugs\VersatileCoatings_1607001Maint_LostPlug.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Reminders\GroupConstruct_0788333_outstandingpayment.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\AlderConst_EvalConf_2144999.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\ThompsonHomes_OrderConf_2142999.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\SoTech_TiltCon_0788996.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\SolTech_AFinerSurface_0788420.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\Software Purchase Receipts\SolTech_HortonPainting_0788419.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\KitchellContractors_WXP_1052011.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\SitePrepInc_0786008_WXP_maintconf.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\TriumphConstruction_MaintFax_0797008.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\RVWagner_Maint_1940001.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2009ActDocs\Payment Receipts\WallaceBuilders_Maint_1942001.doc': the file is missing.
Unable to convert the attachment 'C:\Users\William B\Desktop\siding specialists gtco stylus pen proposal.pdf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\PaymentReceipts\ATECHMaintPymt.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\StuartOlson_0808_maintinvoice.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\j and j WXP Maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\Turner Construction Co maint ws wx usb swap 1223048.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\Turner Construction Co maint ws wx 1223048.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\Willis Roofing ws maint.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\PaymentReceipts\GroathouseConstInc_eWXPro_eval.DOC': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\Turner construction maint wx.rtf': the file is missing.
Unable to convert the attachment 'C:\Cheri\FormLetters_Faxes\ForbesConstMaintPmtConf_1398001.doc': the file is missing.
Unable to convert the attachment 'C:\Cheri\FormLetters_Faxes\LeaseCrutcherLewisPmtRecFax_1444003.doc': the file is missing.
Unable to convert the attachment 'C:\Cheri\FormLetters_Faxes\WattenbargerGradingPmtRecFax.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2008ActDocs\Maintenance Only\Arco Design build maitn.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2007ActDocs\Maintenance Only\AndyJohnsonCo._MaintPayment.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2007ActDocs\PaymentReceipts\D&R_GeneralContractingMaint.Payment.doc': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2007ActDocs\PaymentReceipts\AtkinsonConstructionMaint.Payment.doc': the file is missing.
Unable to convert the attachment 'C:\Wendy\FormLetters_Faxes\Exchange Plug Confirmation.doc': the file is missing.
Unable to convert the attachment 'C:\Wendy\FormLetters_Faxes\Exchange Plug Confirmation.doc': the file is missing.
Unable to convert the attachment 'C:\Wendy\FormLetters_Faxes\SoftwareOrderConfirmationFax_1Page.doc': the file is missing.
Unable to convert the attachment 'C:\Documents and Settings\jeffreyj.SALES2007\Desktop\CJM Construction Maint_5Oct07.rtf': the file is missing.
Unable to convert the attachment 'R:\AA_Yr2007ActDocs\Maintenance Only\AmericanServices_23July2007.rtf': the file is missing.
Value cannot be null.
Parameter name: file

I had read the article earlier today and had planned to try ACT6 tomorrow.

 

Also, today in ACT 5, I am working with a small subset of our database (A's only).  In ACT 5, using database maintenance, I deleted all history/notes/attachments etc that were older than 1825 days old (5 years) and it ran successfully.  I am now trying it for 7 years to see if that will run.  If it does, I plan to try the same thing on the entire database.

 

Thanks Mike

 

Regards,

Carolyn

 

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Convert ACT 2000 database to ACT 2011