• qad progress数据库启动出错解决


      1. 启动时报:SYSTEM ERROR: Wrong dbkey in block. Found 0, should be 6342528 in area 36. 

         (439) ** Save file named core for analysis by Progress Software Corporation.

       原因:查看数据库.lg日志文件,确认是数据库没有还原成功(注:.lg文件盒数据库文件在同一目录

       

    [2015/12/07@00:19:18.579+0800] P-31305 T-14415552 I : (12854) Restoring database from XXXXXXXXXX.db.
    [2015/12/07@00:22:01.085+0800] P-31305 T-14415552 I : (5057) Backup failed due to EOF during next output device request.
    [2015/12/07@00:22:01.085+0800] P-31305 T-14415552 I : (1618) Restore failed.
    [2015/12/07@00:22:01.085+0800] P-31305 T-14415552 I : (8564) !!! ERROR - Database restore utility FAILED !!!
    [2015/12/07@00:22:01.104+0800] P-31305 T-14415552 I : (334) Prorest session end.

      2. 重新还原时,报

        Start of extending target DB to needed size... (9432)

        Unable to extend before-image files enough to proceed. (6743)
        Check for fixed length extents. (6744)
        Restore failed. (1618)
        !!! ERROR - Database restore utility FAILED !!! (8564)

       查找之后发现是源数据库的BI文件又两个,而目标数据库的BI文件只有一个

      3.  尝试给目标数据库加BI:prostrct add mfgtrain mfgtrain-add.st

        You must remove the variable length BI extent before adding
        additional BI extent(s). (8225)
        prostrct add FAILED. (12867)

       确认不好加,所以就想把源数据库的BI删掉,再重新生成一个,也可以释放一点空间。

      4. 重新生成BI, 步骤如下:

       1)  prostrct remove mfgprod bi  执行,提示XXXXXXXXXXX.b2 成功删除

       2)  prostrct remove mfgpord bi 执行,提示XXXXXXXXXXX.b1 成功删除

         3) 创建mfgprod-add.st。 内容:b /qad/qad2010/db/mfgprod.b1

        执行 prostrct add mfgprod mfgprod-add.st  

        5. 备份还原

        probkup XXXXXXXXmfgprod XXXXXmfgprod.bak 备份

         prorest  XXXXXXXXmfgdemo XXXXXmfgprod.bak 还原

  • 相关阅读:
    (转)样本方差的期望
    (转)Python 字典排序
    曝光补偿
    python判断字符串是否包含子字符串
    python requests接口测试 -----博客园串接口
    jmeter+ant+jenkins 搭建接口自动化测试
    TOMCAT闪退。cmd执行startup.bat保错:the CATALINA_HOME environment variable is not defined correctly
    selenium python自动化测试 ddt数据驱动
    jenkins到底如何拉取代码 如何部署的
    git 常用命令
  • 原文地址:https://www.cnblogs.com/linnicke/p/5026099.html
Copyright © 2020-2023  润新知