Skip to Content
0
Dec 02, 2022 at 03:04 PM

Error: System or data source not available - BW Live connection

108 Views Last edit Dec 12, 2022 at 01:50 PM 2 rev

On my Dev environment I have a SAC live model built on BW Bex query. We have built analytics applications on this model. Now we have to change connection of this model to point to the QA system and verify the report.(We have only Dev and Prod environments for SAC but for backend we have a QA as well) When I change the connection using the 'Change data source option' to select the QA connection I can get my Bex query which has been migrated. So I select the query and want to save my model. But I am unable to save the model and I get error. "System or data source is not available"

I then tried to create a new model on QA with that Bex query and it worked. But if I use new model in QA I have to rework on all my SAC reports. So what can be possible reason that change connection doesn't work but new model creation works.

Can anyone suggest what can be verified to rectify this issue...am I doing something wrong in the process of changing connections. Any pointers would be helpful , Thanks