Exception: An exception occured processing record '0' for Command 'ApacheCommand'.

Posted by: analytics on 3 August 2017, 3:55 pm EST

  • Posted 3 August 2017, 3:55 pm EST


    I tried to use an alias of [Entry Date] and [Sheet Date] but it does not work.  I get the error, "Exception: An exception occurred processing record '0' for Command 'ApacheCommand'."  When I changed it to Entry_Date and Sheet_Date it worked.  However, this is less than desirable from a user's point of view if you want to make the columns very clean looking. 

    Is this a  known issue?  Will it be fixed?  Or should I assume we will have to name the fields differently?

    Thanks.
  • Replied 3 August 2017, 3:55 pm EST

    Hello,

    Could you let us know which database you are using? Does this error occur while you drag the attributes/ measures to a shelf? This problem occurs while using MySQL with field names that contain spaces. Let us know if you using MySQL database?

    Regards,
    Aashish
  • Replied 3 August 2017, 3:55 pm EST

    I was using SQL Server 2005 Express.  Thanks.
  • Replied 3 August 2017, 3:55 pm EST

    Hello analytics,

    I have used SQL express 2005, however, I was not able to replicate this issue. Is there a sample application that you can provide that replicates this issue? Could you please let me know the build that you using. Install  the latest build (1.0.912.0) which is available for download here.

    Regards,
    Aashish
  • Replied 3 August 2017, 3:55 pm EST

    analytics,

    I would like to mention that this issue is not related to MySQL or SQL server database, but is related to the functionality of the Data Dynamics Analysis engine. This exception is thrown when there is a field name which contains spaces in it. We already have Case 117942 opened with the development team to address this issue. I have added your E-mail address to the list of affected users for this case. You will be notified once this issue is resolved.

    As a workaround you may continue using an alias (which does not contain spaces) for the field in the query.

    Regards,
    Sankalp
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels