DEVLINEdoesnotexisterrorduringimport_东郊庄主

http://blog.sina.com.cn/u/1426010430

首页博文目录关于我

个人资料

微博

加好友发纸条

写留言加关注

博客等级：
博客积分：

博客访问：
关注人气：
获赠金笔：0支
赠出金笔：0支
荣誉徽章：

正文字体大小：大中小

DEVLINEdoesnotexisterrorduringimport

(2024-03-16 00:01:24)

PI 7.11 System Copy后，报DEVLINE does not exist error during import

根据1244593 - DEVLINE does not exist error during import附件中的SQL语句，得到新旧DEVLINE,然后手工更新。

1.SQL：SELECT WSL.DEVLINE, DEVL.NEWVERSIONSETID COLL FROM XI_REPWORKSP WSL, XI_PKNOWNDEVLINE DEVL WHERE WSL.DEVLINE = DEVL.VERSIONSETID ORDER BY WSL.DEVLINE;

得到新旧DEVLINE

DEVLINE COLL

-------------------------------- --------------------------------

D2A2162F6AE611E48863000000128662 229D1C6AE1B211EEC59A000000128662

D2B349F26AE611E49504000000128662 22A99CE5E1B211EE8EF4000000128662

D2B7A8CD6AE611E4B4BE000000128662 22AAEB98E1B211EE9AC5000000128662

D2D07AF76AE611E4C298000000128662 22BD28A5E1B211EEB70B000000128662

D2DC2EE96AE611E4A6A8000000128662 22C23215E1B211EEAA2C000000128662

D2E564C66AE611E4AF60000000128662 22C349B4E1B211EE9FE9000000128662

D2EA0F636AE611E4A103000000128662 22C6DC30E1B211EEBA7C000000128662

D6D559C16AE611E48B2E000000128662 22F9AD1BE1B211EEC89A000000128662

D748DD8D6AE611E4BBD8000000128662 230ED090E1B211EEC7EE000000128662

D7913DBA6AE611E4C85A000000128662 230FE7C0E1B211EE9F5F000000128662

D7BD25F16AE611E4C7BF000000128662 23132CA1E1B211EECC9E000000128662

DAC01E226AE611E498B4000000128662 23354B90E1B211EE9379000000128662

DAD84EC86AE611E49DE2000000128662 233889C8E1B211EEB30C000000128662

DCB3AFD5A49C11E6B180000000128662 233998E5E1B211EEAEB4000000128662

14 rows selected.

2. 手工更新XI_REPWORKSP表：

update XI_REPWORKSP set DEVLINE='229D1C6AE1B211EEC59A000000128662' where DEVLINE='D2A2162F6AE611E48863000000128662';

update XI_REPWORKSP set DEVLINE='22A99CE5E1B211EE8EF4000000128662' where DEVLINE='D2B349F26AE611E49504000000128662';

update XI_REPWORKSP set DEVLINE='22AAEB98E1B211EE9AC5000000128662' where DEVLINE='D2B7A8CD6AE611E4B4BE000000128662';

update XI_REPWORKSP set DEVLINE='22BD28A5E1B211EEB70B000000128662' where DEVLINE='D2D07AF76AE611E4C298000000128662';

update XI_REPWORKSP set DEVLINE='22C23215E1B211EEAA2C000000128662' where DEVLINE='D2DC2EE96AE611E4A6A8000000128662';

update XI_REPWORKSP set DEVLINE='22C349B4E1B211EE9FE9000000128662' where DEVLINE='D2E564C66AE611E4AF60000000128662';

update XI_REPWORKSP set DEVLINE='22C6DC30E1B211EEBA7C000000128662' where DEVLINE='D2EA0F636AE611E4A103000000128662';

update XI_REPWORKSP set DEVLINE='22F9AD1BE1B211EEC89A000000128662' where DEVLINE='D6D559C16AE611E48B2E000000128662';

update XI_REPWORKSP set DEVLINE='230ED090E1B211EEC7EE000000128662' where DEVLINE='D748DD8D6AE611E4BBD8000000128662';

update XI_REPWORKSP set DEVLINE='230FE7C0E1B211EE9F5F000000128662' where DEVLINE='D7913DBA6AE611E4C85A000000128662';

update XI_REPWORKSP set DEVLINE='23132CA1E1B211EECC9E000000128662' where DEVLINE='D7BD25F16AE611E4C7BF000000128662';

update XI_REPWORKSP set DEVLINE='23354B90E1B211EE9379000000128662' where DEVLINE='DAC01E226AE611E498B4000000128662';

update XI_REPWORKSP set DEVLINE='233889C8E1B211EEB30C000000128662' where DEVLINE='DAD84EC86AE611E49DE2000000128662';

update XI_REPWORKSP set DEVLINE='233998E5E1B211EEAEB4000000128662' where DEVLINE='DCB3AFD5A49C11E6B180000000128662';

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report

前一篇：SAPkernel包SAPEXE包中没有jstart文件

后一篇：2025年新年快乐

新浪BLOG意见反馈留言板　欢迎批评指正