Visual Process cannot find input file

Janet_21505
Janet_21505 Altair Community Member
edited August 2020 in Community Q&A
Ok you smart people out there. What have I missed in this visual process.  It cannot find my input file.  The file name will change daily as it has a date stamp so I am using BIMExtract*.txt in the path.

image


------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
5403490215
------------------------------
Tagged:

Best Answer

  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited August 2020 Answer ✓
    Hi Janet,
    I'm afraid I can't read the screen shot, so I'll start with a couple of guesses!

    1. Is this a network location that you have not previously used?  If so, please ensure that the domain service account being used to run the Agent service has full access to that folder.

    2. Have you changed all references to the original workspace input file (if necessary)? To check this, click on the workspace and make sure you don't see any yellow exclamation marks in the Load plan(s).

    image
    If you see any exclamation marks, work your way into the tree and fix the troublesome reference.
    image


    If that doesn't help, please could you repost the screen shot and select 'Original size'.

    UPDATE !!
    I can just about see from the screenshot that you are using a text delimited file as the input.  In that case, I think you will need to use the Database input rather than the file input (green icon set)

    Then, in the filename input section of the workspace, you should be able to select your Database Input from the drop down.  Having said that, it does look like the path is the same for both, so it may be something else.  It's difficult to be sure from the screen shot resolution.

    Best Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 08-06-2020 08:31 AM
    From: Janet Grimsley
    Subject: Visual Process cannot find input file

    Ok you smart people out there. What have I missed in this visual process.  It cannot find my input file.  The file name will change daily as it has a date stamp so I am using BIMExtract*.txt in the path.

    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------"

Answers

  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited August 2020 Answer ✓
    Hi Janet,
    I'm afraid I can't read the screen shot, so I'll start with a couple of guesses!

    1. Is this a network location that you have not previously used?  If so, please ensure that the domain service account being used to run the Agent service has full access to that folder.

    2. Have you changed all references to the original workspace input file (if necessary)? To check this, click on the workspace and make sure you don't see any yellow exclamation marks in the Load plan(s).

    image
    If you see any exclamation marks, work your way into the tree and fix the troublesome reference.
    image


    If that doesn't help, please could you repost the screen shot and select 'Original size'.

    UPDATE !!
    I can just about see from the screenshot that you are using a text delimited file as the input.  In that case, I think you will need to use the Database input rather than the file input (green icon set)

    Then, in the filename input section of the workspace, you should be able to select your Database Input from the drop down.  Having said that, it does look like the path is the same for both, so it may be something else.  It's difficult to be sure from the screen shot resolution.

    Best Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 08-06-2020 08:31 AM
    From: Janet Grimsley
    Subject: Visual Process cannot find input file

    Ok you smart people out there. What have I missed in this visual process.  It cannot find my input file.  The file name will change daily as it has a date stamp so I am using BIMExtract*.txt in the path.

    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------"
  • Janet_21505
    Janet_21505 Altair Community Member
    edited August 2020
    Steve Caiels_21881 said:

    Hi Janet,
    I'm afraid I can't read the screen shot, so I'll start with a couple of guesses!

    1. Is this a network location that you have not previously used?  If so, please ensure that the domain service account being used to run the Agent service has full access to that folder.

    2. Have you changed all references to the original workspace input file (if necessary)? To check this, click on the workspace and make sure you don't see any yellow exclamation marks in the Load plan(s).


    image
    If you see any exclamation marks, work your way into the tree and fix the troublesome reference.
    image


    If that doesn't help, please could you repost the screen shot and select 'Original size'.

    UPDATE !!
    I can just about see from the screenshot that you are using a text delimited file as the input.  In that case, I think you will need to use the Database input rather than the file input (green icon set)

    Then, in the filename input section of the workspace, you should be able to select your Database Input from the drop down.  Having said that, it does look like the path is the same for both, so it may be something else.  It's difficult to be sure from the screen shot resolution.

    Best Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 08-06-2020 08:31 AM
    From: Janet Grimsley
    Subject: Visual Process cannot find input file

    Ok you smart people out there. What have I missed in this visual process.  It cannot find my input file.  The file name will change daily as it has a date stamp so I am using BIMExtract*.txt in the path.

    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------"
    Steve, you were correct in pointing be to use a Database Input.  My mind was used to File Input and naturally that is were I went.  The file is pipe delimited and it just didn't register to use it as a database.  Made some other adjustments per your instructions regarding those exclamation marks and all is working.  Thanks for your reply and knowledge AND the tip on inserting screen shots!

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 08-07-2020 04:31 AM
    From: Steve Caiels
    Subject: Visual Process cannot find input file

    Hi Janet,
    I'm afraid I can't read the screen shot, so I'll start with a couple of guesses!

    1. Is this a network location that you have not previously used?  If so, please ensure that the domain service account being used to run the Agent service has full access to that folder.

    2. Have you changed all references to the original workspace input file (if necessary)? To check this, click on the workspace and make sure you don't see any yellow exclamation marks in the Load plan(s).

    image
    If you see any exclamation marks, work your way into the tree and fix the troublesome reference.
    image


    If that doesn't help, please could you repost the screen shot and select 'Original size'.

    UPDATE !!
    I can just about see from the screenshot that you are using a text delimited file as the input.  In that case, I think you will need to use the Database input rather than the file input (green icon set)

    Then, in the filename input section of the workspace, you should be able to select your Database Input from the drop down.  Having said that, it does look like the path is the same for both, so it may be something else.  It's difficult to be sure from the screen shot resolution.

    Best Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------

    Original Message:
    Sent: 08-06-2020 08:31 AM
    From: Janet Grimsley
    Subject: Visual Process cannot find input file

    Ok you smart people out there. What have I missed in this visual process.  It cannot find my input file.  The file name will change daily as it has a date stamp so I am using BIMExtract*.txt in the path.

    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------"

Categories