• 11456阅读
  • 4回复

手动解决 The database has not been configured run background jobs 2005 Express [复制链接]

上一主题 下一主题
 
只看楼主 倒序阅读 0楼 发表于: 2011-08-24
安装完p6后,登录pm的时候提示错误,数据库后台工作模式没有配置,如下: = &tmP  
When logging into Project Management 6.0 the following error is received: "The database has not been configured to run background jobs. Tocorrect this problem, please contact your System Administrator or seethe Primavera's Administrator Guide." .fAv*pUzU  
这是因为安装p6的时候没有选择standlong模式,没有安装prmbackagent服务导致的,虽然不影响正常使用,但每次 弹个报错提示让人很烦,下面是我手工解决的方法。 @n -r-Q  
Manually Installing PrmBackAgent under SQL 2005 Express ICC%,$C~l  
Note: This is not required for full SQL 2000/2005 only SQL 2005 Express(只有express版本的sqlserver才需要) K/L;8a  
Althoughthe service is installed automatically by the P6 standaloneinstallation, the service can also be installed manually on the machinewhere the database is located. To install the service manually, youmust be a Windows user with admin access to the databases involved.Follow the procedure below to manually install the service. S >yLqPp  
1  Extract the prmbackgroundagent.exe executable from the Data1.cab file on CD 1.   在安装盘中的数据库目录下找到prmbackgroundagent.exe >R\lqLILb,  
这个文件 <\ `$Jx#  
2  Place the prmbackgroundagent.exe file in a directory on the local machine (for example, C:\Primavera\PrmBackAgent 把文件拷贝到这个目录下,根据你自己的安装路径选择). I%j_"r9-I  
3  From the Start menu, click Run.(点开始 -运行) ?t](a:IX  
4  Substituting the appropriate path to the prmbackgroundagent.exe file from step 2, execute the following command to install the service: 找到上面的文件,按下面的方式运行 >w+HHs/$wK  
C:\Primavera\PrmBackAgent\prmbackgroundagent.exe /install tM4 Cx  
IQZ#-)[T"  
Manually Registering and Starting PrmBackAgent under SQL 2005 Express (下面修改注册表) #bH_Dg5I  
^r6!l.  
Before starting the service, the name of theserver instance containing the P6 databases must be added to theregistry. Follow the procedure below to manually add the serverinstance name to the registry. XI<L;  
/D! ;u]  
1.  Right-click on HKEY_LOCAL_MACHINE\Software\Primavera and choose "New", "Key". 在注册表中右击这个键,添加个新项 V#REjsf,t-  
9KWuN:Sg  
      Enter the name "BackgroundAgent" +M' H0-[  
: cB=SYcC%  
2.  Right-click on BackgroundAgent and choose "New", "String Value".  Enter "Server".  右击添加的新项,新添个字符串 ^9Qy/Er'  
GZI`jS"lU  
3.  Right-click on Server and choose "Modify".  Enter the SQL Server instance name in the "Value Data" field.  右击这个字符串,修改值为 你装的SQLSEVER的名字, [e[<p\]  
@,Gxk   
NOTE:  for standalone installations localhost\primavera can be used. 名字一般是 机器名\sqlexpress,看你装sql的时候起的什么名,可以通过sqlserver的管理器进去查看 W-NDBP:  
               HK`I\,K  
4.  When this is complete, reboot the machine. 这一步做完重启计算机 *na?n2Yzt  
^8.]d~j  
Initializing Primavera Background Jobs  重启完后就对数据库的后台服务初始化 1`ayc|9BR  
=[b)1FUp  
    Go to Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express. 进入sql的管理器 cufH?Xg<  
    Click Connect to log in. :#@= B]  
$Y69@s%f  
    Click on "New Query" S$QG.K:<!  
M#(+c_(r  
    Type: "use nameofdatabase 89r DyRJ;  
    exec initialize_background_procs" `BlI@6th  
uj :%#u  
    Where nameofdatabase is your Primavera Database name. The default is pmdb$primavera.我的数据库名就直接是PMDB,看你自己怎么设的 'Lu__NfN  
    Click the Execute button to run the query. 执行query ZYC<Wb)I  
0#nPbe,Lj  
M5 <@~V/[  
    If it was successful it will show "Command(s) completed successfully.  显示成功 +E{|63~q  
    Close out of SQL 2005 Express. 退出sql管理器 ?Y@N`S  
     Oil?JI Hq  
   下面的自己翻译吧 O#F4WWF  
    Open up Project Management.  You may still see the error message.  If so,..... rx]  @A  
Mnscb  
    Let the program open fora couple of minutes to trigger the jobs to run. Symon process shouldrun every 1 minute and Damon process every 5 minutes. Once both thesejobs have ran successfully for the first time the users should notreceive the error message while logging into Project Management.
2条评分
检查用户名 权重 +10 优秀文章 2011-08-24
检查用户名 权重 +10 优秀文章 2011-08-24
只看该作者 1楼 发表于: 2011-08-25

只看该作者 2楼 发表于: 2011-08-25
赞就一个字:牛!!!!!
提供全国各个行业的定额资源库(含定额子目及人材机),为企业定制资源库,代写各类资源库.欢迎联系!

只看该作者 3楼 发表于: 2012-01-16
p6 r8.1 也可以采用上述方法解决吗?
只看该作者 4楼 发表于: 2012-05-24
P6 8.2 数据库 sql 2008 是否可用,有人尝试过么?
快速回复
限1000 字节
 
上一个 下一个