记录一次powercenter数据抽取问题解决

<div id="article_content" class="article_content csdn-tracking-statistics tracking-click" data-mod="popu_519" data-dsm="post">
                            <div class="htmledit_views">
                        
<p>     昨天调整informatica 的字符集删除了原来的存储库，重新部署新的存储库，手动运行workflow成功后，将工作流按计划执行，可是今天早上过来检查，发现工作流都运行失败，</p>
<p>错误：</p>
<p>CMN_1761 时间戳事件<br>
REP_12400 存储库错误([REP_57145] 在数据库中未找到数据<br>
TM_6247 检查全局对象权限时出错: </p>
<p>第一次遇到这种错误，百度上没有任何结果，无奈谷歌，果然万事通的谷歌有很多解决方案，现在将问题和解决方分享给大家。</p>
<p><br></p>
<p>TM_6247 检查全局对象权限时出错: <br></p>
<p><img src="https://img-blog.csdn.net/20150411100041557?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br></p>
<p><br></p>
<p>谷歌的分析和解决方案是：</p>
<p>please check the permissions on the Connection [ mmfd57_EEFCONV1]. If your <br>
user id is having the rights to use this connection </p>
<p><img src="https://img-blog.csdn.net/20150411101003626?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br><br>
In the worfflow mgr tool, open the DB Connection object(you would have it a <br>
lready defined), that is being used in the session to connect to src and tg <br>
t systems <br><br>
Workflow MGR --> Connections(menu item)--> Relational-->select the CONNECTI <br>
ON from the list and click on PERMISSIONS button , give all rights to all a <br>
vailable users/groups. <br><br>
The "Global Object" refers to the above connection....used in the session u <br>
r trying to run.... <br></p>
<p><img src="https://img-blog.csdn.net/20150411101105617?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br></p>
<p>下面是我操作的截图：</p>
<p>在工作流管理器中点击链接->关系</p>
<p><img src="https://img-blog.csdn.net/20150411100112679?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""></p>
<p>在关系弹出的对话框中点击权限</p>
<p><img src="https://img-blog.csdn.net/20150411100437676?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br></p>
<p>弹出窗口选择全部列出，点击添加</p>
<p><img src="https://img-blog.csdn.net/20150411100443186?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br></p>
<p>更具需要选择需要的用户。默认是administrator 和其他。</p>
<p><img src="https://img-blog.csdn.net/20150411100917696?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br></p>
<p>添加完成后就ok了。</p>
<p><img src="https://img-blog.csdn.net/20150411101007663?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvenV0c29mdA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""><br></p>
<p>上面的解决办法是我在15年4月第一次遇到这个错误时的解决办法，在15年7月再次遇到这个错误，使用了上面的方法无效，最后在informatica技术超群小庄的帮助下找到了解决办法，但是至今不知道为什么要这么做：</p>
<p>控制台集成服务的存储库登陆用户必须是Administrator，之前我登陆的用户是administrator（和Administrator的密码一样），我很想知道这两个用户有什么区别，不过没找到资料</p>
<p><img src="https://img-blog.csdn.net/20150715110844430?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""></p>
                </div>
                    </div>