Forum Discussion

ShivaPrasad's avatar
ShivaPrasad
New Contributor III
3 months ago
Solved

An Error Has Occured BadGateway - Books

Hello, 

When i am running Books from File Explorer -  Application Database, I am getting the below error, did any one come across this issue. requesting to help me how to handle this issue and get output. 

 

Books
  • sameburn's avatar
    sameburn
    3 months ago

    For clarity, I am referring to the output file name (the name of the file output - see example below for excel), not the looping variable. 

    I suspect the book may be trying to create a file that either (a) already exists or (b) is already open.,  This is why I suggested changing the file name output to see if that resolved

     

5 Replies

  • ShivaPrasad's avatar
    ShivaPrasad
    New Contributor III
    3 months ago

    Hi Sam,

    As suggested,  below are the different output names that i have tried. but still we are getting "GateWay" error for two reports. (In these two books we are passing Loop1 as customers and Loop2 as Entity)

     |Loop1Variable|
    |Loop1DisplayVariable|
    |Loop1Index|.

     

    • sameburn's avatar
      sameburn
      Icon for OneStream Employee rankOneStream Employee
      3 months ago

      For clarity, I am referring to the output file name (the name of the file output - see example below for excel), not the looping variable. 

      I suspect the book may be trying to create a file that either (a) already exists or (b) is already open.,  This is why I suggested changing the file name output to see if that resolved

       

  • sameburn's avatar
    sameburn
    Icon for OneStream Employee rankOneStream Employee
    3 months ago

    Since yours seems to work (in some cases). I suspect you are not hitting this bug.

    If you change the file name output (to something new) from the books that are not working, does it resolve?

  • ShivaPrasad's avatar
    ShivaPrasad
    New Contributor III
    3 months ago

    Hello Sam, 

    actually i have created the Books in version 9.1, interesting thing is out of  many  book's only 2 books are not working. the configuration and other settings from source cube view is same.  

     

    Regards,

    Shiva.

  • sameburn's avatar
    sameburn
    Icon for OneStream Employee rankOneStream Employee
    3 months ago

    Hi ShivaPrasad​ 

    I think this might be a bug on v9.  I would recommend reaching out to Support to help you resolve.

    If you are not on version 9, then it could be something wrong with the target filepath e.g si.UserName result is "user name" but target folder is "username",  etc

    Hope this helps

    Sam