英文:
Write back functionality is not working in OBIEE
问题
我已创建了一个写回模板文件，并在现有的更新和插入部分添加了一些额外的列。当我尝试更新这些字段时，它们会恢复到原始值，而在我的情况下，原始值是null。在QA环境中，相同的功能正常工作。我只在生产环境中遇到了这个问题。有人可以帮助我吗？
我已经给予了BI消费者角色所有权限，并在RPD和BI目录页面启用了这些列的写回功能。将写回XML放置在所有自定义消息文件夹中，并重新启动了BI服务器。
英文:
I have created a writeback template file and added few additional columns to the existing update and insert section. When I'm trying to update the fields, they are reverting back to the original value in my case it's null. Same functionality is working fine in QA. I'm facing this issue only in Production environment. Can someone please help me out.
I have given all permissions to the BI consumer role and enables writeback for these columns in RPD and BI catalog page. Placed writeback XML in all custom messages folders and restarted the BI servers
答案1
得分: 1
如您所说，它在QA环境中运行正常。因此，问题在于您需要开始比较您的环境。还要确保验证数据库用户是否被允许写入：QA数据库用户很容易拥有比生产环境数据库用户更多的权限。但是因为在QA环境中运行正常，所以您知道问题肯定出现在生产环境的配置中。
英文:
As you say yourself, it works in QA. Therefore the thing is that you have to start comparing your environments. Also don't forget to verify if the database user is allowed to write: QA DB users can easily have more privileges than a user on a prod DB.
But because it works in QA, you know that the issue is somewhere in your configuration of the prod environment.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论