What to do when you get getting a GOLDMINECOPYTEMPTABLE error when performing a Rebuild?

Version 1

    Details

    What to do when you get getting a GOLDMINECOPYTEMPTABLE error when performing a Rebuild?





    Resolution

    [INFORMATION]
    -  Regardless on which table this error occurs, the very first resource for  the root cause of such an error is always to verify the Windows Event  log on the machine where the error was experienced as this provides  further and more detailed information than the generic message on  screen.
    - Most times a data type mismatch between the existing table  structure and the defined structure is causing such error messages and  the Event log entry provides usually very clear the issue in the  description information, for example (all of them are taken for the  error message occuring for the CONTACT2 table.
    For example when  adding a new user defined field and making a rebuild, but the same may  applied also to other tables where back end changes were performed at  one point.



    ADO  Error in AdoCommand::execute INSERT INTO [dbo].[GOLDMINETEMPCOPYTABLE] (  [ACCOUNTNO] , [CALLBACKON] , [CALLBACKAT] , [CALLBKFREQ] , [LASTCONTON]  , [LASTCONTAT] , [LASTATMPON] , [LASTATMPAT] , [MEETDATEON] ,  [MEETTIMEAT] , [COMMENTS] , [PREVRESULT] , [NEXTACTION] , [ACTIONON] ,..., [UNAICS] , [UBRDETAIL]  , [UCREATEON] , [UCDATE] , [USTATUS] , [UCREATEAT] , [UACCNO] ,  [ULASTUSER] , [ULASTDATE] , [URECNO] , [ULASTTIME] , [URECIDNO] ,  [UTEST] , [UHMAIL] , [UHMAILID] , [U] , [UROLAND] , [UTEST2] , [RECID]  from [dbo].[CONTACT2]
    Com Error IDispatch error #3079
        HRESULT    : -2147217913
        Description: Conversion failed when converting date and/or time from character string.

    Or also

    ADO  Error in AdoCommand::execute INSERT INTO [dbo].[GOLDMINETEMPCOPYTABLE] (  [ACCOUNTNO] , [CALLBACKON] , [CALLBACKAT] , [CALLBKFREQ] , [LASTCONTON]  , [LASTCONTAT] , [LASTATMPON] , [LASTATMPAT] , [MEETDATEON] ,  [MEETTIMEAT] , [COMMENTS] , [PREVRESULT] , [NEXTACTION] , [ACTIONON] , ..., [UHMAILID] , [U] , [UROLAND] , [UTEST2] , [RECID]  from [dbo].[CONTACT2]
    Com Error IDispatch error #3079
        HRESULT    : -2147217913
        Description: Conversion failed when converting the varchar value 'fgh' to data type int.

     Or also

    ADO  Error in AdoCommand::execute INSERT INTO [dbo].[GOLDMINETEMPCOPYTABLE] (  [ACCOUNTNO] , [CALLBACKON] , [CALLBACKAT] , [CALLBKFREQ] , [LASTCONTON]  , [LASTCONTAT] , [LASTATMPON] , [LASTATMPAT] , [MEETDATEON] ,  [MEETTIMEAT] , [COMMENTS] , [PREVRESULT] , [NEXTACTION] , [ACTIONON] ,..., [UHMAIL] ,  [UHMAILID] , [U] , [RECID] from [dbo].[CONTACT2]
    Com Error IDispatch error #3159
        HRESULT    : -2147217833
        Description: String or binary data would be truncated.


    - Windows Event Logs can be reviewed or gathered


    Windows 2012 Server and Windows 8:

     

    1.  On Start view > type simply eventvwr or also Event viewer on the  Start view > press Enter (alternatively open the Control Panel >  System and Security > Administrative Tools > Event Viewer)

    2. Browse to Windows Logs > Application

     

    To review or provide a single event detail

    3. In the Details pane  >  in the Source search for GoldMine (please make sure that you refer to a  GoldMine event recorded when you experienced the undesired behavior)

    4. Double-click the event that you want to view
    a. The Event properties dialog box containing header information and a description of the event is displayed.

    b. To copy the details of the event, > Copy button (right from the event)  >  open a new document/file in the program you want to paste the event  (for example Microsoft Word/Notepad) > paste the content into the  program

     

    To  save the complete event log (this is often useful and necessary when  several related GoldMine entries are available or to determine if also  other applications showed an unexpected behavior)

    3. In the console tree of Event Viewer > Windows Logs > right-click on Application > Save All Events As …

    a. Specify a file name and location where you want to save the file.

    b. In the Save as type box, leave Event Files (*.evtx) > Save

    4.  Verify the size of the saved evtx file > if the file size exceeds 2  MB, make sure to compress it before sending it to GoldMine Technical  Support

     

     

    Windows 7, Windows 2008 Server, Windows Server 2008 R2, Windows Vista

     

    1.  Start > enter eventvwr or also Event viewer into Search Programs and  Files > press Enter (alternatively Start button > Control Panel  > System and Security > Administrative Tools > Event Viewer)

    2. Browse to Windows Logs > Application

     

    To review or provide a single event detail

    3. In the Details pane  >  in the Source search for GoldMine (please make sure that you refer to a  GoldMine event recorded when you experienced the undesired behavior)

    4. Double-click the event that you want to view
    a. The Event properties dialog box containing header information and a description of the event is displayed.

    b. To copy the details of the event, > Copy button (right from the event)  >  open a new document/file in the program you want to paste the event  (for example Microsoft Word/Notepad) > paste the content into the  program

     

    To  save the complete event log (this is often useful and necessary when  several related GoldMine entries are available or to determine if also  other applications showed an unexpected behavior)

    3. In the console tree of Event Viewer > Windows Logs > right-click on Application > Save All Events As …

    a. Specify a file name and location where you want to save the file.

    b. In the Save as type box, leave Event Files (*.evtx) > Save

    4.  Verify the size of the saved evtx file > if the file size exceeds 2  MB, make sure to compress it before sending it to GoldMine Technical  Support

     

     

    Windows 2003 Server and Windows XP:

     

    1.  Start > Run > eventvwr > press Enter (alternatively via Start  > Settings > Control Panel > Administrative Tools > Event  Viewer)

    2. Browse to Application

     

    To review or provide a single event detail

    3. In the Details pane >  in the Source search for GoldMine (please make sure that you refer to a  GoldMine event recorded when you experienced the undesired behavior)

    4. Double-click the event that you want to view
    a. The Event properties dialog box containing header information and a description of the event is displayed.

    b. To copy the details of the event, > Copy button (right from the event) >  open a new document/file in the program you want to paste the event  (for example Microsoft Word/Notepad) > paste the content into the  program

     

    To  save the complete event log (this is often useful and necessary when  several related GoldMine entries are available or to determine if also  other applications showed an unexpected behavior)

    3. In the console tree of Event Viewer > right-click on Application > Save Log File As

    a. Specify a file name and location where you want to save the file.

    b. In the Save as type box, leave Event Log (*.evt) > Save

    4.  Verify the size of the saved evt file > if the file size exceeds 2  MB, make sure to compress it before sending it to GoldMine Technical  Support

     

    - Along with the failing GoldMine table you may then search further in  the Knowledge Base, review the related articles or if the error is not  yet documented submit with the GoldMine Technical Support team