アーティクル - CS432293
Windchill サプライヤー管理で「式をデータ型 nvarchar に変換するときに算術オーバーフロー エラーが発生しました」というエラーが発生し、OEM 部品に製造元部品を追加できませんでした。
修正日: 28-Nov-2024
適用対象
- Windchill Supplier Management 12.0
- SQL Server
説明
- ユーザーが OEM 部品にメーカー部品を追加しようとすると、エラーが発生します。
- このエラーは、データベースで定義された長さを超える列の値にリンクされています。
- Windchill データベース内のAXLEntryテーブルで問題が特定されました
- Methodserver.log の例外
(wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows: Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO AXLEntry(classnameA2A2,updateCountA2,amlPreferenceData,avlPreferenceData,classnamekeyD4,idA3D4,classnamekeyA4,idA3A4,classnamekeyC4,idA3C4,markForDeleteA2,branchIdA2typeDefinitionRefe,idA2typeDefinitionReference,classnamekeyB4,idA3B4,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('com.ptc.windchill.suma.axl.AXLEntry',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Arithmetic overflow error converting expression to data type nvarchar. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:473) at wt.pds.SQLDatabasePds.insertListDefault(SQLDatabasePds.java:3266) at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3150) at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:320) at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2405) at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:573) at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1382) at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1434) at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:534) at wt.fc.StandardPersistenceManager.save(StandardPersistenceManager.java:527) at jdk.internal.reflect.GeneratedMethodAccessor669.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) at com.sun.proxy.$Proxy29.save(Unknown Source) at com.ptc.windchill.suma.axl.StandardAXLService.addAML(StandardAXLService.java:2083) at com.ptc.windchill.suma.axl.StandardAXLService.addAML(StandardAXLService.java:2057) at com.ptc.windchill.suma.axl.StandardAXLService.addAML(StandardAXLService.java:240) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) at com.sun.proxy.$Proxy296.addAML(Unknown Source) at com.ptc.windchill.suma.jca.processor.CreateAXLFormProcessor.doOperation(CreateAXLFormProcessor.java:162) at com.ptc.windchill.suma.jca.processor.CreateAssociateSupplierPartProcessor.postPartCreateProcess(CreateAssociateSupplierPartProcessor.java:98) at com.ptc.windchill.suma.jca.processor.CreateAssociateSupplierPartProcessor.postTransactionProcess(CreateAssociateSupplierPartProcessor.java:64) at com.ptc.core.components.forms.DefaultFormProcessorController.executePostTransactionProcess(DefaultFormProcessorController.java:711) at com.ptc.core.components.forms.DefaultFormProcessorController.performExecutePostTransactionProcess(DefaultFormProcessorController.java:361) at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:279) at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146) at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116) at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93)
最新バージョンはこちらを参照ください CS432293