Search results

  1. Support

    readODBC box, truncation error messages

    this is because the database failed to report correctly the length of a cell. No Worries. Just put "2000" in this parameter here: if "2000" is not enough, continue increasing the number up to the point the error disappear
  2. Support

    Generate fake random Data ?

    Solution in att.
  3. Support

    Error message when opening Excel File

    Solution: 1. open the "Graph Global Parameters": 2. Enter the value "10" in this field (and click the "ok" button): This is still an unexpected behavior. If this does not solve the issue, we'll need to have a deeper look at what's happening
  4. Support

    Json booleans as strings

    Since v2.79 we added this option
  5. Support

    create column with random content

    solution in attachment
  6. Support

    Windows security of files created and/or modified by Anatella is altered ?

    The only possibility we can see for this to happen is that there are processes running under another user that will modify the file. Perhaps such a process could be Jenkins? The normal Jenkins installation procedure is designed so that this kind of thing doesn't happen: i.e. Jenkins runs under...
  7. Support

    stored procedure

    This is typically done with the readODBC box. In the readODBC box, you must be careful to leave this checkbox checked: ..after that, you can run any SQL with the readODBC box.
  8. Support

    When I run Anatella normally, it works but when I run Anatella inside Jenkins, it returns "Invalid Serial Number: check license"

    When Anatella returns "Invalid Serial Number: check license" inside Jenkins but not inside a normal interactive Windows session, this usually means that Jenkins is not running using your own credentials. To run Jenkins with you own credentials, you must see your windows-login here (inside the...
  9. Support

    Split Table ?

    Solution is in attachment.
  10. Support

    SQL in() operator

    If you have a situation with a complex ‘in’ operation, I suggest you use the ‘FilterOnKey’ box: it's like SQL's ‘IN’ (but ultra-efficient and more ‘visual’): there's an example attached.
  11. Support

    error when running python box

    Since Python 3.7, it is necessary to modify the Windows ‘PATH’ environment variable for Python to start (this is not necessary in Python 3.5 or Python 3.6). Also, you need to use Python 3.7.3. which is available here (just unzip the ZIP file is ok). To make the Python box work you need to: 1...
  12. Support

    New table in existing Power BI dataset ?

    Apparently, it is not possible to add a table to an existing PowerBI dataset: https://community.powerbi.com/t5/Power-Query/Create-new-table-in-existing-Dataset-using-Rest-API/td-p/1087444...
  13. Support

    ics/ical

    Please attached a little Anatella graph that reads ics/ical files!
  14. Support

    Temp directory growths ?

    hi, Yaroslav, the global Anatella "temp" directory only growths in size when using Anatella in an interactive way (i.e. the batch executions during the night are NOT increasing the size of the Anatella "temp" directory). This means that, normally, on a TIMi production server that is used only to...
  15. Support

    default location of the global Anatella "temp" directory

    You can change the location of this "temp" directory using two different settings:
  16. Support

    column with an incremented serie

    hello, attached you can fin a graph that does just that !
  17. Support

    Has Anatella an event driven architecture (such as in Azure Data Factory?)

    You can indeed react to "events" with TIMi/Anatella and perform "event driven" actions. There are basically, four mechanisms to react to events inside Anatella: 1. the "build triggers" inside Jenkins. Jenkins is one of the most well-known open source scheduler available today...
  18. Support

    HD cache write buffer is too smal

    You have to increase the value here until it gets through :
  19. Support

    ERROR upsertODBC: cannot find column

    This error appears when you activate the "Row Selection" option without specifying a column to test here: Don't hesitate to contact us again if you run into any more trouble.
  20. Support

    IF, THEN function

    Hello Yaroslav, That's great to hear from you! For a solution: see the graph in the attachment.
Top