topic Advanced Consolidation Exercise- Populating the Queue in University Forum

Advanced Consolidation Exercise- Populating the Queue

JerielLaurel — Thu, 14 May 2020 11:10:00 GMT

Hello. I'am currently working with ACE (Self-study, for additional learning)

The thing is, I'am having a hard time with populating the Queue. There's this error...

System Exception : Error occured when looking for Excel files: Second path fragment must not be a drive or UNC name.
Parameter name: path2

And I don't know where to look. I already looked for my environment variables and file path name and I stuck at this.

Thank you in advance for your response. Hope you could help me.

------------------------------
Jeriel Laurel
------------------------------

RE: Advanced Consolidation Exercise- Populating the Queue

Carl__Carter — Thu, 14 May 2020 12:21:00 GMT

Hi Jeriel,

If you press the Errors button or select the Debug -> Validation menu option in Process Studio, this will display the Process Validation window. Look for errors on the Populate Queue; you should see several, but the ones of interest for this problem are the 'Data item refers to missing environment variable .....'

You need to create Environment variables for these missing items; the names for these variables are provided below:

Create Quotes Excel Input Folder
Create Quotes Excel Input Archive Folder

The value for these new Environment Variables should match the folders you created as part of the training setup procedure, which is detailed in the Setup Guide. For convenience, I have provided the names of the folders you need to create, and also the values for the new Environment Variables.

Once you have created the Environment Variables, you will need to refresh your process so it recognises these new variables.

Regards,

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------

RE: Advanced Consolidation Exercise- Populating the Queue

JerielLaurel — Tue, 19 May 2020 06:58:00 GMT

Thank you for this.

------------------------------
Jeriel Laurel
------------------------------

RE: Advanced Consolidation Exercise- Populating the Queue

JerielLaurel — Tue, 19 May 2020 07:02:00 GMT

One more question, I have this error where the returning date won't grayed out which is supposedly should because the one way is ticked. It just didn't push through and leave the rest of the details blank. Is there any way to solved it? I tried to change the data type at the application modeller and leaving the data item at the object studio as text. Thank you for your answer to this.

------------------------------
Jeriel Laurel
------------------------------

RE: Advanced Consolidation Exercise- Populating the Queue

Carl__Carter — Tue, 19 May 2020 08:08:00 GMT

Hi Jeriel,

I've answered this on your other post.

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=397&MessageKey=f7ac2f2a-eeda-4ecf-9290-ca4af00064b3&CommunityKey=1be7947a-bc2f-4974-bb0a-6347e1a324f8&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d1be7947a-bc2f-4974-bb0a-6347e1a324f8%26tab%3ddigestviewer

Regards,

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------