3 Replies Latest reply: May 15, 2014 10:13 AM by Olly Bond RSS

    Another glitch

    Maurice _

      Hi all,

       

      My MDP ST 10.5 works well for a while and then I get the following error:

       

      The file is not in the expected Excel format. Only Excel 97 and higher versions are supported.

           

        Failed: DwchServer.ExporterFailureException: Exporter method RunAllExports returned false. at DwchServer.JobHandler.a(MpExportClass A_0, JobLog A_1, Int32 A_2) at DwchServer.JobHandler.a()

       

      I have not changed any settings. It shows up from time to time. I recycled the MDP but it does not help.

       

      Any help is greatly valued.

       

      Thank you,

       

      Maurice

        • Another glitch
          Olly Bond

          Hello Maurice,

           

          Is the job trying to update an Excel file by appending data to it? Have users opened the Excel file and changed anything in between job runs?

           

          Best wishes,

           

          Olly

            • Another glitch
              Maurice _

              There is appending but no end user is in the file.

                • Another glitch
                  Olly Bond

                  Hello Maurice,

                   

                  Excel isn't my area of expertise, but I suspect that this error message might be shown when you try to append data to the bottom of a named range and where the columns don't match exactly. If you start with

                   

                  Composer - Qty - Unit Price

                  Mozart   - 102 - $10.99

                  Schumann - 204 - $5.97[/CODE]

                   

                  and try to append

                   

                  Composer - Qty - Unit Price - Description

                  Bartok   - 376 - $2.97 - Sonatas[/CODE]

                   

                  then Monarch will struggle as the second range doesn't fit the first.

                   

                  Assuming that's fixed, then try editing the Options > Export & Clipboard to vary the Excel flavour Monarch (and DataPump) are using.

                   

                  Hope this helps,

                   

                  Olly