DEVLINEdoesnotexisterrorduringimport
2024-03-16 00:01阅读：
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
22A99CE5E1B211EE8EF400000012866
2
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'; |
|
