AnsweredAssumed Answered

Enterprise Survey query fails on SaaS test enviroment.

Question asked by js0054664 on Jul 26, 2018
Latest reply on Aug 6, 2018 by kyle.wright

Hi there. We have been given this query to pull student course evaluation data, but it fails in our SaaS test environment:

 

select 
    'BlackBoard_rpter.exe '|| Deployid  ||' '|| Deployname Outline,
    Deployid, 
    Deployname, 
    Deploydesc, 
    Clp_Sv_Survey_Pk1, 
    Deployment_Pk1
     From 
       (Select
          Pk1 Deployid, 
          Name Deployname,
          Description  Deploydesc 
          From Bb_Bb60.Deployment 
         )
         Left Outer Join (Select Clp_Sv_Survey_Pk1, Deployment_Pk1 From Bb_Bb60.Clp_Sv_Survey_Deployment
            ) Deploylink
               On Deployid = Deploylink.Deployment_Pk1
     Where Deployname like '201831%'
     ;

 

I know that bb_bb60 has gone away with SaaS and I've tried to replace it with our particular schema name string (like BB5b36xxxxxxxxxx) without success.

 

This is the error we receive:

 

SQL Error [42P01]: ERROR: relation "bb5b36xxxxxxxxx.deployment" does not exist
  Position: 273
  ERROR: relation "bb5b36xxxxxxxxx.deployment" does not exist
  Position: 273
  ERROR: relation "bb5b36xxxxxxxxx.deployment" does not exist
  Position: 273

 

Any points in the right direction would be appreciated. Thank you.

Outcomes