Results 1 to 9 of 9

Thread: Error: Expect string or unicode arguments

  1. #1

    Unhappy Error: Expect string or unicode arguments

    Hi there,

    I've got this error message when reading in some tab delimited files. It certainly must be specific to a select number of records as the node runs for a little while and then errors out.

    No doubt there is something unexpected in the files I am reading in but as I'm reading in 2.5M rows, how can I go about either isolating the records that are in error (put them to a different output pin) or find them in the dataset so I can fix them directly in the files?

    Apologies if this question has been asked before but my quick search of the forum couldn't find an answer for this one.

    Mike

  2. #2
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    Mike, have you tried creating a second output pin? On the delimited node, if it can't process records, it will error...unless you create a second output. Then it will attempt to recover and put those records out on that pin.

    Cheers
    Rich

  3. #3
    Contributor
    Join Date
    Mar 2010
    Location
    Melbourne
    Posts
    27

    Default

    Hi Rich, I think I thought I'd done that but perhaps I've not done it right.

    Assuming I have all the workings for output 1 and am ok on those, can you confirm how I need to confirm this for output 2 (the error pin)?

    Mike

  4. #4
    Contributor
    Join Date
    Mar 2010
    Location
    Melbourne
    Posts
    27

    Default

    Let me quickly clarify the above - the error is not on the delimited node (this works fine) - rather on a later filter note where I'm changing formats of the data, doing some preparatory calculations etc.

  5. #5
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    Sure. You should be able to go into the node editor, click on the IO tab, and then click the duplicate button on the right side, next to the outputs list. This should add a second output to the delimited node, which should contain all recoverable errors on your next run.

  6. #6
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    Mike, can you provide a small (obfuscated if necessary) example of what you are encountering? Ideally, the Delimited file should detect this.

    Another way that might tell you how to find the error, right click on the input pin of the node that is failing, and select "view all records". This will pull all the records into the brdViewer (which will take a while), but should tell you all the records it can't read properly when it loads. What version are you using?

    Cheers
    Rich

  7. #7
    Contributor
    Join Date
    Mar 2010
    Location
    Melbourne
    Posts
    27

    Default

    Sure, let me post this in the next day or so.

    I just ran the "view all records" so can't check my version but think its 4.1.5 (?)

    Thanks,
    Mike

  8. #8
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    Ok...there were some enhancements done to the viewer that provide better feedback as to which records might be flawed and where...so your version might not have that, as it is a bit out of date...unless you mean you are 4.5.1, not 4.1.5, and if that's the case, you should be fine

  9. #9

    Default

    Thanks Rich, I've split the incoming files and run them all through and then "cat" them together and for some reason, this seems to work - even though there is no change in the underlying file itself.

    I'll have a chat to the local MDA here team but let's close this one off for now.

    Mike

Similar Threads

  1. timestamp from string
    By awibowo in forum Nodes
    Replies: 5
    Last Post: 04-10-2015, 04:29 PM
  2. String to timestamp convertion
    By vachouli in forum Nodes
    Replies: 2
    Last Post: 07-28-2010, 09:28 AM
  3. Convert string into a date
    By Iain Sanders in forum Nodes
    Replies: 1
    Last Post: 03-25-2010, 12:05 AM
  4. Adding a decimal to string values
    By Iain Sanders in forum Nodes
    Replies: 10
    Last Post: 03-04-2010, 10:01 PM
  5. Date to String function
    By rhallmark3 in forum Nodes
    Replies: 3
    Last Post: 01-05-2008, 12:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •